报告

与其他广告系列类型一样,您可以使用 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')
  AND segments.date DURING LAST_30_DAYS

按广告组名称排序的应用广告系列列表

以下查询将检索前 100 个应用广告系列,即使尚无可用指标也是如此(按广告组名称排序)。

SELECT
  ad_group.name,
  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 = 'APP_CAMPAIGN'
ORDER BY ad_group.name ASC
LIMIT 100

转化次数排名前 10 的应用

如果有多个应用的发布商想要了解转化次数排名前 10 位的应用,可以使用以下查询:

SELECT
  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

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