Geo Report pulled from API not matching UI

[Chris]

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!

[Nathan]

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?

[Chris]

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}'

[Google Ads API Forum Advisor Prod]

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