JDBC Driver for Google Ads

Build 21.0.8137

Google Ads Data Model

Overview

The CData JDBC Driver for Google Ads models Google Ads entities in relational views and stored procedures. The provided views will give you access to your Google Ads data using the Google Ads API.

Changes from the old Google Adwords API Reports

All report names, in addition to several field names have now changed from the Google Ads provider. Please refer to Google's documentation for name mappings between the deprecated Google AdWords API and the current Google Ads API.

Key Features

  • The driver models Google Ads entities like documents, folders, and groups as relational views, allowing you to write SQL to query Google Ads data.
  • Stored procedures allow you to execute operations to Google Ads.
  • Live connectivity to these objects means any changes to your Google Ads account are immediately reflected when using the driver.

Views

Views describes the available views. Views are statically defined to model Campaigns, AdGroups, Customers, and more. They are mainly used as a way to create your custom reports instead of being used standalone.

The Resources view shows the names of the resources, attribute resources and segmenting resources, which you need for the CreateReportSchema stored procedure.

Stored Procedures

Stored Procedures are function-like interfaces to Google Ads. Stored procedures allow you to execute operations to Google Ads, the most important being CreateReportSchema, which is used to create views from resources (like 'distance_view') with attribute resources (like 'customer' in this case) and segmenting resources (like 'campaign' in this case).

Collaborative Query Processing

The driver offloads as much of the SELECT statement processing as possible to Google Ads and then processes the rest of the query in memory. API limitations and requirements are also documented in this section.

See SupportEnhancedSQL for more information on how the driver circumvents API limitations with in-memory client-side processing.

Copyright (c) 2022 CData Software, Inc. - All rights reserved.
Build 21.0.8137