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

Determine loyality of customer

2 posters

Go down

Determine loyality of customer Empty Determine loyality of customer

Post  hennie7863 Sun Jun 28, 2015 7:42 am

Hi,

I want to create something for analyzing the loyality of customer. They pay every month a amount and we define them as loyal when they pay 24 months, every month. We try to find factors that influence loyality. I'm thinking of building a snapshotfact per month, per customer and after 24 months a cusotmer is loyal (1) or not (0). If they pay one month not, the cstomer is not loyal anymore.

Good idea? Better ideas?

Gr,
Hennie

hennie7863

Posts : 31
Join date : 2009-10-19

Back to top Go down

Determine loyality of customer Empty Re: Determine loyality of customer

Post  ngalemmo Mon Jun 29, 2015 11:12 am

There are a lot of ways to deal with segmentations such as this. Usually these are calculated and loaded as attributes of Customer. You could have a snapshot, but it is often more difficult to work with from a end-user query standpoint. Fact tables would typically be built if you plan to do analysis of customer movement among segments over time.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Back to top

- Similar topics

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