عملکرد پویش خرده‌فروشی

SELECT
  metrics.impressions,
  metrics.clicks,
  metrics.conversions,
  metrics.cost_micros
FROM campaign
WHERE campaign.advertising_channel_type = 'PERFORMANCE_MAX'
  AND campaign.shopping_setting.merchant_id IS NOT NULL
  AND segments.date DURING LAST_30_DAYS

SELECT
  metrics.impressions,
  metrics.clicks,
  metrics.conversions,
  metrics.cost_micros
FROM campaign
WHERE campaign.advertising_channel_type = 'PERFORMANCE_MAX'
  AND campaign.shopping_setting.merchant_id IS NOT NULL
  AND campaign.shopping_setting.feed_label = 'WINTER-PRODUCTS'
  AND segments.date DURING LAST_30_DAYS

SELECT
  campaign.name,
  segments.ad_network_type,
  segments.ad_using_product_data,
  metrics.impressions,
  metrics.clicks,
  metrics.conversions,
  metrics.cost_micros
FROM campaign
WHERE campaign.advertising_channel_type = 'PERFORMANCE_MAX'
  AND campaign.shopping_setting.merchant_id IS NOT NULL
  AND segments.date DURING LAST_30_DAYS
  AND segments.ad_using_product_data = true

SELECT
  segments.product_item_id,
  metrics.clicks,
  metrics.cost_micros,
  metrics.impressions,
  metrics.search_budget_lost_impression_share,
  metrics.search_rank_lost_impression_share,
  metrics.search_budget_lost_absolute_top_impression_share,
  metrics.search_rank_lost_absolute_top_impression_share,
  metrics.conversions,
  metrics.all_conversions,
  campaign.advertising_channel_type
FROM shopping_performance_view
WHERE campaign.advertising_channel_type = 'PERFORMANCE_MAX'
  AND 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

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 = 'PERFORMANCE_MAX'
  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 = 'PERFORMANCE_MAX'
  AND campaign.shopping_setting.merchant_id IS NOT NULL
  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

SELECT
  asset_group.id,
  asset_group_listing_group_filter.id,
  metrics.impressions,
  metrics.clicks,
  metrics.conversions,
  metrics.cost_micros
FROM asset_group_product_group_view
WHERE campaign.id = CAMPAIGN_ID
  AND segments.date DURING LAST_30_DAYS

SELECT
  asset_group_listing_group_filter.id,
  metrics.impressions,
  metrics.clicks,
  metrics.conversions,
  metrics.cost_micros
FROM asset_group_product_group_view
WHERE asset_group.id = ASSET_GROUP_ID
  AND segments.date DURING LAST_30_DAYS

SELECT
  asset_group_listing_group_filter.case_value.product_brand.value,
  metrics.impressions,
  metrics.clicks,
  metrics.conversions,
  metrics.cost_micros
FROM asset_group_product_group_view
WHERE asset_group.id = ASSET_GROUP_ID
  AND segments.date DURING LAST_30_DAYS