App campaign reporting

  • 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 performance metrics for App campaigns.

Impressions and clicks in the last 30 days

The following query retrieves 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',
    'APP_CAMPAIGN_FOR_PRE_REGISTRATION'
  )
  AND segments.date DURING LAST_30_DAYS

List ad groups for App campaigns

The following query retrieves ad groups associated with App campaigns sorted by ad group name.

SELECT
  ad_group.id,
  ad_group.name,
  campaign.id,
  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 IN (
    'APP_CAMPAIGN',
    'APP_CAMPAIGN_FOR_ENGAGEMENT',
    'APP_CAMPAIGN_FOR_PRE_REGISTRATION'
  )
ORDER BY ad_group.name ASC
LIMIT 100

Top 10 campaigns by conversions

The following query retrieves the top 10 App campaigns for a specific package name based on total conversions. To aggregate metric totals across multiple campaigns for a single app, perform the aggregation in your client code.

SELECT
  campaign.id,
  campaign.name,
  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

App installs

In App campaigns, installs are recorded as conversions. You can retrieve install data by querying metrics.conversions or metrics.all_conversions and segmenting by segments.conversion_action.

SELECT
  campaign.id,
  campaign.name,
  segments.conversion_action,
  metrics.conversions
FROM campaign
WHERE
  campaign.advertising_channel_type = 'MULTI_CHANNEL'
  AND campaign.advertising_channel_sub_type = 'APP_CAMPAIGN'

SKAdNetwork data for iOS

For iOS App campaigns, Apple's SKAdNetwork framework reports installs and conversions. You can query metrics.sk_ad_network_installs and metrics.sk_ad_network_total_conversions, and segment by fields such as segments.sk_ad_network_fine_conversion_value or segments.sk_ad_network_user_type.

SELECT
  campaign.id,
  campaign.name,
  segments.sk_ad_network_fine_conversion_value,
  segments.sk_ad_network_user_type,
  metrics.sk_ad_network_installs,
  metrics.sk_ad_network_total_conversions
FROM campaign
WHERE
  campaign.advertising_channel_type = 'MULTI_CHANNEL'
  AND campaign.advertising_channel_sub_type = 'APP_CAMPAIGN'

Asset names and performance

To retrieve performance metrics for specific creative assets in an App campaign, query the ad_group_ad_asset_view resource. You can select asset.name directly because asset is an attributed resource.

SELECT
  campaign.id,
  ad_group.name,
  ad_group_ad_asset_view.asset,
  asset.name,
  metrics.clicks,
  metrics.impressions
FROM ad_group_ad_asset_view
WHERE
  campaign.advertising_channel_type = 'MULTI_CHANNEL'
  AND campaign.advertising_channel_sub_type IN (
    'APP_CAMPAIGN',
    'APP_CAMPAIGN_FOR_ENGAGEMENT',
    'APP_CAMPAIGN_FOR_PRE_REGISTRATION'
  )

Top asset combinations

Starting in v23, you can query the app_top_combination_view resource to retrieve the top-performing creative asset combinations that served together in an App campaign.

SELECT
  campaign.id,
  ad_group.id,
  ad_group.name,
  app_top_combination_view.resource_name,
  app_top_combination_view.ad_group_top_combinations
FROM app_top_combination_view
WHERE
  campaign.advertising_channel_type = 'MULTI_CHANNEL'
  AND campaign.advertising_channel_sub_type IN (
    'APP_CAMPAIGN',
    'APP_CAMPAIGN_FOR_ENGAGEMENT',
    'APP_CAMPAIGN_FOR_PRE_REGISTRATION'
  )

Learn more about app conversions and view-through conversions or conversion tracking data.

Previous
Code example