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:

The Shopping Performance View provides aggregated reporting statistics for products by product_item_id.

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

The Product Group View provides aggregated reporting statistics for Shopping listing groups (referred to as product groups in the UI).

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.

Create listing groups