Page Summary
-
The
GoogleAdsService.SearchStreamcan be used to retrieve attributes and performance metrics for App campaigns. -
You can retrieve impressions and clicks for App campaigns from the last 30 days segmented by date.
-
It is possible to list app campaigns ordered by ad group name.
-
You can find the top 10 apps by conversions using a specific query.
As with other campaign types, you can use GoogleAdsService.SearchStream
to retrieve attributes and / or performance metrics for App campaigns.
Impressions and clicks of App Campaigns in last 30 days
The following query will retrieve impressions and clicks from the last 30 days for all App campaigns, segmented by date.
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
List of app campaigns ordered by ad group name
The following query will retrieve the first 100 app campaigns, even if no metrics are yet available, sorted by ad group name.
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
Top ten apps by conversions
If a publisher of multiple apps would like to understand which are the top ten apps by conversions, the following query can be used:
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
Query app installs
In App campaigns, "Installs" are typically recorded as conversions. You can
retrieve install data by querying metrics.conversions
or metrics.all_conversions
. To isolate installs from other conversion types,
segment the report by segments.conversion_action
to identify the specific
conversion action associated with installs.
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'
Query asset names and performance
To retrieve performance metrics for specific assets (creatives) in an App
campaign, you can query the ad_group_ad_asset_view
resource. This view
provides performance data at the asset level. You can also select asset.name
directly in the query because asset
is an attributed resource.
SELECT
ad_group
.
name
,
ad_group_ad_asset_view
.
asset
,
asset
.
name
,
metrics
.
clicks
,
metrics
.
impressions
FROM
ad_group_ad_asset_view
Learn more about app conversions and view through conversions or conversion tracking data .
