Tim Wilson BLOG

Using Excel to Count Text Occurrences
Using Excel to Count Text Occurrences
By on January 19, 2015

[UPDATE 1/19/2015: A couple of comments have pointed out that COUNTIF would address this scenario in a single formula. That’s a great point…and one that had not occurred to me. ... read more »

Introducing the Digital Analytics Power Hour Podcast
By on January 5, 2015

Happy New Year! Reflecting on 2014, I have to give it high marks from a personal and professional fulfillment front, and I’m looking to outperform those results in 2015. Who Doesn’t ... read more »

Every Analyst Should Follow fivethirtyeight.com
By on December 30, 2014

I’ll admit it: I’m a Nate Silver fanboy. That fandom is rooted in my political junky-ism and dates back to the first iteration of fivethirtyeight.com back in 2008. Since then, ... read more »

Excel Dropdowns Done Right
By on November 5, 2014

Do you used in-cell dropdowns in your spreadsheets? I used them all the time. It’s both an ease-of-use and a data quality maneuver: clicking a dropdown is faster than typing ... read more »

10 Tips for Building a Dashboard in Excel
By on October 19, 2014

This post has an unintentionally link bait-y post title, I realize. But, I did a quick thought experiment a few weeks ago after walking a client through the structure of ... read more »

Exploring Optimal Post Timing…Redux
By on October 4, 2014

Back in 2012, I developed an Excel worksheet that would take post-level data exported from Facebook Insights and do a little pivot tabling on it to generate some simple heat ... read more »

What I Love: Adobe and Google Analytics*
By on September 24, 2014

While in Atlanta last week for ACCELERATE, I got into the age-old discussion of “Adobe Analytics vs. Google Analytics.” I’m up to my elbows in both of them, and they’re ... read more »

5 Tips for #ACCELERATE Exceptionalism
By on August 11, 2014

Next month’s ACCELERATE conference in Atlanta on September 18th will be the fifth — FIFTH!!! — one. I wish I could say I’d attended every one, but, sadly, I missed ... read more »

I’ve Become Aware that Awareness Is a #measure Bugaboo
By on August 8, 2014

A Big Question that social and digital media marketers grapple with constantly, whether they realize it or not: Is “awareness” a valid objective for marketing activity? I’ve gotten into more than a ... read more »

Hello. I’m a Radical Analytics Pragmatist
By on July 23, 2014

I was reading a post last week by one of the Big Names in web analytics…and it royally pissed me off. I started to comment and then thought, “Why pick ... read more »