應用程式廣告活動報表

與其他廣告活動類型一樣，您可以使用 GoogleAdsService.SearchStream 擷取應用程式廣告活動的屬性和成效指標。

最近 30 天內的曝光次數和點擊次數

下列查詢會擷取過去 30 天內所有應用程式廣告活動的曝光次數和點擊次數，並依日期區隔。

SELECT
  campaign.id,
  campaign.name,
  campaign.advertising_channel_type,
  campaign.advertising_channel_sub_type,
  campaign.app_campaign_setting.app_id,
  campaign.app_campaign_setting.app_store,
  campaign.app_campaign_setting.bidding_strategy_goal_type,
  segments.date,
  metrics.impressions,
  metrics.clicks
FROM campaign
WHERE
  campaign.advertising_channel_type = 'MULTI_CHANNEL'
  AND campaign.advertising_channel_sub_type IN (
    'APP_CAMPAIGN',
    'APP_CAMPAIGN_FOR_ENGAGEMENT',
    'APP_CAMPAIGN_FOR_PRE_REGISTRATION'
  )
  AND segments.date DURING LAST_30_DAYS

列出應用程式廣告活動的廣告群組

下列查詢會擷取與應用程式廣告活動相關聯的廣告群組，並依廣告群組名稱排序。

SELECT
  ad_group.id,
  ad_group.name,
  campaign.id,
  campaign.app_campaign_setting.app_id,
  campaign.app_campaign_setting.bidding_strategy_goal_type,
  campaign.app_campaign_setting.app_store
FROM ad_group
WHERE
  campaign.advertising_channel_type = 'MULTI_CHANNEL'
  AND campaign.advertising_channel_sub_type IN (
    'APP_CAMPAIGN',
    'APP_CAMPAIGN_FOR_ENGAGEMENT',
    'APP_CAMPAIGN_FOR_PRE_REGISTRATION'
  )
ORDER BY ad_group.name ASC
LIMIT 100

轉換次數前 10 多的廣告活動

下列查詢會根據總轉換次數，擷取特定套件名稱的前 10 大應用程式廣告活動。如要匯總單一應用程式多個廣告活動的指標總計，請在用戶端程式碼中執行匯總作業。

SELECT
  campaign.id,
  campaign.name,
  campaign.app_campaign_setting.app_id,
  metrics.all_conversions,
  metrics.view_through_conversions
FROM campaign
WHERE
  campaign.app_campaign_setting.app_id LIKE 'com.google.android.apps.%'
ORDER BY metrics.all_conversions DESC
LIMIT 10

應用程式安裝

在應用程式廣告活動中，系統會將安裝次數記錄為轉換。您可以查詢 metrics.conversions 或 metrics.all_conversions，並依 segments.conversion_action 區隔，即可擷取安裝資料。

SELECT
  campaign.id,
  campaign.name,
  segments.conversion_action,
  metrics.conversions
FROM campaign
WHERE
  campaign.advertising_channel_type = 'MULTI_CHANNEL'
  AND campaign.advertising_channel_sub_type = 'APP_CAMPAIGN'

iOS 的 SKAdNetwork 資料

如果是 iOS 應用程式廣告活動，Apple 的 SKAdNetwork 架構會回報安裝次數和轉換次數。您可以查詢 metrics.sk_ad_network_installs 和 metrics.sk_ad_network_total_conversions，並依 segments.sk_ad_network_fine_conversion_value 或 segments.sk_ad_network_user_type 等欄位區隔。

SELECT
  campaign.id,
  campaign.name,
  segments.sk_ad_network_fine_conversion_value,
  segments.sk_ad_network_user_type,
  metrics.sk_ad_network_installs,
  metrics.sk_ad_network_total_conversions
FROM campaign
WHERE
  campaign.advertising_channel_type = 'MULTI_CHANNEL'
  AND campaign.advertising_channel_sub_type = 'APP_CAMPAIGN'

素材資源名稱和成效

如要擷取應用程式廣告活動中特定廣告素材資源的成效指標，請查詢 ad_group_ad_asset_view 資源。由於 asset 是已歸因的資源，因此您可以直接選取 asset.name。

SELECT
  campaign.id,
  ad_group.name,
  ad_group_ad_asset_view.asset,
  asset.name,
  metrics.clicks,
  metrics.impressions
FROM ad_group_ad_asset_view
WHERE
  campaign.advertising_channel_type = 'MULTI_CHANNEL'
  AND campaign.advertising_channel_sub_type IN (
    'APP_CAMPAIGN',
    'APP_CAMPAIGN_FOR_ENGAGEMENT',
    'APP_CAMPAIGN_FOR_PRE_REGISTRATION'
  )

成效最佳的素材資源組合

從第 23 版開始，您可以查詢 app_top_combination_view 資源，擷取在應用程式廣告活動中一起放送的成效最佳廣告素材資源組合。

SELECT
  campaign.id,
  ad_group.id,
  ad_group.name,
  app_top_combination_view.resource_name,
  app_top_combination_view.ad_group_top_combinations
FROM app_top_combination_view
WHERE
  campaign.advertising_channel_type = 'MULTI_CHANNEL'
  AND campaign.advertising_channel_sub_type IN (
    'APP_CAMPAIGN',
    'APP_CAMPAIGN_FOR_ENGAGEMENT',
    'APP_CAMPAIGN_FOR_PRE_REGISTRATION'
  )

進一步瞭解應用程式轉換和瀏覽後轉換，或轉換追蹤資料。

上一頁
程式碼範例