Connect Intercom To Qlik 〈2025〉
| 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 |
You need an Access Token from Intercom (Settings > Apps & Integrations > Access Tokens). connect intercom to qlik
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)'; | Intercom Field | Qlik Table Strategy |
Here is a pseudo-code example of the Qlik load script: Apps & Integrations >
Connecting these two platforms allows you to visualize support volume against feature releases, or predict churn based on frustration keywords in tickets.
1 comments:
Click here for commentstx
ConversionConversion EmoticonEmoticon