The DataHero Blog

How to Find the Precious Gems Buried in Your Stripe Data

April 10th, 2017

We’re’re all about simple solutions for complex problems, like helping you find answers to your questions about your Stripe data. Connect the app with DataHero and you’ll be able to see a detailed analysis of charges, subscriptions and customers without spending valuable engineering resources to build something yourselves.

Lucky for you, DataHero’s mission is to help you unmask the answers in your data. We’ve built a direct connection to Stripe so you don’t miss out on all the insights concealed in your payment data.

Simply authorize your Stripe account in Datahero and select the Stripe data you’d like to import. Among other visualizations you can create using this connection are:

  • Segment and analyze your revenue by subscription plan, against discounts, or another metric
  • Graph your customer growth over time

Charting Stripe Data

A very popular metric to chart using the Stripe connection: Monthly Recurring Revenue (MRR). It measures predictable revenue based on a subscription, so for many SaaS businesses, it’s their lifeblood. It’s also one of the first metrics investors or your board will want to hear about.

For monthly recurring revenue, import Customer Invoices. There is a subtle difference between charges and invoices in Stripe. Invoices are recurring payments, charges are one time payments. Therefore, if you’d like to simply see monthly revenue import Customer Charges, if you’d like to see monthly recurring revenue, import Customer Invoices. Once you import Customer Invoices, DataHero will present a suggested chart of monthly recurring revenue; click it and you’re done!

MRR Quarter

Segmentation

Click and drag on other variables like Plan, Coupon or Amount Refunded to get a clearer idea of where your Stripe revenue comes from.

For annual or daily recurring revenue, simply click the Grouped By dropdown menu under the Time variable. You can even measure tricky things like amount by day of the week to see which days bring in the most revenue.

To do cohort analysis, click and drag on Charge Created, Customer Created and Amount to see monthly recurring revenue broken down by when a customer was created.

To keep your charts up to date in DataHero, enable Live Charts. Set Live Charts to update based on your schedule, and charts will automatically update as the data within Stripe changes.

Layer On Zendesk

Monthly recurring revenue can be calculated in a few different ways (contracted versus committed, monthly versus annual subscriptions and so on) but this idea should get you started.

Combining the Stripe and Zendesk connections yields even deeper insights — if you know where to click. For instance, you can look at how customer support contributes to revenue, or segment your help tickets by payment information.

Usually this data sits in two different places but with DataHero’s Combines, you can merge data from these two services for business insights.

Segment help-desk tickets by customer plan, or other payment characteristics. Then you can drill down to see which customers are likeliest to upgrade and which questions are most common among the customers who generate the most revenue.

Here are three key questions you can answer using the Stripe and Zendesk connections in combination:

    1. Which of my customers are filing the most tickets? With the Customers and Invoices report from Stripe, you can easily see which customers are asking the most questions by plan.
    2. Where are my customers getting hung up in my product? We already have the ability to look at how trends in your tickets change over time by importing Zendesk data into DataHero, but by combining your support data with payment data, we can easily filter based on when the customer was created or what plan that customer is currently on.
    3. How can I analyze how cohorts of users request help? Using DataHero’s combines for your customer payment and support information, you can see how to best support your customers, who has the most questions and how best to segment your help tickets by customer payment attributes.

We love feedback on what our users are calculating, so please let us know what other Stripe questions you have in the comments below. And if you’d like to learn more about how to visualize your Stripe revenues, please click here.

By Jeff Zabel

Create my Free DataHero Account

Get the fastest, easiest way to understand your data today.