Transformação de dados do Display & Video 360
Quando os dados do Display & Video 360 são transferidos para o BigQuery, são transformados nas seguintes tabelas e vistas do BigQuery.
Quando vê as tabelas e as vistas no BigQuery, o valor de displayvideo_id é o ID do anunciante ou do parceiro do Display & Video 360.
| Recurso do Display & Video 360 | Tabela do BigQuery | Vista do BigQuery |
|---|---|---|
| Ficheiros da Transferência de dados | ||
| Impressão | p_Impression_displayvideo_id | Impression_displayvideo_id |
| Clique | p_Click_displayvideo_id | Click_displayvideo_id |
| Activity | p_Activity_displayvideo_id | Activity_displayvideo_id |
| Recurso da API DV360 (v3) | ||
| Partner | p_Partner_displayvideo_id | Partner_displayvideo_id |
| Anunciante | p_Advertiser_displayvideo_id | Advertiser_displayvideo_id |
| LineItem | p_LineItem_displayvideo_id | LineItem_displayvideo_id |
| LineItemTargeting | p_LineItemTargeting_displayvideo_id | LineItemTargeting_displayvideo_id |
| Campanha | 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 |
| Criativo | p_Creative_displayvideo_id | Creative_displayvideo_id |