SaaS company wants to track current customer counts on a more micro level than a other companies normally would. We want to track specific count of customer losses per month and specific count of customer additions per month.
Customers are brought on to ther service and then it’s a recurring monthly fee for some period of time before they might end up dropping the service. In order to more accurately delve into “Churn Rate” as a KPI, having a measurement for a monthly amount of customers lost and a measurement for a monthly amount of customers added is crucial.
Please note: this is different from customer “NET gain/loss” per month. I have already done that metric, which just counts customers invoiced per month and finds the difference from one month to the next.
Due to limitations in accounting procedures, I am not able use the “active” or “inactive” status in their accounting software as a marker.
Database structure is as such:
One customer record can have many sales records. Dynamic date table linked to sales records in standard one-to-many fashion as well.
Any direction or brainstorming anyone might have on how to do this would be greatly appreciated. Or if someone has a finished solution for this that would be great!
Thank you for your help!!
