Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Customer Journey Expand / Collapse
Author
Message
Posted Wednesday, May 22, 2013 4:22 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 3, 2014 5:27 AM
Points: 2, Visits: 30
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.
Post #1455410
Posted Wednesday, May 22, 2013 12:41 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 8:15 AM
Points: 3,068, Visits: 4,639
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.
Post #1455648
Posted Thursday, May 23, 2013 4:51 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, March 3, 2014 5:27 AM
Points: 2, Visits: 30
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.
Post #1455937
Posted Sunday, May 26, 2013 7:11 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 3:03 AM
Points: 450, Visits: 842
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/

Post #1456934
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse