The Google Analytics Data Model lets you load your GA data into your relational databases via the Google Analytics Reporting API.
Model your Google Analytics data
Please note that you need a SQL database to load your Google Analytics data into. If you don't have any, please check out our guide here.
1. Go to Data Modeling page
At this step, you must already have a modeling-support source. Select the source that you want to load your Google Analytics into.
##2. Create Data Model from Other Sources Click on Create, choose Other Sources and select Google Analytics.
##3. Connect to 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.
##4. Load your Data
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
Greater than or equal to
Less than or equal to
Does not match
Does not contain substring
Contains a match for the regular expression
Does not match regular expression
- 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.
##5. Advanced Settings 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.
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.