Reporting

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 .

Design a Mobile Site
View Site in Mobile | Classic
Share by: