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:
Alright, let's get to the bad news. Let's assume you have 100 customers who spent $100 12 months ago, via your online channel...
Say you manage a paid search program. Last month you spent $100,000 and the following happened. Cost = $100,000. Clicks = 200,000. Co...
Two weeks ago I ran a poll on Twitter, asking if users calculated the profitability of their marketing efforts. 32% said "no"...
Yeah, that's a lousy picture. Too bad. Today is essay day. If you don't want to read something long, stop here. I spend a...