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:
Buy the Kindle version for just $0.99 !! I worked with a new Chief Marketing Officer. This poor dude was in OVER HIS HEAD! He had...
RFM is great for targeting one catalog to one customer. However, RFM is tough to manage in a multichannel environment. This becomes clear ...
Look at the first four rows of our life table (values of 0/1/2/3). These are the first 12-15 weeks after a customer buys for the firs...
It's common for folks to measure cost per new customer. Total Marketing Cost = $10,000. Total New Customers = 130. Cost per New C...