Adding Metro area in the query is not returning any result

[anirudh maddy]

Below is the query I'm using to fetch data from the API for Locations Report

SELECT  customer.currency_code, campaign.name, segments.geo_target_metro, segments.geo_target_region, segments.geo_target_city,  metrics.clicks, metrics.impressions, metrics.cost_micros FROM geographic_view

When I run the below query I'm getting data from the API. 

SELECT  customer.currency_code, campaign.name, segments.geo_target_region, segments.geo_target_city,  metrics.clicks, metrics.impressions, metrics.cost_micros FROM geographic_view

Adding 

segments.geo_target_metro

metric is causing some problem. I'm not getting any data if I add the metric. 

I'm applying for Standard Access, as per the guidelines, "segments.geo_target_metro" metric is mandatory for showing Location Reports.  

I'm stuck with this, how do I proceed further?

[Google Ads API Forum Advisor Prod]

Hi Anirudh,

Thank you for reaching out. Could you please share the client customer Id for which you are running the shared report query for me to investigate further? Please use Reply privately to author option while replying.

Regards,
Nikisha Patel, Google Ads API Team

ref:_00D1U1174p._5001UHF5JP:ref