Google Ads (Former AdWords)

With CData Virtuality, you can work with the Google Ads API which enables you to interact with the Google Ads platform. For more details, see Google Ads API Information.

How to Connect

There are two ways to connect to Google Ads: 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 subpage.

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

2. Find the Google Ads button in the list of connectors or type ‘google’ in the search field and select it:

3. Enter the data source name, click Sign in with Google, and follow the instructions:

Usage

The Google Ads connector introduces a new virtual schema google_ads_src that contains the following stored procedures:

In addition to these public API procedures, there is the google_ads_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_ads_examples.