Stripe payments data into Excel & Google Sheets

We recently added Stripe as a payment option on our site and were so happy with their well-designed API that we decided to add Stripe also as a data source to our reporting tools. To our knowledge, there are no other spreadsheet add-ons currently connecting with Stripe, so our integration should be quite handy for any businesses offering Stripe as a payment option and needing more detailed reporting than what Stripe offers on their dashboard.

Like all our intergrations, the Stripe connector gives you the freedom to choose exactly the metrics you want to see and how you want them split. And of course, you can split by different dimensions into both rows and columns, and can add filters to specify exactly what data to fetch. In the example query below, we’re splitting net revenue by product into columns and by month into rows. Once you’ve created queries, you can refresh the data by the press of a button, or in our Google Sheets add-on, schedule automatic refreshing.

 

Screen Shot 2014-12-01 at 13.39.36

 

 

Currently, you can fetch data for charges and refunds. Depending on the reception this integration gets, we may later add customer-centric metrics like churn/retention rates, ARPU and LTV.

Stripe is available as a data source now in Supermetrics for Google Docs, Supermetrics Data Grabber for Excel, and Supermetrics Functions. Let us know if you have any feedback on the integration!

 

Leave a Comment

  • (will not be published)