Data Model
The CData Tableau Connector for Google Campaign Manager 360 models Google Campaign Manager 360 entities in relational Tables, Views, and Stored Procedures. The provided tables will give you an overview of your account information and the reports available for DoubleClick Campaign Manager queries.
The connector uses the Google Campaign Manager 360 API to process supported filters. The connector processes other filters client-side within the connector.
Create Additional Schemas
The CreateCustomSchema stored procedure can be used to easily generate new schema files for a given report. This procedure takes the TableName and a report ID and builds a schema file that can be read by the connector.
If the Location connection property is set, the file will be output to that folder. Otherwise, the OutputFolder input can be used to specify an output folder. To begin querying these new files, simply set the Location connection property to the folder containing these new schema files.
Views
Views are tables that cannot be modified. Typically, data that are read-only and cannot be updated are shown as views.
Stored Procedures
Stored Procedures are function-like interfaces to the data source. They can be used to search, update, and modify information in the data source.