The Google Analytics Data Model lets you load your GA data into your relational databases via the Google Analytics Reporting API.
At this step, you must already have a modeling-support source. Select the source that you want to load your Google Analytics into.
Click on Create, choose Other Sources and select Google Analytics.
If you have previously connected to your Google Analytics account, you can select a property from the dropdown. If not, select + Connect new data source.
Holistics will first request your permission to connect to your Google Analytics account. The credentials will be saved for further use.
Next, select Metrics (required), Dimensions, and Date Range to build a Google Analytics query. For an in-depth guide about Google Analytics dimensions and metrics, please refer to this guide by Google.
Analytics API limits
Google Analytics only allows a maximum number of 7 Dimensions and 10 Metrics.
After that, customize your query with Filter. Some basic syntax:
|!=||Does not equal||ga:timeOnPage!=10|
|>=||Greater than or equal to||ga:timeOnPage>=10|
|<=||Less than or equal to||ga:timeOnPage<=10|
|!=||Does not match||ga:country!=Singapore|
|[email protected]||Contains substring||ga:[email protected]|
|[email protected]||Does not contain substring||ga:[email protected]|
|=~||Contains a match for the regular expression||ga:country=~^s.*|
|!~||Does not match regular expression||ga:country!~^s.*|
- OR: using a comma (
,) to define
- AND: using a semi-colon (
;) to define
For more details, please refer to Google Analytics's Filter Syntax docs.
After that, click Validate query to Preview your data, then Execute.
From Advanced Settings you can modify the destination table from Destination Settings, and control how column types will be cast from Sync Configuration. Please visit the dedicated page for more details.
Holistics allows relative date range when loading data from Google Analytics. Please refer to Working With Dates - Relative Date Syntax for more information.
Basing on the combination of your dimensions and metrics, a Google Analytics query may return aggregations based on sampled data instead of your full data. For more details, please refer to this documentation by Google.
When sampling is applied, Holistics will try to import the most accurate data provided.
Updated 4 months ago