Google-sheets

Published on
September 28, 2020
Forecasting a Website's Organic Traffic
google-sheets seo
A Google Sheets template to forecast your site's organic traffic, using traffic data from Google Analytics and keyword opportunities from SEMrush.
Published on
April 7, 2020
Just Enough Google Sheets Formulas
google-sheets
Learn the only Google Sheets formulas you'll ever need in life: ARRAYFOMRULA, SPLIT, LEFT / RIGHT, IF / IFERROR, TODAY, TEXT, QUERY, working with dates, and combining data ranges. Cheat sheet included!
Published on
March 5, 2020
Google Sheets Query Function
google-sheets sql
The Google Sheets Query function replaces so many other spreadsheet functions it’s not even funny. FILTERs, AVERAGEs, and SUMs all go out the window when it enters the picture.
Published on
March 2, 2020
VLOOKUP like the Pros
google-sheets
Learn to use the VLOOKUP formula in Google Sheets to fetch data matches in a few unorthodox ways: to lookup right-to-left, from another Sheet, or based on multiple criteria.
Published on
December 2, 2019
Connecting Google Sheets and BigQuery
sql google-sheets
A bridge connecting Google Sheets to a BigQuery analytics warehouse. Automates creation of BigQuery tables + views, and uploading of data to tables on a schedule.

Forecasting a Website's Organic Traffic