Check out the Demo Pipeline Data Studio dashboard
See how we ultimately used Data Studio to answer the question we set out to answer about the CIFL blog:
Which marketing channel drove the most signups last September and October, while we were running ad campaigns?
Which marketing channel drove the most signups last September and October, while we were running ad campaigns?
Build your Agency Data Pipeline
Bring your digital agency into the 22nd century
Already enrolled?
Sign in to continue learning.
Sign in to continue learning.
Table of contents
Intro to the Course Pipeline Project
Intro to the Course Pipeline Project
Draft
WTF is ADP?
Draft
Copy the Tracking Plan Template
Draft
Check out the Demo Pipeline Tracking Plan
Draft
Check out the Demo Pipeline SQL Models on Github
Draft
Check out the Demo Pipeline Data Studio dashboard
Start your Pipeline with a Question
Start your Pipeline with a Question
Draft
Intro to question asking
Draft
Demo questions for the CIFL pipeline
Translating your Question into a Tracking Plan
Translating your Question into a Tracking Plan
Draft
Meet the Tracking Plan
Draft
Mapping out your Data Sources
Draft
Planning your Data Models
Draft
Scoping out each Site or Client
Firing up your Data Feeds
Firing up your Data Feeds
Draft
Intro to data feeds
Draft
BigQuery initial setup
Draft
Setting up your BigQuery tables
Draft
Pushing data from Sheets to BigQuery
Draft
Supermetrics quickstart for beginners
Draft
Pulling data from unsupported APIs into the Tracking Plan
Using Stitch for Automated Data Feeding
Using Stitch for Automated Data Feeding
Draft
Stitch initial setup
Draft
Pulling GA data using Stitch
Draft
Pulling Adwords data using Stitch
Draft
Pulling FB Ads data using Stitch
Writing SQL queries to answer your questions
Writing SQL queries to answer your questions
Draft
Intro to DBT for SQL data modeling
Draft
Creating your DBT project
Draft
Connect your BigQuery database to DBT
Draft
Writing your 'processing' level SQL queries
Draft
Writing your 'join' level SQL models
Draft
Sidenote: on debugging DBT models
Draft
Pro tip: standardizing URL structure
Draft
Pro tip: using DBT macros
Draft
Writing your 'admin' level SQL models
Draft
Writing your 'math' and 'visualization' level SQL models
Visualizing your analysis in Data Studio
Visualizing your analysis in Data Studio
Draft
Intro to visualization with Data Studio
Draft
QCing your raw data in Data Studio
Draft
Reaching the summit: answering your question
Draft
Answering ancillary questions
Draft
Pulling data from BigQuery into Sheets
Putting your Pipeline into production
Putting your Pipeline into production
Draft
Intro to productionalizing your pipeline
Draft
Pushing your SQL models to Github
Draft
Using Sinter to run your SQL models on a schedule
Draft
Scheduling your data pipeline
Draft
Testing changes to your data pipeline
Draft
QCing data using Supermetrics as a check
Yay! You're back.
Enter your info below to login.