May 22, 2013 at 4:22 am
Hello,
Has anybody had any experience with representing the customer journey (funnel/loyalty levels) as part of a dimensional model? Would love to hear from experience!
Thanks.
May 22, 2013 at 12:41 pm
ofridar (5/22/2013)
Has anybody had any experience with representing the customer journey (funnel/loyalty levels) as part of a dimensional model? Would love to hear from experience!
That sounds to me more like a query - perhaps against a dimensional structure - than a particular dimensional model. Query would depend on business requirements and the existing underlying structure.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.May 23, 2013 at 4:51 am
Thanks!
I assume there will be a query but I was hoping to model into a fact table the "stages" in the customer lifecycle, triggers for coming in and out of each stage etc. Still considering best approach on grain and related dimensions.
May 26, 2013 at 7:11 pm
What you're looking for is an "accumulating snapshot" fact table. This is a fairly common data-warehousing pattern.
There's heaps of information on how to create them which I won't repeat here, but a great resource is the Kimball group who pretty much invented this (or if they didn't they certainly created a succinct definition) :
http://www.kimballgroup.com/2002/06/13/design-tip-37-modeling-a-pipeline-with-an-accumulating-snapshot/[/url]
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply