Hi Nadine,
I am follow up here on the thread so that the thread is kept alive even
just using Campaign I am getting an error(See Below). I get the same error
for "select metrics. historical_quality_score FROM ad_group" also.
2019-03-22 09:52:08,733 WARN [Gax-3] logging.RequestLogger
(RequestLogger.java:153) - FAILURE REQUEST SUMMARY. Method:
google.ads.googleads.v1.services.GoogleAdsService/Search, Endpoint:
googleads.googleapis.com:443, CustomerID: 9254837834, RequestID:
Y8n9_oFfwoEuZGR4kkE21Q, ResponseCode: INVALID_ARGUMENT, Fault: Request
contains an invalid argument..
2019-03-22 09:52:09,001 INFO [Gax-3] logging.RequestLogger
(RequestLogger.java:151) - FAILURE REQUEST DETAIL.
Request
-------
MethodName: google.ads.googleads.v1.services.GoogleAdsService/Search
Endpoint: googleads.googleapis.com:443
Headers: {developer-token=REDACTED, login-customer-id=**************,
x-goog-api-client=gl-java/11.0.1 gapic/ gax/1.35.0 grpc/1.16.1}
Body: customer_id: "*************"
query: "Select metrics.historical_quality_score FROM campaign"
page_size: 1000
Response
--------
Headers:
Metadata(content-type=application/grpc,request-id=Y8n9_oFfwoEuZGR4kkE21Q,date=Fri,
22 Mar 2019 13:52:08 GMT,alt-svc=quic=":443"; ma=2592000; v="46,44,43,39")
Body: null
Status: Status{code=INVALID_ARGUMENT, description=Request contains an
invalid argument., cause=null}.
Request ID Y8n9_oFfwoEuZGR4kkE21Q failed due to GoogleAdsException.
Underlying errors:
Error 0: error_code {
query_error: PROHIBITED_METRIC_IN_SELECT_OR_WHERE_CLAUSE
}
message: "Cannot select or filter on the following metrics:
\'historical_quality_score\'(could not support requested resources:
\'CAMPAIGN\'), since metric is incompatible with the resource in the FROM
clause or other selected segmenting resources."
Process finished with exit code 0
===============================================================================================================================================
Hi,
Hello,
If you want granularity at a higher level, then you would change your from
clause and remove the more detailed items in the select. For example, you
can do this to get it by just campaign:
SELECT
metrics.historical_quality_score
FROM
campaign
LIMIT
100
or you can do this if you want granularity at the ad group level:
SELECT
metrics.historical_quality_score
FROM
ad_group
LIMIT
100
Of course, you can add more than that in the SELECT clause, but I was
simplifying it to show you that this metric can be retrieved for other
objects as well. If it is available for that resource, then it will be
returned.
Regards,
Nadine, Google Ads API Team
On Thursday, March 21, 2019 at 8:17:39 AM UTC-4, Darshan Pradhan wrote:
>
> Hi, i am aware of that rule so i corrected my query in the 2nd question.
> My issue is i am unable to pull historical_quality_score for customer, ad
> group or campaign.
>
> On Wed, Mar 20, 2019, 5:24 PM <[email protected]>
> wrote:
>
>> Greetings!
>>
>> There's a rule that I had to get used to when first querying. You can go
>> up the tree from most specific to general, but you can't go down the tree.
>> So, if I select *FROM campaign*, I can't *select ad_group*. However, if
>> I select *FROM ad_group*, I can *select campaign*. So, to get what you
>> need, you would do this:
>>
>> SELECT
>> campaign.id,
>> customer.id,
>> ad_group.id,
>> metrics.historical_quality_score
>> FROM
>> ad_group
>> LIMIT
>> 100
>>
>>
>> Just to sanity check myself, I use the Query Builder
>> <https://developers.google.com/google-ads/api/docs/query/interactive-gaql-builder>
>> all
>> the time, especially with more complicated queries. I took this query and
>> built it using the Query Builder just to be sure that the syntax made sense.
>>
>> Take care,
>> Nadine Sundquist, Google Ads API Team
>> =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
>> Also find us on our blog and discussion group:
>> http://googleadsdeveloper.blogspot.com/search/label/adwords_api
>> https://developers.google.com/adwords/api/community/
>> =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
>>
>> On 03/20/19 09:28:49 [email protected] wrote:
>>
>> Hi Support,
>> I am trying to pull metrics.historical_quality_score of customer,
>> ad_group, campaign and keyword_view resources but I am getting following
>> message in the response for all except keyword_view. The documentation
>> mentions
>> <https://developers.google.com/google-ads/api/docs/fields/metrics#metricshistorical_quality_score>
>>
>> I should be able to pull for these resources. Please advice.
>>
>> -- customer resource
>> message: "Cannot select or filter on the following metrics:
>> \'historical_quality_score\'(could not support requested resources:
>> \'CUSTOMER\'), since metric is incompatible with the resource in the FROM
>> clause or other selected segmenting resources."
>> * ad_group resource
>> message: "Cannot select fields from the following resource: \'AD_GROUP\',
>> since the resource is incompatible with the resource in FROM clause."
>>
>>
>> Request
>> -------
>> MethodName: google.ads.googleads.v1.services.GoogleAdsService/Search
>> Endpoint: googleads.googleapis.com:443
>> Headers: {developer-token=REDACTED, login-customer-id=***********,
>> x-goog-api-client=gl-java/11.0.1 gapic/ gax/1.35.0 grpc/1.16.1}
>> Body: customer_id: "**********"
>> query: "Select metrics.historical_quality_score, ad_group.id,
>> campaign.id, customer.id FROM campaign limit 100"
>> page_size: 1000
>>
>>
>> Response
>> --------
>> Headers:
>> Metadata(content-type=application/grpc,request-id=vDMcF0EmG2UIxWrQ8-wtxQ,date=Wed,
>>
>> 20 Mar 2019 13:20:49 GMT,alt-svc=quic=":443"; ma=2592000; v="46,44,43,39")
>> Body: null
>> Status: Status{code=INVALID_ARGUMENT, description=Request contains an
>> invalid argument., cause=null}.
>> Request ID vDMcF0EmG2UIxWrQ8-wtxQ failed due to GoogleAdsException.
>> Underlying errors:
>> Error 0: error_code {
>> query_error: PROHIBITED_RESOURCE_TYPE_IN_SELECT_CLAUSE
>> }
>> message: "Cannot select fields from the following resource: \'AD_GROUP\',
>> since the resource is incompatible with the resource in FROM clause."
>>
>> --
>> --
>> =~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
>> 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 [email protected]
>> To unsubscribe from this group, send email to
>> [email protected]
>> 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 [email protected].
>> 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/0c34e7b5-aefe-460b-91cb-277b4774ac71%40googlegroups.com
>>
>> <https://groups.google.com/d/msgid/adwords-api/0c34e7b5-aefe-460b-91cb-277b4774ac71%40googlegroups.com?utm_medium=email&utm_source=footer>
>> .
>> For more options, visit https://groups.google.com/d/optout.
>>
>>
--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
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 [email protected]
To unsubscribe from this group, send email to
[email protected]
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 [email protected].
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/5099a2aa-ae3d-429e-992c-cda07de01140%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
