Each table presents the information it measures in a different way, given than each is providing the answer to a different question.
This can cause confusion as, for example, the number of sales in a certain month in the "Summary" table may not match the number of sales in the "Sales" table.
This is because some tables measure activity in a given period of time, while others measure activity with regard to a certain cohort.
What is a cohort?
A cohort is a collection of clients. The date a client was entered into the Sirena system determines what cohort they will be in. For example if we're talking about the client cohort from the month of May, we are referring to all the clients entered into Sirena during the month of May.
Why measure activity by cohort?
When we measure activity by cohort instead of by time period, we do it in order to be able to find metric such as conversion (number of clients/ number of clients who made a purchase) which don't make sense if they aren't linked to a certain group of clients.
How do date filters affect my metrics?
The date filter limits a table to a determined period of time.
- When the table measures by cohort, it takes the cohort that corresponds to the dates applied in the filter. In other words, it measures activity related to clients entered in the dates indicated.
- When the table measures by activity date rather than by cohort, it measures the activity that occurred during the dates indicated.
Which tables measure by cohort?