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:
Yesterday I shared with you a graph ... showing you how likely first-time buyers were to respond by month. Remember the graph? The graph pro...
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...
Here's a common dynamic in my projects ... see if this happens at your company. Your average price point is $40.00. Customer response...
I always face a challenge from marketers when I talk about implementing a Welcome Program. When I tell marketers that a Welcome Program gene...