Creating a custom Google Analytics report in a Google spreadsheet

Continuing my recent infatuation with dashboards in Google spreadsheets, I’ve been playing around with the Google Analytics Add-on to build a custom web analytics dashboard in a Google spreadsheet. The idea originated from discussions with my wife about the tedium of preparing month-end website performance reports for her content management clients. This dashboard was a … Continue reading Creating a custom Google Analytics report in a Google spreadsheet

Creating a dynamic dashboard in Google Spreadsheets to track sales for a digital product launch

This article covers how to build a dynamic dashboard in Google Sheets, using formulas and data validation methods so that charts change dynamically based on user input. Check out my course: Build Dashboards with Google Sheets and Data Studio This post is based on work I did in 2014 with The Write Life team to … Continue reading Creating a dynamic dashboard in Google Spreadsheets to track sales for a digital product launch