how to get reach data(unique impressions) for each campaign

[Eitan Shay]

 Hi,

I am trying to get reach data(unique impressions) for each campaign.
From https://developers.google.com/adwords/api/docs/guides/structure-reports, I can see that I can use JOIN in awql on CAMPAIGN_PERFORMANCE_REPORT and CAMPAIGN_REACH_FREQUENCY_REPORT

But I got "HTTP Response Code: 400, Type: QueryError.PARSING_FAILED" error with the following awql:

SELECT Id, Name, Impressions, Clicks, Ctr, AverageCpm, AverageCpc, UniqueUserCountAsLong, ReachFrequency
FROM CAMPAIGN_PERFORMANCE_REPORT
JOIN CAMPAIGN_REACH_FREQUENCY_REPORT ON CAMPAIGN_PERFORMANCE_REPORT.Id=CAMPAIGN_REACH_FREQUENCY_REPORT.CampaignId
WHERE CampaignStatus IN [ENABLED, PAUSED] DURING LAST_WEEK

Then I found CAMPAIGN_REACH_FREQUENCY_REPORT is not supported in the latest version
since I got error
“HTTP Response Code: 500, FieldPath: selector, Trigger: Enum ReportDefinitionReportType does not have a constant corresponding to CAMPAIGN_REACH_FREQUENCY_REPORT, Type: ReportInfoError.REPORT_INFO_ERROR”
when querying on only CAMPAIGN_REACH_FREQUENCY_REPORT in the following:

SELECT UniqueUserCountAsLong, ReachFrequency
FROM CAMPAIGN_REACH_FREQUENCY_REPORT
WHERE CampaignStatus IN [ENABLED, PAUSED] DURING LAST_WEEK

Can anyone please help me solve this?

Thanks very much!
Eitan

[Michael Cloonan (AdWords API Team)]

Hello,

We are aware of this gap and are working on adding a method for you to reach this data via reporting. Please watch our blog for new feature announcements to keep up do date.

Regards,

Mike, AdWords API Team

[Eitan Shay]

Thanks Michael.
So for now we cannot get the reach data from AdWords API, is there any other way to get it?
If not, Could you please tell us the approximate time that this feature will be released?

Best regards,
Eitan

[Michael Cloonan (AdWords API Team)]

Hello,

For now, I believe you can still use these reports with API version v201406.

Unfortunately, I cannot comment on release dates or timelines for future features.

Regards,

Mike, AdWords API Team

[Eitan Shay]

Thanks Michael.
I've got the reach data with API version v201406.

But I still got "HTTP Response Code: 400, Type: QueryError.PARSING_FAILED" error with the following awql using JOIN.
According to the example awql in https://developers.google.com/adwords/api/docs/guides/structure-reports, we can use the JOIN clause.
Can you please help me find any error from the following awql.

Thanks very much!

===================awql with JOIN================

SELECT Id, Name, Impressions, Clicks, Ctr, AverageCpm, AverageCpc, UniqueUserCountAsLong, ReachFrequency
FROM CAMPAIGN_PERFORMANCE_REPORT
JOIN CAMPAIGN_REACH_FREQUENCY_REPORT ON CAMPAIGN_PERFORMANCE_REPORT.

Id=CAMPAIGN_REACH_FREQUENCY_REPORT.CampaignId
WHERE CampaignStatus IN [ENABLED, PAUSED] DURING LAST_WEEK

[Eitan Shay]

From another thread, I know I cannot use JOIN.
But I got several different statistics data for the same campaign ID.
Can anyone help explain why this happens?

Here's my awql query:
SELECT
CampaignId, CampaignName, UniqueUserCountAsLong, ReachFrequency, ReachFrequencyClicks, ReachFrequencyCtr "

FROM CAMPAIGN_REACH_FREQUENCY_REPORT
WHERE CampaignStatus IN [ENABLED, PAUSED]
DURING LAST_WEEK

Thanks a lot!

Campaign ID

Unique Users

Frequency

Clicks

CTR

318515843		2	1	0	0.00%
318515843		1	2	0	0.00%
318515843		1	3	0	0.00%
318515843		2	1	0	0.00%
318515843		1	2	0	0.00%
318515843		1	3	0	0.00%

[Eitan Shay]

Seems it's bcoz the ReachFrequency field causes segmentation.
But even if I SELECT only CampaignId, UniqueUserCountAsLong I still get same or different rows in the result like below:
Can anyone help shed some light on this?

Thanks!
=========sample result===

Campaign ID	Unique Users
318518123	1
318518123	1
318515843	4
318515843	4
318515483	10
318515483	4
318515483	6

[Eitan Shay]

Bounce. Anyone can help this??
I found the different rows seems to come from different ReachFrequencyDate.
Is there any way to aggregate all data in one row? Since it's UniqueUserCountAsLong  I cannot sum them by date simply.

Thanks a lot for kindly help in advance!

[Michael Cloonan (AdWords API Team)]

Hello,

What happens if you just select the Campaign ID? Is it still segmented? There might be some innate segmentation in this report on a field other than Campaign ID.

Regards,

Mike, AdWords API Team