CData TDV Adapter for Google Analytics
Google Analytics Adapter
Google Analytics Version Support
The adapter supports both Universal Analytics and Google Analytics 4 APIs. The adapter provides a relational view of the Google Analytics profiles in your Google account or across your Google Apps domain. The adapter includes tables that contain often-used dimensions and metrics as columns; additionally, you can customize the table schemas or write your own to combine any valid set of dimensions and metrics. The adapter exposes the columns available through the Google Analytics Management API (Universal Analytics), the Google Anlytics Core Reporting API (Universal Analytics), the Data API (Google Analytics 4) and the Admin API (Google Analytics 4). You must enable these APIs by creating a project in the Google Developers Console. See "Connecting to Google Analytics" for a guide to creating a project and authenticating to the APIs.
The SQL Compliance
section shows the SQL syntax supported by the adapter and points out any limitations.