You need an Access Token from Intercom (Settings > Apps & Integrations > Access Tokens).
| Intercom Field | Qlik Table Strategy | Business Use | | :--- | :--- | :--- | | conversation.id | Fact table (Grain = 1 row per message) | Count total interactions | | contact.id | Dimension table (Grain = 1 row per user) | Filter by MRR or Plan | | conversation_parts.body | Text field (Do not use as dimension) | Keyword search / NLP | | conversation.tags | Bridge table (Many-to-many) | Filter by ticket type | connect intercom to qlik
Have you tried building an Intercom dashboard in Qlik? Share your experience with the REST connector’s pagination loop in the comments below. You need an Access Token from Intercom (Settings
LIB CONNECT TO 'Intercom_REST'; SQL SELECT id as conversation_id, created_at, updated_at, source_type, (SELECT value FROM tags WHERE type='tag') as tag_list FROM conversations WHERE updated_at > '$(vLastLoadTime)'; LIB CONNECT TO 'Intercom_REST'; SQL SELECT id as
Qlik provides a built-in library of connectors for common SaaS platforms. Intercom is supported via the Web Connector, which uses OAuth 2.0 to pull data.
Connecting these two platforms allows you to visualize support volume against feature releases, or predict churn based on frustration keywords in tickets.