Google Display & Video 360

Google Display & Video 360 is the evolution and consolidation of DoubleClick Bid Manager, Campaign Manager, Studio, and Audience Center. It offers a single tool for planning campaigns, designing and managing creative, organizing and applying audience data, finding and buying inventory, measuring and optimizing campaigns.

How to Connect

There are two ways to connect to Google Display & Video 360: via the Sources connection wizard in the Web UI (recommended), or using SQL statements in the CData Virtuality Studio or the Code Editor in the Web UI. Here, we describe the first way; for the second way, see the the subpage.

1. Go to the Sources tab and click + New Source:

2. Find the Google Display & Video 360 button in the list of connectors or type ‘google display’ in the search field and select it:

3. Click the button, change the data source name if needed, enter the client ID and secret, and click 'Sign in with Google':

Usage 

The Google Display & Video 360 API connector introduces a new google_display_video virtual schema that contains the following stored procedures:

In addition to these public API procedures, there is the google_display_video_examples virtual schema that shows an exemplary usage of the public API:

If not needed, you can delete all the example views directly by dropping google_display_video_examples.