New Integration: Import your Intercom Data into your Data Warehouse

Blendo
Blend your data world
3 min readJun 22, 2016

Welcome Intercom. Intercom is a customer communication SaaS platform. It includes a number of products for marketing automation, customer feedback, customer support and live chat. We are Intercom’s customers some time now and we are happy to have the Intercom integration up and running.

The data that reside in Intercom are rich of information. Data about from the conversations with our customers or leads, marketing data, events data you name it. By making easy for anyone to import their data from Intercom to a data warehouse we help them:

  • have easy SQL access to all your data sources
  • combine in one place data from other sources, such us marketing and sales
  • have freedom. Load everything to your own data store, access it and analyze it with your favorite BI or visualization tool.

Why? To answer questions like:

How many messages each of our customers has exchanged with our customer support?

or

How many open assigned conversations in total has each one of our customer support heroes?

and even more questions for your data. By having Intercom data with customer data, sales or marketing data together in one place, there is even more information to uncover.

With Blendo you may import Intercom data to Amazon Redshift, Heroku PostgreSQL or Amazon RDS PostgreSQL or Azure MS SQL Database. It is only a few clicks and a few minutes away.

After setting up your data pipeline from Intercom to your data store all your new data will be available at the time you needed it.

Intercom Integration setup

In order to pull your data, you need only two steps.

  1. From Intercom you will need the App Id and the API Key.
  2. Then Connect with Blendo.
    3-ish. You may also need to connect with a webhook. Why do I need an Intercom Webhook integration?

For more details read about our Intercom integration in the documentation.

How to import your data from Intercom into your Data Warehouse

Now you have to decide where you want your data. With Blendo integrations we will help you get them there fast and reliably or you are welcome to check our documentation about Data Warehouses and databases with more details.

If you’d like a demo on how to use Blendo, we’re here for you — just reach out to us and we’ll show you around!

That is all. Get yourself some deserved rest now.

Do you use Intercom? Do you want to ask more?

Originally published at blog.blendo.co

--

--

Blendo
Blend your data world

Blendo is a self-serve platform that helps companies to build, maintain and use a single view of all the data they have access to. https://www.blendo.co/