View product details in a shopping campaign

[Miroslav Buriánek]

Please let me know where I have an error in the sql query.
I need to know detailed information about the products in the shopping campaign, such as: number of impressions, number of compressions, etc. This is not a Max Performance campaign, but an ordinary shopping campaign. The SQL query that I am sending will show me only the summary information of the given campaign, but will not show me information about the individual products in the campaign. Is there an error in the definition of the sql query or in the product settings in the campaign?
Thank you for your help.

Mirk B.

Script:

https://googleads.googleapis.com/v14/customers/6402949336/googleAds:search

{"pageSize": 10000,"query":"SELECT campaign.id, campaign.name, ad_group.id, ad_group_criterion.criterion_id, ad_group_criterion.display_name, ad_group_criterion.cpc_bid_micros,metrics.clicks, metrics.impressions , metrics.conversions_value, metrics.cost_micros, metrics.conversions, metrics.impressions FROM product_group_view WHERE campaign.name LIKE 'SK Nakupni%' ORDER BY metrics.conversions_value DESC"}

[Google Ads API Forum Advisor]

Hi Mirk B,

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

By reviewing your query, I understand that you would like to retrieve the information about the individual products in the shopping campaign.

Kindly refer to the below query to retrieve the product details using the shopping_performance_view report: 

SELECT campaign.id, campaign.name, ad_group.id, metrics.clicks, metrics.impressions, metrics.conversions, metrics.conversions_value, metrics.cost_micros, segments.product_brand, segments.product_channel, segments.product_condition, segments.product_country, segments.product_language, segments.product_title, segments.product_store_id, segments.product_merchant_id, segments.product_item_id FROM shopping_performance_view WHERE campaign.name LIKE 'SK Nakupni%'

Also, you can use Query Builder to create your query and Query Validator to validate your query. Hope this helps. Let us know if you have any further queries.
 

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

Thanks,
 

Google Ads API Team