How to get stats of products that are in Performance campaign from arbitrary timeframe

[Lukas St]

Hello,

I am trying to get performance metrics of products that are in specific campaign of type 'Performance Max'. I tried to use following query

SELECT campaign.id, campaign.status, metrics.clicks
FROM product_group_view
WHERE segments.date = '$date' AND campaign.status = 'ENABLED' AND campaign.id = xxx

However, the product_group_view returns only products that belong to Shopping campaigns.

So my question is, how can I get stats of products belonging to a Performance campaign.

I am including a screenshot from Google Ads UI, where you can see that the campaign I am on is Performance max, I have arbitrary timeframe selected and on the list of products I see their stats for that specific timeframe.

Thank you for help.

[Google Ads API Forum Advisor]

Hi Lukas,

Thank you for reaching out to us.

You may refer to this documentation as giving sample query on how to retrieve metrics summarized by product segments. Let me know if you have further questions.

Best regards,

Heidi Google Ads API Team

ref:_00D1U1174p._5004Q2blxkk:ref