Intercom Integration and Expected Data

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 Pipeline

2. Click on Intercom icon.

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

 

4. In the new pop up you will be prompted to allow 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 Next.

6. Select your preferred Resources

7. Then you will return back to the home dashboard. Click on your new Intercom data pipeline.

 

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.

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

9. 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:

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 source, Exporting 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 consult the csv in the link below.

Intercom Resource	Blendo Table Name	Description
Admins	admins	The table contains information about the Admin and Teams in Intercom.
Companies	companies	Companies 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.
Conversations	conversations	This table has information about the conversations with users in Intercom.
Conversations parts	conversations_parts	This table has information about the elements of conversations called conversation parts.
Conversations ratings	conversations_ratings	This table has information regarding the customer rating of a conversation.
Leads	leads	This table has information about the logged-out users or visitors of your application.
Segments	segments	A 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.
Tags	tags	Tags are labeling for the users and companies. The table contains information about these Tags.
User Events	user_events	This table includes the information about User Events in Intercom.
Users	users	This 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.