Blog / Sql

How to figure out your month-over-month revenue growth with an SQL query (PostgreSQL)

September 10, 2017

These last couple of days, I've been working on a dashboard for one of our Shopify apps so we can get a quick overview of how our app is doing revenue-wise.

One of the metrics we'd like to be able to see instantly is the month-over-month revenue growth rate. For a subscription-based SaaS (software as a service) product, this is a very important metric to track as it tells you if your business is growing …