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 &gt

Connecting these two platforms allows you to visualize support volume against feature releases, or predict churn based on frustration keywords in tickets.

Previous
Next Post »

1 comments:

Click here for comments
Admin
admin
January 8, 2024 at 1:47 AM ×

tx

Congrats Bro Admin Thanks...
Reply
avatar