Mailchimp + Orcabase

Which newsletters actually bring sales?

Sync Mailchimp through Fivetran and ask which campaigns get opened, clicked and bought from, and how your audience grows, in plain words and next to your orders.

Get started How to connect

Synced by Fivetran
Syncs every 6 hours
No Fivetran account needed

AgentMailchimp connected

Which newsletters got the most clicks this year?

Reading your Mailchimp data…

Brewing guides get twice the clicks of product announcements.

The best one, “Five ways to brew”, had a 9.8% click rate.
Sales emails get fewer clicks, but bring more orders.
Tuesday sends beat Friday ones by 30%.

Click rate by newsletter type, %

How I got this· 4 steps

Looked at your Mailchimp campaigns and reports
Grouped this year’s campaigns by type
Worked out click rates for each
Matched clicks to orders

Example answer. Numbers are illustrative.

In plain words

How do I know if my Mailchimp newsletter drives sales?

Mailchimp shows opens and clicks. Whether readers buy lives in your store. Fivetran copies your campaigns, audiences and results into a database Orcabase hosts for you, next to your orders.

Ask which newsletters bring orders, or whether subscribers buy more often than everyone else, and get the answer with a chart.

Ask in plain words

What you can ask about your Mailchimp 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

Which campaigns got the most clicks this year?
How fast is our audience growing?
Which subject lines get opened most?
Which campaigns lead to orders?
How many people unsubscribe per campaign?
What’s the best day to send?
Which tags or segments engage most?
Show me opens and clicks by month.

What comes in

Your Mailchimp data, ready to ask about.

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

Campaigns

Every campaign, its subject, audience and send time.

Opens and clicks

Campaign results, down to each link.

Audiences

Members, their status, tags and where they signed up.

Automations

Automated emails, and how they did.

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 Mailchimp data.

How metrics work

Click rate
Unique clicks divided by emails delivered.
Open rate
Unique opens divided by emails delivered; some mail apps make it look higher.
Unsubscribe rate
Unsubscribes divided by emails delivered.
Audience growth
New members minus unsubscribes, each month.

Dashboards to start with

Your Mailchimp numbers at a glance.

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

4 charts

Opens and clicks by campaign
Audience growth
Unsubscribes
Best send days

Newsletter to sales

3 charts

Orders from email clicks
Revenue by campaign type
Subscribers who became customers

About dashboards

Better together

Ask across Mailchimp and the rest of your business.

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

“Which newsletters bring orders?”

Mailchimp + WooCommerce

“Do subscribers buy more often than other customers?”

Mailchimp + Shopify

“What do newsletter readers do on the site?”

Mailchimp + Google Analytics

How to connect

Connect Mailchimp, step by step.

1
Find it in Sync data
In Orcabase, go to Sync data → Add source and search for Mailchimp. Pick the database to sync into.
2
Connect Mailchimp on Fivetran’s page
Sign in to Mailchimp on Fivetran’s page and allow it to read your account.
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 Mailchimp data.

What you’ll need

A Mailchimp login with access to the audiences you want.
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 Mailchimp and Orcabase

More in the docs: Sync apps with Fivetran

Why do open rates look so high?

Some mail apps, like Apple Mail, open emails automatically to protect privacy, which makes opens look higher. Clicks and orders are more reliable, and Orcabase can put them side by side.

Can Orcabase send campaigns or change our audience?

No. Orcabase only reads the synced copy.

Do I need a Fivetran account?

No. Orcabase uses its own. You sign in to Mailchimp 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 Mailchimp 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 Mailchimp 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