Tutorials for Lazy Marketers

Mastering the Google Cloud stack: BigQuery, Data Studio, Sheets, Supermetrics and more.

Sheets

Google Sheets Query Function

Learn how to take advantage of the QUERY function, letting you write SQL queries in Sheets.

Automation

SEO APIs: Ranked and Reviewed

A detailed review of the best APIs available for SEOs and how to them up and running.

Sheets

How to Productize Your Agency’s Services

Turning time consuming tasks into revenue generating products for an agency.

Data Studio

All the Latest Google Data Studio Hacks

Tracking Data Studio feature updates in real time, brought to you by the CIFL community.

BigQuery

Learning to Code for Technical Marketers

On avoiding rabbit holes + shiny object syndrome when climbing the technical ladder.

BigQuery

Stitch vs Supermetrics for BigQuery

Reviewing the best ETL tools on the market for building marketing data pipelines in BigQuery.

Sheets

Blockspring vs Supermetrics for Sheets

Reviewing the pros and cons of two powerful Google Sheets reporting automation Add-ons, Blockspring and Supermetrics.

BigQuery

Connecting Sheets and BigQuery

A bridge connecting Google Sheets to a BigQuery analytics warehouse. Automates creation of BQ views, tables, and uploading of data.

Data Studio

Getting Started with Google Data Studio

Diving into Data Studio: connecting a Google Sheets as a data source, building tables and charts, and styling them with themes.

BigQuery

Learning BigQuery SQL

Tutorials (cheat sheet included) using the Google Analytics sample dataset to walkthrough BigQuery SQL concepts like grouping, joining and unnesting.

Sheets

VLOOKUP like the Pros

Vlookup is the gateway drug of spreadsheet formulas - master it with this cheat Sheet.

Sheets

All the Google Sheets Formulas

Learn the only Google Sheets formulas you'll ever need in life (cheat sheet included). Includes 10 function hacks specifically for digital marketers.

Ready to automate your business?

Let's automate your marketing + ops processes in Sheets, Data Studio and BigQuery.

FIND OUT MORE