Some or all of the information on this page might not apply to Trusted Cloud by S3NS.
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 |
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2025-07-02 UTC.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-07-02 UTC."],[[["Display & Video 360 data, when moved to BigQuery, are converted into specific tables and views."],["The BigQuery tables and views are created based on both Data Transfer files and DV360 API resources."],["Data Transfer files like Impression, Click, and Activity are transformed into BigQuery tables (p\\_Impression, p\\_Click, p\\_Activity) and views (Impression, Click, Activity) respectively."],["DV360 API resources such as Partner, Advertiser, and LineItem are converted into their respective BigQuery tables (p\\_Partner, p\\_Advertiser, p\\_LineItem) and views (Partner, Advertiser, LineItem)."],["The `displayvideo_id` in BigQuery tables and views represents either the Display & Video 360 partner or advertiser ID."]]],[]]
