...
Select
User ID
Create the cohort and when you are done click on
Save
...
...
Give your cohort a title and click on
Save
...
8. Create a new analysis, selecting segmentation and use as event Online Loyalty Transaction Claimed & In Store Loyalty Transaction Claimed all together (all RS). You can adjust the timeframe where the condition have to be verified, and the period you want to look at.
...
| Info |
|---|
By selecting “daily” the unique users will be counted each day. By selecting weekly, the unique users will be determined on a weekly basis. Therefore the sum of the weekly unique does not correspond to the monthly unique |
9. Include as segmentation criteria where cohort = test group and control group
...
10. Extract unique, event totals and monetary value (note: to extract monetary value, select group by subtotal and then click on properties, and select sum of property value)
...
11. Calculate frequency, check and monetary value per user by using as denominator the fixed cohort
12. Calculate the pre-post NoC by comparing the behavior of the test group with the behavior of the control group. Eg:
Fixed cohorts
Test: 10k
Control: 1K
Unique per week
Week 1 | Week 2 | Week 3 | Week 4 | |
|---|---|---|---|---|
Test | 120 | 121 | 130 | 133 |
Control | 12 | 11 | 11 | 12 |
Events Total
Week 1 | Week 2 | Week 3 | Week 4 | |
|---|---|---|---|---|
Test | 140 | 141 | 160 | 173 |
Control | 12 | 12 | 11 | 14 |
Monetary Value
Week 1 | Week 2 | Week 3 | Week 4 | |
|---|---|---|---|---|
Test | 140 | 141 | 160 | 173 |
Control | 12 | 12 | 11 | 14 |
Frequency = events total by week by cohort / fixed cohort size
Check = total sales by week by cohort / total events by week by cohort
Monetary value = frequency x check