✓ TestedWorks with CSV, Excel, Google Sheets → JSON-LD Schema
By dataclean.to team · 2026-02-12
Intercom's user tracking creates duplicate profiles when anonymous website visitors later identify themselves, when the same person uses your product on multiple devices, and when lead data imported from other tools overlaps with existing Intercom users. A user who chatted as an anonymous visitor, then signed up, then was imported from a Salesforce sync might have three separate Intercom profiles. dataclean.to identifies these duplicates across your Intercom export by matching emails, user IDs, and behavioral patterns.
The Problem
Intercom charges per user on most plans, so duplicates directly increase costs. Beyond billing, duplicate profiles cause the Intercom messenger to show conflicting user states: a customer sees onboarding messages because their anonymous visitor profile lacks the 'completed_setup' attribute that exists on their identified profile. Product tours trigger repeatedly for the same person across duplicate records. Customer support agents see partial conversation history when a returning customer's messages are split across profiles. Intercom's built-in merge works for individual cases but does not offer bulk duplicate detection across the entire user base. Intercom data management documentation
How to Fix It
1
Export user data from Intercom
Use Intercom's CSV export from the People section or the REST API to download user and lead records. Include user ID, email, name, created date, last seen, session count, and any custom attributes.
2
Upload the CSV to dataclean.to
Upload the exported data. The tool identifies anonymous-to-identified user pairs, cross-device duplicates, and import-created duplicates by matching emails, names, and behavioral patterns like creation timestamps.
3
Review duplicate user clusters
Examine groups of duplicate profiles. The tool distinguishes between anonymous leads that became identified users (same person, different lifecycle stage) and genuine duplicates from import overlaps.
4
Merge duplicate profiles
Consolidate duplicate user records. Anonymous visitor profiles are folded into identified user profiles. Conversation counts, custom attributes, and event histories are combined into the surviving record.
5
Export the clean user dataset
Download the deduplicated CSV with merge instructions. Use Intercom's merge feature for individual pairs or the API for bulk merges to clean up your user base.
Frequently Asked Questions
How does the tool handle anonymous visitor profiles?
Anonymous visitors who later provide an email are matched to identified user profiles by comparing attributes like first-seen dates, browser information, and page visit patterns. These are flagged as merge candidates rather than true duplicates.
Can merging reduce my Intercom bill?
Yes. Intercom charges per active user or lead. Merging duplicate profiles reduces your billable user count. For companies with thousands of users, deduplication can result in a lower pricing tier.
Will conversation history be preserved?
When you merge users through Intercom's merge feature (identified by dataclean.to), all conversations from both profiles are combined under the surviving user. No message history is lost.
Example: Input → Output
name
email
phone
city
status
Alice Johnson
alice@example.com
+1-555-0101
New York
active
alice johnson
ALICE@EXAMPLE.COM
5550101
new york
Active
Red rows show common data quality issues. dataclean.to normalizes and generates JSON-LD automatically.