Intercom Connector Reference

9 metrics104 dimensions

Fields

https://connectors.windsor.ai/intercom?fields=android_app_name,android_app_version,android_device,android_last_seen_at,android_os_version,android_sdk_version,browser,browser_language,browser_version,created_at,email,external_id,has_hard_bounced,id,ios_app_name,ios_app_version,ios_device,ios_last_seen_at,ios_os_version,ios_sdk_version,language_override,last_contacted_at,last_email_clicked_at,last_email_opened_at,last_replied_at,last_seen_at,location_city,location_country,location_region,location_type,marked_email_as_spam,name,os,owner_id,phone,role,signed_up_at,sms_consent,type,unsubscribed_from_emails,unsubscribed_from_sms,updated_at,workspace_id&api_key=[your API key]

The Intercom connector exposes 113 fields (9 metrics, 104 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.

Intercom Fields

Intercom Contacts fields

The Contacts report of the Intercom connector includes 43 fields.

Intercom Contacts fields (android_app_name to unsubscribed_from_emails)

ID	Type	Name	Description
android_app_name	TEXT	Android app name	The name of the Android app which the contact is using.
android_app_version	TEXT	Android app version	The version of the Android app which the contact is using.
android_device	TEXT	Android device	The Android device which the contact is using.
android_last_seen_at	TEXT	Android last seen at	The time when the contact was last seen on an Android device.
android_os_version	TEXT	Android os version	The version of the Android OS which the contact is using.
android_sdk_version	TEXT	Android sdk version	The version of the Android SDK which the contact is using.
browser	TEXT	Browser	The name of the browser which the contact is using.
browser_language	TEXT	Browser language	The language set by the browser which the contact is using.
browser_version	TEXT	Browser version	The version of the browser which the contact is using.
created_at	DATE	Created at	The time when the contact was created.
email	TEXT	Email	The contacts email.
external_id	TEXT	External id	The unique identifier for the contact which is provided by the Client.
has_hard_bounced	TEXT	Has hard bounced	Whether the contact has had an email sent to them hard bounce.
id	TEXT	Id	The unique identifier for the contact which is given by Intercom.
ios_app_name	TEXT	Ios app name	The name of the iOS app which the contact is using.
ios_app_version	TEXT	Ios app version	The version of the iOS app which the contact is using.
ios_device	TEXT	Ios device	The iOS device which the contact is using.
ios_last_seen_at	TIMESTAMP	Ios last seen at	The last time the contact used the iOS app.
ios_os_version	TEXT	Ios os version	The version of iOS which the contact is using.
ios_sdk_version	TEXT	Ios sdk version	The version of the iOS SDK which the contact is using.
language_override	TEXT	Language override	A preferred language setting for the contact, used by the Intercom Messenger even if their browser settings change.
last_contacted_at	TIMESTAMP	Last contacted at	The time when the contact was last messaged.
last_email_clicked_at	TIMESTAMP	Last email clicked at	The time when the contact last clicked a link in an email.
last_email_opened_at	TIMESTAMP	Last email opened at	The time when the contact last opened an email.
last_replied_at	TIMESTAMP	Last replied at	The time when the contact last messaged in.
last_seen_at	TIMESTAMP	Last seen at	The time when the contact was last seen (either where the Intercom Messenger was installed or when specified manually).
location_city	CITY	Location city	The city that the contact is located in
location_country	COUNTRY	Location country	The country that the contact is located in
location_region	REGION	Location region	The overal region that the contact is located in
location_type	TEXT	Location type	Always location
marked_email_as_spam	TEXT	Marked email as spam	Whether the contact has marked an email sent to them as spam.
name	TEXT	Name	The contacts name.
os	TEXT	Os	The operating system which the contact is using.
owner_id	TEXT	Owner id	The id of an admin that has been assigned account ownership of the contact.
phone	TEXT	Phone Number	The contacts phone.
role	TEXT	Role	The role of the contact.
signed_up_at	TIMESTAMP	Signed up at	The time specified for when a contact signed up.
sms_consent	TEXT	Sms consent	Sms consent
type	TEXT	Type	The type of object.
unsubscribed_from_emails	TEXT	Unsubscribed from emails	Whether the contact is unsubscribed from emails.

Intercom Contacts fields (unsubscribed_from_sms to workspace_id)

ID	Type	Name	Description
unsubscribed_from_sms	TEXT	Unsubscribed from sms	Unsubscribed from sms
updated_at	DATE	Updated at	The time when the contact was last updated.
workspace_id	TEXT	Workspace id	The id of the workspace which the contact belongs to.

Intercom Conversations fields

The Conversations report of the Intercom connector includes 34 fields.

ID	Type	Name	Description
conversation_admin_assignee_id	TEXT	Conversation Admin Assignee Id	The id of the admin assigned to the conversation.
conversation_contact_ids	TEXT	Conversation Contact Ids	Comma-separated ids of the contacts in the conversation.
conversation_count_assignments	NUMERIC	Conversation Count Assignments	The number of times the conversation was assigned.
conversation_count_conversation_parts	NUMERIC	Conversation Count Parts	The number of parts (messages) in the conversation.
conversation_count_reopens	NUMERIC	Conversation Count Reopens	The number of times the conversation was reopened.
conversation_created_at	DATE	Conversation Created At	The time the conversation was created.
conversation_first_admin_reply_at	TIMESTAMP	Conversation First Admin Reply At	The time an admin first replied in the conversation.
conversation_first_close_at	TIMESTAMP	Conversation First Close At	The time the conversation was first closed.
conversation_first_contact_reply_at	TIMESTAMP	Conversation First Contact Reply At	The time the contact first replied in the conversation.
conversation_id	TEXT	Conversation Id	The unique identifier for the conversation.
conversation_last_close_at	TIMESTAMP	Conversation Last Close At	The time the conversation was last closed.
conversation_median_time_to_reply	NUMERIC	Conversation Median Time To Reply	Median seconds to reply within the conversation.
conversation_open	BOOLEAN	Conversation Open	Whether the conversation is currently open.
conversation_priority	TEXT	Conversation Priority	The priority of the conversation (priority or not_priority).
conversation_rating	NUMERIC	Conversation Rating	The CSAT rating (1-5) given to the conversation.
conversation_rating_contact_id	TEXT	Conversation Rating Contact Id	The id of the contact who left the conversation rating.
conversation_rating_remark	TEXT	Conversation Rating Remark	The remark left with the conversation rating.
conversation_rating_teammate_id	TEXT	Conversation Rating Teammate Id	The id of the teammate the conversation rating was given to.
conversation_read	BOOLEAN	Conversation Read	Whether the conversation has been read.
conversation_snoozed_until	TIMESTAMP	Conversation Snoozed Until	The time the conversation will be unsnoozed. Null if not snoozed.
conversation_source_author_id	TEXT	Conversation Source Author Id	The id of the author who started the conversation.
conversation_source_author_type	TEXT	Conversation Source Author Type	The type of the author who started the conversation.
conversation_source_delivered_as	TEXT	Conversation Source Delivered As	How the conversation was initiated, e.g. customer_initiated.
conversation_source_subject	TEXT	Conversation Source Subject	The subject of the first part of the conversation.
conversation_source_type	TEXT	Conversation Source Type	The type of the first part of the conversation.
conversation_state	TEXT	Conversation State	The state of the conversation (open, closed or snoozed).
conversation_team_assignee_id	TEXT	Conversation Team Assignee Id	The id of the team assigned to the conversation.
conversation_time_to_admin_reply	NUMERIC	Conversation Time To Admin Reply	Seconds until an admin replied to the conversation.
conversation_time_to_assignment	NUMERIC	Conversation Time To Assignment	Seconds until the conversation was assigned.
conversation_time_to_first_close	NUMERIC	Conversation Time To First Close	Seconds until the conversation was first closed (resolution time).
conversation_time_to_last_close	NUMERIC	Conversation Time To Last Close	Seconds until the conversation was last closed.
conversation_title	TEXT	Conversation Title	The title given to the conversation.
conversation_updated_at	DATE	Conversation Updated At	The time the conversation was last updated.
conversation_waiting_since	TIMESTAMP	Conversation Waiting Since	The time a customer started waiting for a reply.

Intercom Tickets fields

The Tickets report of the Intercom connector includes 15 fields.

ID	Type	Name	Description
ticket_admin_assignee_id	TEXT	Ticket Admin Assignee Id	The id of the admin assigned to the ticket.
ticket_category	TEXT	Ticket Category	The category of the ticket (Customer, Back-office or Tracker).
ticket_contact_ids	TEXT	Ticket Contact Ids	Comma-separated ids of the contacts affected by the ticket.
ticket_created_at	DATE	Ticket Created At	The time the ticket was created.
ticket_description	TEXT	Ticket Description	The default description of the ticket.
ticket_id	TEXT	Ticket Id	The ticket id shown in the Intercom inbox and Messenger (the API `ticket_id`).
ticket_internal_id	TEXT	Ticket Internal Id	The globally unique identifier for the ticket given by Intercom (the API `id`).
ticket_open	BOOLEAN	Ticket Open	Whether the ticket is open. If false, the ticket is closed.
ticket_snoozed_until	TIMESTAMP	Ticket Snoozed Until	The time the ticket will be unsnoozed. Null if not snoozed.
ticket_state	TEXT	Ticket State	The state of the ticket, e.g. submitted, in_progress, resolved.
ticket_team_assignee_id	TEXT	Ticket Team Assignee Id	The id of the team assigned to the ticket.
ticket_title	TEXT	Ticket Title	The default title of the ticket.
ticket_type_id	TEXT	Ticket Type Id	The id of the ticket type.
ticket_type_name	TEXT	Ticket Type Name	The name of the ticket type.
ticket_updated_at	DATE	Ticket Updated At	The time the ticket was last updated.

Intercom other fields

The Intercom connector has 21 fields that do not belong to a named report, or belong to a report with only one or two fields.

ID	Type	Name	Description	Report
account_id	TEXT	Account Id	Intercom account id.	Account
account_name	TEXT	Account Name	Intercom account name.	Account
data_fetched_at	TIMESTAMP	Data fetched at	UTC timestamp (second precision) of when the connector request that pulled the row started. Freshly pulled rows show this request's start time; cache hits keep the start time of the request that filled the cache. Selecting this field disables aggregation, so rows are returned individually (each keeping its own fetch time) instead of being summed.
datasource	TEXT	Data Source	The name of the Windsor connector returning the row
date	DATE	Date	The creation date/time of the contact	Time
day_of_month	TEXT	Day of month	Day of the month
month	TEXT	Month	Number of the month
now	TIMESTAMP	Now	Current timestamp
source	TEXT	Source	The name of the Windsor connector returning the row
today	DATE	Today	Today's date
week	TEXT	Week	Week (Sun-Sat).
week_day	TEXT	Day of week and day number	Weekday number and name combined (Sun-Sat).Numbered from 0 Sunday to 6 Saturday.
week_day_iso	TEXT	Day of week and day number, ISO	Weekday number and name combined, ISO format (Mon-Sun).Numbered from 1 Monday to 7
week_iso	TEXT	Week ISO	Week, ISO format (Mon-Sun).
year	TEXT	Year	Year
year_month	TEXT	Yearmonth	Year and month, e.g. 2024\|3
year_month_name	TEXT	Year month name	Year and month with the month name written out, e.g. "Jan 2025".
year_of_week	TEXT	Year of week	The year that contains first day of the week (Sun-Sat).
year_of_week_iso	TEXT	Year of week, ISO	The year that contains first day of the ISO week (Mon-Sun).
year_week	TEXT	Year week	Year and week for US weeks (Sun-Sat), e.g. 2024\|15
year_week_iso	TEXT	Year week ISO	Year and week for ISO weeks (Mon-Sun), e.g. 2024\|20

API Connectors