AI-generated Key Takeaways
-
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 query below 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 query below 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 10 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
Learn more about app conversions and view through conversions or conversion tracking data .
