UPDATE: I shared this post because I know marketers are quite fond of the OFFSET function. But I share a much more stable alternative to the OFFSET function. If you’re building out a dashboard or large Excel file, the INDEX function will take less of a toll on your workbook than its more volatile OFFSET counterpart. And […]
Search Results for: excel
How To See If You’re Trashing Your Analytics With Campaign Tracking
Okay, I’m back from my blogging hiatus. I took a few months off from all blogging (guest blogging as well as my site) to focus on training for myself. In that time I finally learned VBA for Excel and SQL to rock Google Spreadsheets’ awesome query functions. During my time away several people asked me, […]
Seminars
In this three-day seminar you’ll learn how to create dynamic dashboards using the Google Analytics API – and even marry them to your data from your databases and/or Google Spreadsheets!