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/CAHVGiTU%3D-VNkMVZNkXux_8ShXR7wEvVUW%2B9kgr2aXeNp%2BJO%3DLA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
