Connect Google Display & Video 360 to Google Sheets with Windsor.ai
+
Finally, all your marketing data from Google Display & Video 360 available in Google Sheets
About Google Display & Video 360
Google Display & Video 360 or DV360, formerly known as DoubleClick Bid Manager (DBM) is part of Googles Marketing Platform and allows marketers to buy and manage programmatic advertising across display, video, TV, audio and other channels.
About Google Sheets
Google Sheets is a web based spreadsheet tool. It allows end users to create spreadsheets, pivot tables, charts and run Google App Script code to automate various functions.
First step:
you need to select DV 360 as Data Source and Grant Access to Windsor.ai.
Second step:
Select Google sheets as a data destination.
Third Step:
You can choose between two options:
Option 1: Advanced and for large data volumes
- Click this link to install the Google Sheets add-on
- Enter your API key: defab2f1e4d0b69f2aa9fcca30c8abe0f996
- Start using the add-on in Google Sheets from the Add-ons menu in a Google Sheets document and select your fields
Option 2: Quickstart
Copy the snippet below into your Google Sheet. Only works for fast queries below 60 seconds, use the add-on in case of issues.
The URL works as an API data feed and the fields can be adjusted with the parameters in the URL.
You can add any field that is available in the data sources you have added.
=IMPORTDATA(“https://connectors.windsor.ai/dv360?api_key=defab2f1e4d0b69f2aa9fcca30c8abe0f996&date_preset=last_7d&fields=date,campaign,clicks,spend&_renderer=googlesheets”)
Instruction: The list of selected fields must contain a date field.
You should also read :
Connect Google Display & Video 360 to Excel
Data Studio Google Display & Video 360 (DV 360) Overview Report
Templates for Google Display & Video 360 and Google Sheets
Windsor.ai: Connecting all marketing data
See the value and return on every marketing touchpoint
Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketeers, whenever they want.
Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.