Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

tracking customer activity

3 posters

Go down

tracking customer activity Empty tracking customer activity

Post  salaman Fri Apr 01, 2011 11:03 am

Hi,

I'm working on a model where the business wants to keep track of customer activity. An active customer is one who purchased goods within the last 30 days - otherwise they're classed as an inactive customer.

The business wants to track how many customers went from being active to inactive over time and vice versa (i.e. went from being inactive to active).

In order to do this I thought I'd create a fact_customer_movement table where each row represents the movement of one customer in either direction. Something like this:

customer_key
date_moved_key
direction_key

direction_key would link to either "Moved from Active to Inactive" or "Moved from Inactive to Active".

Does this approach seem reasonable? Or is there a different/better way to approach this type of requirement?

Thanks,

salaman

Posts : 21
Join date : 2011-03-24

Back to top Go down

tracking customer activity Empty Re: tracking customer activity

Post  Jeff Smith Sat Apr 02, 2011 5:59 pm

I'd probably call the Direction Dimension something like Event dimension.

You are basically capturing the events of the Customer, except for the very first event - when they became a customer. I figure they would want to know the total number of Customer, number of new customers, active customers, and inactive customers.

Jeff Smith

Posts : 471
Join date : 2009-02-03

Back to top Go down

tracking customer activity Empty Re: tracking customer activity

Post  BoxesAndLines Sat Apr 02, 2011 10:27 pm

I'd just capture active customer in the customer dimension. You could even do it as a mini dimension if the volume is high.
BoxesAndLines
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

Back to top Go down

tracking customer activity Empty Re: tracking customer activity

Post  salaman Sun Apr 03, 2011 3:43 am

Thanks for the reponses.

I like the idea of an event dimension.

I did think of capturing active customer in the customer dimension but the business would want to know how many new customers we got in March 2010 or any other period in history so having it in the dimension would only show how many active customers we have right now.

salaman

Posts : 21
Join date : 2011-03-24

Back to top Go down

tracking customer activity Empty Re: tracking customer activity

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum