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)';
Connecting these two platforms allows you to visualize support volume against feature releases, or predict churn based on frustration keywords in tickets. connect intercom to qlik
You need an Access Token from Intercom (Settings > Apps & Integrations > Access Tokens). LIB CONNECT TO 'Intercom_REST'; SQL SELECT id as
Have you tried building an Intercom dashboard in Qlik? Share your experience with the REST connector’s pagination loop in the comments below. Share your experience with the REST connector’s pagination
| 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 |
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.
Here is a pseudo-code example of the Qlik load script: