Create the Connection
In Tableau CRM, click the gear icon (Gear icon) and select Data Manager.
In the data manager, click the Connect tab.
Click Connect to Data.
Click Add Connection.
Click the connector’s icon and enter its settings, as described in the Connection Settings section.
When you finish entering the settings, either click Save or Save & Test. Save & Test validates your settings by attempting to connect to the source. If the connection fails, Tableau CRM shows possible reasons.
Connection Settings
All settings require a value, unless otherwise indicated.
SETTING DESCRIPTION
Connection Name Identifies the connection. Use a convention that lets you easily distinguish between different connections.
Developer Name API name for the connection. This name can’t include spaces. The API name is used in your dataflows to reference data extracted through this connection. You can’t change the developer name after you create the connection.
Description Description of the connection for internal use.
APIVersion Version of the Google Core Reporting API used for the connection. The Google Analytics connector uses Core Reporting API v3. This value is populated for you.
NOTE: For information about limits associated with Core Reporting API v3, see Google’s Limits and Quotas on API Requests guide
Client Email Enter the client_email value from the JSON file.
Private Key Enter the private_key value from the JSON file.
NOTE: Don’t include “private_key”: “—-BEGIN PRIVATE KEY—-\n at the start of the key and \n—-END PRIVATE KEY—-\n” at the end.
Advanced Object Properties
Each time you connect to an object with a Google Analytics connection, you also provide advanced properties for the object. The Google Core Reporting API uses these properties to query the object in Google Analytics. All settings require a value.
Screenshot of advanced object properties dialog
PROPERTY VALUE
Enter in the format YYYY-MM-DD, or use a relative date keyword, such as today, yesterday, or NdaysAgo, where N is a positive integer.
ViewID The View ID for the Google Analytics account, which determines which data is available for sync. You can find the View ID in the account’s View Settings in Google Analytics.
EndDate The end date of the date range that you want to sync.
Enter in the format YYYY-MM-DD, or use a relative date keyword, such as today, yesterday, or NdaysAgo, where N is a positive integer.
NOTE: For more information about supported StartDate and ecuador phone number EndDate values, see Google’s Core Reporting API Reference Guide.
Google Analytics Connector considerations
Keep these behaviors in mind when working with the Google Analytics connector.
Maximum number of characters in a field is 32,000.
Maximum number of concurrent data sync runs is 3.
You can sync data from up to 100 objects in Tableau CRM. This total includes local and external objects.
Connected object names must start with a letter and contain only letters, digits, or underscores. Object names cannot have consecutive underscores or end with an underscore.
This connector can sync up to 10 million rows or 5 GB per object, whichever limit it reaches first.
Google Analytics limits the number of rows that you can sync for each object to 1 million. When you sync more than 1 million rows, Tableau CRM aggregates data from the extra rows and syncs it as a row marked “Others.”
Custom fields are not supported.