Error while trying to query asset_group_product_group_view

188 views
Skip to first unread message

Marc Karam

unread,
Nov 29, 2021, 8:44:30 AM11/29/21
to AdWords API and Google Ads API Forum
I got the below error when trying to query the asset_group_product_group_view although I copied and pasted the query from adwords Ads Query Builder :

{{ "errors": [ { "errorCode": { "queryError": "PROHIBITED_RESOURCE_TYPE_IN_FROM_CLAUSE" }, "message": "Resource type asset_group_product_group_view is not supported for Search and SearchStream." } ], "requestId": "eufneRyzgE5fY_bFlcxDUQ" }}
    Errors: {[ { "errorCode": { "queryError": "PROHIBITED_RESOURCE_TYPE_IN_FROM_CLAUSE" }, "message": "Resource type asset_group_product_group_view is not supported for Search and SearchStream." } ]}

The query text:

SELECT metrics.impressions, metrics.clicks, metrics.cost_micros, asset_group.campaign, asset_group.id, asset_group.name, asset_group.resource_name, asset_group_product_group_view.resource_name FROM asset_group_product_group_view WHERE segments.date = '2021-11-29'

the link to the query builder page:
https://developers.google.com/google-ads/api/fields/v9/asset_group_product_group_view_query_builder

Google Ads API Forum Advisor

unread,
Nov 30, 2021, 3:58:54 PM11/30/21
to marc....@mobi-mind.com, adwor...@googlegroups.com
Hi Marc,

Thank you for reporting this, I reproduced the issue and raised it with my team. We will get back to you as soon as possible.

Reminder: Share your feedback about the Google Ads (AdWords) API! Take the 2021 Google Ads API and AdWords API Annual Survey
 
Regards,
 
Google Logo
Aryeh Baker
Google Ads API Team
 


ref:_00D1U1174p._5004Q2RwoNZ:ref

Google Ads API Forum Advisor

unread,
Dec 10, 2021, 11:55:58 AM12/10/21
to adwor...@googlegroups.com, marc....@mobi-mind.com
Hi Marc,

After some investigating I determined that this endpoint is currently working as intended. The team is still finalizing the implementation, but exposed the endpoint ahead of time due to the limitations of our release process. I anticipate that the resource will start functioning very soon. I'm trying to determine whether we have any comms planned so that you can easily know when it's working, but in the meantime if you want to test the endpoint every few days it should start working at some point.

Thanks,
Ben, Google Ads API Team

ref:_00D1U1174p._5004Q2RwoNZ:ref

maria.r...@funnel.io

unread,
Jan 10, 2022, 10:46:45 AM1/10/22
to AdWords API and Google Ads API Forum

Hi there,
Any updates on this? We would also like to use this report.

Kind regards,
Maria Ravander,
Developer @ Funnel 

Google Ads API Forum Advisor

unread,
Jan 13, 2022, 10:57:23 AM1/13/22
to maria.r...@funnel.io, adwor...@googlegroups.com
Hi Maria,

I'm still working with the engineering team responsible for this component to get it published. I don't have an exact timeline at the moment, but will report back once I have a better idea of the expected timing.

Best,

Google Ads API Forum Advisor

unread,
Jan 18, 2022, 2:03:26 PM1/18/22
to adwor...@googlegroups.com, maria.r...@funnel.io
Hi Maria,

Just letting you know that the report resource asset_group_product_group_view has been published and should be operational for you now.

Please let us know if you have any other questions or issues.

Thanks,

Johan Alpne

unread,
Jan 27, 2022, 10:36:01 AM1/27/22
to Google Ads API and AdWords API Forum
Hello,

We are trying to get "asset_group.name" (asset_group) with metrics. We are using the report "asset_group_product_group_view" report which has "asset_group" as an attributed resource and the metrics we are after. However we do not get any data when doing so. If we request the "asset_group" report directly we do get data.

Does the "asset_group_product_group_view" do any kind of filtering and removes rows which has empty columns?

Or do you have any other suggestion to get "asset_group.name" with metrics?

Best regards,
Johan Alpne
Developer @ Funnel

Google Ads API Forum Advisor

unread,
Jan 27, 2022, 11:24:11 AM1/27/22
to johan...@funnel.io, adwor...@googlegroups.com
Hi Johan,

Is the issue that you do not receive the "asset_group.name" field value when querying it via the "asset_group_product_group_view"? I'm unsure what you mean about retrieving metrics, because the "asset_group" resource does not have metrics in it.

So my question is - are you unable to retrieve non-metric fields for "assset_group" from "asset_group_product_group_view" or are you trying to use the latter to build a report that associated metrics with asset groups?

maria.r...@funnel.io

unread,
Jan 28, 2022, 6:20:44 AM1/28/22
to Google Ads API and AdWords API Forum
Hello,
Maria here, I work together with Johan. 

We want to get the asset_group.name in the same report as some common metrics. Here is an example query we are trying to use:
SELECT campaign.name, campaign.id, asset_group.name, metrics.impressions, metrics.clicks, metrics.cost_micros, segments.date FROM asset_group_product_group_view WHERE segments.date BETWEEN '2021-01-01' AND '2022-01-01'

It's valid, we tried it in your Query Validator. The problem is that we don't get any data back at all even though we get data when just querying the asset_group resource like this: 
SELECT asset_group.name FROM asset_group
From this query we get some Asset group names.

Are there any sort of filtering in the background when requesting the asset_group_product_group_view resource? We have tried several older date spans in the first query but we never get any data. Are we doing something wrong in the first query or do you have any other suggestion for how to get the asset_group.name in the same report as campaign fields and some common metrics?

Kind regards,
Maria Ravander
Developer @ Funnel

Google Ads API Forum Advisor

unread,
Jan 28, 2022, 10:40:34 AM1/28/22
to maria.r...@funnel.io, adwor...@googlegroups.com
Hi Maria,

Could you share the Customer ID you're working with? I'd like to try to reproduce this behavior.
Reply all
Reply to author
Forward
0 new messages