Error while trying to query asset_group_product_group_view

[Marc Karam]

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]

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,
 

Aryeh Baker Google Ads API Team

ref:_00D1U1174p._5004Q2RwoNZ:ref

[Google Ads API Forum Advisor]

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]

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]

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]

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]

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]

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]

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]

Hi Maria,

Could you share the Customer ID you're working with? I'd like to try to reproduce this behavior.