It will probably not surprise you that we’re using Redash to track our business metrics. As those are pretty much standard for all SaaS businesses, I thought it will be useful to share the query we use to calculate these metrics.
The full query is here: https://gist.github.com/arikfr/8b86207746a84ff9d32f97fa6343f567, but I describe it step by step in this blog post: https://blog.redash.io/sql-query-to-calculate-saas-metrics-dd25d72a0521
I hope this will be useful for others. If you created some elaborate SQL queries, we are welcoming you to share them. Either here in the forum, or as a guest blog post.