Reporting

  • Use GoogleAdsService.SearchStream to retrieve App campaign data, including attributes and performance metrics.

  • Provided are example queries to get impressions and clicks of App campaigns for the last 30 days, list App campaigns sorted by ad group name, and identify the top 10 apps by conversions.

  • Queries can be tailored to specific needs such as filtering by date range, campaign type (APP_CAMPAIGN or APP_CAMPAIGN_FOR_ENGAGEMENT), or app ID.

  • Learn more about app conversions, view-through conversions, and conversion tracking data using the provided links.

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.

Previous
Code example