Hey Tiana, Thanks for the head's up!! That makes sense.
I was able to find the store visits metrics in the "*extension_feed_item*"
report.
This is unfortunate as google has forced me to create double the API calls,
as our advertising agency considers store visit metrics as part of standard
metric set for campaigns.
Thanks,
Shawn
On Monday, February 21, 2022 at 12:08:44 PM UTC-6 Tiana S. wrote:
> Hi Shawn,
>
> Not Google, but I've ran into this issue as well a while back.
> There's a bit of text above the lists of fields in the docs for the
> resource types stating that some fields are actually not available if you
> explicitly have the resource type specified in your FROM clause:
> [image: Screenshot 2022-02-21 at 18.59.26.png]
>
> There's also a selector there which allows you to specify whether you want
> to see the lists of fields available for the campaign resource or only the
> ones specifically available when you have campaign stated in your FROM
> clause.
> It defaults to "No", so you'll have to switch that to "Yes, it is" to see
> the fields you can use with "campaign" specified as FROM clause.
>
> I have no idea why they've made it this way, but it means the field you're
> trying to request from it is not actually compatible with your query,
> unfortunately.
>
>
> On Monday, 21 February 2022 at 17:32:47 UTC+1 Shawn Naquin wrote:
>
>> 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 <(438)%20811-9023>"
>> }
>> 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/00426c15-3190-472b-8355-7082a64b4646n%40googlegroups.com.
