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...]
Archives for June 2013
Real-World Example Of Advanced Filters in Excel [VIDEO]
Not too long ago I wrote a post on the Search Engine Land site about advanced filters and how they're an amazing alternative to regular expression … [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 Know If Your Data Is Sampled In Google Analytics
If you're working with a large site that gets a lot of traffic or are using advanced segments, you could be running reports with a lot of sampling. … [Read more...]
Give Your Data an Extreme Makeover
I had the privilege of speaking at SMX Advanced today in Seattle with other data aficionados. I took a slightly different approach (for me at least) … [Read more...]