Intercom Connector

Start moving your Intercom data with fully managed data pipelines. Get clean normalized data ready for analytics, easy to setup and analyze with AI in minutes.

View more about the Intercom connector in the Weld documentation

conversation

18 more intercom tables

Explore available Intercom data

Browse all the data tables available for the Intercom connector, in our interactive ERD data viewer.

View the Intercom 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 powerful built in SQL editor and AI Assistant.

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 Intercom.

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.

Monthly Ticket Resolution Time

Extracts the monthly ticket resolution time for a specific integration (intercom). It selects the month, team ID, team name, and average resolution time in days. It joins the ticket and team tables, filters for resolved tickets, groups the results by month and team, and sorts them in descending order by month and ascending order by average resolution time.

Monthly Tags By Conversation

This SQL template extracts monthly tags by conversation from the Intercom integration. It uses a common table expression (CTE) to join the conversation and conversation_tag tables, and then retrieves the month, tag name, and tag count for each conversation. The results are grouped by month and tag name, and ordered by month in descending order.

Monthly Average Conversations Rating

Extracts the monthly average rating for conversations from the Intercom integration. It selects the truncated month and calculates the average rating for conversations that have a non-null rating value. The results are grouped by month and ordered in descending order.

View all Intercom templates

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.

View more about the Intercom integration in the Weld documentation

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

Here are four popular data analytics use cases with data derived from Intercom:

Customer Support Analysis: Intercom tracks metrics like response time, resolution time, and conversation ratings. Analyzing these metrics helps support teams assess their efficiency, identify areas of improvement, and ensure customers are receiving timely and effective assistance.
Lead Engagement and Conversion Metrics: Intercom's tools for sales provide insights into how leads interact with messages, products, or services. By evaluating metrics such as message open rates, click-through rates, and conversion events, sales teams can refine their outreach strategies and tailor communication to enhance lead conversion.
User Behavior and Segmentation: With Intercom, businesses can segment their users based on behavior, product usage, or custom attributes. Analyzing the interactions and preferences of these segments allows businesses to personalize communication, offers, and product recommendations, enhancing user engagement and retention.
Campaign Effectiveness Assessment: Intercom's marketing tools provide data on the performance of outbound campaigns, from message delivery to engagement rates. Evaluating the effectiveness of various messages, campaigns, or channels helps marketers optimize their strategies, ensuring higher engagement and ROI.

Harnessing the data from Intercom allows businesses to refine their communication strategies, enhance customer experience across touchpoints, and make data-driven decisions that lead to increased engagement, loyalty, and growth.

Start working with your Intercom data today

Get started building your data warehouse with Intercom and 150+ more apps and database connectors available.

Get started for free