和其他廣告類型一樣,您可以使用 GoogleAdsService.SearchStream
擷取購物廣告的成效資料。下方查詢範例會擷取購物廣告群組過去 30 天內的曝光次數和點擊次數,並按日期區隔。
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 Performance View 提供 product_item_id
產品的匯總報表統計資料。
以下查詢範例會擷取 product_item_id
產品過去 30 天內點擊次數的曝光次數、點擊次數、費用、轉換次數和所有轉換 (以遞減順序排序,依序依所有轉換、轉換、點擊、費用和曝光排序):
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
產品群組檢視畫面提供購物產品資訊群組的匯總報表統計資料 (在 UI 中稱為產品群組)。
以下查詢範例會擷取購物產品資訊群組的曝光、點擊、轉換和所有轉換,按照廣告活動在過去 30 天內獲得曝光的廣告活動排序 (依所有轉換、轉換、點擊、曝光的遞減排序):
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
如要進一步瞭解查詢,請參閱報表指南。
透過購物車資料回報的產品成效
零售業廣告客戶可以查看相關的銷售和利潤指標,例如收益、毛利、毛利率和商品售出數量等。這些指標適用於所有在購物廣告活動中導入透過購物車資料回報的轉換,並與下列報表相容。
下列購物車資料指標可用於報表,例如 shopping_performance_view
報表。
metrics.average_cart_size
metrics.average_order_value_micros
metrics.cost_of_goods_sold_micros
metrics.cross_sell_cost_of_goods_sold_micros
metrics.cross_sell_gross_profit_micros
metrics.cross_sell_revenue_micros
metrics.cross_sell_units_sold
metrics.gross_profit_margin
metrics.gross_profit_micros
metrics.lead_cost_of_goods_sold_micros
metrics.lead_gross_profit_micros
metrics.lead_revenue_micros
metrics.lead_units_sold
metrics.orders
metrics.revenue_micros
metrics.units_sold
以下例子說明如何使用購物車資料指標,分析最近 30 天內購物廣告活動的產品層級成效。
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
透過購物車資料回報的廣告活動成效
您可以在廣告活動層級使用購物車資料指標,並可搭配其他成效指標,例如曝光、點擊和費用。
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