In Bindle’s data warehouse we have a privilege to check whether a user is a customer or not by a value of the status column. Users with the customer status have full access to the Bindle’s book catalog.
The value of the status column is dynamic – subscriptions expire and for these users the
status is set back to free.
It’s important to understand when we’re running queries and calculating ARPU, CAC etc – are we considering only current customers or the past customers as well?
Knowing the amount of customers we’ve ever had could help us...