One of your frequently asked questions about Multichannel Forensics is this ... "Do you have a spreadsheet I can borrow that does the analysis for me?"
If you manage a two-channel (or two-brand or two-product) business, I have a spreadsheet for you.
Download this spreadsheet, and you are just 48 easy steps away from understanding the dynamics of your two-channel business.
Open the spreadsheet. Page down to cell K48, and enter each of the 48 metrics readily available from your database marketing team, or the forecast you maintain for new customers by channel.
Once you've completed this task, cells A6 - G28 illustrate the forecasted five year trajectory of your business!
Cells I4 - N14 illustrate the Migration Probability Table necessary for understanding the true underlying dynamics of your business.
Understand two-channel dynamics, and you can build a three-channel worksheet. Beyond three channels, things get interesting, that's where a simulation tool makes life easier.
Available Multichannel Forensics Resources:
Helping CEOs Understand How Customers Interact With Advertising, Products, Brands, and Channels
September 23, 2007
Free Multichannel Forensics Worksheet!
Subscribe to: Post Comments (Atom)
As usual, my summer schedule will dial back just a bit ... maybe three posts per week instead of five, sometimes four, sometimes more. And y...
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...
Sometimes you think "people already know this stuff". Sometimes you realize that Google Analytics give smart analysts almost no op...
If you want to understand why clients don't trust vendors and trade journalists, read this little peach from a week ago: Direct Mail is ...
Post a Comment
Note: Only a member of this blog may post a comment.