Metro ids nowhere to be found inside Geo target csv

115 views
Skip to first unread message

Alin Baicu

unread,
Apr 26, 2023, 10:11:02 AM4/26/23
to Google Ads API and AdWords API Forum
Hello,

We query the geo performance metrics report, we get 5 levels to test the daily performance (country_territory, region, metro, city, and  most_specific_location), after we get the geo-locations ids we try to get their names in order to have a better understanding and further analysis. We failed to find the metro_ids in the csv geo targets. The metro ids are only available in the LocationCriterionService?

Google Ads API and AdWords API Forum

unread,
Apr 26, 2023, 10:35:22 AM4/26/23
to Google Ads API and AdWords API Forum
Re-posting the last inquiry (https://groups.google.com/g/adwords-api/c/7L4VN2vwkwg) from the forum as it wasn't routed to our support queue.

Regards,
Google Ads API Team

Google Ads API and AdWords API Forum

unread,
Apr 26, 2023, 10:44:54 AM4/26/23
to Google Ads API and AdWords API Forum
Hi,

I am from the Google Ads API support team.

Regarding this issue, please note that the Google Ads API mirrors the Google Ads UI. Meaning the Google Ads API should be able to manage and retrieve the data that the Google Ads UI shows. In order for our team to better check and investigate this issue on our end, can you provide the below data?
  • Provide the complete request and response logs with request ID and request header generated on your end.
  • Complete screenshots (without cropping) from the Google Ads UI/Interface showing the data you want to retrieve via the Google Ads API

You may then send the requested logs via the Reply privately to author option. If this option is not available, you may send the details directly to our googleadsa...@google.com alias instead.

In addition, since this is specifically about reporting, I would suggest referring to our Reporting and Reports guides for more information about this.

Links included in this email:

Regards,
Google Ads API Team
On Wednesday, April 26, 2023 at 10:11:02 PM UTC+8 aba...@grubhub.com wrote:

Alin Baicu

unread,
Apr 27, 2023, 5:09:24 AM4/27/23
to Google Ads API and AdWords API Forum
Hi, 

This is not a problem of a request is more like a question, I want to know if, in the geo target csv https://developers.google.com/static/google-ads/api/data/geo/geotargets-2023-03-28.csv.zip , I can find segments.geoTargetMetro.

Google Ads API Forum Advisor

unread,
Apr 27, 2023, 9:09:06 AM4/27/23
to adwor...@googlegroups.com

Hi,

Thanks for reaching out to Google Ads Forum.

With regards to your concern, can you confirm if you want to retrieve the metro ID using the CSV of geo targets? If so, please note that under the CSV of geo target the following fields are listed in the geo target columns documentation. 

Moreover, can you confirm if you want to use the segments.geo_target_metro using the geo_target_constant? If so, please note that the segments.geo_target_metro is not available on this report type. However, there are multiple report types with segments.geo_target_metro fields. 

Please note that Google Ads API mirrors the Google Ads UI. Meaning by using the Google Ads API, you can get and manage the data that you are seeing in the UI. 

With that being said, can you provide us with the full (not cropped) and non-redacted screenshot of the Google Ads UI data that you want to retrieve in Google Ads API? This is for us to be able to perform and to replicate the data on our side.

You may then send the requested information via the Reply privately to the author option. If this option is not available, you may send the details directly to our googleadsa...@google.com alias instead.



Links included in this email:

Alin Baicu

unread,
Apr 27, 2023, 10:12:36 AM4/27/23
to Google Ads API and AdWords API Forum
To provide more context, we are currently utilizing the Google Ads API and leveraging the google_ads_service.search_stream function to retrieve a dataset that includes the segments.geoTargetMetro field. It's worth noting that this particular column only provides the ID of the metro and not its corresponding name.

We attempted to cross-reference this ID with the CSV file of geo targets; however, we were unable to locate the corresponding metro names in this file. As a result, we are now facing the question of where we can find a mapping between the metro IDs and their respective names.

One possible solution we are considering is querying the GeoTargetConstantService, which is the new service for obtaining locationCriterion data. This approach may provide us with the necessary information to map the metro IDs to their corresponding names.
Reply all
Reply to author
Forward
0 new messages