Google Display & Video 360 (DV360) Field Reference
Sample
https://connectors.windsor.ai/dv360?api_key=[your API key]&date_preset=last_7d&fields=campaign,clicks,spend,impressions,date,source&_renderer=csv
Fields
| ID | Type | Name | Description |
|---|---|---|---|
| account_id | TEXT | Account ID | Your DV360 advertiser ID |
| account_name | TEXT | Account Name | Your DV360 advertiser name |
| audio_mutes_audio | NUMERIC | Audio Mutes (Audio) | Audio Mutes (Audio) |
| audio_unmutes_audio | NUMERIC | Audio Unmutes (Audio) | Audio Unmutes (Audio) |
| campaign | TEXT | Campaign | The Campaign Name |
| campaign_budget_id | TEXT | Campaign Budget ID | The unique ID of the campaign budget. Assigned by the system. Do not set for new budgets. |
| campaign_budget_name | TEXT | Campaign Budget Name | The display name of the budget. |
| campaign_budget_unit | TEXT | Campaign Budget Unit | Specifies whether the budget is measured in currency or impressions. |
| campaign_goal_type | TEXT | Campaign Goal Type | The type of the campaign goal. |
| campaign_id | TEXT | Campaign ID | The Campaign ID |
| campaign_performance_goal_amount | NUMERIC | Campaign Performance Goal Amount | The goal amount, in micros of the advertiser's currency. |
| campaign_performance_goal_perc | NUMERIC | Campaign Perfomance Goal Percentage | The decimal representation of the goal percentage in micros. |
| campaign_performance_goal_type | TEXT | Campaign Performance Goal Type | The type of the campaign perfomance goal. |
| campaign_planned_end_date | NUMERIC | Campaign Planned End Date | End date that the campaign is expected to run. They are resolved relative to the parent advertiser's time zone. |
| campaign_planned_spend | NUMERIC | Campaign Planned Spend | The amount the campaign is expected to spend for its given plannedDates. |
| campaign_planned_start_date | NUMERIC | Campaign Planned Start Date | Start date that the campaign is expected to run. They are resolved relative to the parent advertiser's time zone. |
| campaign_update_time | DATE | Campaign Update Time | The timestamp when the campaign was last updated. Assigned by the system. |
| clicks | NUMERIC | Clicks | The Number of Clicks |
| clicks_lead_conv_perc | NUMERIC | Clicks Lead Conv Percentage | Clicks Leading to Conversions % |
| cm_ad_id | TEXT | CM Ad ID | The Campaign Manager 360 tracking ad associated with the creative. |
| cm_placement_id | TEXT | CM Placement ID | The unique ID of the Campaign Manager 360 placement associated with the creative. |
| companion_clicks_audio | NUMERIC | Companion Clicks (Audio) | Companion Clicks (Audio) |
| companion_impressions_audio | NUMERIC | Companion Views (Audio) | Companion Views (Audio) |
| complete_listens_audio | NUMERIC | Complete Listens (Audio) | Complete Listens (Audio) |
| complete_views_video | NUMERIC | Complete Views (Video) | Complete Views (Video) |
| completion_rate_audio | NUMERIC | Completion Rate (Audio) | Completion Rate (Audio) |
| conversions | NUMERIC | Conversions | Total conversions |
| creative | TEXT | Creative | Creative |
| creative_create_time | DATE | Creative Create Time | The timestamp when the creative was created. Assigned by the system. |
| creative_hosting_source | TEXT | Creative Hosting Source | Indicates where the creative is hosted. |
| creative_id | TEXT | Creative ID | Creative ID |
| creative_update_time | DATE | Creative Update Time | The timestamp when the creative was last updated. Assigned by the system. |
| creativetype | TEXT | Creative Type | The type of the creative. |
| currency_advertiser | TEXT | Advertiser Currency | Advertiser currency |
| currency_partner | TEXT | Partner Currency | Partner currency |
| date | DATE | Date | The Date |
| first_quartile_audio | NUMERIC | First-Quartile (Audio) | First-Quartile (Audio) |
| first_quartile_views_video | NUMERIC | First-Quartile Views (Video) | First-Quartile Views (Video) |
| fullscreens_video | NUMERIC | Fullscreens (Video) | Fullscreens (Video) |
| impressions | NUMERIC | impressions | The Number of Impressions Served |
| insertion_order | TEXT | Insertion Order | The Insertion Order Name |
| insertion_order_id | TEXT | Insertion Order ID | The Insertion Order ID |
| line_item | TEXT | Line Item Name | The Line Item Name |
| line_item_id | TEXT | Line Item ID | The Line Item ID |
| midpoint_audio | NUMERIC | Midpoint (Audio) | Midpoint (Audio) |
| midpoint_views_video | NUMERIC | Midpoint Views (Video) | Midpoint Views (Video) |
| pauses_audio | NUMERIC | Pauses (Audio) | Pauses (Audio) |
| post_click_conversions | NUMERIC | Post-Click Conversions | Post-Click Conversions |
| post_view_conversions | NUMERIC | Post-View Conversions | Post-View Conversions |
| revenue_advertiser | NUMERIC | Revenue (Advertiser Currency) | Revenue (Advertiser Currency) |
| revenue_partner | NUMERIC | Revenue (Partner Currency) | Revenue (Partner Currency) |
| revenue_usd | NUMERIC | Revenue (USD) | Revenue (USD) |
| skips_video | NUMERIC | Skips (Video) | Skips (Video) |
| spend | NUMERIC | Spend in Advertiser Currency | The Media Spend in the Advertiser Currency |
| spend_partner | NUMERIC | Spend in Partner Currency | The Media Spend in the Partner Currency |
| spend_usd | NUMERIC | Spend in USD | The Media Spend in USD |
| starts_audio | NUMERIC | Starts (Audio) | Starts (Audio) |
| starts_video | NUMERIC | Starts (Video) | Starts (Video) |
| stops_audio | NUMERIC | Stops (Audio) | Stops (Audio) |
| third_quartile_audio | NUMERIC | Third-Quartile (Audio) | Third-Quartile (Audio) |
| third_quartile_views_video | NUMERIC | Third-Quartile Views (Video) | Third-Quartile Views (Video) |
| total_conversions | NUMERIC | Total Conversions | Total Conversions |
| total_display_time | NUMERIC | Total Display Time | Total Display Time |
| totalcost | NUMERIC | Total Cost in Advertiser Currency | The Media Spend in the Advertiser Currency (Duplicate) |
| totalcost_usd | NUMERIC | Total Cost USD | The Media Spend in USD (Duplicate) |