Archive for July, 2007

The Beauty of Seasonality in Data

Friday, July 20th, 2007

In terms of dealing with data, many companies struggle with seasonal fluctuations.
seasonality of data
Some of the most common seasonal fluctuations I’ve seen are due to:

  • Holidays - like Christmas, Thanksgiving, Labor Day, etc.
  • Hallmark Holidays - like Valentines day, Mother’s day, etc.
  • Traditions - like New Year’s resolutions, etc.
  • School-related events - like spring & summer breaks, football season, homecoming, proms, school year starts, graduations, reunions, etc.
  • Actual Seasonal changes - like the coldness of winter, summer heat, rainy season, etc.

While some people see seasonality as the bane of their existence, I see it another way. For me…

SEASONALITY = OPPORTUNITY

They way I see it, the more complex something gets, the bigger the opportunity for those who are able to deal with it because the barrier to entry is high and the number of savvy companies that can figure out how to properly deal with it properly are low.

Seasonality mucks up data. Companies that don’t learn to deal with it correctly will make bad decisions. Not realizing that Easter falls in March next year could cause you to mimic activity from this year 2-3 weeks late, but not realizing that Easter was the cause of your increased sales this year is an even bigger missed opportunity.

To best tackle seasonality, mine your data and mine external industry data. Look for monthly, weekly and even daily fluctuations. Keep tabs on w/w, m/m and y/y growth rates. Also, keep a calendar of events that may cause fluctuations in data (site redesign), so you don’t mistakenly attribute that fluctuation to something else. And when you can identify a source for the seasonality, make an action plan for next year.

Understanding your seasonality is the first part. Acting upon the intelligence is the second. For example, if a weight loss company discovers that summer high school graduations cause a burst of new customers in June, target your late May to June advertising to reunion planning sites like facebook, classmates, yahoo groups, reunions.com or bidding on long-tail local reunion terms like “ehs 2007 reunion” (note: not a single advertiser has figured this one out yet) or “roosevelt high school 1994 class reunion”. Even consider creating a special plan targeted to those customers (Rapid Reunion Weight-Loss Program).

To be fair, many companies, especially retail, have seasonality built into their veins, but even these types of companies could easily improve if they understood what exactly is driving people’s interest and the exact timing of it.

If you are in a business affected by seasonality, be happy that your data has a pulse:

seaonal data chart

instead of a a flat line like this (call life support, we’ve got a flatliner):

non-seasonal data chart

Unknowingly Published

Friday, July 20th, 2007

Just found out Andy Beal has created a free SEO eBook based off two years of scholarship entries. There were some educational entries and some funny entries. My entry was all about humor and was shoved near the bottom of the book, despite its popularity because it probably embarassed Andy a bit - heck, I called him a “Master Baiter”. Kudos to Andy for working hard to make the scholarship contest more valuable.

The ebook is availble for a free download here (2.1mb pdf)

In related news, I was recently quoted on Omniture’s iPerceptions integration.

Sit and Sphinn Search Marketers

Thursday, July 12th, 2007

Danny Sullivan just launched a cool social networking site for search marketers called Sphinn. I decided to take Sphinn for a spin and must say it looks promising. It has Digg-like search news voting features, profiles that allow lots of great links to other social sites & personal blog RSS pulls, a shared events calendar, and some cool networking components.

The service just launched, so expect lots of bugs and some spam at first, but from what I can tell, Sphinn will be a great place to keep up on search news that matters and a place to connect and keep track of your fellow search peers.

My LinkedIn Network Has Grown

Tuesday, July 10th, 2007

I just added my 200th LinkedIn connection and I must say it feels good. I’m proud of it because it is an indicator of my networking skills and general likeability, especially considering I’ve always worked for very small companies, have never hired a consultant, rarely consult others, and rarely get to go to conferences. 98% of my network consists of people I’ve had several in-person discussions with and the other 2% are people I share common interest or situations with (more on this topic below).

LinkedIn
According to LinkedSEO, I’m the 2nd most well-connected SEO in the Greater Seattle area. I’m sure my buddy Rand will catch up to me soon, but for now Dana Melick is the only person listed above me and it appears that Dana Melick is more of a salesman of SEO services than an SEO practitioner.

LinkedIn is definitely hitting critical mass. In the past couple months, I’ve seen tons of people jumping on the service. Social networking for business seems to have caught on. LinkedIn is doing a great job of staying focused on launching features that compliment their core focus. LinkedIn Answers is working well, groups are cool, recommendations make complete sense and the ability to find unbiased references when hiring people is awesome.

My tips for anyone looking to grow their LinkedIn network:

  • Connect with only people you know or trust. This isn’t like myspace where having tons of friends makes you look cool. People are weary of connecting with people with large networks and recommendations from a stranger are essentially worthless.
  • If you have a good conversation with someone and get their business card, send a LinkedIn request within 3 days and remind them exactly who you are. Don’t wait to long because you may forget who they are and they may forget who you are, which greatly reduces the likelyhood of a connection.
  • Use LinkedIn as your rolodex. It is where you keep all your important contacts.
  • Don’t recommend people you don’t believe in. I haven’t done it, but I am confident it will come back to bite you.
  • Avoid linking up with recruiters unless you want to scare your boss or co-workers.
  • Don’t be afraid to connect with a competitor. Being connected to them allows you to see who they are working with based off their new connections. Besides, you never know when a competitor will become an ally when tackling an issue that affects you both.
  • If you participate in Answers, know what you are talking about. Stupid answers (or even questions) can leave a scar on your entire career. No pressure ;) .
  • Help people out in your network.

And, of course, if you know me or think you should know me, definately check out my LinkedIn profile and send me a request. My email is my [first name]@[the website address you are visiting].com. Here’s a link to my profile:
View Dustin Woodard's profile on LinkedIn

Blogging Excuse: Server Issues and DNS Changes

Saturday, July 7th, 2007

My blog has been a bit offline due to server issues, DNS changes, sickness & being incredibly busy. I realize not blogging and making excuses is lame, but I just wanted to drop a note that I am still here and the blog is very much alive. In fact, I fully expect a plethora posts in the near future.