Klaviyo + Orcabase
See what your emails really earn.
Sync Klaviyo through Fivetran and ask which flows and campaigns bring orders, who’s tuning out, and how email revenue compares with your store’s own numbers, in plain words.
- Synced by Fivetran
- Syncs every 6 hours
- No Fivetran account needed
Which email flow earned the most in August?
The welcome flow earned $6.1k in August, more than all campaigns put together.
- It turned 9% of new subscribers into first orders.
- The win-back flow brought back 41 lapsed customers.
- Campaign clicks fall after the third email in a week.
Revenue by flow, August, $k
How I got this· 4 steps
- Looked at your Klaviyo flows and campaigns
- Added up the orders each one was credited with
- Checked those orders against your store
- Compared flows with campaigns
Example answer. Numbers are illustrative.
In plain words
How do I measure Klaviyo revenue against real orders?
Klaviyo credits revenue to your emails using its own attribution window. Orcabase syncs your campaigns, flows and events through Fivetran into a database Orcabase hosts for you, next to your store, so you can compare Klaviyo’s view with what customers actually did.
Ask which flow earns the most, or which emails bring customers back for a second order.
Ask in plain words
What you can ask about your Klaviyo data
The agent answers with the number, a chart and the steps it took. Keep the good answers on a dashboard.
Which flows and campaigns earned the most last month?
Which emails bring customers back for a second order?
How many people unsubscribed after each campaign?
Which segments open and click most?
How fast is our list growing?
Do discount emails bring customers who stay?
How did the welcome flow do this quarter?
Show me email revenue next to total revenue, by week.
What comes in
Your Klaviyo data, ready to ask about.
A copy in a database Orcabase hosts for you, with its own folder for each app.
Campaigns
Flows
Events
Profiles
Lists and segments
Texts
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 Klaviyo data.
Email revenue
Orders credited to emails, by Klaviyo’s attribution.
Click rate
Unique clicks divided by emails delivered.
Unsubscribe rate
Unsubscribes divided by emails delivered.
List growth
New subscribers minus unsubscribes, each month.
Dashboards to start with
Your Klaviyo numbers at a glance.
Ask the agent to build one of these, or pin charts yourself. Share any dashboard with a link.
- Revenue by flow
- Campaign clicks and unsubscribes
- List growth
- Top segments
Email and store
3 charts- Email revenue vs total revenue
- Second orders from email
- Discount emails vs repeat rate
Better together
Ask across Klaviyo 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 Klaviyo, step by step.
- 1
Find it in Sync data
In Orcabase, go to Sync data → Add source and search for Klaviyo. Pick the database to sync into.
- 2
Connect Klaviyo on Fivetran’s page
Fivetran’s page asks for a Klaviyo private API key, which you create in Klaviyo’s settings under API keys.
- 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 Klaviyo data.
What you’ll need
- A Klaviyo login that can create a private 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.
Will Klaviyo’s revenue match our store?
Does it include text messages?
Do I need a Fivetran account?
How fresh is my Klaviyo data in Orcabase?
What does syncing cost?
Your Klaviyo data already has the answers.
Connect it, ask your first question, and pin the answers you want to see every week.