Failed Reach Report | Google Ad Manager API | Python | v202102

[Hadil Charafeddine]

Hello,

I created a reach report on the Google Ad Manager platform and it runs successfully there. Below are the dimensions and metrics:

However, when I try to create the same report using the python library, I always get report failed. Below is the report query:

input = {
"reportJob": {
"reportQuery": {
"dimensions": ['AD_UNIT_NAME', 'MONTH_AND_YEAR', 'COUNTRY_NAME'],
"columns": ['UNIQUE_REACH_FREQUENCY', 'UNIQUE_REACH_IMPRESSIONS', 'UNIQUE_REACH'],
"dateRangeType": "LAST_MONTH"
}
}
}

When I run the report job with the above query, everything works fine and it returns a report ID. However, every time I check the status of that report to download it, I get status "FAILED".

Can anyone help? All I need from the report are these three metrics per Ad_Unit (I don't care about the dimensions or date range).

[Ad Manager API Forum Advisor Prod]

Hi Hadil,

 

Thank you for reaching out to us.

 

Can you please provide your network code so I can replicate the issue on my end? You may send these to me via Reply privately to author option.

 

Regards,

Kevin Gil Soriano Ad Manager API Team

ref:_00D1U1174p._5004Q2FaeCY:ref

[Hadil Charafeddine]

The "reply to author" button is grey for me and it says I don't have the permission to do this action in this group. Is it safe for me to send the network code publicly? If yes, I'll send it here.

[Ad Manager API Forum Advisor Prod]

Hi Hadil,

 

You can send information to us privately by sending it to admanagera...@google.com. Let me know in this thread once you have sent it so I can check if we received it properly on our end.

[Hadil Charafeddine]

Hello! I sent the network code through email like you requested.

[Ad Manager API Forum Advisor Prod]

Hi Hadil,

 

Thank you for providing more information. Upon testing on my end, I was able to encounter the same issue as you do.

 

I'm sharing the details of your concern with the rest of our team for further investigation. Rest assured that one of my colleagues will reach out to you as soon as possible.

[Hadil Charafeddine]

Hello Kevin! OK noted. We'll wait for an update then. Thank you for the help!

[Ad Manager API Forum Advisor Prod]

Hi, Hadil.

I've raised this issue to a reporting engineer, and they're looking into this issue currently. I'll let you know as soon as we find the reason for this report failure.

Donovan McMurray Ad Manager API Team

ref:_00D1U1174p._5004Q2FaeCY:ref

[Hadil Charafeddine]

Hi Donovan,

Thank you for the update! We'll be waiting for your feedback soon then.

[Ad Manager API Forum Advisor Prod]

Hi, Hadil.

I heard back from the engineer and this is an easy fix. You need to add `"adUnitView": "FLAT"` to your `reportQuery`. The default value is "TOP_LEVEL", and this value is not supported in Reach Reports where "AD_UNIT_NAME" is in the dimensions list.

I'll also look into updating our client library examples to highlight this. In the Python client library, for instance, we don't include "AD_UNIT_NAME" is in the dimensions list, so this problem doesn't arise. I will also ask the reporting engineers if they can make a better error for this case.

Please let me know if you still experience a problem after setting "adUnitView" to "FLAT".

[Hadil Charafeddine]

Hello Donovan,

Thank you! This solved the issue. And yes, I agree, if there were examples in the python library git repository of reach report being used with Ad Unit, we would have been able to work it ourselves. But, seen as all the examples in all versions of the library are on a Line Item level, we couldn't figure out why we were getting an error.

Thank you again very much for your help!

Kind regards,

Hadil