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/186u55000000000089uq3k000qn992z60mj6c9i74o30c1g68qjee1o%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
