I have a task that I don’t quite know how to approach. Any help would be much appreciated.
I have two tables to work with. First is the customer information with relevant fields being customer ID (customer_id) and account creation date (account_created_date). The second table stores customer sessions, i.e. customer visits to the system. Fields we need here are customer_id and session_date.
The task is to figure out customer retention. Specifically, for each customer I have to calculate number of days in which he/she had a session within first 14/30/60 days after account creation. I know how to then aggregate this information, what I don’t know is how to obtain it.
to count all session dates within the first 14 days (replace 14 by 30/60 to retrieve the other buckets then).
Create a straight table with dimension customer_id, then use above expression(s). Your sessions should already be correctly linked to the customer via customer_id. session_date and account_created_date must also be recognized as Date type by QlikView, please have a look into date format and Date() and Date#() functions for that.
Does this answer your question? I assumed you already loaded the tables into QlikView and the tables are linked together.
to count all session dates within the first 14 days (replace 14 by 30/60 to retrieve the other buckets then).
Create a straight table with dimension customer_id, then use above expression(s). Your sessions should already be correctly linked to the customer via customer_id. session_date and account_created_date must also be recognized as Date type by QlikView, please have a look into date format and Date() and Date#() functions for that.
Does this answer your question? I assumed you already loaded the tables into QlikView and the tables are linked together.
