إعداد التقارير

SELECT
  campaign.id,
  campaign.status,
  campaign.bidding_strategy_type,
  metrics.impressions,
  metrics.clicks,
  metrics.cost_micros
FROM campaign
WHERE campaign.advertising_channel_type = DEMAND_GEN

SELECT
  campaign.id,
  segments.click_type,
  metrics.clicks
FROM campaign
WHERE campaign.advertising_channel_type = DEMAND_GEN
  AND segments.click_type = CROSS_NETWORK

SELECT
  campaign.id,
  segments.ad_network_type,
  segments.ad_sub_network_type,
  metrics.impressions,
  metrics.clicks,
  metrics.cost_micros,
  metrics.video_trueview_views
FROM campaign
WHERE campaign.advertising_channel_type = DEMAND_GEN

SELECT
  ad_group_ad.ad.id,
  ad_group_ad.ad.type,
  ad_group_ad.ad.demand_gen_multi_asset_ad.marketing_images,
  ad_group_ad.ad.demand_gen_multi_asset_ad.square_marketing_images,
  ad_group_ad.ad.demand_gen_multi_asset_ad.portrait_marketing_images,
  ad_group_ad.ad.demand_gen_multi_asset_ad.tall_portrait_marketing_images,
  ad_group_ad.ad.demand_gen_multi_asset_ad.classic_display_images,
  ad_group_ad.ad.demand_gen_multi_asset_ad.logo_images,
  ad_group_ad.ad.demand_gen_multi_asset_ad.headlines,
  ad_group_ad.ad.demand_gen_multi_asset_ad.descriptions,
  ad_group_ad.ad.demand_gen_multi_asset_ad.business_name,
  ad_group_ad.ad.demand_gen_multi_asset_ad.call_to_action_text,
  metrics.impressions,
  metrics.clicks,
  metrics.cost_micros
FROM ad_group_ad
WHERE ad_group_ad.ad.type = DEMAND_GEN_MULTI_ASSET_AD

SELECT
  ad_group_ad.ad.id,
  ad_group_ad.ad.type,
  ad_group_ad.ad.demand_gen_carousel_ad.business_name,
  ad_group_ad.ad.demand_gen_carousel_ad.logo_image,
  ad_group_ad.ad.demand_gen_carousel_ad.headline,
  ad_group_ad.ad.demand_gen_carousel_ad.description,
  ad_group_ad.ad.demand_gen_carousel_ad.call_to_action_text,
  ad_group_ad.ad.demand_gen_carousel_ad.carousel_cards,
  metrics.impressions,
  metrics.clicks,
  metrics.cost_micros
FROM ad_group_ad
WHERE ad_group_ad.ad.type = DEMAND_GEN_CAROUSEL_AD

SELECT
  ad_group_ad.ad.id,
  ad_group_ad.ad.type,
  ad_group_ad.ad.demand_gen_video_responsive_ad.breadcrumb1,
  ad_group_ad.ad.demand_gen_video_responsive_ad.breadcrumb2,
  ad_group_ad.ad.demand_gen_video_responsive_ad.business_name,
  ad_group_ad.ad.demand_gen_video_responsive_ad.call_to_actions,
  ad_group_ad.ad.demand_gen_video_responsive_ad.companion_banners,
  ad_group_ad.ad.demand_gen_video_responsive_ad.descriptions,
  ad_group_ad.ad.demand_gen_video_responsive_ad.headlines,
  ad_group_ad.ad.demand_gen_video_responsive_ad.logo_images,
  ad_group_ad.ad.demand_gen_video_responsive_ad.long_headlines,
  ad_group_ad.ad.demand_gen_video_responsive_ad.videos,
  metrics.impressions,
  metrics.clicks,
  metrics.cost_micros,
  metrics.video_trueview_views
FROM ad_group_ad
WHERE ad_group_ad.ad.type = DEMAND_GEN_VIDEO_RESPONSIVE_AD

SELECT
  ad_group_ad.ad.id,
  ad_group_ad.ad.type,
  ad_group_ad.ad.demand_gen_product_ad.headline,
  ad_group_ad.ad.demand_gen_product_ad.description,
  ad_group_ad.ad.demand_gen_product_ad.logo_image,
  ad_group_ad.ad.demand_gen_product_ad.breadcrumb1,
  ad_group_ad.ad.demand_gen_product_ad.breadcrumb2,
  ad_group_ad.ad.demand_gen_product_ad.business_name,
  ad_group_ad.ad.demand_gen_product_ad.call_to_action,
  metrics.impressions,
  metrics.clicks,
  metrics.cost_micros
FROM ad_group_ad
WHERE ad_group_ad.ad.type = DEMAND_GEN_PRODUCT_AD

SELECT
  ad_group_ad.ad.id,
  ad_group_ad.ad.type,
  ad_group_ad.ad.demand_gen_multi_asset_ad.headlines,
  ad_group_ad.ad.demand_gen_carousel_ad.headline,
  ad_group_ad.ad.demand_gen_video_responsive_ad.headlines,
  ad_group_ad.ad.demand_gen_product_ad.headline,
  ad_group_ad.ad.demand_gen_product_ad.description,
  ad_group_ad.ad.demand_gen_product_ad.business_name,
  metrics.impressions,
  metrics.clicks,
  metrics.cost_micros
FROM ad_group_ad
WHERE ad_group_ad.ad.type IN (
  DEMAND_GEN_MULTI_ASSET_AD,
  DEMAND_GEN_CAROUSEL_AD,
  DEMAND_GEN_VIDEO_RESPONSIVE_AD,
  DEMAND_GEN_PRODUCT_AD
)

SELECT
  asset.id,
  asset.demand_gen_carousel_card_asset.marketing_image_asset,
  asset.demand_gen_carousel_card_asset.square_marketing_image_asset,
  asset.demand_gen_carousel_card_asset.portrait_marketing_image_asset,
  asset.demand_gen_carousel_card_asset.headline,
  asset.demand_gen_carousel_card_asset.call_to_action_text
FROM asset
WHERE asset.type = DEMAND_GEN_CAROUSEL_CARD

SELECT
  asset.id,
  asset.name,
  asset.type,
  metrics.impressions
FROM ad_group_ad_asset_view
WHERE ad_group_ad_asset_view.field_type = DEMAND_GEN_CAROUSEL_CARD