Re: error trying to get metrics.phone_calls for customer
You should update your doc then, as it's shown as Selectable in the doc in the Customer. :) But thanks for the confirmation! On Thursday, April 27, 2023 at 5:03:29 a.m. UTC-4 Google Ads API Forum Advisor wrote: > Hi, > > Thank you for raising this concern to the Google Ads API support team. > > Regarding your concern, please note that the metrics.phone_calls is not a > compatible/selectable metric for the customer report and this is the reason > why you are getting the said error. Kindly note that for you to know what > fields that are compatible or selectable to a specific report, you will > need to select the '*Yes it is*' option in the dropdown of a specific > report. I would suggest using the *customer_query_builder* ( > https://developers.google.com/google-ads/api/fields/v13/customer_query_builder) > > as this will greatly help you build and validate your query. > > Let us know if you have further questions. > > Regards, > [image: Google Logo] Google Ads API Team > > ref:_00D1U1174p._5004Q2kqou6:ref > -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@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 "Google Ads API and AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/e4f31442-913a-4983-a24e-a2c9f2271dcbn%40googlegroups.com.
RE: error trying to get metrics.phone_calls for customer
Hi, Thank you for raising this concern to the Google Ads API support team. Regarding your concern, please note that the metrics.phone_calls is not a compatible/selectable metric for the customer report and this is the reason why you are getting the said error. Kindly note that for you to know what fields that are compatible or selectable to a specific report, you will need to select the 'Yes it is' option in the dropdown of a specific report. I would suggest using the customer_query_builder (https://developers.google.com/google-ads/api/fields/v13/customer_query_builder) as this will greatly help you build and validate your query. Let us know if you have further questions. Regards, Google Ads API Team ref:_00D1U1174p._5004Q2kqou6:ref -- -- =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~ 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 adwords-api@googlegroups.com To unsubscribe from this group, send email to adwords-api+unsubscr...@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 "Google Ads API and AdWords API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/JmuMm0RTRNT300OvF4Vm3JQA2FzgBdVkPeIg%40sfdc.net.
Error trying to get metrics.phone_calls for customer
Hey folks,
We're trying to fetch the number of phone calls (metrics.phone_calls) on a
customer level with this query:
```
SELECT
metrics.phone_calls
FROM customer
WHERE segments.date >= '2021-01-01'
AND segments.date <= '2023-01-28'
```
We're getting this error:
{"error"=>{"code"=>400, "message"=>"Request contains an invalid
argument.", "status"=>"INVALID_ARGUMENT",
"details"=>[{"@type"=>"type.googleapis.com/google.ads.googleads.v13.errors.GoogleAdsFailure",
"errors"=>[{"errorCode"=>{"queryError"=>"PROHIBITED_METRIC_IN_SELECT_OR_WHERE_CLAUSE"},
"message"=>"Cannot select or filter on the following metrics:
'phone_calls'(could not support requested resources: 'CUSTOMER'), since
metric is incompatible with the resource in the FROM clause or other
selected segmenting resources."}], "requestId"=>"HIDDEN_FOR_YOU_FOLKS"}]}}
But it should work, according to the doc
:
[image: Screenshot 2023-04-26 at 7.21.39 PM.png]
Which one is wrong, and which one is right?
I guess there is always the workaround of getting it on the campaign level
and adding them all, but it's not ideal, if it should be supported anyways.
Thanks! :)
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 adwords-api@googlegroups.com
To unsubscribe from this group, send email to
adwords-api+unsubscr...@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
"Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to adwords-api+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/adwords-api/f4eacf83-23ff-4750-9cca-b615abc8a71cn%40googlegroups.com.
