Display & Video 360 資料轉換

將 Display & Video 360 資料移轉至 BigQuery 時,系統會將資料轉換成下列 BigQuery 表格和檢視表。

當您在 BigQuery 中檢視資料表和檢視表時,displayvideo_id 的值即為您的 Display & Video 360 合作夥伴或廣告客戶 ID。

Display & Video 360 資源 BigQuery 資料表 BigQuery 檢視表
資料移轉檔案
曝光 p_Impression_displayvideo_id Impression_displayvideo_id
點擊 p_Click_displayvideo_id Click_displayvideo_id
活動 p_Activity_displayvideo_id Activity_displayvideo_id
DV360 API 資源 (v3)
合作夥伴 p_Partner_displayvideo_id Partner_displayvideo_id
廣告主 p_Advertiser_displayvideo_id Advertiser_displayvideo_id
LineItem p_LineItem_displayvideo_id LineItem_displayvideo_id
LineItemTargeting p_LineItemTargeting_displayvideo_id LineItemTargeting_displayvideo_id
Campaign p_Campaign_displayvideo_id Campaign_displayvideo_id
CampaignTargeting p_CampaignTargeting_displayvideo_id CampaignTargeting_displayvideo_id
InsertionOrder p_InsertionOrder_displayvideo_id InsertionOrder_displayvideo_id
InsertionOrderTargeting p_InsertionOrderTargeting_displayvideo_id InsertionOrderTargeting_displayvideo_id
AdGroup p_AdGroup_displayvideo_id AdGroup_displayvideo_id
AdGroupTargeting p_AdGroupTargeting_displayvideo_id AdGroupTargeting_displayvideo_id
AdGroupAd p_AdGroupAd_displayvideo_id AdGroupAd_displayvideo_id
廣告素材 p_Creative_displayvideo_id Creative_displayvideo_id