Need assistance in fetching the Quality score and Impression share metrics from Google ads

[anu varghese]

Hi Team,

Can you kindly assist me in building a query in GAQL to fetch the quality score and impression share?. Thanks in advance.

Regards,

Anu

[Google Ads API Forum Advisor]

Hi Anu,

Thank you for reaching out to Google Ads API support. We have impression share metrics and quality score, for example the campaign resource has metrics.historical_creative_quality_score and metrics.search_impression_share. The campaign report has a GAQL query generator you can access by clicking on the "Help me build a query" button at top of page, just like every other report resource in the API has a query generator.

Could you privately send us a full screen screenshot of the Ads UI of a report that you want to replicate in the API?

Regards,

Aryeh Google Ads API Team

ref:_00D1U1174p._5004Q2d4pts:ref

[anu varghese]

Hi Google Support,

Thanks for your response, but I was not able to find metrics.historical_creative_quality_score in the campaign resource. When I validated the query I am getting this error as well.

I've run into an issue with the Google Ads Query Validator and need some help debugging.

  * API Version: v11

  * Query: "SELECT metrics.search_impression_share,metrics.historical_creative_quality_score FROM campaign"

  * Result: Invalid Query (errors below)

    * 'metrics.historical_creative_quality_score' is not a valid field in the SELECT clause when 'campaign' is the resource in the FROM clause. Fields in the SELECT must be 'Selectable'.

  * Link to query result: https://gaql-query-builder.uc.r.appspot.com/v11/share?q=SELECT%20metrics.search_impression_share%2Cmetrics.historical_creative_quality_score%20FROM%20campaign


Thanks!

[Google Ads API Forum Advisor]

Hi Anu,

Thank you for getting back to us.

Moving forward to your concern, the reason why you are encountering the invalid query error is because the metrics.historical_creative_quality_score is not a SELECTABLE field for the campaign report. 

Kindly note that for you to know what fields are compatible or selectable to a specific report, you will need to select 'Yes it is' option in the dropdown of a specific report. That being said, in the campaign report, you will need to select the  'Yes it is' option in this dropdown and you will see that 'metrics.historical_creative_quality_score' is not a selectable field for the said report.

Since the quality score metric is specific to keyword_level, then I would suggest using the keyword_view report and SELECT the metrics.search_impression_share and metrics.historical_quality_score or metrics.historical_creative_quality_score. 

Regards,

Carmela Google Ads API Team

ref:_00D1U1174p._5004Q2d4pts:ref

[Anu Varghese]

Hi Team,

 

Thank you for the response.

 

In the query builder I gave the query as “SELECT campaign.name, campaign.id, campaign.start_date, metrics.search_impression_share,metrics.historical_quality_score FROM keyword_view WHERE segments.date >= '2022-01-01' AND segments.date <= '2022-01-15'”

And got the below response

 

 

Also the metrics object in the response was null,

 

I am unable to find the response received for impression share and quality score . Please help.

 

Regards,

Anu

Carmela Google Ads API Team

ref:_00D1U1174p._5004Q2d4pts:ref

___________________________________
The information contained in this communication is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. It may contain confidential or legally privileged information. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by responding to this email and then delete it from your system. EY is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt.