Bring your digital agency into the 22nd century

Overview

Wrestle your agency's data analysis workflow completely to the ground, by building a BigQuery data pipeline to house + analyze all of your critical data. Down with chaos!

At CIFL, we operate the Agency Data Pipeline service for a number of digital agencies - ranging from SEO to eCommerce, and in size from 5 clients to 50.

This course completely opens the kimono on how we operate that service, and allows you to build + operate your own Agency Data Pipeline.

The course includes:

A detailed walkthrough of how we built our own internal data pipeline at CIFL, pulling data from 8 APIs (Google Analytics, FB Ads, and more) to answer the question: which is the highest performing marketing channel for the CIFL blog?
Roadmapping exercises and instructions for building your own data pipeline, specific to the challenges of your work.
A one-hour coaching session with David, commissioner of Coding is for Losers, to make sure your data pipeline tracking plan gets put into action.

Many thanks to Supermetrics and Stitch for providing demo accounts for use in building the course.

With love,
David
Commissioner, Coding is for Losers

What's included?

38 videos 5 files

Mastering Google Sheets, Data Studio and BigQuery

Helping you wrangle your data + automate your work, without (hardly ever) leaving the Google stack.

FAQ

Q

Is the course only for digital agency owners?

Nope - if you work with sales + marketing data in any way (Google Analytics, FB Ads, SEMrush, a CRM, Shopify, etc) in your work, you can benefit from data pipelining.

If you don't analyze digital marketing + sales data in your day-to-day work, I'd recommend not taking this course.

Q

How much do the tools cost to build my pipeline?

The tools required to build your pipeline are:

Stitch (Free up to 5mm rows pushed to a database, $100 / month and up after that) or Supermetrics ($50 / month) for pulling data from APIs
Google Sheets + Apps Script (Free)
Google BigQuery (or similar database) for data warehousing (free 12month trial + $300 credit, cost varies by usage after that)
DBT to model data using SQL (Free + open-source)
Sinter to run DBT models on a schedule (Free for up to 6 runs a day, $100 / month for unlimited runs)

So the bottom line is - the cost of your pipeline depends on the size of your pipeline. If you're pulling + storing a small amount of data, it may be completely free.

If you're pulling a large amount of data, it will be more expensive. The raw tool cost for most of our large Agency Data Pipeline implementations is around $500-$600 a month.

Build your Agency Data Pipeline

Overview

What's included?

Contents

Mastering Google Sheets, Data Studio and BigQuery

FAQ

Is the course only for digital agency owners?

How much do the tools cost to build my pipeline?