Targeting Users for Upgrade
Welcome to the first edition of Data for Marketers!
Here's your 3 minute video for today. Prefer written? No problem, scroll down.
Today's Problem:
How can you identify and target users that are likely to upgrade?
Why?:
One of the most important things you can do as a Product Led Growth marketer is to upsell your free users to a paid plan.
How can you identify users that are likely to upgrade?
You don’t want to waste your time or resources on users with no intention of paying you.
What you need:
You’ll need a way to run SQL on your database.
Ask your developer for a read-only connection string to your database. There are many programs that allow you to run SQL on a database such as HelloQuery, TablePlus, etc.
Ask your developer for a read-only connection string to your database. There are many programs that allow you to run SQL on a database such as HelloQuery, TablePlus, etc.
You'll also need.....
- A Customers table that tracks your customers, their email addresses, and when they last logged in.
- A Subscriptions table that tracks subscription details.
- A Plans table that tracks which plan they are on (Free, Pro, Enterprise for example).
Not sure if you have that? You can use HelloQuery or another AI enabled tool to examine your schema.
SQL Solution:
I hope that helped!
I'd love to hear about the data problems you're facing in your business - reply to this email and let me know!
Who knows, maybe you'll get featured!
Colleen