Intercom + Orcabase

Hear what your customers keep asking.

Sync Intercom through Fivetran and ask what customers write about, how fast you reply, and whether support changes who stays, in plain words and next to usage and billing.

  • Synced by Fivetran
  • Syncs every 6 hours
  • No Fivetran account needed
AgentIntercom connected

What did customers ask about most this month?

Reading your Intercom data…

Billing was the top topic this month: 27% of conversations.

  • Most were about invoices on the new annual plan.
  • The median first reply took 42 minutes, up from 25.
  • Import questions doubled after the last release.

Conversations by topic, %

27BillingImportLoginBugsSetupOther
How I got this· 4 steps
  1. Looked at your Intercom conversations and tags
  2. Grouped this month’s conversations by topic
  3. Measured first reply times
  4. Compared topics with last month

Example answer. Numbers are illustrative.

In plain words

How can I analyze Intercom conversations?

Intercom’s reports show your team’s workload. The bigger questions, like whether customers who talk to support stay longer, need conversations next to billing and usage. Fivetran copies your conversations, contacts and ratings into a database Orcabase hosts for you.

Ask what customers write about most, or how reply times changed, and get the answer with a chart.

Ask in plain words

What you can ask about your Intercom data

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

  • What do customers ask about most?

  • How fast do we reply, by hour of the day?

  • Which teammates close the most conversations?

  • Do customers who contact support churn less?

  • How many conversations does each new customer start?

  • Which topics are growing?

  • What’s our satisfaction rating by topic?

  • Show me conversations by week and tag.

What comes in

Your Intercom data, ready to ask about.

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

01

Conversations

Every conversation, with its messages, tags, state and timing.
02

Contacts and companies

The people and companies who write in, with their attributes.
03

Teammates and teams

Who handled what.
04

Ratings

Satisfaction ratings and remarks, where customers left one.

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

How metrics work

  • First reply time

    Median time to your team’s first reply.

  • Time to close

    Median time from first message to closed.

  • Conversations per customer

    Conversations divided by active customers.

  • Satisfaction

    Share of ratings that were good or great.

Dashboards to start with

Your Intercom numbers at a glance.

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

Support

4 charts
  • Conversations by week
  • First reply time
  • Top topics
  • Satisfaction

Support and revenue

3 charts
  • Conversations per customer
  • Churn by support contact
  • Topics from paying customers

About dashboards

How to connect

Connect Intercom, step by step.

  1. 1

    Find it in Sync data

    In Orcabase, go to Sync data → Add source and search for Intercom. Pick the database to sync into.

  2. 2

    Connect Intercom on Fivetran’s page

    Sign in to Intercom on Fivetran’s page and choose the workspace to sync.

  3. 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. 4

    Ask away

    The first sync starts straight away. When it’s done, ask the agent about your Intercom data.

What you’ll need

  • An Intercom workspace with an active subscription, and a login that can authorize apps.
  • 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 Intercom and Orcabase

More in the docs: Sync apps with Fivetran

Can I split conversations by customer plan?
Yes, if your plan data is in Orcabase too, from your billing tool or your app’s database. The agent matches conversations to customers.
Can Orcabase reply to customers?
No. Orcabase only reads the synced copy.
Do I need a Fivetran account?
No. Orcabase uses its own. You sign in to Intercom 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 Intercom 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.

Your Intercom data already has the answers.

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