Display & Video 360 data transformation
When your Display & Video 360 data are transferred to BigQuery, they are transformed into the following BigQuery tables and views.
When you view the tables and views in BigQuery, the value for displayvideo_id is your Display & Video 360 partner or advertiser ID.
| Display & Video 360 resource | BigQuery table | BigQuery view |
|---|---|---|
| Data Transfer files | ||
| Impression | p_Impression_displayvideo_id | Impression_displayvideo_id |
| Click | p_Click_displayvideo_id | Click_displayvideo_id |
| Activity | p_Activity_displayvideo_id | Activity_displayvideo_id |
| DV360 API Resource (v3) | ||
| Partner | p_Partner_displayvideo_id | Partner_displayvideo_id |
| Advertiser | 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 |
| Creative | p_Creative_displayvideo_id | Creative_displayvideo_id |