This query is not showing country name, it is showing country_criterion_id. Any way we can map it to country name?
On Friday, June 13, 2025 at 11:49:56 AM UTC+5:30 Google Ads API Forum Advisor wrote: > Hi, > > Please note that *campaign* > <https://developers.google.com/google-ads/api/fields/v20/campaign> and > *geographic_view* > <https://developers.google.com/google-ads/api/fields/v19/geographic_view> > are distinct reports, and their data should not be compared. If you try to > compare the data between these two reports, obviously it will show > different records. As we informed earlier, the *geographic_view* > <https://developers.google.com/google-ads/api/fields/v19/geographic_view> > report can be utilized to retrieve matched locations. Please refer to the > below query: > > > SELECT geographic_view.country_criterion_id, geographic_view.location_type, > geographic_view.resource_name, campaign.id, campaign.name, metrics.clicks, > metrics.impressions, metrics.ctr, metrics.average_cpc, metrics.cost_micros, > metrics.conversions_from_interactions_rate, metrics.conversions, > metrics.cost_per_conversion, segments.date FROM geographic_view WHERE > segments.date BETWEEN '2017-05-09' AND '2025-06-12' > > Based on the provided screenshot, it appears that data is being fetched at > the manager account level, which aggregates data from all client accounts. > To accurately retrieve the geographic_view report, it is necessary to > utilize each individual client account and subsequently compare the data > between the Google Ads UI and the data returned via the Google Ads API. > > If you are still facing discrepancy in the data, kindly provide us with > customer ID with complete API logs (*request* > <https://developers.google.com/google-ads/api/docs/concepts/field-service#request> > > and *response* > <https://developers.google.com/google-ads/api/docs/concepts/field-service#response> > > logs with *request-id* > <https://developers.google.com/google-ads/api/docs/concepts/call-structure#request-id> > > and *request header* > <https://developers.google.com/google-ads/api/docs/concepts/call-structure#request_headers>) > > generated at your end and the uncropped UI screenshot of Google Ads account > displaying the matched location. > > Thanks, > > [image: Google Logo] Google Ads API Team > Feedback > How was our support today? > > [image: rating1] > <https://docs.google.com/forms/d/e/1FAIpQLSeRhIg5VeThVmbcD0c5DTWTDjmpJuSktN8vFelEL7_KV_Orbg/viewform?usp=pp_url&entry.141427034=1&entry.295079254=500Ht00001reLw4IAE> > > [image: rating2] > <https://docs.google.com/forms/d/e/1FAIpQLSeRhIg5VeThVmbcD0c5DTWTDjmpJuSktN8vFelEL7_KV_Orbg/viewform?usp=pp_url&entry.141427034=2&entry.295079254=500Ht00001reLw4IAE> > > [image: rating3] > <https://docs.google.com/forms/d/e/1FAIpQLSeRhIg5VeThVmbcD0c5DTWTDjmpJuSktN8vFelEL7_KV_Orbg/viewform?usp=pp_url&entry.141427034=3&entry.295079254=500Ht00001reLw4IAE> > > [image: rating4] > <https://docs.google.com/forms/d/e/1FAIpQLSeRhIg5VeThVmbcD0c5DTWTDjmpJuSktN8vFelEL7_KV_Orbg/viewform?usp=pp_url&entry.141427034=4&entry.295079254=500Ht00001reLw4IAE> > > [image: rating5] > <https://docs.google.com/forms/d/e/1FAIpQLSeRhIg5VeThVmbcD0c5DTWTDjmpJuSktN8vFelEL7_KV_Orbg/viewform?usp=pp_url&entry.141427034=5&entry.295079254=500Ht00001reLw4IAE> > > [2025-06-13 06:19:05Z GMT] This message is in relation to case > "ref:!00D1U01174p.!500Ht01reLw4:ref" (ADR-00310279) > > > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 visit https://groups.google.com/d/msgid/adwords-api/56c01693-e473-4489-8c36-ff87c58e99e4n%40googlegroups.com.
