/ga-conversion-index

SQL models (in the DBT framework) for calculating top-performing channels and landing pages from Google Analytics data

MIT LicenseMIT

Google Analytics Conversion Indexing

SQL models (in the DBT framework) for calculating top-performing channels and landing pages from Google Analytics data.

These models leverage the Agency Data Pipeline stack we use internally:

  1. BigQuery as a data warehouse
  2. Stitch + Google Apps Script to push data to BigQuery
  3. The DBT SQL framework to model raw data into tables of metrics, and Sinter to run them from ‘le cloud’
  4. A Data Studio template to visualize it all

To get set up, read the blog post at:

https://codingisforlosers.com/google-analytics-bigquery-data-pipeline

And copy the Tracking Plan at the bottom of the post.

Questions? Need a custom setup? Holler to help@codingisforlosers.com.