As with other ad types, you can use
retrieve performance data for Shopping Ads. Below is an example query that will
retrieve impressions and clicks for your Shopping ad groups over the last 30
days, segmented by date.
SELECT campaign.name, campaign.status, ad_group.name, segments.date, metrics.impressions, metrics.clicks FROM ad_group WHERE ad_group.type = SHOPPING_PRODUCT_ADS AND segments.date DURING LAST_30_DAYS
Shopping ads have the following dedicated reports:
Here is an example query that retrieves impressions, clicks, cost, conversions
and all conversions for products by
product_item_id with clicks in the last 30
days (sorted in descending order by all conversions, then conversions, then
clicks, then cost, then impressions):
SELECT segments.product_item_id, metrics.clicks, metrics.cost_micros, metrics.impressions, metrics.conversions, metrics.all_conversions FROM shopping_performance_view WHERE segments.date DURING LAST_30_DAYS AND metrics.clicks > 0 ORDER BY metrics.all_conversions DESC, metrics.conversions DESC, metrics.clicks DESC, metrics.cost_micros DESC, metrics.impressions DESC
Here is an example query that retrieves impressions, clicks, conversions, and all conversions for Shopping listing groups by campaign with impressions in the last 30 days (sorted in descending order by all conversions, then conversions, then clicks, then impressions):
SELECT campaign.name, metrics.impressions, metrics.clicks, metrics.conversions, metrics.all_conversions FROM product_group_view WHERE segments.date DURING LAST_30_DAYS AND metrics.impressions > 0 ORDER BY metrics.all_conversions DESC, metrics.conversions DESC, metrics.clicks DESC, metrics.impressions DESC
See the Reporting guide for more details on queries.
Product performance with cart data
Retail advertisers can access relevant sales and profit metrics such as Revenue, Gross Profit, Gross Profit Margin, and Units sold. These metrics are available to all advertisers who implement Conversions with cart data across Shopping campaigns and are compatible with the following reports.
customer(Aggregated for all campaigns)
The following cart data metrics can be used in reports, such as the
The following example demonstrates how cart data metrics can be used to analyze product level performance for Shopping campaigns in the last 30 days.
SELECT segments.product_item_id, segments.product_title, metrics.average_cart_size, metrics.average_order_value_micros, metrics.conversions, metrics.conversions_value, metrics.gross_profit_micros, metrics.gross_profit_margin, metrics.revenue_micros, metrics.units_sold, campaign.advertising_channel_type FROM shopping_performance_view WHERE campaign.advertising_channel_type = 'SHOPPING' AND segments.date DURING LAST_30_DAYS AND metrics.conversions > 0 ORDER BY metrics.gross_profit_margin DESC, metrics.revenue_micros DESC, metrics.conversions_value DESC
Campaign performance with cart data
Cart data metrics can be used at the campaign level and can be combined with other performance metrics such as impressions, clicks, and cost.
SELECT campaign.id, campaign.name, campaign.advertising_channel_type, metrics.impressions, metrics.clicks, metrics.conversions, metrics.cost_micros, metrics.average_order_value_micros, metrics.gross_profit_micros, metrics.gross_profit_margin FROM campaign WHERE campaign.advertising_channel_type = 'SHOPPING' AND segments.date DURING LAST_30_DAYS ORDER BY metrics.gross_profit_margin DESC, metrics.average_order_value_micros DESC, metrics.cost_micros DESC, metrics.conversions DESC, metrics.clicks DESC, metrics.impressions DESC