Trasformazione dei dati di Display & Video 360
Quando i dati Display & Video 360 vengono trasferiti in 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 |
| Clic | p_Click_displayvideo_id | Click_displayvideo_id |
| Activity | p_Activity_displayvideo_id | Activity_displayvideo_id |
| Risorsa API DV360 (v3) | ||
| 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 |