Sale!

David Krevitt – Build Your Agency Data Pipeline

Name: David Krevitt - Build Your Agency Data Pipeline
Availability: InStock

Original price was: $999.Current price is: $99.

Delivery Method: Digital download is available after purchase, and you can access your courses anytime, anywhere, using a computer, tablet, or smartphone.

Category: SEO & Design Website Tags: Build Your Agency Data Pipeline, David Krevitt, David Krevitt - Build Your Agency Data Pipeline

Description
Reviews (8)

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

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.

Proof Content

David Krevitt - Build Your Agency Data Pipeline

Archive: https://web.archive.org/web/20200921082753/https://learn.codingisforlosers.com/agency-data-pipeline/

8 reviews for David Krevitt – Build Your Agency Data Pipeline

There are no reviews yet.

David Krevitt – Build Your Agency Data Pipeline

Use the 30% Coupon Code: Sale30

David Krevitt – Build Your Agency Data Pipeline

Proof Content

8 reviews for David Krevitt – Build Your Agency Data Pipeline

Be the first to review “David Krevitt – Build Your Agency Data Pipeline” Cancel reply

David Krevitt – Build Your Agency Data Pipeline

Use the 30% Coupon Code: Sale30

David Krevitt – Build Your Agency Data Pipeline

Proof Content

8 reviews for David Krevitt – Build Your Agency Data Pipeline

Be the first to review “David Krevitt – Build Your Agency Data Pipeline” Cancel reply

Related products

Login

Register