campaign conversions_value_per_cost not available

[Quentin]

Hello,

I am trying to get the field conversions_value_per_cost in my campaigns report but it doesn't work.

It seems like it should be available :

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

A basic query for reproduction : 

SELECT

metrics.conversions_value_per_cost

FROM

campaign

Result : 

GoogleAdsError {

error_code: [ErrorCode],

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."

}

I might be doing something wrong.

Thank you for any insight,

[Google Ads API Forum Advisor]

Hi Quentin,

Thank you for reaching out to our API support team.

The metrics.conversions_value_per_cost unfortunately is not available when the campaign resource is specified in the FROM clause.

When constructing queries, we recommend using the query builder tool instead (see here for campaign resource specific query builder), since this tool should already provide indicators of supported fields during the construction of the query.

I hope this helps.

Best regards,

Peter Laurence Google Ads API Team

ref:_00D1U1174p._5004Q2gPLiR:ref

[Quentin]

thank you for your answer. 

I ended up doing all_conversion_value / cost  which is the same thing seems like.

Best,