Intercom Integration

Intercom

Get smart about support and success with pre-defined customer data models directly in Intercom

Load data from Intercom to your Data Warehouse

Start moving your Intercom data to BigQuery, Snowflake, or Redshift with fully managed data pipelines. Get clean normalized data ready for analytics, easy to setup in minutes with no coding required. Up to 1 minute sync frequency for real-time data syncronisation.

View more about the Intercom integration in the Weld documentation

View the Intercom data avaialble in the Data Schema

Transform and model Intercom data

Get clean data models from your Intercom data. Weld makes it easy to transform and model with the powerfull built in SQL editor.

Intercom

raw.intercom.table1

raw.intercom.table2

Get started with Intercom SQL Templates

Get inspiration on how to model your data, with our collection of foundational SQL templates we have battle-tested at Weld. All the templates work out of the gate with the Weld data integrations for Hubspot.

Monthly Conversations By Team

Extracts monthly conversation data by team from the Intercom integration. It selects the month, team ID, team name, and ticket count from the conversation table. It then joins the conversation table with the team table and groups the results by month, team ID, and team name, ordering them by month and ticket count in descending order.

Monthly Tickets By Team

Extracts monthly ticket data for each team, including the team ID, team name, and the count of tickets. It uses the Intercom integration and joins the ticket and team tables based on the team assignee ID. The results are grouped by month, team ID, and team name, and ordered by month and ticket count in descending order.

View all Intercom templates

Connect Intercom data to any BI tool

Transform and combine Intercom data with other data sources with Weld, to build valuable business insights. Connect any BI Tool to build valueable analytics and reporting for your company.

Send data to Intercom

Sync data from any data source to Intercom, with the Weld Reverse ETL, for powerful data enrichment. Easy setup fully managed data pipeline to Intercom in minutes with no coding required.

Conversational Relationship Platform helping businesses build customer relationships through personalized, messenger-based experiences.

Sync your Intercom data into your data warehouse and back again. View your valuable product usage data directly in Intercom, such as which feature customers interacted with.

Use Cases

Centralize all of your Intercom data in your BigQuery or Snowflake data warehouse to build the most accurate and fine-tuned customer data models.
Get a 360° view of your customers directly in Intercom to help your customer success team to spot potential churn before it happens and be proactive about it.
Get notified in real-time when a customer completes an onboarding step and build powerful workflows in Intercom to merge product data with your CRM.

‍

Start working with your Intercom data today

Get started building your data warehouse with Intercom and 100+ more apps and database integrations available.