How to get zip code data from Search Ads 360 API

[Lu Liu]

Hi,

I am new in using SA360 API.  I am looking for help to get geo location data, specifically US zip code and DMA (if available) data through API to Power BI.  

I see 2 geo related resources, but they don't seem to have zip level data.

geo_target_constant  |  Search Ads 360 Reporting API (beta)  |  Google for Developers

location_view  |  Search Ads 360 Reporting API (beta)  |  Google for Developers

Thank you in advance for your help!

Lu

[Lu Liu]

Looking more, I see campaign_criterion has campaign_criterion.location_group.geo_target_constants.  This page shows there is a TARGET TYPE of DMA region in geo_target_constant.

Search Ads 360 Reporting API (beta)  |  Google for Developers

Documentation says fields from Campaign, Customer, user_list may be selected along with this resource in the SELECT and WHERE clause.  

campaign_criterion  |  Search Ads 360 Reporting API (beta)  |  Google for Developers

But I have not figured out how to connect these resources using SELECT query to get geotargeting campaign data.  For example, campaign impressions by DMA.

Can anyone share related syntax?

Thank you,

Lu

[Google Ads API Forum Advisor]

Hi Lu,

Thank you for reaching out to Google Ads API Forum.

Kindly note that this channel and our team provide support for Google Ads API (https://developers.google.com/google-ads/api/docs/start)-related concerns and technical implementations only. Upon checking the links you provided, it appears that you are using Search Ads 360 Reporting API. With this, I recommend reaching out to the Search Ads 360 support team (https://support.google.com/searchads/gethelp?issue_description=contact+us) as they are better equipped to provide guidance regarding your concern.

This message is in relation to case "ref:_00D1U1174p._5004Q2oj4QR:ref"

Thanks,
 

Google Ads API Team

[Lu Liu]

Search Ads help is very limited.  Would you be able to share codes how to get campaign or ad_group impressions and clicks by DMA or postal code from Google Ad api?  I am going to try to use Google Ads to get the data.  Thanks!

[Google Ads API Forum Advisor]

Hi,

Thank you for getting back to us.

Can you please provide us with an uncropped screenshot of the Google Ads UI that shows the data you wish to obtain, so we can provide the appropriate report and fields to recommend? I am asking for this because the Google Ads UI and API mimic each other’s behavior, if the data is available in the UI it should also be available via API.