gender view problem consultation

[bing li]

hi, I can't find out the data through the following sql, may I ask why?

account_id :  1028394798

SELECT customer.id, campaign.id, ad_group.id, ad_group_criterion.criterion_id, segments.ad_network_type, segments.conversion_action, segments.conversion_action_category, segments.conversion_action_name, segments.device, segments.external_conversion_source, metrics.all_conversions, metrics.all_conversions_value, metrics.conversions , metrics.conversions_value, metrics.cross_device_conversions, metrics.view_through_conversions FROM gender_view WHERE segments.date BETWEEN '2022-10-18' AND '2022-10-25'

[Google Ads API Forum Advisor]

Hi Bing,

This is Carmela from the Google Ads API team. 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._5004Q2fnofB:ref