Blog

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 solution to streamline the monthly web reporting and offer insights that might otherwise be missed. Rather than having to visit Google Analytics for each website in turn and click around gathering the necessary data, this pulls it all together in one place.

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.

This post is based on work I did in 2014 with The Write Life team to develop some behind-the-scenes sales data analysis during their 3-day digital bundle sale. The team wanted a simple way of gauging progress and seeing how the different sales channels fared as the sale took place.

Here’s the final dynamic dashboard:

dynamic dashboard in action
Interactive sales dashboard in a Google spreadsheet
Want your own copy of this dashboard?
Click here to access your copy of this template >>

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