TL;DR: User/visitor-based KPIs have never reflected actual users. They've only ever reflected clients (IOW, the combination of device and browser you … [Read more...]
How To Chart Year-Over-Year Google Analytics Reports In Excel [VIDEO]
Measuring year-over-year growth in your analytics data is oftentimes much more important than month-over-month traffic trends, especially if your … [Read more...]
How To Create A Scrolling Table In Excel [VIDEO]
In today's video I demonstrate how to create a scrolling table in Excel using the scrollbar option in your format controls. This is a great way to … [Read more...]
How To Use The SUMIF And SUMIFS Functions To Build Dynamic Dashboards [VIDEO]
In today's #FunctionFriday post we're going to look at how the SUMIF and SUMIFS functions can be used to build out interactive dashboards like the … [Read more...]
The INDEX Function: Excel’s More Stable Alternative To OFFSET [VIDEO]
Back in March I did a post on three marketing uses for the OFFSET function. But, truth be told, I avoid the OFFSET function like the plague. The … [Read more...]
- « Previous Page
- 1
- 2
- 3
- 4
- 5
- …
- 7
- Next Page »