Data Wrangling: the Final Showdown
Aggregating ALL the data we’ve pulled so far from Google Analytics and Search Console, to make one unified dataset.
The Lazy Toolbelt
Automate your work with Google Sheets, Blockspring and Supermetrics
Already enrolled?
Sign in to continue learning.
Sign in to continue learning.
Table of contents
Intro to the Lazy Toolbelt
Intro to the Lazy Toolbelt
Draft
Why the Lazy Toolbelt?
Draft
WTF is Blockspring?
Draft
WTF is Supermetrics?
What you'll Build
What you'll Build
Draft
Meet the Templates
Draft
Spreadsheet Template Design
Draft
The Blockspring Template
Draft
The Supermetrics Template
Wrangling Data with Blockspring
Wrangling Data with Blockspring
Draft
First: Install Blockspring
Draft
Your Turn: Chaining APIs Together
Draft
What Data to Pull?
Draft
Setting up Blocks
Draft
Your Turn: Diving into Blockspring
Draft
Rounding out the Template
Draft
Building Dropdown Menus in Sheets
Wrangling Data in Supermetrics
Wrangling Data in Supermetrics
Draft
First: Install Supermetrics
Draft
Key Differences in Supermetrics
Draft
Meet to the Supermetrics Sidebar
Draft
Building Queries in Supermetrics
Draft
Your Turn: Firing up Supermetrics
Draft
Modifying Supermetrics Queries
Draft
Your Turn: Getting Nimble with Supermetrics
Draft
Wrapping up with Supermetrics
Build your own Lazy Toolbelt
Build your own Lazy Toolbelt
Draft
Access the Template Vault
Draft
Pick an Add-on
Draft
Build your own Template
Draft
Get Help with a Project
Taking Action with your Wrangled Data
Taking Action with your Wrangled Data
Draft
Warning: Google Sheets Formulas Incoming
Draft
Data Wrangling: the Final Showdown
Draft
Teasing out your Next Steps
Draft
Your Turn: Taking Action
Draft
Chaining APIs Together with Blockspring
Draft
Using Blockspring for Team Communication