Annual Sales Planning is an important art, one that has been largely lost in the e-commerce era, as traditional web analytics packages focus on conversions, and not on actual customer behavior measured over time.
Strategically, we want to know what the future holds. We need to be able to react to business trends that are within our control.
In this example, a soft 2009 yields a customer file that is likely to generate a 4.4% decrease in annual sales.
So, what can we do to get business back on track?
First, let's calculate how many new customers we need, in order for the business to be at the same size as last year. In this case, if I increase new customers from 228,094 to 271,500, the annual sales total is constant.
Now, given that new customers dropped from 263,006 to 228,094 from 2008 to 2009, there must be a valid strategy in place to cause new customers to increase to 271,500.
As an analyst, your job is to communicate to your CEO, CFO, and/or CMO what it would cost to acquire enough new customers to keep the business at a flat sales level. If that cost is prohibitive, then it is reasonable to assume that the business will decline.
Next up --- we'll look at what has to happen across customer retention metrics, in order to keep the business flat.
Helping CEOs Understand How Customers Interact With Advertising, Products, Brands, and Channels
January 06, 2010
Planning: New Customers
Subscribe to: Post Comments (Atom)
Price / Customer Tradeoff
When you are developing categories, you likely look at your cost of goods and determine a price that (theoretically) delivers enough profit ...
It is time to find a few smart individuals in the world of e-mail analytics and data mining! And honestly, what follows is a dataset that y...
As is my tradition, I'm going to take a long weekend. No posts until early next week. I've been doing this for almost twenty years, ...
Sometimes you think "people already know this stuff". Sometimes you realize that Google Analytics give smart analysts almost no op...
Post a Comment
Note: Only a member of this blog may post a comment.