TLDR
With just graphing tools, it’s near impossible to spot trends in customer usage. Postgres' statistical functions help you rapidly sift through the noise. The good news: a single proactive outreach can reverse a downward trend. I explore these functions further in our template on Linear Regression in SQL. The output of the CTE action_data looks like this:Finding slope of all customer usage trendlines. Contact the customers with the worst slope! Their usage of your product is plummeting. You could be letting great customers slip away!via the TL;DR App
no story
Written by billbeaux | Head of Growth @ PopSQL
