Reporting

As with other ad types, you can use GoogleAdsService.SearchStream to 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:

• Shopping Performance View (equivalent to the SHOPPING_PERFORMANCE_REPORT in AdWords API)
• Product Group View (equivalent to the PRODUCT_PARTITION_REPORT in AdWords API)

The Shopping Performance View provides aggregated reporting statistics for products by product_item_id (equivalent to OfferId in AdWords API). Below is an example query that will retrieve 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

The Product Group View provides aggregated reporting statistics for Shopping listing groups (referred to as product groups in the UI). Below is an example query that will retrieve 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

Note: Smart Shopping campaigns don't support network segmentation. The ad_network_type segment in the Product Group View will always be returned as MIXED or "Cross-network".

See the Reporting guide for more information.