ETL Google Analytics data to ClickHouse

Google Analytics is a number one tool in the world for collecting data on user behavior on websites and digital advertising optimization.

Renta automatically exports the stats from Google Analytics to ClickHouse and ensures secure data updates in your own data warehouse due to safely encrypted transfers. 

Advantages of using Renta:

  1. Renta avoids data sampling possibility with using Google Analytics API. Requests to API are built by days and if there’s no daily sampling you get unsampled data. 
  2. Renta can use Google Analytics data streaming. This type of integration doesn’t use API. You can integrate Renta with JavaScript and all the data that would be sent within Google Analytics will be now duplicated in your DWH in real time. This is how you escape sampling and get the data structure similar to Google Analytics 360.

Simple integration configuration

Set integration in 4 easy steps:

  1. Select Google Analytics from the list of integrations
  2. Add your Google Analytics account
  3. Indicate which parameters and metrics you want to export
  4. Add your data warehouse

It really is a matter of several minutes and simply 4 clicks.