As with other campaign types, you can use
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.