和其他廣告活動類型一樣
GoogleAdsService.SearchStream敬上
，擷取應用程式廣告活動的屬性和 / 或成效指標。
應用程式廣告活動過去 30 天內的曝光次數和點擊次數
以下查詢會擷取最近 30 天內的曝光次數和點擊次數 。
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
按廣告群組名稱排序的應用程式廣告活動清單
即使沒有指標，以下查詢會擷取前 100 個應用程式廣告活動 但按廣告群組名稱排序
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
轉換次數前 10 名的應用程式
如果多個應用程式的發布者想知道哪些應用程式排名前十名 應用程式，可以使用下列查詢：
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
進一步瞭解應用程式轉換和瀏覽後轉換 或轉換追蹤資料。