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 On Wednesday, November 16, 2022 at 4:51:21 PM UTC+8 Max wrote: > Hi, > > I have two reports in the UI. Following are the fields of the reports: > > > > > > > > > > *CampaignAd groupCountry/Territory (User location)City (User > location)DayCurrency codeImpr.ClicksConversionsCost* > > > > > > > > > > > > > *CampaignAd groupCountry/Territory (Matched)City (Matched)DayCurrency > codeImpr.ClicksConversionsCost* > > 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 <http://campaign.id>,* > * campaign.name <http://campaign.name>,* > * ad_group.id <http://ad_group.id>,* > * ad_group.name <http://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 > > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 "Google Ads API and AdWords 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/d0c76474-dca1-4967-983b-754dc611aeb5n%40googlegroups.com.
