Re: Geo Report pulled from API not matching UI
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! > -- *DISCLAIMER:* Any advice or comments provided by an employee of Healthcare Research LLC (HCR) is provided with the understanding that neither the employee nor HCR is rendering legal advice. HCR customers (including myCNAjobs.com and HealthHire.com) are responsible for ensuring job and other content meets EEO standards and all applicable State and Federal law requirements. HCR is not responsible. HCR may make recommendations via phone consultation, email, webinars, or other site content or data reports. The recommendations are not intended to be legal advice and it is recommended that all customers seek advice of its own counsel to ensure such compliance. -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/6203d8e9-5a34-4299-80e8-93f329e9369c%40googlegroups.com.
Re: Geo Report pulled from API not matching UI
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.
RE: Geo Report pulled from API not matching UI
Hi Chris, Thank you for reaching out. As requested by my colleague in the forum thread that Nathan posted, could you also send to me your customer ID so I can look into the discrepancy issue further? You may reply using the Reply privately to author option. Best regards, Peter Google Ads API Team ref:_00D1U1174p._5001UCancA:ref -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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/3cyel0PU3VG900MybQBT6JTnycTAVCJmpbdQ%40sfdc.net.
