Reporting

Page Summary

• The GoogleAdsService.SearchStream can 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.