Now more than ever, you have to hold onto every customer you can. Customers don’t love your product one minute, then fall out of love with it the next. Normally there’s a declining trend in usage of your product over time.

The good news: a single proactive outreach can reverse a downward trend.

The challenge: efficiently finding customers with declining usage.

Why SQL?

With just graphing tools, it’s near impossible to spot trends in customer usage. It’s neon spaghetti:

And examining customers one by one? That would take ages.

Using statistical functions

PostgreSQL’s  statistical functions help you rapidly sift through the noise. I explore these functions further in our  template on Linear Regression in SQL_ (full disclosure: I am an avid SQL writer at PopSQL, a modern SQL editor built for teams)._

#sql #postgresql #postgres