Mismatch between Audience and Campaign report

[da...@improvado.io]

Hi there, 

Recently we've observed that the Audience report returns not all data. 

for example, a query to the campaign report 

https://adwords.google.com/api/adwords/reportdownload/v201809?__fmt=CSV&__rdquery=SELECT CampaignId,Impressions FROM CAMPAIGN_PERFORMANCE_REPORT WHERE CampaignId=10251593972 DURING 20200601,20200630  

response:

"CAMPAIGN_PERFORMANCE_REPORT (Jun 1, 2020-Jun 30, 2020)"

Campaign ID,Impressions

10251593972,5958871

Total,5958871

a query to the Audience report 

https://adwords.google.com/api/adwords/reportdownload/v201809?__fmt=CSV&__rdquery=SELECT CampaignId,Impressions FROM AUDIENCE_PERFORMANCE_REPORT WHERE CampaignId=10251593972 DURING 20200601,20200630 

response:

"AUDIENCE_PERFORMANCE_REPORT (Jun 1, 2020-Jun 30, 2020)"

Campaign ID,Impressions

10251593972,41483

10251593972,45701

10251593972,144142

10251593972,67139

10251593972,17231

10251593972,115290

10251593972,6310

10251593972,218861

10251593972,19628

10251593972,17494

10251593972,120300

10251593972,68777

10251593972,41218

10251593972,91254

10251593972,16772

10251593972,16053

10251593972,78114

10251593972,5086

10251593972,5646

Total,1136499

So, the count impressions is different. Campaign report 5958871 vs 1136499 Audience report. 

Morethan If dig deeper and add to the query AdgroupID dimension you will see that one of the reasons that data discrepancy is missing some ad groups at all in the audience report.

At first glance, those ad groups don't have any differences from others. Examples such as ad groups 101150581094, 101029514623. These ad groups weren't returned in the audience report. 

I've closely read the API documentation and didn't find any reasonable explanation of such behavior. 

Please explain why it is happening?  

Thanks in advance!

  

[Google Ads API Forum Advisor Prod]

Hi Damir,

As you can see from the screenshot I attached, your API reports match with your UI. The missing data you from your audience reports are coming from Expansion and Other. The Audience Performance Report will only show you the Audience totals.

Regards,
Anthony
Google Ads API Team

ref:_00D1U1174p._5004Q23KnUJ:ref

[da...@improvado.io]

Thanks! Got it!

[da...@improvado.io]

By the way, is it possible to get data for  Expansion and Other from Adwords API or Google Ads beta API?

On Tuesday, August 18, 2020 at 3:27:39 AM UTC+7 adsapiforumadvisor wrote:

[Google Ads API Forum Advisor Prod]

Hi Damir,

Unfortunately, there is no way to get these rows in either of the APIs. I've created a feature request on   your behalf.

You can follow our blog to get announcements or updates regarding this.

Cheers,