Google Analytics and Amazon Redshift Integration

google-analytics-integrations

  • Simple drag-and-drop configuration
  • Load and integrate traffic, events, goal completions, Adwords & Adsense, site content and any other GA data type directly from Google Analytics into Amazon Redshift
  • Schedule data load and transformation and combine with other data, processes and services
  • Use in concert with other components to join Google Analytics data with transactional, marketing, CRM or social media
  • You can also access analytics data held in Google Adwords and Google BigQuery using the Google Adwords Query and Google BigQuery components

High performance Google Analytics data load into Amazon Redshift

How to Get Started

 

 

Google Analytics to Amazon Redshift Query Component

The Google Analytics Query component in Matillion ETL for Amazon Redshift provides drag-and-drop data load from Google Analytics into Amazon Redshift.  Easily load traffic, events, goal completions, adwords & adsense, site content and any other GA data into Amazon Redshift tables, as standalone jobs or as part of sophisticated integration orchestrations.

 

Features and Benefits

The Google Analytics Query component in Matillion ETL for Amazon Redshift delivers fast data load performance, with simple drag-and-drop configuration and is extensible to the most sophisticated data load and transform requirements.

  • Fast and simple – load and transform Google Analytics, Google Adwords and Google BigQuery data into Amazon Redshift in a drag-and-drop interface
  • Load and integrate Google Analytics Accounts, Profiles, Segments, Web Properties, Adsense, Adwords, Ecommerce, Events, Goal Completions, Site Content, Site Search, Site Speed and Traffic data
  • Basic and Advanced modes. Basic mode provides simple data selection and filtering.  Advanced mode provides a powerful SQL-like interface to query the Google Analytics API
  • Secure –SSL encryption for in-flight data. OAuth authentication
  • Implements Redshift best-practice – automatically sets column encoding settings on data loaded from Google Analytics. Specify distribution style (Key, Even or All) and Compound/Interleaved sort keys
  • Standalone data load or sophisticated integration – combine data from Google Analytics with data from other databases and systems.  Integrate with other AWS services including RDS, S3, DynamoDb, EMR, Kinesis, SQS and SNS
  • For Google Analytics Premium users, Matillion ETL for Amazon Redshift also provides data load components for Google BigQuery, allowing you to load Google BigQuery analytics data into Amazon Redshift
  • For Google Adwords users, Matillion ETL for Amazon Redshift also provides data load components for Google Adwords, allowing you to load Adwords data into Amazon Redshift and combine it with Google Analytics or other data
  • Monitor load status. Comprehensive logging, audit and alerting features

 

Google Analytics RS

 

Useful links:

 

Want to try the Google Analytics Query component in Matillion ETL for Amazon Redshift?

Arrange a free 1-hour demo, or start a free 14-day trial.