Stripe + Orcabase

Ask your Stripe data anything.

See MRR, churn, refunds and failed payments without exporting a thing. Orcabase syncs your Stripe account through Fivetran, so you can ask in plain words and get the number, the chart and how it was worked out.

Get started How to connect

Synced by Fivetran
Syncs every 6 hours
No Fivetran account needed

AgentStripe connected

What was MRR in August, and what moved it?

Reading your Stripe data…

MRR reached $33.4k in August, up 7% on July.

New subscriptions added $2.9k.
Upgrades to the 1 kg bag added $0.6k.
Cancellations took $1.3k, mostly from subscribers in their first two months.

MRR by month, $k

How I got this· 4 steps

Used your MRR metric (certified)
Looked at your Stripe subscriptions
Split the change into new, upgrades and cancellations
Checked how long cancelled subscribers had stayed

Example answer. Numbers are illustrative.

In plain words

How do I see MRR and churn from Stripe?

Stripe records every charge and subscription change, but its reports only go so far. Orcabase syncs your Stripe data into your warehouse through Fivetran. You define MRR and churn once, the way your business counts them, and certify them.

From then on the agent, your dashboards and your team all use the same numbers, and you can ask follow-ups like “which plan did we lose the most from?”

Ask in plain words

What you can ask about your Stripe data

The agent answers with the number, a chart and the steps it took. Keep the good answers on a dashboard.

Meet the data agent

What’s our MRR today, and how has it moved this year?
How many subscribers cancelled last month, and after how long?
How much revenue did failed payments cost us?
Which plan brings in the most revenue?
What’s our refund rate by product?
How much did Stripe keep in fees last quarter?
How big was our last payout, and what was in it?
Which customers have paid us the most, all time?

What comes in

Your Stripe data, ready to ask about.

A copy in a database Orcabase hosts for you, with its own folder for each app.

Payments and refunds

Every charge, refund and failed payment, with amounts, currencies and statuses.

Customers

Who paid, when they started, and where they’re from.

Subscriptions

Plans, prices, trials, upgrades and cancellations, with their dates.

Invoices

What each customer was billed, paid, or still owes.

Payouts and fees

What landed in your bank, and what Stripe kept.

Disputes

Chargebacks, their reasons, and how they ended.

Numbers worth defining

Define them once. Every answer agrees.

Tell Orcabase what each number means, certify it, and your dashboards, the agent and your whole team use the same one. The agent can draft these from your Stripe data.

How metrics work

MRR
Monthly value of active subscriptions, after discounts, in one currency.
Churn rate
Share of subscribers at the start of the month who cancelled during it.
Net revenue
Payments minus refunds and Stripe’s fees.
Failed payment rate
Share of payment attempts that failed.
Average revenue per customer
Net revenue divided by paying customers.

Dashboards to start with

Your Stripe numbers at a glance.

Ask the agent to build one of these, or pin charts yourself. Share any dashboard with a link.

Revenue

4 charts

MRR by month
New, upgrade and cancelled MRR
Net revenue by week
Revenue by plan

Payments health

4 charts

Failed payment rate
Refunds by reason
Disputes
Payouts

About dashboards

Better together

Ask across Stripe and the rest of your business.

The best questions need more than one app. The agent can pull from several sources for one answer.

“What did each paying customer cost us in ads last month?”

Stripe + Google Ads

“Which lead sources turn into customers who pay the most?”

Stripe + HubSpot

“Which features do our paying customers use most?”

Stripe + PostgreSQL

How to connect

Connect Stripe, step by step.

1
Find it in Sync data
In Orcabase, go to Sync data → Add source and search for Stripe. Pick the database to sync into.
2
Connect Stripe on Fivetran’s page
Create a restricted key in Stripe’s dashboard with read access, then paste it into Fivetran’s page. A read-only key can’t move money or change anything.
3
Choose what to sync
Back in Orcabase, tick the data you want. Only what you pick is synced, and only it counts toward your allowance.
4
Ask away
The first sync starts straight away. When it’s done, ask the agent about your Stripe data.

What you’ll need

A Stripe login that can create API keys, like an Administrator or Developer.
The Admin role in Orcabase, and data hosting: Fivetran writes into a database Orcabase hosts for you.

At a glance

How it connects: Synced by Fivetran
How fresh: Every 6 hours, as standard.
Where your data lives: A copy in a database Orcabase hosts for you, with its own folder for each app.
Who can set it up: An admin in your organization.
Your login: You sign in on Fivetran’s own page. Orcabase never sees your password or keys.
Cost: Counts toward your monthly sync allowance: 500,000 changed rows a month, as standard.

Sync apps with FivetranStep-by-step, in the docs.

Questions

About Stripe and Orcabase

More in the docs: Sync apps with Fivetran

Will Orcabase’s MRR match Stripe’s dashboard?

Close, but not always to the cent. Stripe makes its own choices about discounts, trials and currencies. In Orcabase you define MRR once, the way you count it, and every chart shows how it’s worked out.

Does Orcabase see my customers’ card numbers?

No. Stripe never shares full card numbers through its API. The synced data has amounts, statuses and customers, and card details like the brand and last four digits.

Can Orcabase charge customers or issue refunds?

No. The key you create can only read, and Orcabase only reads the synced copy. Nothing in Orcabase can move money.

Do I need a Fivetran account?

No. Orcabase uses its own. You sign in to Stripe on Fivetran’s page, and the data lands in a database Orcabase hosts for you, so there’s nothing else to set up or pay Fivetran for.

How fresh is my Stripe data in Orcabase?

Fivetran syncs it every 6 hours as standard, and an admin can run a sync by hand at any time. The page for each source shows when it last synced and when it syncs next.

What does syncing cost?

Counts toward your monthly sync allowance: 500,000 changed rows a month, as standard. Each distinct row that’s added or changed in a month counts once, however often it changes, and the first full copy is free. You choose which tables sync, so you only spend the allowance on what you need.

Keep exploring

More data sources

All data sources

Your Stripe data already has the answers.

Connect it, ask your first question, and pin the answers you want to see every week.

Get started All data sources