Connect Intercom To Qlik » [FAST]

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

Here is a pseudo-code example of the Qlik load script:

Have you tried building an Intercom dashboard in Qlik? Share your experience with the REST connector’s pagination loop in the comments below.

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)';