রিপোর্ট করুন এবং অপ্টিমাইজ করুন

SELECT
  campaign.id,
  campaign.status,
  campaign.bidding_strategy_type
FROM campaign
WHERE campaign.advertising_channel_type = DEMAND_GEN

SELECT
  campaign.id,
  campaign.status,
  campaign.bidding_strategy_type
FROM campaign
WHERE campaign.advertising_channel_type = DISCOVERY

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.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,
  ad_group_ad.ad.demand_gen_multi_asset_ad.lead_form_only
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
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.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,
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.discovery_multi_asset_ad.marketing_images,
  ad_group_ad.ad.discovery_multi_asset_ad.square_marketing_images,
  ad_group_ad.ad.discovery_multi_asset_ad.portrait_marketing_images,
  ad_group_ad.ad.discovery_multi_asset_ad.logo_images,
  ad_group_ad.ad.discovery_multi_asset_ad.headlines,
  ad_group_ad.ad.discovery_multi_asset_ad.descriptions,
  ad_group_ad.ad.discovery_multi_asset_ad.business_name,
  ad_group_ad.ad.discovery_multi_asset_ad.call_to_action_text,
  ad_group_ad.ad.discovery_multi_asset_ad.lead_form_only
FROM ad_group_ad
WHERE ad_group_ad.ad.type = DISCOVERY_MULTI_ASSET_AD

SELECT
  ad_group_ad.ad.id,
  ad_group_ad.ad.type,
  ad_group_ad.ad.discovery_carousel_ad.business_name,
  ad_group_ad.ad.discovery_carousel_ad.logo_image,
  ad_group_ad.ad.discovery_carousel_ad.headline,
  ad_group_ad.ad.discovery_carousel_ad.description,
  ad_group_ad.ad.discovery_carousel_ad.call_to_action_text,
  ad_group_ad.ad.discovery_carousel_ad.carousel_cards
FROM ad_group_ad
WHERE ad_group_ad.ad.type = DISCOVERY_CAROUSEL_AD

SELECT
  ad_group_ad.ad.id,
  ad_group_ad.ad.type,
  ad_group_ad.ad.discovery_video_responsive_ad.breadcrumb1,
  ad_group_ad.ad.discovery_video_responsive_ad.breadcrumb2,
  ad_group_ad.ad.discovery_video_responsive_ad.business_name,
  ad_group_ad.ad.discovery_video_responsive_ad.call_to_actions,
  ad_group_ad.ad.discovery_video_responsive_ad.descriptions,
  ad_group_ad.ad.discovery_video_responsive_ad.headlines,
  ad_group_ad.ad.discovery_video_responsive_ad.logo_images,
  ad_group_ad.ad.discovery_video_responsive_ad.long_headlines,
  ad_group_ad.ad.discovery_video_responsive_ad.videos,
FROM ad_group_ad
WHERE ad_group_ad.ad.type = DISCOVERY_VIDEO_RESPONSIVE_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.discovery_carousel_card_asset.marketing_image_asset,
  asset.discovery_carousel_card_asset.square_marketing_image_asset,
  asset.discovery_carousel_card_asset.portrait_marketing_image_asset,
  asset.discovery_carousel_card_asset.headline,
  asset.discovery_carousel_card_asset.call_to_action_text
FROM asset
WHERE asset.type = DISCOVERY_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

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

## Unsupported entities

Ads that show up in the Google Ads frontend with ad type "Demand Gen
video ad (legacy)" are not supported by the Google Ads API and won't be returned by
[`GoogleAdsService.SearchStream`](/google-ads/api/reference/rpc/v18/GoogleAdsService#searchstream)