This course can be delivered immediately. It explains how we created our own internal data pipeline for CIFL. The data was pulled from 8 APIs (Google Analytics. FB Ads.) to answer the following question: Which marketing channel is the best for the CIFL blog?
David Krevitt – Build Your Agency Data Pipeline
Overview
You can completely overhaul your agency’s data analysis workflow by creating a BigQuery data pipeline that houses and analyzes all your data. You can’t afford to be in chaos!
CIFL operates the following: Agency Data Pipeline Service for a variety of digital agencies – ranging in size from 5 to 50 clients, and ranging from SEO to SEO to eCommerce.
This course will teach you how to operate the service and give you the tools to create + manage your own. Agency Data Pipeline.
The course includes:
- This is a detailed walkthrough of how we created our internal data pipeline at CIFL. It pulls data from 8 APIs (Google Analytics and FB Ads) to answer the question, “Which marketing channel is the most effective for the CIFL Blog?”
- Instructions for building your data pipeline and roadmapping exercises, tailored to your needs.
- One-One hour coaching session DavidCommissioner of Coding is For Losers to ensure your data pipeline tracking plan is put into practice.
Supermetrics, Stitch and others are grateful to have provided demo accounts for course building.
With love
David
Commissioner Coding is for losers
David
Commissioner Coding is for losers
What’s included?
38 videos 5 files
Download immediately David Krevitt – Build Your Agency Data Pipeline
Contents
Introduction to the Course Pipeline Project
What is ADP?
Preview
Copy the Tracking Plan Template
Preview
Take a look at the Demo Pipeline Tracking Plan
Take a look at the Demo Pipeline Github SQL Models
Preview
Take a look at the Demo Pipeline Data Studio dashboard
Preview
Start planning! Pipeline Answer a Question
Intro to question asking
2 minutes
Preview
Demo questions for the CIFL Pipeline
7 minutes
Preview
Translating your Question into a Tracking Plan
Meet the Tracking Plan
5 minutes
Preview
Map your area Data Sources
6 minutes
You are planning your Data Models
7 minutes
Scope out each Client or Site
5 minutes
Get started with your Data Feeds
Intro to data feeds
2 minutes
Preview
BigQuery Initial Setup
4 minutes
Set up your BigQuery tables
7 minutes
Push data from Sheets into BigQuery
6 minutes
Supermetrics quickstart for beginners
3 minutes
Incorporating data from unsupported APIs into Tracking Plan
9 minutes
Preview
Stitch for Automated Data Feeding
Make the initial setup.
3 minutes
Stitch can be used to pull GA data
7 minutes
Preview
Pulling Adwords data using Stitch
4 minutes
Pulling FB Ads data using Stitch
4 minutes
SQL queries are written to answer questions
Introduction to DBT in SQL data modeling
4 minutes
Preview
Create your DBT Project
8 minutes
Connect your BigQuery data to DBT
8 mins
Writing your ‘processing’ level SQL queries
9 minutes
Write your ‘join” level SQL models
6 minutes
Sidenote: On debugging DBT-models
7 minutes
Preview
Pro tip: standardizing URL structure
3 minutes
Pro tip: using DBT macros
6 minutes
Writing your ‘admin’ level SQL models
3 minutes
Write your’maths’ and visualization’ SQL models
8 minutes
Visualizing your analysis Data Studio
Introduction to visualization Data Studio
3 minutes
QCing your raw data in Data Studio
6 minutes
Answering your question to reach the summit
11 minutes
Answering ancillary queries
4 minutes
BigQuery data into sheets
4 min
Put your Pipeline into production
Intro to productionalizing your pipeline
2 minutes
Pushing your SQL models onto Github
3 minutes
Sinter is a tool that allows you to run your SQL models on a scheduled basis.
5 minutes
Scheduling your data pipeline
5 minutes
Make sure to test any changes in your data pipeline
3 minutes
Supermetrics is used to check data quality.
5 minutes
Congrats!
Wapow! You made it.
2 minutes
Google Sheets: Mastering the basics Data Studio and BigQuery
This service will help you organize your data and automate all your work, without having to leave the Google stack.
Here’s what you’ll get in David Krevitt – Build Your Agency Data Pipeline
Course Features
- Lectures 1
- Quizzes 0
- Duration 10 weeks
- Skill level All levels
- Language English
- Students 116
- Assessments Yes