Direct Mail Analysis Cube
-
Hello All,
I am building a cube to analyze response to direct marketing, both direct mail and email. My question is when designing my cube, is it best to have a loaded cube, a responded cube, then a virtual cube to show measures like response rate (loaded / responded)? Thanks in advance for your help.
S
-
You want to track the responses to your marketing campaigns, and you want to specifically
know who responded to them - you may consider:
- the initial state of the campaigns (list of sent emails or addresses or whatever, with ID)
- increment every time a new campaign launched
- the outcome from each campaign ID, with a status flag (field)
A. answered (by channel: email, postal, phone, etc)
B. not answered
I would have a single cube, no need to duplicate data, and as DIM I'll use the status;
the response rate, etc are just calculated measure. You'll have to sort and match responses
with some kind of ID on campaigns, and these responses could arrive later on, therefore no
partitioning on this date. Let the Marketing guys decide on cutoff period.
- You'll need manual input for the snail mail arrivals (who and how often will enter data?)
Just a start...
Gus
-
Thanks Gus. I appreciate your input.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply