Google Ads API Beta Python - Query a keyword's quality score and conversion rate

[Ky Nguyen]

Hi, I'm currently trying to retrieve a keyword's quality score and or conversion rate and was wondering if there was a specific resource I can query.

Thank you,

Ky

[Google Ads API Forum Advisor Prod]

Hi Ky,

Thank you for reaching out to us. For a keyword's quality score, could you show me a screenshot of what quality score you want to retrieve from the UI? For the conversion rate, there is the conversions from interactions rate from the keywords report in Google Ads API. Let me know if you have further questions.

Thank you,
Bryan, Google Ads API Team

ref:_00D1U1174p._5004Q1zpic2:ref

[Ky Nguyen]

Thanks for the help, Bryan! I've attached a screenshot of the quality score I'm trying to retrieve.

[Google Ads API Forum Advisor Prod]

Hi Ky,

I've taken a look and can see that Keywords Reports has a Quality Score field, and to retrieve it, you need to query ad_group_criterion.quality_info.quality_score. For your convenience, if you're having trouble writing the query, you can use this interactive query builder at your convenience. Let me know if you have further questions.

[Ky Nguyen]

Thanks so much, Bryan!

[Ky Nguyen]

Hi Bryan,

Wanted to follow up on this resource. I just wanted to double check that it's behaving as I'm expecting it to with the query:

'SELECT ad_group.id, '

       'ad_group_criterion.criterion_id, '

       'ad_group_criterion.keyword.text, '

       'metrics.conversions_from_interactions_rate, '

       'ad_group_criterion.quality_info.quality_score '

  'FROM keyword_view '

 'WHERE ad_group_criterion.type = KEYWORD '

   'AND ad_group_criterion.status = ENABLED '

Would ad_group_criterion.quality_info.quality_score.value and metrics.conversions_from_interactions_rate.value always return 0 if the keyword hasn't shown any conversion? In the Ads UI, quality score is shown as a dash indicating no value while conversion rate shows 0%, so I just wanted to confirm that it will always return 0.

Thank you!

On Monday, May 18, 2020 at 1:22:52 PM UTC-7, adsapiforumadvisor wrote:

[Google Ads API Forum Advisor Prod]

Hi Ky,

Thank you for the update. Yes, it should show a zero, but if there is not enough information then the field will not be populated for both fields. Let me know if you have further questions.