How do I calculate an average retention rate

[Deleted User]

Greetings,

 

I am trying to calculate an average retention rate in my card and the numbers don’t validate when I take an average. I know the sum is not the right thing to do, any help would be appreciated. 

 

Thanks!

jmo

You should always use a Beast Mode to calculate ratios. When you upload a ratio into a data source and then take an average you are weighting each individual ratio equally and this is almost never what you want to do. The correct Beast Mode logic for a retention rate would be as follows.

 

sum(`Customers Renewing`) / sum(`Total Customers`)’

 

This equation will always be correct no matter how you filter or drill.

jmo

You should always use a Beast Mode to calculate ratios. When you upload a ratio into a data source and then take an average you are weighting each individual ratio equally and this is almost never what you want to do. The correct Beast Mode logic for a retention rate would be as follows.

 

sum(`Customers Renewing`) / sum(`Total Customers`)’

 

This equation will always be correct no matter how you filter or drill.