hi age_range_view Query questions

[bing li]

When I use the sql query below, no data is returned.May I ask why?

account_id 1001022441

SELECT customer.id, campaign.id, ad_group.id, ad_group_criterion.criterion_id, bidding_strategy.id , segments.ad_network_type, segments.device,  metrics.active_view_impressions, metrics.active_view_measurability , metrics.active_view_measurable_cost_micros, metrics.active_view_measurable_impressions, metrics.active_view_viewability, metrics.all_conversions, metrics.all_conversions_value , metrics.clicks, metrics.conversions, metrics.conversions_value, metrics.cost_micros, metrics.cross_device_conversions , metrics.engagements, metrics.gmail_forwards, metrics.gmail_saves, metrics.gmail_secondary_clicks, metrics.impressions , metrics.interactions, metrics.video_quartile_p100_rate, metrics.video_quartile_p25_rate, metrics.video_quartile_p50_rate, metrics.video_quartile_p75_rate , metrics.video_views, metrics.view_through_conversions FROM age_range_view WHERE metrics.impressions > 0 AND segments.date BETWEEN '2022-10-10' AND '2022-10-20

[Google Ads API Forum Advisor]

Hi,

This is Carmela from the Google Ads API. Thank you for reaching out.

With regard to your concern, I've replicated your query on my end and I also got an empty result. Then, I've tried removing the segments in your query and I already got results. Having said that, as per this documentation, kindly note that when adding some segments, the metrics in the summary row may decrease. It says here that for example:

• When segments.keyword.info.match_type is added to a query with FROM ad_group_ad, that segment is telling the query to only get the rows of data that have keywords, and remove any row that is not associated with a keyword. In this case, the metrics would be lower because it would exclude any non-keyword metrics.

Regards,

Carmela Google Ads API Team

ref:_00D1U1174p._5004Q2cOkhJ:ref