Google Display & Video 360 / DV360

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

IDTypeNameDescription
account_idTEXTAccount IDYour DV360 advertiser ID
account_nameTEXTAccount NameYour DV360 advertiser name
audio_mutes_audioNUMERICAudio Mutes (Audio)Audio Mutes (Audio)
audio_unmutes_audioNUMERICAudio Unmutes (Audio)Audio Unmutes (Audio)
campaignTEXTCampaignThe Campaign Name
campaign_budget_idTEXTCampaign Budget IDThe unique ID of the campaign budget. Assigned by the system. Do not set for new budgets.
campaign_budget_nameTEXTCampaign Budget NameThe display name of the budget.
campaign_budget_unitTEXTCampaign Budget UnitSpecifies whether the budget is measured in currency or impressions.
campaign_goal_typeTEXTCampaign Goal TypeThe type of the campaign goal.
campaign_idTEXTCampaign IDThe Campaign ID
campaign_performance_goal_amountNUMERICCampaign Performance Goal AmountThe goal amount, in micros of the advertiser's currency.
campaign_performance_goal_percNUMERICCampaign Perfomance Goal PercentageThe decimal representation of the goal percentage in micros.
campaign_performance_goal_typeTEXTCampaign Performance Goal TypeThe type of the campaign perfomance goal.
campaign_planned_end_dateNUMERICCampaign Planned End DateEnd date that the campaign is expected to run. They are resolved relative to the parent advertiser's time zone.
campaign_planned_spendNUMERICCampaign Planned SpendThe amount the campaign is expected to spend for its given plannedDates.
campaign_planned_start_dateNUMERICCampaign Planned Start DateStart date that the campaign is expected to run. They are resolved relative to the parent advertiser's time zone.
campaign_update_timeDATECampaign Update TimeThe timestamp when the campaign was last updated. Assigned by the system.
clicksNUMERICClicksThe Number of Clicks
clicks_lead_conv_percNUMERICClicks Lead Conv PercentageClicks Leading to Conversions %
cm_ad_idTEXTCM Ad IDThe Campaign Manager 360 tracking ad associated with the creative.
cm_placement_idTEXTCM Placement IDThe unique ID of the Campaign Manager 360 placement associated with the creative.
companion_clicks_audioNUMERICCompanion Clicks (Audio)Companion Clicks (Audio)
companion_impressions_audioNUMERICCompanion Views (Audio)Companion Views (Audio)
complete_listens_audioNUMERICComplete Listens (Audio)Complete Listens (Audio)
complete_views_videoNUMERICComplete Views (Video)Complete Views (Video)
completion_rate_audioNUMERICCompletion Rate (Audio)Completion Rate (Audio)
conversionsNUMERICConversionsTotal conversions
creativeTEXTCreativeCreative
creative_create_timeDATECreative Create TimeThe timestamp when the creative was created. Assigned by the system.
creative_hosting_sourceTEXTCreative Hosting SourceIndicates where the creative is hosted.
creative_idTEXTCreative IDCreative ID
creative_update_timeDATECreative Update TimeThe timestamp when the creative was last updated. Assigned by the system.
creativetypeTEXTCreative TypeThe type of the creative.
currency_advertiserTEXTAdvertiser CurrencyAdvertiser currency
currency_partnerTEXTPartner CurrencyPartner currency
dateDATEDateThe Date
first_quartile_audioNUMERICFirst-Quartile (Audio)First-Quartile (Audio)
first_quartile_views_videoNUMERICFirst-Quartile Views (Video)First-Quartile Views (Video)
fullscreens_videoNUMERICFullscreens (Video)Fullscreens (Video)
impressionsNUMERICimpressionsThe Number of Impressions Served
insertion_orderTEXTInsertion OrderThe Insertion Order Name
insertion_order_idTEXTInsertion Order IDThe Insertion Order ID
line_itemTEXTLine Item NameThe Line Item Name
line_item_idTEXTLine Item IDThe Line Item ID
midpoint_audioNUMERICMidpoint (Audio)Midpoint (Audio)
midpoint_views_videoNUMERICMidpoint Views (Video)Midpoint Views (Video)
pauses_audioNUMERICPauses (Audio)Pauses (Audio)
post_click_conversionsNUMERICPost-Click ConversionsPost-Click Conversions
post_view_conversionsNUMERICPost-View ConversionsPost-View Conversions
revenue_usdNUMERICRevenue (USD)Revenue (USD)
skips_videoNUMERICSkips (Video)Skips (Video)
spendNUMERICSpend in Advertiser CurrencyThe Media Spend in the Advertiser Currency
spend_partnerNUMERICSpend in Partner CurrencyThe Media Spend in the Partner Currency
spend_usdNUMERICSpend in USDThe Media Spend in USD
starts_audioNUMERICStarts (Audio)Starts (Audio)
starts_videoNUMERICStarts (Video)Starts (Video)
stops_audioNUMERICStops (Audio)Stops (Audio)
third_quartile_audioNUMERICThird-Quartile (Audio)Third-Quartile (Audio)
third_quartile_views_videoNUMERICThird-Quartile Views (Video)Third-Quartile Views (Video)
total_conversionsNUMERICTotal ConversionsTotal Conversions
total_display_timeNUMERICTotal Display TimeTotal Display Time
totalcostNUMERICTotal Cost in Advertiser CurrencyThe Media Spend in the Advertiser Currency (Duplicate)
totalcost_usdNUMERICTotal Cost USDThe Media Spend in USD (Duplicate)