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?


-- 
-- 
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
--- 
You received this message because you are subscribed to the Google Groups 
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/adwords-api/032e618e-a782-49ab-91ec-90a69b492fc2n%40googlegroups.com.

Reply via email to