報表

與其他廣告活動類型一樣，您可以使用 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

進一步瞭解應用程式轉換和瀏覽後轉換或轉換追蹤資料。

上一頁
程式碼範例