Skip to main content

Google Analytics Setup


Since December 2021, we are no longer supporting the new version of importing data from Google Analytics. Please check out the announcement and suggested solution here.

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

First, select a Property and an Analytics View.

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:

Metric Filters






Does not equal


Greater than



Less than



Greater than or equal to



Less than or equal to


Dimension Filters


Exact match



Does not match


[email protected]

Contains substring

ga:[email protected]

[email protected]

Does not contain substring

ga:[email protected]


Contains a match for the regular expression



Does not match regular expression


Combining filters

  • OR: using a comma (,) to define OR operator. Example:
ga:country==Hong Kong,ga:country=Canada
  • AND: using a semi-colon (;) to define AND operator. Example:

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.

Other Notes

Relative Date

Holistics allows relative date range when loading data from Google Analytics.

Data Sampling

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.