Conversions value per cost (ROAS) - Cannot select or filter

[Hubert Jaworski]

Hey there!

I query the Google Ads API for some reporting metrics.

The Campaign Resource DOES list metrics.conversions_value_per_cost as available:

https://developers.google.com/google-ads/api/fields/v10/campaign#metrics.conversions_value_per_cost

But I get the following error:

error_code {
    query_error: PROHIBITED_METRIC_IN_SELECT_OR_WHERE_CLAUSE
  }
  message: "Cannot select or filter on the following metrics: \'conversions_value_per_cost\'(could not support requested resources: \'CAMPAIGN\'), since metric is incompatible with the resource in the FROM clause or other selected segmenting resources."

Here's the query:

SELECT 

segments.device, 

metrics.impressions, 

metrics.clicks, 

metrics.ctr, 

metrics.average_cpc, 

metrics.cost_micros, 

metrics.conversions, 

metrics.conversions_value, 

metrics.conversions_value_per_cost, 

metrics.conversions_from_interactions_rate, 

metrics.search_impression_share, 

metrics.search_rank_lost_impression_share, metrics.search_budget_lost_impression_share 

FROM campaign 

WHERE segments.date BETWEEN '2022-05-16' AND '2022-05-22' 

AND campaign.advertising_channel_type = 'SEARCH' 

AND campaign.name LIKE "%MyPattern%"

The Google Ads UI does have this metric, so I guess I'm missing something here?

[Google Ads API Forum Advisor]

Hi Hubert,

Thank you for raising your concern to the team.

Upon checking our document, I can see that it should be supported for the said report type. However, you've encountered the error where it says that the field is not compatible with the said report type. Also, I tried it in the query validator and I can see the same error.

With this, so that I can further investigate or raise it to the team, would you be able to provide the complete request and response logs with request ID and request header generated on your end? You can provide it via Reply privately to author option. If this option is not available, then send it instead on this email address googleadsa...@google.com.

Regards,

Ernie John Google Ads API Team

ref:_00D1U1174p._5004Q2bDLrx:ref

[Hubert Jaworski]

How do I do that in Python?

Here's a snippet of how I use the Python library to send requests to the API:

ga_service = googleads_client.get_service("GoogleAdsService")
search_request = googleads_client.get_type("SearchGoogleAdsStreamRequest")
search_request.customer_id = customer['id']
search_request.query = query
search_request.summary_row_setting = googleads_client.get_type(
'SummaryRowSettingEnum').SummaryRowSetting.SUMMARY_ROW_WITH_RESULTS

stream = ga_service.search_stream(search_request)

for batch in stream:

(...)

Not quite sure how to obtain the complete logs here :(

[Google Ads API Forum Advisor]

Hi Hubert,

Thank you for the reply.

For you to check if you have an API logs, note that this can be requested or provided to the developer handling the Google Ads API transactions when logging of the API requests has been enabled.

This is the specific guideline for Python to enable it.

• Python - https://developers.google.com/google-ads/api/docs/client-libs/python/logging

You may then send the requested information via the Reply privately to author option. If this option is not available, you may send the details directly to our googleadsa...@google.com alias instead.

Best regards,

Heidi Google Ads API Team

ref:_00D1U1174p._5004Q2bDLrx:ref

[Zeyuan Gu]

Hey, 

Were you able to pull roas (conversion_value_per_cost) from campaigns? 

[Google Ads API Forum Advisor]

Hi Zeyuan,

Thank you for reaching out to us.

Kindly note that 'metrics.conversions_value_per_cost' 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.

However, to see the attributed resource fields that can be put in the same SELECT clause as the fields of campaign report, you can refer to its query builder. You can freely see the selectable fields in the “Choose a Clause to Select From” section.

I would also recommend that you use the Google Ads Query Builder and Query Validator tools for constructing queries.

You may see the links below for the emphasized words from the above statement:

• metrics.conversions_value_per_cost: https://developers.google.com/google-ads/api/fields/v13/campaign#metrics.conversions_value_per_cost
• campaign: https://developers.google.com/google-ads/api/fields/v13/campaign
• campaign query builder: https://developers.google.com/google-ads/api/fields/v13/campaign_query_builder
• Google Ads Query Builder: https://developers.google.com/google-ads/api/fields/v13/overview_query_builder?hl=en
• Query Validator: https://developers.google.com/google-ads/api/fields/v13/query_validator?hl=en

Best regards,

Google Ads API Team

ref:_00D1U1174p._5004Q2bDLrx:ref