製作報表及提高成效

需求開發廣告活動的報表可在不同層級擷取,就像其他廣告活動類型一樣。

廣告活動層級報表

與其他廣告活動類型一樣,您可以使用 GoogleAdsService.SearchStream 擷取需求開發廣告活動的屬性和成效指標。

使用 Google Ads API 17 以上版本:

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

使用 Google Ads API v16 以下版本:

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

如要在需求開發廣告活動的報表中擷取點擊次數,請以 CROSS_NETWORKclick_type 進行篩選。

廣告層級報表

Google Ads API 支援三種需求開發廣告,如要擷取這類查詢,請搭配 GoogleAdsService.SearchStream 使用。

使用 Google Ads API 17 以上版本:

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

使用 Google Ads API v16 以下版本:

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

素材資源層級報表

需求開發廣告活動具備輪轉廣告專用的素材資源類型。請使用 GoogleAdsService.SearchStream 擷取這些資產。

使用 Google Ads API 17 以上版本:

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

使用 Google Ads API v16 以下版本:

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

您也可以擷取 DEMAND_GEN_CAROUSEL_CARD 項資產的指標。

使用 Google Ads API 17 以上版本:

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

使用 Google Ads API v16 以下版本:

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/v17/GoogleAdsService#searchstream)