I have been trying to make a cohort analysis.
I have managed to get it working , but after I looked deeper into the numbers I noticed that it was not showing what I wanted.
I have created an 'Open Rating' calculated field, which changes overtime as a user opens a newsletter or not.
I would like to create the cohort analyis so I can track how the 'Open Rating' of the clients change as they receive more reports.
Currently the open rating is stuck on the value of the final(latest) month, and the cohort analysis is changing depending whether a client is added or removed.
I would like it to only follow the 'Open Rating' and not number of clients.
Thank you for your help, and let me know if you have any questions.
Hello Camille,
Very interesting analysis!
I created a sample based on this description for your reference.
"I would like to create the cohort analyis so I can track how the 'Open Rating' of the clients change as they receive more reports."
X-axis is received reports, Y-axis is open rate.
In this example, the open rate of client 2 raised after the third report.
You may highlight each client to view the pattern.
Regards
Lei
