Hi Pim, I don't know if you've managed to ever find the solution to your issue here but I've been trying to understand how to pull cost data by country from the Google Ads DT setup as well. I've got the same numbers as in the Google Ads API (I used the 'Country (User location)' field in there) by adding 'AND LocationType = 'LOCATION_OF_PRESENCE'' in the WHERE clause of my query. See the official doc here: https://developers.google.com/adwords/api/docs/appendix/reports/geo-performance-report#locationtype
Hope that helps you or anyone who's come across the same blocker. Cheers, Olivier On Thursday, 7 June 2018 at 19:19:54 UTC+1 Bharani Cherukuri (AdWords API Team) wrote: > Hello Pim, > > Sure, it looks like you're comparing the results between Account > Performance Report and Geo Performance Report. From the AdWords API > perspective, the Account Performance Report > <https://developers.google.com/adwords/api/docs/appendix/reports/account-performance-report> > corresponds > to the stats aggregated at the account level with one row per account. On > the other hand, Geo Performance Report > <https://developers.google.com/adwords/api/docs/appendix/reports/geo-performance-report> > returns > the stats aggregated at the country/territory level, one row per > country/territory. Please check this guide > <https://developers.google.com/adwords/api/docs/guides/uireports> on how > the API reports map with the UI fields. > > Since you're using Big Query data transfer, which pulls the data from > AdWords we will not be able to comment on how they're pulling this > information. At any given time, the AdWords API results match with the > AdWords UI. If that's not the case, please share the complete report > definition and client customer Id, so I can take a look. If you believe > that the AdWords stats are inflated when using BigQuery, it would be best > to reach out to the support channels shared in my previous response. > > Thanks, > Bharani, AdWords API Team > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ Also find us on our blog: https://googleadsdeveloper.blogspot.com/ =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/adwords-api?hl=en --- You received this message because you are subscribed to the Google Groups "AdWords API and Google Ads API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/7bc38c8e-479a-431b-85bf-c08c0d58dd9bn%40googlegroups.com.
