Metrics missing or null values

[Werner Reyneke]

I need to extract the following columns from my GAQL query below. I only get values for certain columns and other columns I have no idea where to find.

Columns required:

Campaign Name, I only get the ID; Ad group name - I only get the ID; Status - such as Eligible(Limited) Below first page bid(ARS1.56); Max. CPC; Avg. CPC; Cost, CPC; SearchImpresssionShare; SearchExactMatchIS; Quality Score; Conversions, Cost/Conversion, Conversion Rate, Label.

My query:
select segments.date, ad_group.id, campaign.id, ad_group_criterion.criterion_id, ad_group_criterion.keyword.text,ad_group_criterion.keyword.match_type,metrics.clicks, metrics.search_absolute_top_impression_share, metrics.search_impression_share, metrics.historical_landing_page_quality_score,metrics.ctr,metrics.impressions from keyword_view where metrics.clicks > 1 and metrics.ctr > 0 and metrics.impressions > 1 and segments.date between '2021-11-30' and '2022-01-31'

Thanks :)

Werner

[Google Ads API Forum Advisor]

Hi Werner,

Thank you for reaching out to the Google Ads API support team.

With regards to your concern, you can check report migration guide. You can query all of that info from the Keywords_view report and you can pull fields from the reports in the "attributed resources”. You may use the query validator tools. Let me know if you have any question.

Thanks,

Nirmita Patel Google Ad API Team

ref:_00D1U1174p._5004Q2W4JgO:ref