Holistics Docs - End-to-End Business Intelligence Platform

Holistics Documentation

Welcome to the Holistics Documentation page. You'll find comprehensive guides and documentation to help you start working with Holistics as quickly as possible, as well as support if you get stuck. Let's jump right in!

Get Started

Import Google Analytics Data

📘

Update: Google Analytics Data Import is replaced with Third-party model feature

The Google Analytics Data Import feature will be replaced with Third-party model feature for new companies signing up after 12 Dec 2019. For more information, please refer to Google Analytics Setup.

If your company signs up before 12 Dec 2019, please ignore this update.

The Google Analytics integration lets you import your Google Analytics data — provided by the Google Analytics Reporting API — into your relational databases.

Step Setup

1. Create a Google Analytics data source

https://secure.holistics.io/manage/data_sources

Holistics will first request your permission to access your Google Analytics data. The credentials will be saved for further uses.

2. Import Your Data

https://secure.holistics.io/data_imports

  • Select a Property and a Analytics View
  • Select Metrics (required), Dimensions, and Date Range to preview your data.
  • You can also customize your query with Filter. Here are some basic syntax:

Metric Filters

OperatorDescriptionExamples
==Equalsga:timeOnPage==10
!=Does not equalga:timeOnPage!=10
>Greater thanga:timeOnPage>10
<Less thanga:timeOnPage<10
>=Greater than or equal toga:timeOnPage>=10
<=Less than or equal toga:timeOnPage<=10

Dimension Filters

OperatorDescriptionExample
==Exact matchga:country==Singapore
!=Does not matchga:country!=Singapore
[email protected]Contains substringga:[email protected]
[email protected]Does not contain substringga:[email protected]
=~Contains a match for the regular expressionga:country=~^s.*
!~Does not match regular expressionga:country!~^s.*

Combining filters

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

Please follow the Filter Syntax for more information.

For an in-depth guide about Google Analytics dimensions and metrics, please refer to this guide by Google: Dimensions and metrics

  • Click Validate query to Preview your data

Note: Google Analytics only allows a maximum number of 7 Dimensions and 10 Metrics.

Relative Date

Please note that Holistics allows users to select relative date range when importing Google Analytics.

With this feature, you could get the newest data from Google Analytics by setting the End Date to a relative date (for example, Yesterday, a Week ago, etc.) rather than a Specific Date (2019-01-05)

3. Select Destination

  • The final step is to select a destination data source for storing the Google Analytics data

Note About Sampling

Google Analytics may or may not return sampled data based on your query (dimensions and metrics). When sampling is applied, Holistics will try to import the most accurate data provided.

Auto-import data from Google Analytics to Database

For example, if you want to import your Google Analytics Data weekly, you need to choose a relative date range (7 days ago - yesterday)

By doing this, your Data from Google Analytics will always be updated from a week ago to yesterday of your current date. Therefore, you will always get weekly updated data from Google Analytics going to your Database

Updated 7 months ago

Import Google Analytics Data


Suggested Edits are limited on API Reference Pages

You can only suggest edits to Markdown body content, but not to the API spec.