与其他广告系列类型一样,您可以使用
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
查询应用安装次数
在应用广告系列中,“安装”通常会记录为转化。您可以通过查询 metrics.conversions 或
metrics.all_conversions 检索安装数据。如需将安装与其他转化类型区分开来,请按
segments.conversion_action 对报告进行细分,以确定与安装相关的特定转化操作。
SELECT
campaign.id,
campaign.name,
metrics.conversions,
segments.conversion_action
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
ad_group.name,
ad_group_ad_asset_view.asset,
asset.name,
metrics.clicks,
metrics.impressions
FROM ad_group_ad_asset_view
详细了解 应用转化和浏览型转化 或转化跟踪数据。