Windsor brings all your Intercom data into Power BI, Looker Studio, Google Sheets, Excel, BigQuery, Snowflake, Tableau, Azure, PostgreSQL, MySQL, Python, Amazon S3, Azure MS SQL
Intercom Field Reference
Sample
https://connectors.windsor.ai/hubspot?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]
Fields
| ID | Type | Name | Description | Report |
|---|---|---|---|---|
| account_id | TEXT | Account Id | Intercom account id. | Account |
| account_name | TEXT | Account Name | Intercom account name. | Account |
| android_app_name | TEXT | Android app name | The name of the Android app which the contact is using. | Contacts |
| android_app_version | TEXT | Android app version | The version of the Android app which the contact is using. | Contacts |
| android_device | TEXT | Android device | The Android device which the contact is using. | Contacts |
| android_last_seen_at | TEXT | Android last seen at | The time when the contact was last seen on an Android device. | Contacts |
| android_os_version | TEXT | Android os version | The version of the Android OS which the contact is using. | Contacts |
| android_sdk_version | TEXT | Android sdk version | The version of the Android SDK which the contact is using. | Contacts |
| browser | TEXT | Browser | The name of the browser which the contact is using. | Contacts |
| browser_language | TEXT | Browser language | The language set by the browser which the contact is using. | Contacts |
| browser_version | TEXT | Browser version | The version of the browser which the contact is using. | Contacts |
| created_at | DATE | Created at | The time when the contact was created. | Contacts |
| 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 | |
| TEXT | The contacts email. | Contacts | ||
| external_id | TEXT | External id | The unique identifier for the contact which is provided by the Client. | Contacts |
| has_hard_bounced | TEXT | Has hard bounced | Whether the contact has had an email sent to them hard bounce. | Contacts |
| id | TEXT | Id | The unique identifier for the contact which is given by Intercom. | Contacts |
| ios_app_name | TEXT | Ios app name | The name of the iOS app which the contact is using. | Contacts |
| ios_app_version | TEXT | Ios app version | The version of the iOS app which the contact is using. | Contacts |
| ios_device | TEXT | Ios device | The iOS device which the contact is using. | Contacts |
| ios_last_seen_at | TIMESTAMP | Ios last seen at | The last time the contact used the iOS app. | Contacts |
| ios_os_version | TEXT | Ios os version | The version of iOS which the contact is using. | Contacts |
| ios_sdk_version | TEXT | Ios sdk version | The version of the iOS SDK which the contact is using. | Contacts |
| language_override | TEXT | Language override | A preferred language setting for the contact, used by the Intercom Messenger even if their browser settings change. | Contacts |
| last_contacted_at | TIMESTAMP | Last contacted at | The time when the contact was last messaged. | Contacts |
| last_email_clicked_at | TIMESTAMP | Last email clicked at | The time when the contact last clicked a link in an email. | Contacts |
| last_email_opened_at | TIMESTAMP | Last email opened at | The time when the contact last opened an email. | Contacts |
| last_replied_at | TIMESTAMP | Last replied at | The time when the contact last messaged in. | Contacts |
| 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). | Contacts |
| location_city | CITY | Location city | The city that the contact is located in | Contacts |
| location_country | COUNTRY | Location country | The country that the contact is located in | Contacts |
| location_region | REGION | Location region | The overal region that the contact is located in | Contacts |
| location_type | TEXT | Location type | Always location | Contacts |
| marked_email_as_spam | TEXT | Marked email as spam | Whether the contact has marked an email sent to them as spam. | Contacts |
| month | TEXT | Month | Number of the month | |
| name | TEXT | Name | The contacts name. | Contacts |
| os | TEXT | Os | The operating system which the contact is using. | Contacts |
| owner_id | TEXT | Owner id | The id of an admin that has been assigned account ownership of the contact. | Contacts |
| phone | TEXT | Phone Number | The contacts phone. | Contacts |
| role | TEXT | Role | The role of the contact. | Contacts |
| signed_up_at | TIMESTAMP | Signed up at | The time specified for when a contact signed up. | Contacts |
| sms_consent | TEXT | Sms consent | Sms consent | Contacts |
| source | TEXT | Source | The name of the Windsor connector returning the row | |
| today | DATE | Today | Today's date | |
| type | TEXT | Type | The type of object. | Contacts |
| unsubscribed_from_emails | TEXT | Unsubscribed from emails | Whether the contact is unsubscribed from emails. | Contacts |
| unsubscribed_from_sms | TEXT | Unsubscribed from sms | Unsubscribed from sms | Contacts |
| updated_at | DATE | Updated at | The time when the contact was last updated. | Contacts |
| 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). | |
| workspace_id | TEXT | Workspace id | The id of the workspace which the contact belongs to. | Contacts |
| year | TEXT | Year | Year | |
| year_month | TEXT | Yearmonth | Year and month, e.g. 2024|3 | |
| 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 |