Trasformazione dei dati di Display & Video 360
Quando i dati di Display & Video 360 vengono trasferiti a BigQuery, vengono trasformati nelle seguenti tabelle e viste BigQuery.
Quando visualizzi le tabelle e le visualizzazioni in BigQuery, il valore di displayvideo_id è l'ID partner o inserzionista Display & Video 360.
| Risorsa Display & Video 360 | Tabella BigQuery | Vista BigQuery |
|---|---|---|
| File Data Transfer | ||
| Impressione | p_Impression_displayvideo_id | Impression_displayvideo_id |
| Fai clic su | p_Click_displayvideo_id | Click_displayvideo_id |
| Attività | p_Activity_displayvideo_id | Activity_displayvideo_id |
| Risorsa API DV360 (v3) | ||
| Partner | p_Partner_displayvideo_id | Partner_displayvideo_id |
| Inserzionista | p_Advertiser_displayvideo_id | Advertiser_displayvideo_id |
| LineItem | p_LineItem_displayvideo_id | LineItem_displayvideo_id |
| LineItemTargeting | p_LineItemTargeting_displayvideo_id | LineItemTargeting_displayvideo_id |
| Campagna | 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 |
| Creatività | p_Creative_displayvideo_id | Creative_displayvideo_id |