How to extract Reach & frequency for all campaigns under an account from the adwords api

[Nabeela tabu]

Hi,

I want to extract Reach & Frequency for all the campaigns under an account from adwords API. I can see under the campaign performance report of V201609 ImpressionReach is available. But when I try to use it to extract with the date range as ALL time, I get the error INVALID_FIELD_NAME_FOR_REPORT.

Is there anyway where I can get the data for all campaigns/

Regards,

Nabeelah

[Anthony Madrigal]

Hi Nabeelah,

Are you using a report definition with XML or AWQL to run this report? When using AWQL, you cannot use the date type ALL_TIME. You can omit the DURING clause to get all time stats. You should expect to see INVALID_DURING_CLAUSE when using ALL_TIME.

Since you are getting INVALID_FIELD_NAME_FOR_REPORT, there may be another field you are using that is causing this. Please make sure that you are not using any of the fields listed under "Not compatible with the following fields:" along with ImpressionReach.

If you are not using any incompatible fields, please send me your report definition through reply privately to author so that I can take a look.

Regards,

Anthony

AdWords API Team

[Nabeela tabu]

Hi Anthony,

I am using python lib to extract data and not with AWQL. I figured out this problem was mainly due to the date range being ALL_TIME. When I use the date range as the start & end date of a particular campaign, I get the results. But for that I have to make API calls for every campaign. Is there anyway I could get the reach & frequency for all the campaigns at once?

Regards,

Nabeelah

[Anthony Madrigal]

Hi Nableelah,

As a workaround, what you can do is log onto your AdWords account and choose the All time date on the top right of the Campaigns tab in the UI. There you will see the date in which you started using AdWords and today's date. You can use those dates as a custom date range to get the stats for all campaigns in the report. 

[Jonathan Lautaha]

Hey Anthony,

I'm trying to pull in the fields "Unique users" and "Avg. impr. freq per user," through AWQL (NOT "Unique cookies" or "Avg. imr. freq. per cookie"). How do I do this?

I noticed that the CAMPAIGN_REACH_FREQUENCY_REPORT is no longer supported by the AdWords API.