Google Analytics to Snowflake integration

google analytics matillion etl snowflake

  • 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 Snowflake
  • 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 and out of Snowflake

How to Get Started

 

 

Google Analytics to Snowflake Query Component

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

 

Features and Benefits

The Google Analytics Query component in Matillion ETL for Snowflake 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 Snowflake 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 APISecure –SSL encryption for in-flight data. OAuth authentication
  • Implements Snowflake best-practice – automatically sets column encoding settings on data loaded from Google Analytics.
  • Standalone data load or sophisticated integration – combine data from Google Analytics with data from other databases and systems.  Integrate with AWS services including RDS, S3, DynamoDb, EMR, Kinesis, SQS and SNS
  • For Google Analytics Premium users, Matillion ETL for Snowflake also provides data load components for Google BigQuery, allowing you to load Google BigQuery analytics data into Snowflake
  • For Google Adwords users, Matillion ETL for Snowflake also provides data load components for Google Adwords, allowing you to load Adwords data into Snowflake and combine it with Google Analytics or other data

 

Useful links: