Google Ads API - Geo location breakdown

[Max]

Hi, 

I have two reports in the UI. Following are the fields of the reports:    

Campaign
Ad group
Country/Territory (User location)
City (User location)
Day
Currency code
Impr.
Clicks
Conversions
Cost                                                                                                                                                                                          

Campaign
Ad group
Country/Territory (Matched)
City (Matched)
Day
Currency code
Impr.
Clicks
Conversions
Cost

I am trying to produce these reports using the geographic_view report (Google Ads API), however, the results (for the impressions, clicks, etc..) differ from the results in the UI reports.

Following is the query I am using:

SELECT

campaign.id,

campaign.name,

ad_group.id,

ad_group.name,

geographic_view.location_type,

geographic_view.resource_name,

metrics.impressions,

metrics.clicks,

metrics.conversions,

metrics.cost_micros,

segments.geo_target_county,

segments.geo_target_city,

segments.date

FROM

geographic_view

WHERE

segments.date BETWEEN XX AND YY

Could you please help me translate these UI reports to the correct queries?

Max

[Google Ads API and AdWords API Forum]

Re-posting the last inquiry [https://groups.google.com/g/adwords-api/c/3VBK4RC97UA] from the forum as it wasn't routed to our support queue.

Regards,
Carmela

Google Ads API Team

[Google Ads API Forum Advisor]

Hi Max,

Thank you for reaching out to our API support team.

The API and UI reports in certain conditions would differ depending on the supported entity types, and also sometimes due to the API's reporting behavior such as segmentation (see also this section). That being said, and in order for our team to have a clearer picture of the discrepancy you are encountering, could you also provide the following details :

• Your customer_id
• Complete screenshot of the Google Ads UI view / report, with all the applied filters, if any.
• The complete (request, response, request-id) logs generated by the API report request.

If you haven't yet, logging can be enabled by referring to this guide, and by using the DEBUG log level setting.

You may then send the requested information via the Reply privately to author option. If this option is not available, you may send the details directly to our googleadsa...@google.com alias instead.

Best regards,

Peter Laurence Google Ads API Team

ref:_00D1U1174p._5004Q2gPMNi:ref