Unable to Extract State or Location Column with Campaign, Ad Group, Ad Group Ads, and Metrics in Google Ads Using API Call

[digitalreachpremium premium]

Hi

I am writing to seek assistance regarding an issue I am facing with extracting state or location information along with campaign, ad group, ad group ads, and their respective metrics in Google Ads using the API call.

Despite my efforts, I have encountered challenges in retrieving the desired state or location data along with the mentioned entities and their metrics through API calls to the Google Ads platform.

I have thoroughly reviewed the documentation and explored various approaches, but unfortunately, I have been unable to find a solution to this problem.

If any of you have encountered a similar issue in the past or have insights into how to resolve this matter, I would greatly appreciate your guidance and assistance.

Your expertise and input would be invaluable in helping me overcome this obstacle and achieve my objectives in utilizing the Google Ads API effectively.

Thank you very much for your attention to this matter. I look forward to your response and any assistance you may be able to provide.

thanks 

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads API Support team.

Please refer to this example GAQL query on how to retrieve Locations information along with the campaign resource and their metrics using the Google Ads API. Also, a location view summarizes the performance of campaigns by Location criteria. It's attributed with the campaign resource, so it's not possible to retrieve the ad group and ad group ad resource metrics along with the location information. 
 

This message is in relation to case "ref:!00D1U01174p.!5004Q02tOsKV:ref" (ADR-00229995)

Thanks,
 

Google Ads API Team

[digitalreachpremium premium]

hi

I need county, State, city details, data type of   campaign_criterion.location.geo_target_constant is RESOURCE NAME, how to extract string content from it

[Google Ads API Forum Advisor]

Hi,

In order to assist you further, kindly provide us with the uncropped UI screenshot of the fields that you want to retrieve via the Google Ads API.

You can send the details via Reply privately to the author option, or direct private reply to this email.