tracking customer activity

View previous topic View next topic Go down

tracking customer activity

Post  salaman on 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

View user profile

Back to top Go down

Re: tracking customer activity

Post  Jeff Smith on 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

View user profile

Back to top Go down

Re: tracking customer activity

Post  BoxesAndLines on 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.
avatar
BoxesAndLines

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

View user profile

Back to top Go down

Re: tracking customer activity

Post  salaman on 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

View user profile

Back to top Go down

Re: tracking customer activity

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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