Analyze your Intercom data with R in minutes

Two powerful tools, together

Integrate Intercom and R to turn your data into actionable insights.

About Intercom

Intercom is a popular database.

Stitch offers detailed documentation on how to sync all your Intercom data today.

About R

R is a free software environment for statistical computing, and one of the top three most common skills for data scientists. R’s community of users maintains a rich ecosystem of libraries, packages, in-person events, and online resources.

Learn more about R

Stitch makes it easy to get data into R.

Follow these three steps:

Connect Intercom to Stitch

Quickly connect your Intercom account to Stitch, choose your data, and replicate on a schedule you define.

Send your data to the leading warehouses

Stitch delivers your data to the analytics warehouse of your choice. Don't have a warehouse yet? No problem. Stitch can provision one for you.

Connect your warehouse to R

In most cases, it's simply a matter of providing access credentials. Stitch helps you focus on analysis, not data consolidation.

Expected Intercom data

Here’s a sample of the raw Intercom data that Stitch will replicate to your analytics warehouse:

Admins

The admins table has columns for the admin type, ID, name, and email.


                  Table name:
                  admins

Companies

The companies table contains the Intercom company ID, name, custom attributes, session count, monthly spend, user count, plan, and creation and updated at info.


                  Table name:
                  companies

Conversations

Our Intercom integration retrieves user conversations, or convos initiated by your users. Attributes of the conversations table include the ID, the starting message, the user, the assignee, read and open flags, and created at and updated at info.


                  Table name:
                  conversations

Segments

Segments are groups of users defined by rules you set. Attributes of this table include the type, ID, name, and creation and updated at info.


                  Table name:
                  segments

Users

The users table includes information about the users in your Intercom account such as the Intercom ID, type, user ID, email, name, custom attributes, request info, session count, location data, IP, tags, and creation, sign-up, and updated at info.


                  Table name:
                  users

View all tables

Integrate your Intercom data with R

Select your integrations, choose your warehouse, and enjoy Stitch free for 14 days.

Set up in minutes Unlimited data volume during trial 5 million rows of data free, forever

Intercom to your data warehouse in minutes

Stitch delivers all your data to the leading data lakes, warehouses, and storage platforms.

We saved around two months of engineering work by adopting ETL as a service, and it's cost us pretty much zero maintenance overhead.

Michael Andrews

CTO, IceTrends.com

Why our customers choose Stitch

Stitch is a simple, powerful ETL service built for developers. Stitch connects to your first-party data sources – from databases like MongoDB and MySQL, to SaaS tools like Salesforce and Zendesk – and replicates that data to your warehouse. With Stitch, developers can provision data for their internal users in minutes, not weeks.

Explore all of Stitch's features

Simple setup: Start replicating data in minutes, and never worry about ETL maintenance.
Own your own data infrastructure: Stitch replicates to your warehouse, meaning you’re always in control.
Mature replication engine: Accurate data from any structure, all the time.