Conversion Rate = (# of paying customers / # visitors) * 100
Conversion rate is an important metric to track to see if you are offering what users are willing to pay, to improve your product, and to truly benefit them.
On Outcode, you can create a Conversion Rate Datapage in under 10 minutes.
Sample MySQL database
We have made a MySQL database for a fake B2B SaaS startup called Awesome Company to make your creating datapages experience more fun!
This is what Awesome Company's MySQL database looks like.
To track the conversion rate, you need the following data:
- visitors (= users on free-tier or free-trial in this case)
- paying users
How to calculate the conversion rate in SQL
The simplest way to calculate the conversion rate from the Awesome Company’s database is to use the
user_id in the login_history and payment table.
You can also create your own Datapage and share it with your team.
select CONCAT(Round(( select count(*) as 'Paying Users' from ( select user_id from payment group by user_id) p) / (select count(*) as 'Visitors' from ( select user_id from login_history group by user_id) lh ) * 100), '%') as 'Conversion Rate' from dual;
With that query, we can see that Awesome Company's conversion rate is 44%. Compared the the SaaS average of around 15%, Awesome Company seems to be doing great!
Do you have a better way to find CVR? Please reply below and inspire the fellow Outcoders!
Want to do more with your data?
- It is important to analyze your business deeper, beyond this conversion rate metric. Don’t just stop at saying “it’s positive or negative.” Try breaking it down by tier or product.
- Check out our templates and see how you can use your data here.
Share and automate
Outcode helps you to track measures in real-time with the Datapage.
- Share your Datapage or data table with other team members. Copy and paste the page URL anywhere you like.
- Get your real-time CVR sent via Slack or email with Outcode's quick automation feature.