Hunting for Customers With PostgreSQLby@billbeaux
209 reads

Hunting for Customers With PostgreSQL

by Bill5mSeptember 22nd, 2020
Read on Terminal Reader
Read this story w/o Javascript
tldt arrow

Too Long; Didn't Read

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!

People Mentioned

Mention Thumbnail
featured image - Hunting for Customers With PostgreSQL
Bill HackerNoon profile picture
Bill

Bill

@billbeaux

Head of Growth @ PopSQL

About @billbeaux
LEARN MORE ABOUT @BILLBEAUX'S
EXPERTISE AND PLACE ON THE INTERNET.
L O A D I N G
. . . comments & more!

About Author

Bill HackerNoon profile picture
Bill@billbeaux
Head of Growth @ PopSQL

TOPICS

THIS ARTICLE WAS FEATURED IN...

Permanent on Arweave
Read on Terminal Reader
Read this story in a terminal
 Terminal
Read this story w/o Javascript
Read this story w/o Javascript
 Lite