Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikeers
Creator II
Creator II

Customers indicators

Hi!

I think I've come to the point where I can not handle myself. I neet to calculate a couple of indicators related to clients. Let us assume that the structure is like in the annex (example_cust).

For each indicator I would like to receive a minimum such a graph as in the annex (draft).

Difficulty of the task seen with my eyes:

1) Historical data - not only for the current period, but also backwards,

2) For each indicator, in addition to the number - it must be possible to see what clients were included.

Necessary indicators - all per month:

1) New customers - his first purchase was in a given month - never before.

2) Lost customers - these are those who have not bought in the last 3 months.

3) Restored customers - these are those who bought this month, and previously did not buy for 3 months.

4) "Regulars" - they buy at least once a month in the last year.

5) "Down-at-heel" -  they bought the last 3 months, but they have not bought this month.

Additional indicators:

1) How many times the customer was lost?

2) How many times the customer was restored?

Thanks for help!

1 Reply
qlikeers
Creator II
Creator II
Author

Any ideas?