PROHIBITED_METRIC_IN_SELECT_OR_WHERE_CLAUSE for conversion_last_conversion_date

[Alexander]

The query builder (https://developers.google.com/google-ads/api/docs/query/interactive-gaql-builder) gave me following output:

 

SELECT
     metrics.conversion_last_conversion_date
FROM
    customer
LIMIT

    100




But the java-client-library gives me following error: query_error: PROHIBITED_METRIC_IN_SELECT_OR_WHERE_CLAUSE


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





How can I select metrics.conversion_last_conversion_date?





[Michael Ladewig]

similar issue here.

[googleadsapi...@google.com]

Hello,

Thanks for reporting this issue. Our documentation also states that this field should be selectable with customer, so it looks like this is unintended. I am investigating and will post here again when I have any information to share.

Regards,

Mike, Google Ads API Team

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
    https://ads-developers.googleblog.com/search/label/google_ads_api
    https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscribe@googlegroups.com
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 "AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscribe@googlegroups.com.
Visit this group at https://groups.google.com/group/adwords-api.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/6e081237-28c0-4d53-a53b-d000c6202873%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[googleadsapi...@google.com]

Hello,

To determine what metrics are selectable with a given entity type, we actually need to look at that entity type's documentation. For example, for customer, look here: https://developers.google.com/google-ads/api/docs/fields/customer#customer

And then expand the "Metrics" section. You'll see that conversion_last_conversion_date doesn't actually appear in that list, which means it is not selectable from a report using "FROM customer".

We are going to work on improving the documentation for the "selectable with" section to try to avoid this kind of confusion in the future.

Regards,

Mike, Google Ads API Team

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
    https://ads-developers.googleblog.com/search/label/google_ads_api
    https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

[Alexander]

Thank you.

According to

https://developers.google.com/google-ads/api/docs/fields/metrics#metricsconversion_last_conversion_date

it should be selectable with customer (no other resource is in the "selectable with" list). So if it is not selectable with customer, is it selectable at all?

[googleadsapi...@google.com]

Hello,

As I mentioned:

To determine what metrics are selectable with a given entity type, we actually need to look at that entity type's documentation. For example, for customer, look here: https://developers.google.com/google-ads/api/docs/fields/customer#customer

The "selectable with" drop down lists what other entities can be selected in the same query, not what entities can be used in the FROM clause with that field. So you can select customer fields along with this field if they are both example in the same report type, but you can't select this field from the customer report type.

We are working on improving this documentation.

Regards,

Mike, Google Ads API Team 

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
    https://ads-developers.googleblog.com/search/label/google_ads_api
    https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscribe@googlegroups.com
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 "AdWords API and Google Ads API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscribe@googlegroups.com.
Visit this group at https://groups.google.com/group/adwords-api.

To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/0bb96cdc-bea5-4715-b89e-3af992366e2d%40googlegroups.com.

[Imp Lin]

I am using "googleads-api-v2"

Also encountered the same problem

When is it repaired?

googleadsapi-forumadvisor於 2019年4月10日星期三 UTC+8上午3時07分11秒寫道：

Hello,

As I mentioned:

To determine what metrics are selectable with a given entity type, we actually need to look at that entity type's documentation. For example, for customer, look here: https://developers.google.com/google-ads/api/docs/fields/customer#customer

The "selectable with" drop down lists what other entities can be selected in the same query, not what entities can be used in the FROM clause with that field. So you can select customer fields along with this field if they are both example in the same report type, but you can't select this field from the customer report type.

We are working on improving this documentation.

Regards,

Mike, Google Ads API Team 

=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog and discussion group:
    https://ads-developers.googleblog.com/search/label/google_ads_api
    https://developers.google.com/adwords/api/community/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~

[Alexander]

Actually, it is easy. According to https://developers.google.com/google-ads/api/fields/v2/metrics,

conversion_last_conversion_date IS ONLY selectable with resource "customer". But since it is not in the metrics-list of "customer" ( https://developers.google.com/google-ads/api/fields/v2/customer ), it is also NOT selectable FROM "customer".

Apperently, this is not considered a bug. Just a metric you can't select in any query.

[Imp Lin]

So the data for this indicator

The current API is not available and data cannot be obtained.

right?

Alexander於2019年7月14日星期日UTC + 8上午2時55分41秒寫道：

實際上，這很容易。根據https://developers.google.com/ google-ads / api / fields / v2 / metrics，

conversion_last_conversion_date IS ONLY selectable with resource "customer". But since it is not in the metrics-list of "customer" ( https://developers.google.com/google-ads/api/fields/v2/customer ), it is also NOT selectable FROM "customer".

顯然，這不是一個錯誤。只是您無法在任何查詢中選擇的指標。

[Google Ads API Forum Advisor Prod]

Hi,

The data for the conversion_last_conversion_date  field is not selectable from the customer resource. Let us know if you need additional information.

Regards,
Nikisha Patel, Google Ads API Team

ref:_00D1U1174p._5001U8L4Fh:ref