Mastering the Google Cloud stack: BigQuery, Data Studio, Sheets, Supermetrics and more.
Reviewing the best ETL tools on the market for building marketing data pipelines in BigQuery.
Reviewing the pros and cons of two powerful Google Sheets reporting automation Add-ons, Blockspring and Supermetrics.
A bridge connecting Google Sheets to a BigQuery analytics warehouse. Automates creation of BQ views, tables, and uploading of data.
Diving into Data Studio: connecting a Google Sheets as a data source, building tables and charts, and styling them with themes.
Reviewing all the best SEO APIs out there: Google Search Console, Majestic, Moz and SEMrush. Includes a starter Google Sheets template to get up and running.
Tutorials (cheat sheet included) using the Google Analytics sample dataset to walkthrough BigQuery SQL concepts like grouping, joining and unnesting.
Vlookup is the gateway drug of spreadsheet formulas - master it with this cheat Sheet.
Learn how lazy Google Sheets users take advantage of the QUERY function, which lets you write SQL queries in a Sheet. Sit back and watch the data flow.
Learn the only Google Sheets formulas you'll ever need in life (cheat sheet included). Includes 10 function hacks specifically for digital marketers.
Let's automate your marketing + ops processes in Sheets, Data Studio and BigQuery.