Cohort Chart Analysis

Hello! 

 

Cohort Chart:

Requirement :

Cohort view (table or chart) to visualize these recurring orders by showing the average order value and also the percentage of customers who place recurring orders on a monthly basis.

 

Workaround:

I am currently using custom queries with the following calculations:

1.Identifies the first purchase month for each customer.
2.Counts new customers each month (first-time buyers).
3.Tracks how many customers make repeat purchases in the following months.
4.Calculates repurchase rates for up to 12 months after the first purchase.

Do you know if we can recreate the cohort chart in Pyramid (Without using sql custom queries)?

Thanks in advance.

Rebeca.