That makes sense, Nadine, great explanation of how to read the documentation.
On Friday, March 22, 2019 at 6:32:30 PM UTC-4, googleadsapi-forumadvisor wrote: > > Hello Darshan, > > I was looking directly at the new documentation without considering that > the documentation may be unclear and that historical quality score only > makes sense in a certain context. In the AdWords API, > HistoricalQualityScore > <https://developers.google.com/adwords/api/docs/appendix/reports/keywords-performance-report#historicalqualityscore> > was > only available at the keyword level. You couldn't get it for campaign or ad > group. This leads me to believe that the way the API is responding is > correct, but the documentation we have is a bit, I admit, confusing. There > is no historical quality score backing the campaign or ad group. It's only > at the keyword level. That now makes sense why these queries are reacting > this way. > > I can explain how to interpret the documentation. If you go to campaign > <https://developers.google.com/google-ads/api/docs/fields/campaign>, > you'll see that there is a *Metrics *row for campaign. If you open up > that list of metrics, there is no quality score there. This means that is > campaign is in the FROM clause, then only these metrics can be in the > SELECT clause. There is also a row under campaign called *Selectable With* > where > you do see quality score. This means that if you are retrieving a resource > that does have this metrics and you have campaign in the select, then you > can also call this metric in the select because they are compatible. So, in > this case, quality score is not a metric for campaign, but if you are > getting the the quality score for keywords and then you have campaign in > the SELECT, then you can also get the metric. > > I'm sorry about the confusion. I misread the wrong drop-down when I was > responding back to you and didn't give it a try before responding. I hope > that clears it up for you. > > Take care, > Nadine, 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/22/19 10:00:08 dar...@companionlabs.com <javascript:> wrote: > > 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 <googleadsapi-forumadvi...@google.com> > 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 dars...@companionlabs.com 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 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 > "AdWords API and Google Ads API Forum" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to adwords-api+unsubscr...@googlegroups.com. > 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 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 > "AdWords API and Google Ads API Forum" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to adwords-api+unsubscr...@googlegroups.com. > 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 > > <https://groups.google.com/d/msgid/adwords-api/5099a2aa-ae3d-429e-992c-cda07de01140%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 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 "AdWords API and Google Ads API Forum" group. To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api+unsubscr...@googlegroups.com. 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/28745cb1-fe9a-4e52-b723-ae50f22994bc%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
