应用广告系列报告

与其他广告系列类型一样，您可以使用 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.name，因为 asset 是归因资源。

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'
  )

效果最佳的素材资源组合

从 v23 开始，您可以查询 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'
  )

详细了解应用转化和浏览型转化或转化跟踪数据。

上一页
代码示例