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 |