Using Data at Paddle
Using Data at Paddle
This post originally appeared on the Paddle company blog
How We Use Data
Data… Everybody wants lots of it but often no-one’s quite quite sure why. Being “data-driven”, leveraging “big data”, and measuring everyone and everything is fundamental for most businesses, but how this data is used and how it directly impacts the business can often be unclear.
At Paddle we’re a business that creates a lot of data: every day, we help hundreds of software businesses all over the world sell their products. We gather data on every part of the purchase journey, creating tons of data points, metrics, attributes and events that feed our business.
Making sense of this data so that it’s easy to access, and proportional to our needs can be a real challenge, and has been a core focus since I joined Paddle to set up its Data and Operations practice in early 2017.
I’ll cover how we went about implementing the right tools to access and manipulate data, then some of the main data projects and how they’ve been useful to our vendors and our team.
Making Sense Of Our Data Landscape
I joined Paddle with a background in Management Consulting and a degree in English Literature - so I wouldn’t describe myself as your classic ‘data guy’. I’ve found however that the real advantage of my background has been to try to constantly approach our data in the context of our business, aiming to deliver ‘data’ that is accessible, actionable and without barriers to entry.
We had 2 main requirements:
- One of our core values is our transparency: we share the same dashboard with our board and with our team, so it’s important to us that our core business metrics were made available to everyone, rather than hidden in a spreadsheet.
- We needed a business intelligence / data visualisation tool that would make our data come to life, and that could be easily managed, manipulated and scaled irrespective of the changes to our back end infrastructure.
We landed on Periscope Data - a beautifully simple data visualization tool which takes queries and scripts in SQL, Python and R and converts them into dynamic charts and dashboards. With the ability to plug in multiple databases and enrich the insights through cross database querying, it’s proved to be a great tool for our scaling data function.
The team pretty quickly built out a selection of dashboards, covering our core business metrics (net revenues, checkout conversion, refunds, chargebacks etc.) - and it wasn’t long before we began to be inundated by requests from the business for more in-depth analysis and additional metrics.
Building the Right Dashboards
“We have a lot of business metrics, that we report at many different levels. Using Periscope Data we report on all of these in close to real time, enabling our teams to see performance data in a transparent and clear way.”
To drive the right kind of adoption amongst our teams and avoid the dreaded case of beautiful dashboards that no one looks at, we’ve tried hard to ensure that there is a specific ‘Use Case’ for each of our dashboards.
For example, for our Customer Success team we built a comprehensive overview of each of our vendors to provide immediate insights that help them build better relationships and constantly bring value. Their ability to start a call by saying “here are 3 specific ways you can increase your revenue” is extremely valuable!
For our Product function, we’ve built dashboards and reports to measure the success of new features (most recently the rollout of Apple Pay) or the results of A/B tests.
For our Risk Management team we’re creating a suite of reports to measure the impact on our business of risky customer transactions and our efforts to manage them. All of this is only scratching the surface!
Like many start-ups, we also rely heavily on third party tools (CRM systems, helpdesk solutions, surveys, marketing automation, ATS, payment processors etc.) and as our teams have scaled, access to this data for reporting and trend spotting has become essential.
We’ve been working hard to pipe this data into a central set of databases, enabling us to measure our key business metrics and detailed team-based KPIs within a single system at the click of a button.
I started this blog post talking about the dangers of collecting data for data’s sake - and how it’s a dangerous pitfall for any data-driven organization to fall into.
In the beginning, we didn’t have much in place - so we’ve had to lay a lot of foundations to ensure we have a working data ‘infrastructure’, but it’s always been with particular objectives in mind.
I’d like to go over a few of the cool ‘so whats’ that having access to this kind of data has enabled us to achieve.
Building a Great Product: Subscription Analytics
Analytics platforms dedicated to subscription businesses can be expensive, time consuming to configure and slow to accumulate sufficient data to drive actionable insights. We wanted to see if we could leverage our existing data to achieve the same thing for our vendors using our extensive historic data.
We built a prototype, covering all of the core metrics that any self-respecting SaaS business should be interested in including:
- Monthly Recurring Revenue (MRR)
- Average Revenue Per Account (ARPA)
- Customer Lifetime Value (LTV)
- Cohorts and movements
We built this kind of reporting for several key reasons - mainly to quickly test potential platform improvements without any development and find additional ways to add value to our vendors’ businesses.
In showcasing this data with our existing vendors, we can quickly see what is important to them and tweak them until they’re perfect, then hand them off to our Engineering team to integrate directly into our Dashboard. This allows us to stay very agile.
Making Our Internal Reporting Transparent and Effortless: Our Global View Dashboard
We have a lot of business metrics, that we report at many different levels. Using Periscope Data we report on all of these in close to real time, enabling our teams to see performance data in a transparent and clear way.
These metrics roll up into our ‘Global View’ - the top level metrics that we report to our Exec team and our Board (and share across the whole company), and that indicate the health of the business at the highest level.
Up until quite recently, compiling each of these metrics was manual and time consuming, whilst the output was a Google Sheet - not the most dynamic way to present where we are as a business!
We’ve worked to automate as much of this as possible, reducing this reporting burden to a fraction of the time it took previously, and creating a fantastic, comprehensive and dynamic snapshot of our business’ performance in real time.
As a result, we’ve managed to move the effort away from ‘reporting’ and towards ‘analysis’ - giving our teams across the business more time to engage with our metrics by spending less time calculating them.
Managing Risk and Keeping Our Customers Safe
Using data to manage risk, detect fraud and protect our customers is something we work really hard on. Risk profile changes over time, and strong data infrastructure, tooling and thought is key to taking a proactive rather than reactive approach to risk.
On one hand we use dashboards to track and share health metrics, which helps us set goals and measure the impact of our risk initiatives.
There is always a trade-off between customer experience and risk: to give two extreme examples, we could for example ask everyone to come into our office with their passport (therefore eliminating risk but seriously decreasing revenue), or at the other end have no risk checks at all (therefore increasing conversion but enabling all kinds of potential fraud). Measuring this trade-off is not trivial and our dashboards are a massive help.
On the other hand we dive into the data on a project by project basis, to better understand what is happening and formulate ideas on how we could improve. Ad hoc dashboards are essential to share this across teams and facilitate discussions, as opposed to cryptic spreadsheets hidden away.
The three examples above are just some of the data-related projects that the Data and Operations team at Paddle are involved in right now. The function has grown with the needs of the business, and now that we’ve got decent foundations in place we’re able to spend more time focussing on outcomes, rather than dashboard building.
There’s plenty more to do. We have a lot still to do on the data infrastructure side including thinking about data warehousing, how to achieve real-time data flows in an efficient manner and of course, factoring in the impact of GDPR on our business.
On the analysis side we’re working to be more and more sophisticated with our metrics - moving away from retrospective reporting and thinking about how to use our data more and more predictively to drive our business forward. Definitely exciting times ahead!