RevenueCat + Orcabase
Your app’s subscriptions, in plain answers.
RevenueCat already brings App Store and Google Play subscriptions together. Sync it through Fivetran and ask about trials, renewals and revenue in plain words, next to what people do in your app.
- Synced by Fivetran
- Syncs every 6 hours
- No Fivetran account needed
How many trials converted this week?
212 trials converted to paid this week: a 39% conversion rate.
- iOS converts better: 44%, against 32% on Android.
- Annual plans took 57% of conversions.
- Conversion is up 6 points since the new onboarding went live.
Trial conversion by week, %
How I got this· 4 steps
- Looked at your RevenueCat subscriptions
- Found trials that ended this week
- Checked which renewed as paid
- Split them by platform and plan
Example answer. Numbers are illustrative.
In plain words
How can I analyze RevenueCat subscription data?
Fivetran copies your RevenueCat customers, subscriptions and transactions into a database Orcabase hosts for you. Define trial conversion, MRR and churn once, and every answer uses them.
Because it sits next to your app’s own data, you can ask what paying subscribers do differently, not just how many there are.
Ask in plain words
What you can ask about your RevenueCat data
The agent answers with the number, a chart and the steps it took. Keep the good answers on a dashboard.
How many trials started and converted each week?
What’s our MRR across iOS and Android?
Which plan do subscribers choose most?
How many subscribers turned off auto-renew?
What share of subscribers are on annual plans?
Which countries bring the most revenue?
How many refunds did the stores give this month?
Show me active subscribers by platform.
What comes in
Your RevenueCat data, ready to ask about.
A copy in a database Orcabase hosts for you, with its own folder for each app.
Customers
Subscriptions
Transactions
Products
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 RevenueCat data.
MRR
Monthly value of active subscriptions, across both stores.
Trial conversion
Share of trials that renewed as paid.
Auto-renew off
Share of active subscribers who turned off auto-renew.
Annual share
Share of subscribers on annual plans.
Dashboards to start with
Your RevenueCat numbers at a glance.
Ask the agent to build one of these, or pin charts yourself. Share any dashboard with a link.
Subscriptions
4 charts- MRR by platform
- Active subscribers
- Trial conversion by week
- Plan mix
Churn
3 charts- Auto-renew turned off
- Cancellations by month
- Billing issues
Better together
Ask across RevenueCat and the rest of your business.
The best questions need more than one app. The agent can pull from several sources for one answer.
How to connect
Connect RevenueCat, step by step.
- 1
Find it in Sync data
In Orcabase, go to Sync data → Add source and search for RevenueCat. Pick the database to sync into.
- 2
Connect RevenueCat on Fivetran’s page
Fivetran’s page asks you to sign in to RevenueCat, or for an API key. Your login goes to Fivetran, never to Orcabase.
- 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 RevenueCat data.
What you’ll need
- A RevenueCat login with admin access, to create a secret API key.
- The Admin role in Orcabase, and data hosting: Fivetran writes into a database Orcabase hosts for you.
- 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.
Does it cover both the App Store and Google Play?
Why don’t the numbers match App Store Connect exactly?
Do I need a Fivetran account?
How fresh is my RevenueCat data in Orcabase?
What does syncing cost?
Your RevenueCat data already has the answers.
Connect it, ask your first question, and pin the answers you want to see every week.