geographic_view with ad_name

[Haruma]

Hi, I am currently fetching data from geographic_view, and understand that it could not breakdown by ad_name. Is there any possible table/query, that i can use to get ad_name as well as the geo information in single request?

Thanks,

[Google Ads API Forum Advisor]

Hi,

Thanks for reaching out to the Google Ads API Forum.

Kindly note that the geographic_view report can not pull the data by Ad level. However, if you’re expecting data that you see in the Google Ads UI showing ad_name or Ad level data as well as the geo information, then you may provide us with a complete Ads UI screenshot without cropping showing the fields data along with the customer Id, so we provide specific recommendations.

Please send a screenshot via reply privately to author option.

Regards,

Yasar Google Ads API Team

ref:_00D1U1174p._5004Q2dx72k:ref

[Hulma Abdul Rahman]

Hi, I could not find geo information along with ad_name in the google ads UI hence I am trying extract the information from the API. 

Currently the query that i am using is

Select 
  customer.descriptive_name,
  ad_group.name,
  campaign.name,
  metrics.impressions,
  geographic_view.country_criterion_id,
  metrics.cost_micros,
  metrics.clicks,
  segments.date,
  customer.currency_code,
  metrics.conversions_value,
  metrics.conversions,
  campaign.advertising_channel_type
From geographic_view

I need to extract one more attribute which is ad_name and understand that I cannot use geograhic_view to get ad_name attributes. 

So, could you advise any other report that I can use?

Thanks,

[Hulma Abdul Rahman]

Also would like to add that I tried to use Ad Group Ad report.

SELECT
  ad_group_ad.ad.name,
  ad_group.name,
  campaign.name,
  metrics.impressions, 

  ad_group_ad.ad.call_ad.country_code, 

  metrics.cost_micros, 
  metrics.clicks, 

  segments.date, 
  customer.currency_code,
  metrics.conversions_value,
  metrics.conversions,
  campaign.advertising_channel_type
FROM ad_group_ad

However, it didnt return the country code attributes (not sure why).

[Chad Wood]

Looks like you requested the currency code by mistake, unless you planned to map currency codes to country codes. That wouldn't be perfect, but better than nothing I suppose.

I see it has been about 2-3 months. Did you find a solution? I am facing a very similar problem.

[Google Ads API Forum Advisor]

Hi Chad,

I am Sherwin from Google Ads API and I hope that all of you are doing well today.

Moving forward to your concern, since you mentioned that you are having the same problem, could you please provide us the complete request and response logs with request ID and request header generated on your end? If you haven't enabled the logging yet, logging can be enabled by navigating to the Client libraries > Your client library (ex. Java) > Logging documentation, which you can access from this link.

Please provide the requested logs via Reply privately to the author option. If this option is not available, then send it instead on this email address googleadsa...@google.com. 

Kind regards,

Sherwin Vincent Google Ads API Team

ref:_00D1U1174p._5004Q2dx72k:ref