Cannot get asset group data from asset_group_product_group_view though data exist in asset_group

[Lộc Đoàn]

Hi everyone,

I'm trying to get asset group reporting data segment by date but it seems I cannot get it from asset_group_product_group_view. However, I can get its lifetime data from asset_group. It seems to happen with this specific campaign, so I will attach the campaign in this query.

asset_group_product_group_view query segment by date

SELECT segments.date, customer.time_zone, customer.currency_code, 

customer.id, campaign.id, campaign.advertising_channel_type, 

asset_group.id, metrics.impressions, metrics.clicks, metrics.cost_micros, 

metrics.average_cpc, metrics.average_cpm, metrics.ctr
                FROM asset_group_product_group_view
                WHERE campaign.id IN (20739465821)
                AND segments.date >= '2023-12-01' AND segments.date <= '2023-12-31'

asset_group query for lifetime data:

SELECT customer.time_zone, customer.currency_code, customer.id, campaign.id, 

campaign.advertising_channel_type, asset_group.id, metrics.impressions, metrics.clicks, 

metrics.cost_micros, metrics.average_cpc, metrics.ctr
                FROM asset_group
                WHERE campaign.id IN (20739465821)

There are data on UI for the asset group

[Google Ads API Forum Advisor]

Hi,

Thank you for reaching out to the Google Ads API support team.

After reviewing your query, I understand that you are trying to get the asset group reporting data segment by date, but it seems you cannot get it from asset_group_product_group_view.

I would like to inform you that the asset_group_product_group_view requires some listing groups to be defined in order to work. Listing groups are the PMax equivalent of a product group in a normal shopping campaign. If what you want is a breakdown by asset, you can use the asset_group_view instead, which doesn't have this limitation.
 

This message is in relation to case "ref:!00D1U01174p.!5004Q02ry114:ref"

Thanks,
 

Google Ads API Team

[Lộc Đoàn]

Hi,

Can you provide an api reference to the asset_group_view? The python library is giving me this error "Error in asset_group_view:  is not a valid resource name."

[Lộc Đoàn]

Moreover, I'm not trying to get asset reporting data breakdown by asset. I'm trying to get data breakdown by asset_group instead.

[Lộc Đoàn]

Moreover, I thought anything on UI can be retrieved by API?

[Google Ads API Forum Advisor]

Hi,

Thank you for getting back to us.

Yes, your understanding is correct, anything from the UI can be retrieved via the API. Kindly note that retrieving the date segmentation from the asset_group is currently not yet supported by the Google Ads API. We have already raised a feature request to support this feature from the Google Ads API. We do not have a specific time frame for the availability of this feature at the moment. However, please be assured that our team is actively working on it. I would recommend you to please follow our Release Notes and Blog post for future updates. Also, you can refer to this API documentation for guidance on what reporting is currently available for performance max campaigns. 

[Lộc Đoàn]

Hi,

So currently, no workaround for my problem yet?

[Google Ads API Forum Advisor]

Hi,

Thank you for getting back to us.

Please note that our team is aware of the request and understands the urgency. Unfortunately there are no workarounds at this time. You can refer to this API documentation for guidance on what reporting is currently available for performance max, and monitor the Release Notes for updates.