與其他廣告活動類型一樣,您可以使用
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
轉換次數前十名的應用程式
如果多個應用程式的發布者想瞭解轉換次數前十名的應用程式,可以使用下列查詢:
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
查詢應用程式安裝次數
在應用程式廣告活動中,「安裝」通常會記錄為轉換。您可以查詢 metrics.conversions 或 metrics.all_conversions,擷取安裝資料。如要將安裝次數與其他轉換類型區隔開來,請依 segments.conversion_action 區隔報表,找出與安裝次數相關聯的特定轉換動作。
SELECT
campaign.id,
campaign.name,
metrics.conversions,
segments.conversion_action
FROM campaign
WHERE campaign.advertising_channel_type = 'MULTI_CHANNEL'
AND campaign.advertising_channel_sub_type = 'APP_CAMPAIGN'
查詢資產名稱和成效
如要擷取應用程式廣告活動中特定素材資源 (廣告素材) 的成效指標,可以查詢 ad_group_ad_asset_view 資源。這個檢視畫面會顯示素材資源層級的成效資料。您也可以直接在查詢中選取 asset.name,因為 asset 是已歸因的資源。
SELECT
ad_group.name,
ad_group_ad_asset_view.asset,
asset.name,
metrics.clicks,
metrics.impressions
FROM ad_group_ad_asset_view
進一步瞭解應用程式轉換和瀏覽後轉換,或轉換追蹤資料。