The Annielytics Dashboard Course Is Live!

I’ll keep this brief. As I predicted in this post, the Annielytics Dashboard Course is now live! We’ve been working around the clock to take the footage from my last live seminar and bring it online. What Drove Me I’m not going to repeat what I’ve already written at length in my last blog post […]

Annielytics Dashboard Course Coming To A Living Room Near You

At the request of many in the marketing community, I decided to move my three-day dashboard course online. And you can be alerted when it’s available by signing up via the form at the bottom of this page (if you’re more the shut-up-and-take-my-money type). UPDATE: It’s live. Check it out, yo! Why This Course? First off […]

Excel’s INDEX MATCH Alternative To VLOOKUP For Marketers [VIDEO]

Last week’s #FunctionFriday video tutorial covered VLOOKUP tips and techniques for marketers. This week’s video explores the INDEX MATCH alternative to VLOOKUP. Why would VLOOKUP need an understudy? Because VLOOKUPs require that the lookup column be the far-left column in your lookup data set (aka the table_array argument). The INDEX-MATCH dream team doesn’t have that […]

How To Clean Up Google Analytics’ Content Reports

One of the basic tenets of SEO is the handling of non-canonical URLs. Countless posts have been written on the topic, and it’s a topic that’s discussed at probably every Internet marketing conference. Yet when it comes to our analytics, my experience has been that typically little-to-no attention is dedicated to keeping our content reports […]

VLOOKUP Tips And Tricks For Marketers [VIDEO]

The VLOOKUP function in Excel is one of the most essential functions marketers need to master. It’s a staple in my tool set because it allows you to join any number of data sets, as long as they have one column in common. Sadly, as is the case with most really useful Excel techniques, it […]