A Tool to Help Planning for Next Year

  |  October 31, 2008   |  Comments

Consider this approach to vetting new digital marketing ideas based on business goals, technical complexity, and ROI.

Because our economy (and industry) has a bleak outlook, everyone is freezing budgets and is afraid to spend money on development for next year. In this column, we'll look at a tool my company uses to help clients decide what functionality to spend money on. It's my hope that this model will help you determine how to continue growing your strategy wisely in the coming year and invest in features that will show the greatest ROI (define).

Functionality Matrix 1.0

Ten years ago, I was a software architect at artificial intelligence think tank Open Sesame in Cambridge, MA. A colleague had joined the team from a big management consulting company (I'm not sure which one) and brought with him something called a "functionality matrix." It was an Excel-based spreadsheet that plotted out every proposed piece of functionality for new software in its own cell.


click to enlarge

The layout was simple. Each big idea had its own row. The first cell in the row would represent the big idea. The remaining cells in the row (to the right of the big idea) would be the specific functionality ideas that could make up that big idea. For instance, if the big idea were "build an account area for users," then the functionality in the cells in that row would include "Let users sign in with e-mail/password," "Let users update their addresses," "Let users view their purchases," "Let users link directly to UPS/FedEx to track packages," "Let users cancel their account," and so on.

Each functionality cell was then rated "high," "medium," or "low" on two different scales: business value (how important the feature was to business) and technical complexity (how difficult it would be to build). Once every piece of functionality was graded, we then manually sorted all the cells by business value (high to low) and technical complexity (low to high). We would also sort the rows of big ideas by business value so the highs were at the top of the spreadsheet and the lows at the bottom. Finally, we would draw a jagged line down the spreadsheet to mark off what functionality was in phase 1, 2, and 3 of the project.

Functionality Matrix 2.0

Being a computer nerd with limited Excel skills, I decided to automate this process in 1997 by building a software application. It basically mirrored the process above but automated the sorting process and the phase demarcations. We used that software for many years to create development scope and phasing for our clients.

However, there's a big piece missing in that functionality matrix, and that piece is very relevant in this economic turmoil. It's the cost and ROI analysis component. Scoring each field high, medium, or low is great for a first-pass analysis of features and scope. But it isn't enough to plan a budget with or to create a profit and loss (P&L) sheet that reflects the development strategy.

Functionality Matrix 3.0

Enter version 3.0, which is what my company uses currently for its clients. We've built this into our client extranet, but you could easily achieve the same thing with some crafty Excel magic or by hand.

In this version of the functionality matrix, each major idea is also scored with a business goal. Examples of business goals include: increase conversion, increase traffic, increase loyalty, increase brand awareness, or reduce returns. Each goal has an actual metric attached. The increase conversion goal has a percentage attached to it, which is the percentage you feel the feature will increase conversion by. For example, if you are proposing a "people who bought this also bought that" functionality, you might think it will increase conversion by 10 percent. In that case, you would enter either "10 percent" into that field or the calculated number that is 10 percent of your conversion rate (depending on how you set up your math). There is some guesswork involved here; while it's easy to say that a big idea will increase conversion by 10 percent, it's more difficult to look at each functional component of that idea and assess its ROI.

Other goals have their own metrics. For example, "increase traffic" takes either a number of increased visitors or a percentage of increased visitors.

Each functionality field also has a "cost" field associated with it. Depending on how granular you want to get, you could have separate fields for "front-end development," "back-end development," "other software costs," and so on. The total number is how much this feature would cost to implement.

Once all the fields are filled with the cost and ROI numbers and phases have been attached to each field, it's time to look at the numbers.

Depending on how you implemented the matrix, you can now create graphs that show a lot of numbers. One important graph we have compares a site's current traffic, conversion rate, and annual sales with anticipated numbers for phases 1, 2, and 3 of development. The graph shows sales with conversion rate superimposed on it. Other graphs show sales numbers for each phase versus the costs of each phase.

Our model also takes personas into account, though this is probably harder to do in Excel. Each functionality field can be targeted to any number of personas that have been defined for the site. The charts showing the persona spread across all features per phase can easily be created, so you can see how well you're accommodating each persona per phase.

Finally, the functionality matrix's output is a direct input into a prospective P&L sheet. We automate this to make it easy, but it's a no-brainer to plug the finalized costs and sales data into your existing P&L sheet manually.

Conclusion

If you use a tool for forecasting your strategy ideas that works for you, terrific. If you don't, consider using this souped-up version of a functionality matrix to help you decide what features you'll implement next year. Any tool like this will be based on estimates and best guesses, but it's better than nothing.

In this tough economy in which budgets are being cut severely and people are afraid to spend money, a model like this can really help you decide what are the most important things to invest in next year and what can wait.

Thoughts, questions, comments? Let me know!

Until next time...

Jack

Join us for a Consumers and the Influence of Blogs: What It Means for Your Marketing Mix on November 20 at 2 pm EST. Find out how online consumers discover blogs and navigate between them, what kind of opportunity blogs represent for advertisers, and much more!

ClickZ Live Toronto Twitter Canada MD Kirstine Stewart to Keynote Toronto
ClickZ Live Toronto (May 14-16) is a new event addressing the rapidly changing landscape that digital marketers face. The agenda focuses on customer engagement and attaining maximum ROI through online marketing efforts across paid, owned & earned media. Register now and save!

ABOUT THE AUTHOR

Jack Aaronson

Jack Aaronson, CEO of The Aaronson Group and corporate lecturer, is a sought-after expert on enhanced user experiences, customer conversion, retention, and loyalty. If only a small percentage of people who arrive at your home page transact with your company (and even fewer return to transact again), Jack and his company can help. He also publishes a newsletter about multichannel marketing, personalization, user experience, and other related issues. He has keynoted most major marketing conferences around the world and regularly speaks at Shop.org and other major industry shows. You can learn more about Jack through his LinkedIn profile.

COMMENTSCommenting policy

comments powered by Disqus

Get the ClickZ Analytics newsletter delivered to you. Subscribe today!

COMMENTS

UPCOMING EVENTS

Featured White Papers

ion Interactive Marketing Apps for Landing Pages White Paper

Marketing Apps for Landing Pages White Paper
Marketing apps can elevate a formulaic landing page into a highly interactive user experience. Learn how to turn your static content into exciting marketing apps.

eMarketer: Redefining Mobile-Only Users: Millions Selectively Avoid the Desktop

Redefining 'Mobile-Only' Users: Millions Selectively Avoid the Desktop
A new breed of selective mobile-only consumers has emerged. What are the demos of these users and how and where can marketers reach them?

Jobs

    • Contact Center Professional
      Contact Center Professional (TCC: The Contact Center) - Hunt ValleyLooking to join a workforce that prides themselves on being routine and keeping...
    • Recruitment and Team Building Ambassador
      Recruitment and Team Building Ambassador (Agora Inc.) - BaltimoreAgora, www.agora-inc.com, continues to expand! In order to meet the needs of our...
    • Design and Publishing Specialist
      Design and Publishing Specialist (Bonner and Partners) - BaltimoreIf you’re a hungry self-starter, creative, organized and have an extreme...