Training Annielytics Dashboard Course (Online) If you are a marketer who wants to learn more about how to work with Google Analytics and create sexy … [Read more...]
Search Results for: excel
How To Create A Dynamic Chart From A Pivot Table [VIDEO]
In a post I wrote last week, I demonstrated in a video how to use advanced filters (one of Excel's best-kept secrets) to divide a list of keywords … [Read more...]
Regular Expressions: Don’t Use Google Analytics Without Them
I'll admit it: I used to be a regexaphobe. When I was new to analytics, I remember someone sending me a snippet of regular expressions (AKA regex) to … [Read more...]
My Biggest Pivot Table Annoyance (And How To Fix It)
If you use pivot tables in Excel a lot like I do and you've ever had to pivot data with long entries, such as URLs (like from a Screaming … [Read more...]
How To Create Pivot Table-Friendly Custom Reports in Google Analytics
Normally, in Google Analytics, if you create a custom report and you need more than one dimension, you create drill-down dimensions like … [Read more...]