You need an Access Token from Intercom (Settings > Apps & Integrations > Access Tokens).
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)'; connect intercom to qlik
Here is a pseudo-code example of the Qlik load script: You need an Access Token from Intercom (Settings
Connecting these two platforms allows you to visualize support volume against feature releases, or predict churn based on frustration keywords in tickets. Apps & Integrations >
| 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 |