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
See the Reporting guide for more information.