Hey Google Ads Support,
When I make a query FROM campaign, and include
"metrics.all_conversions_from_store_visit" I get an error.
if I remove this metric from the following call, the query is successful! I
am trying to pull store visits, any advice?
below you will find the resulting error log.
Thanks,
Shawn
[2022-02-21T10:20:27.909942-06:00] google-ads.WARNING: Request made: Host:
"googleads.googleapis.com", Method:
"/google.ads.googleads.v10.services.GoogleAdsService/SearchStream",
CustomerId: 2290915083, RequestId: "HtRxzt5TXLs_iVm2qWcs7Q", IsFault: 1,
FaultMessage: "["Cannot select or filter on the following metrics:
'all_conversions_from_store_visit'(could not support requested resources:
'CAMPAIGN'), since metric is incompatible with the resource in the FROM
clause or other selected segmenting resources."]"
[2022-02-21T10:20:27.910456-06:00] google-ads.NOTICE: Request
-------
Method Name:
/google.ads.googleads.v10.services.GoogleAdsService/SearchStream
Host: googleads.googleapis.com
Headers: {
"x-goog-api-client": "gl-php\/8.1.2 gccl\/14.0.0 gapic\/14.0.0
gax\/1.11.4 grpc\/1.43.0 rest\/1.11.4",
"x-goog-request-params": "customer_id=2290915083",
"developer-token": "REDACTED",
"login-customer-id": "4388119023"
}
Request:
{"customerId":"2290915083","query":"SELECT
campaign.advertising_channel_type, campaign.name, segments.date,
customer.currency_code, metrics.cost_micros, metrics.impressions,
metrics.interactions, metrics.interaction_rate, metrics.average_cpc,
metrics.conversions, metrics.conversions_from_interactions_rate,
metrics.all_conversions_from_store_visit FROM campaign WHERE segments.date
>= '2020-08-01' AND segments.date <= '2022-02-20' AND campaign.name =
'performance_max'"}
Response
-------
Headers: {
"request-id": "HtRxzt5TXLs_iVm2qWcs7Q",
"date": "Mon, 21 Feb 2022 16:20:27 GMT",
"alt-svc": "h3=\":443\"; ma=2592000,h3-29=\":443\";
ma=2592000,h3-Q050=\":443\"; ma=2592000,h3-Q046=\":443\";
ma=2592000,h3-Q043=\":443\"; ma=2592000,quic=\":443\"; ma=2592000;
v=\"46,43\""
}
Fault
-------
Status code: 3
Details: Request contains an invalid argument.
Failure:
{"errors":[{"errorCode":{"queryError":"PROHIBITED_METRIC_IN_SELECT_OR_WHERE_CLAUSE"},"message":"Cannot
select or filter on the following metrics:
'all_conversions_from_store_visit'(could not support requested resources:
'CAMPAIGN'), since metric is incompatible with the resource in the FROM
clause or other selected segmenting
resources."}],"requestId":"HtRxzt5TXLs_iVm2qWcs7Q"}
Google\Ads\GoogleAds\Lib\V10\GoogleAdsException
{
"message": "Request contains an invalid argument.",
"code": 3,
"status": "INVALID_ARGUMENT",
"details": [
{
"@type": "google.ads.googleads.v10.errors.googleadsfailure-bin",
"data": "<Unknown Binary Data>"
},
{
"@type": "grpc-status-details-bin",
"data": "<Unknown Binary Data>"
},
{
"@type": "request-id",
"data": "HtRxzt5TXLs_iVm2qWcs7Q"
}
]
}
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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/35cb2d57-f5a8-48be-856c-131098b84343n%40googlegroups.com.
