what are the views that support "metrics.biddable_app_install_conversions", "metrics.biddable_app_post_install_conversions"

[Vinay Kumar]

In the API, it was given that Customer View will support the following metrics: 

biddable_app_install_conversions
biddable_app_post_install_conversions

But when we hit these metrics, we are seeing the following error:

Request:

    {

    "query": "SELECT  metrics.biddable_app_install_conversions, metrics.biddable_app_post_install_conversions FROM customer WHERE segments.date >= '2021-10-09' AND segments.date <= '2022-04-06' PARAMETERS omit_unselected_resource_names = true"
}

Error Response:

[

{

"error": {

"code": 400,

"message": "Request contains an invalid argument.",

"status": "INVALID_ARGUMENT",

"details": [

{

"@type": "type.googleapis.com/google.ads.googleads.v10.errors.GoogleAdsFailure",

"errors": [

{

"errorCode": {

"queryError": "PROHIBITED_METRIC_IN_SELECT_OR_WHERE_CLAUSE"

},

"message": "Cannot select or filter on the following metrics: 'biddable_app_install_conversions'(could not support requested resources: 'CUSTOMER'), 'biddable_app_post_install_conversions'(could not support requested resources: 'CUSTOMER'), since metric is incompatible with the resource in the FROM clause or other selected segmenting resources."

}

],

"requestId": "yfHQAeXJhc8Ido0yK0CwSw"

}

]

}

}

]

In API docs it was mentioned that "is customer specified in the FROM clause of the query" as shown in the attachment?. We haven't understood the difference of the dropdown as we always have "customer" in the query. Can you please let us know what is the query to retrieve these metrics? 

Thank you.

VinayV9

[Google Ads API Forum Advisor]

Hi Vinay,

Thank you for reaching out to us.

Upon checking, 'metrics.biddable_app_install_conversions' and ‘metrics.biddable_app_post_install_conversions’ are not a valid field in the SELECT clause when customer is the resource in the FROM clause. Fields in the SELECT must be 'Selectable'.

To see the metrics and segments that can be put in the same SELECT clause as the fields of customer, you can refer to this documentation by clicking “Yes, it is” in the dropdown box.

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

And for the question "In API docs it was mentioned that "is customer specified in the FROM clause of the query" as shown in the attachment?. We haven't understood the difference of the dropdown as we always have "customer" in the query."

- The dropdown box specifies in what part of the query you use the resource (customer). For example, you want to get the selectable fields in the customer, so you will click "Yes, it is" and the compatible fields will be displayed.

Best regards,

Heidi Google Ads API Team

ref:_00D1U1174p._5004Q2ZLl16:ref

[Vinay Kumar]

Thank you for the response, 

Can you please tell me which resources that supports "metrics.biddable_app_install_conversions", "metrics.biddable_app_post_install_conversions"

Thank you,

VinayV9.

[Google Ads API Forum Advisor]

Hi Vinay,

Thank you for reaching out to the Google Ads API support team.

The "metrics.biddable_app_install_conversions" and "metrics.biddable_app_post_install_conversions" field supported in the ad_group_ad_assest_view report. You can use query validator tools. Let me know if you have any question.

Thanks,

Nirmita Google Ads API Team

ref:_00D1U1174p._5004Q2ZLl16:ref