How to Setup Intercom Integration

This integration will allow you to connect with Intercom and start collecting your data. It is a matter of minutes to send your data to feed your BI, your data warehouse, or your custom analytics stack.

Here are the steps involved:

  1. Connecting Intercom
  2. Set the Replication Frequency
  3. Load your Intercom data into your data warehouse
  4. Intercom expected Data Model and schema

Getting Started – Setup Intercom integration at Blendo

1. To add this integration, go to Blendo dashboard. Click Add a Source and click on Intercom.

Import your Intercom data into your data warehouse - Blendo.co

2. Click on Intercom icon.

3. In the new Setup your Intercom source screen, click on Connect with Intercom.

Import your Intercom data into your data warehouse - Blendo.co

4. In the new pop up you will be prompted to alow Blendo to connect to Intercom. Click Connect.

5. At the next page see if everything is OK. Add a Table Prefix if you want and click Validate & Save.

Import your Intercom data into your data warehouse - Blendo.co6. Then you will return back to the home dashboard. Click on your new Intercom data source.

Setup Intercom integration

Set the Replication Frequency

This configuration controls how often Blendo will pull data from your Intercom integration. Loading to your data warehouse could take a little bit longer.

7. If you want to change the replication schedule go to the Schedule section and click on Reschedule.

8. In the next pop-up select one of the options available and click Apply.

To help prevent overages, consider setting the integration to replicate less frequently. Ask us for help or recommendations.

Load your Intercom data into your data warehouse

Here is how to start loading your Intercom data into your data warehouse:

Load Intercom data into data warehouse

Expected Intercom Data Model and Schema

Let’s see:

  1. How Blendo syncs Intercom data
  2. The tables with Intercom data that we create in your destination data warehouse

How Blendo syncs Intercom data

Historical Data

When Blendo first connects to Intercom Data source, will pull all your historical data.

Sync Schedule

Blendo syncs Intercom data based on the schedule and frequency you choose. The default setting is every 1 hour but is configurable from inside the app.

Replication Process

The first time Blendo syncs your Intercom data performs a full replication. Then your Intercom data is replicated incrementally. Note that Blendo will only read your data.

After you finish the integration with Intercom, you might see its status as Importing from sourceExporting to the destination, or Completed.

What Intercom data do I have available?

Blendo creates a table for an object in Intercom API in your data warehouse and the object’s fields are its columns.

In the next array you will see a sample of the tables we replicate from Intercom. If you want the full schema information please download the csv in the link below.

Download the Full Intercom Schema Information >>

Intercom ResourceBlendo Table NameDescription
AdminsadminsThe table contains information about the Admin and Teams in Intercom.
CompaniescompaniesCompanies represent organizations using your product. This table holds information about these companies in Intercom. Due to a limitation of the Intercom API, we can import only the first 10k companies, ordered by Intercom default API ordering. Read more here.
ConversationsconversationsThis table has information about the conversations with users in Intercom.
Conversations partsconversations_partsThis table has information about the elements of conversations called conversation parts.
Conversations ratingsconversations_ratingsThis table has information regarding the customer rating of a conversation.
LeadsleadsThis table has information about the logged-out users or visitors of your application.
SegmentssegmentsA segment is a group of users defined by certain rules and users are automatically added to the segment as soon as they match those rules. This table has information about these segments.
TagstagsTags are labeling for the users and companies. The table contains information about these Tags.
User Eventsuser_eventsThis table includes the information about User Events in Intercom.
UsersusersThis table contains information about your users inside Intercom.

Custom Fields

Blendo will create a column for any of your custom fields and will sync it accordignly.

Questions? Contact us!

in Connecting SaaS Data Sources