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

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

Features

  • Supports all Google Analytics dimensions and metrics such as Users Sessions
    Page Load Time Browser etc.
  • Selectively import data with the filter clause: ga:browser==Firefox

Upcoming Features

  • Cohorts and Lifetime value
  • Multiple segments
  • Incremental/Upsert

2-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 (require), Dimensions, and Date Range to preview your data.
  • You can also customize your query with Filter. Here are some basic syntax:

Metric Filters

Operator
Description
Examples

==

Equals

ga:timeOnPage==10

!=

Does not equal

ga:timeOnPage!=10

>

Greater than

ga:timeOnPage>10

<

Less than

ga:timeOnPage<10

>=

Greater than or equal to

ga:timeOnPage>=10

<=

Less than or equal to

ga:timeOnPage<=10

Dimension Filters

Operator
Description
Example

==

Exact match

ga:country==Singapore

!=

Does not match

ga:country!=Singapore

=@

Contains substring

ga:country=@si

!@

Does not contain substring

ga:country!@si

=~

Contains a match for the regular expression

ga:country=~^s.*

!~

Does not match regular expression

ga: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.

  • 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.