Hi, this is the query I'm using to test with. I attached an image of the
fields that are selected in the Google Ads UI.
When I compare the two results I see the following
Cost off by 10%
Impressions off by 8%
Interactions off by 12%
Views off by 12%
The total amount of rows between the two results are off by 2%.
SELECT
segments.date,
customer.descriptive_name,
campaign.name,
ad_group.name,
ad_group.type,
segments.geo_target_city,
segments.geo_target_region,
geographic_view.country_geo_target_constant,
segments.device,
metrics.clicks,
metrics.conversions,
metrics.cost_micros,
metrics.impressions,
metrics.interactions,
metrics.video_views
FROM
geographic_view
WHERE
segments.date = '{date}'
On Wednesday, July 3, 2019 at 7:02:29 AM UTC-7, Nathan wrote:
>
> Hi Chris
>
> Weird, but I just noticed this exact same thing (
> https://groups.google.com/forum/?utm_medium=email&utm_source=footer#!topic/adwords-api/nFlapFrCGdc
> ).
>
> Can you share your query you're using, and how different it is vs the UI?
>
>
> On Wednesday, July 3, 2019 at 4:08:58 AM UTC-7, Chris wrote:
>>
>> Hello,
>> I currently have a Geo report in Google Ads UI that I created. I wrote my
>> own search query to hit Google Ads API. I used the same fields that my Geo
>> report has in the UI. When I compare the aggregations the numbers do not
>> match. The UI is showing larger numbers for Cost,
>> Impressions, Interactions, and Views. I'll be happy to post additional
>> information. Please let me know what I need to share. Thanks!
>>
>
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@googlegroups.com
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 adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/d53fbe99-1e09-4701-bc6f-953a617af0a4%40googlegroups.com.
