Destinations
Data sources
AI insights
About us
Careers
Security
Customer reviews
Contact us
Affiliate program
Solution partners
Template gallery
Looker Studio templates
Power BI templates
Excel templates
Google Sheets templates
Tableau templates
Facebook Ads templates
Google Ads templates
Data fields & Metrics
AI prompt library & Guides
Product documentation
API documentation
Case studies
Blog
Data models
Windsor vs Supermetrics
Windsor vs Funnel.io
Windsor vs Fivetran
Windsor vs Rivery
Windsor vs Portermetrics
Windsor vs Coupler.io
Send your Iterable data to
Iterable Connector Reference
11 metrics367 dimensions
The Iterable connector exposes 378 fields (11 metrics, 367 dimensions). Every field ID below can be passed to the Windsor.ai API in the fields parameter.
Iterable Fields
Iterable campaigns fields
The campaigns report of the Iterable connector includes 18 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| campaigns__campaignstate | TEXT | campaigns.campaignState | campaigns.campaignState |
| campaigns__createdat | TEXT | campaigns.createdAt | campaigns.createdAt |
| campaigns__createdbyuserid | TEXT | campaigns.createdByUserId | campaigns.createdByUserId |
| campaigns__endedat | TEXT | campaigns.endedAt | campaigns.endedAt |
| campaigns__id | TEXT | campaigns.Id | campaigns.id |
| campaigns__labels | OBJECT | campaigns.labels | campaigns.labels |
| campaigns__listids | OBJECT | campaigns.listIds | campaigns.listIds |
| campaigns__messagemedium | TEXT | campaigns.messageMedium | campaigns.messageMedium |
| campaigns__name | TEXT | campaigns.name | campaigns.name |
| campaigns__recurringcampaignid | TEXT | campaigns.recurringCampaignId | campaigns.recurringCampaignId |
| campaigns__sendsize | NUMERIC | campaigns.sendSize | campaigns.sendSize |
| campaigns__startat | TEXT | campaigns.startAt | campaigns.startAt |
| campaigns__suppressionlistids | OBJECT | campaigns.suppressionListIds | campaigns.suppressionListIds |
| campaigns__templateid | TEXT | campaigns.templateId | campaigns.templateId |
| campaigns__type | TEXT | campaigns.type | campaigns.type |
| campaigns__updatedat | TEXT | campaigns.updatedAt | campaigns.updatedAt |
| campaigns__updatedbyuserid | TEXT | campaigns.updatedByUserId | campaigns.updatedByUserId |
| campaigns__workflowid | TEXT | campaigns.workflowId | campaigns.workflowId |
Iterable channels fields
The channels report of the Iterable connector includes 4 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| channels__channeltype | TEXT | channels.channelType | channels.channelType |
| channels__id | TEXT | channels.Id | channels.id |
| channels__messagemedium | TEXT | channels.messageMedium | channels.messageMedium |
| channels__name | TEXT | channels.name | channels.name |
Iterable custom_event fields
The custom_event report of the Iterable connector includes 6 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| custom_event___type | TEXT | custom_event._type | custom_event._type |
| custom_event__createdat | TEXT | custom_event.createdAt | custom_event.createdAt |
| custom_event__data | OBJECT | custom_event.data | custom_event.data |
| custom_event__email | TEXT | custom_event.email | custom_event.email |
| custom_event__itblinternal | OBJECT | custom_event.itblInternal | custom_event.itblInternal |
| custom_event__userid | TEXT | custom_event.userId | custom_event.userId |
Iterable email_bounce fields
The email_bounce report of the Iterable connector includes 8 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| email_bounce__campaignid | TEXT | email_bounce.campaignId | email_bounce.campaignId |
| email_bounce__createdat | TEXT | email_bounce.createdAt | email_bounce.createdAt |
| email_bounce__email | TEXT | email_bounce.email | email_bounce.email |
| email_bounce__itblinternal | OBJECT | email_bounce.itblInternal | email_bounce.itblInternal |
| email_bounce__messageid | TEXT | email_bounce.messageId | email_bounce.messageId |
| email_bounce__recipientstate | TEXT | email_bounce.recipientState | email_bounce.recipientState |
| email_bounce__templateid | TEXT | email_bounce.templateId | email_bounce.templateId |
| email_bounce__userid | TEXT | email_bounce.userId | email_bounce.userId |
Iterable email_click fields
The email_click report of the Iterable connector includes 16 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| email_click__campaignid | TEXT | email_click.campaignId | email_click.campaignId |
| email_click__city | CITY | email_click.city | email_click.city |
| email_click__contentid | TEXT | email_click.contentId | email_click.contentId |
| email_click__country | COUNTRY | email_click.country | email_click.country |
| email_click__createdat | TEXT | email_click.createdAt | email_click.createdAt |
| email_click__email | TEXT | email_click.email | email_click.email |
| email_click__hrefindex | NUMERIC | email_click.hrefIndex | email_click.hrefIndex |
| email_click__ip | TEXT | email_click.ip | email_click.ip |
| email_click__itblinternal | OBJECT | email_click.itblInternal | email_click.itblInternal |
| email_click__messageid | TEXT | email_click.messageId | email_click.messageId |
| email_click__region | REGION | email_click.region | email_click.region |
| email_click__templateid | TEXT | email_click.templateId | email_click.templateId |
| email_click__url | TEXT | email_click.url | email_click.url |
| email_click__useragent | TEXT | email_click.userAgent | email_click.userAgent |
| email_click__useragentdevice | TEXT | email_click.userAgentDevice | email_click.userAgentDevice |
| email_click__userid | TEXT | email_click.userId | email_click.userId |
Iterable email_complaint fields
The email_complaint report of the Iterable connector includes 8 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| email_complaint__campaignid | TEXT | email_complaint.campaignId | email_complaint.campaignId |
| email_complaint__createdat | TEXT | email_complaint.createdAt | email_complaint.createdAt |
| email_complaint__email | TEXT | email_complaint.email | email_complaint.email |
| email_complaint__itblinternal | OBJECT | email_complaint.itblInternal | email_complaint.itblInternal |
| email_complaint__messageid | TEXT | email_complaint.messageId | email_complaint.messageId |
| email_complaint__recipientstate | TEXT | email_complaint.recipientState | email_complaint.recipientState |
| email_complaint__templateid | TEXT | email_complaint.templateId | email_complaint.templateId |
| email_complaint__userid | TEXT | email_complaint.userId | email_complaint.userId |
Iterable email_open fields
The email_open report of the Iterable connector includes 13 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| email_open__campaignid | TEXT | email_open.campaignId | email_open.campaignId |
| email_open__city | CITY | email_open.city | email_open.city |
| email_open__country | COUNTRY | email_open.country | email_open.country |
| email_open__createdat | TEXT | email_open.createdAt | email_open.createdAt |
| email_open__email | TEXT | email_open.email | email_open.email |
| email_open__ip | TEXT | email_open.ip | email_open.ip |
| email_open__itblinternal | OBJECT | email_open.itblInternal | email_open.itblInternal |
| email_open__messageid | TEXT | email_open.messageId | email_open.messageId |
| email_open__region | REGION | email_open.region | email_open.region |
| email_open__templateid | TEXT | email_open.templateId | email_open.templateId |
| email_open__useragent | TEXT | email_open.userAgent | email_open.userAgent |
| email_open__useragentdevice | TEXT | email_open.userAgentDevice | email_open.userAgentDevice |
| email_open__userid | TEXT | email_open.userId | email_open.userId |
Iterable email_send fields
The email_send report of the Iterable connector includes 12 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| email_send__campaignid | TEXT | email_send.campaignId | email_send.campaignId |
| email_send__channelid | TEXT | email_send.channelId | email_send.channelId |
| email_send__contentid | TEXT | email_send.contentId | email_send.contentId |
| email_send__createdat | TEXT | email_send.createdAt | email_send.createdAt |
| email_send__email | TEXT | email_send.email | email_send.email |
| email_send__itblinternal | OBJECT | email_send.itblInternal | email_send.itblInternal |
| email_send__messagebusid | TEXT | email_send.messageBusId | email_send.messageBusId |
| email_send__messageid | TEXT | email_send.messageId | email_send.messageId |
| email_send__messagetypeid | TEXT | email_send.messageTypeId | email_send.messageTypeId |
| email_send__templateid | TEXT | email_send.templateId | email_send.templateId |
| email_send__transactionaldata | OBJECT | email_send.transactionalData | email_send.transactionalData |
| email_send__userid | TEXT | email_send.userId | email_send.userId |
Iterable email_send_skip fields
The email_send_skip report of the Iterable connector includes 12 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| email_send_skip__campaignid | TEXT | email_send_skip.campaignId | email_send_skip.campaignId |
| email_send_skip__channelid | TEXT | email_send_skip.channelId | email_send_skip.channelId |
| email_send_skip__contentid | TEXT | email_send_skip.contentId | email_send_skip.contentId |
| email_send_skip__createdat | TEXT | email_send_skip.createdAt | email_send_skip.createdAt |
| email_send_skip__email | TEXT | email_send_skip.email | email_send_skip.email |
| email_send_skip__itblinternal | OBJECT | email_send_skip.itblInternal | email_send_skip.itblInternal |
| email_send_skip__messageid | TEXT | email_send_skip.messageId | email_send_skip.messageId |
| email_send_skip__messagetypeid | TEXT | email_send_skip.messageTypeId | email_send_skip.messageTypeId |
| email_send_skip__reason | TEXT | email_send_skip.reason | email_send_skip.reason |
| email_send_skip__templateid | TEXT | email_send_skip.templateId | email_send_skip.templateId |
| email_send_skip__transactionaldata | OBJECT | email_send_skip.transactionalData | email_send_skip.transactionalData |
| email_send_skip__userid | TEXT | email_send_skip.userId | email_send_skip.userId |
Iterable email_subscribe fields
The email_subscribe report of the Iterable connector includes 9 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| email_subscribe__createdat | TEXT | email_subscribe.createdAt | email_subscribe.createdAt |
| email_subscribe__email | TEXT | email_subscribe.email | email_subscribe.email |
| email_subscribe__emaillistid | TEXT | email_subscribe.emailListId | email_subscribe.emailListId |
| email_subscribe__emaillistids | OBJECT | email_subscribe.emailListIds | email_subscribe.emailListIds |
| email_subscribe__itblinternal | OBJECT | email_subscribe.itblInternal | email_subscribe.itblInternal |
| email_subscribe__profileupdatedat | TEXT | email_subscribe.profileUpdatedAt | email_subscribe.profileUpdatedAt |
| email_subscribe__signupsource | TEXT | email_subscribe.signupSource | email_subscribe.signupSource |
| email_subscribe__userid | TEXT | email_subscribe.userId | email_subscribe.userId |
| email_subscribe__workflowid | TEXT | email_subscribe.workflowId | email_subscribe.workflowId |
Iterable email_unsubscribe fields
The email_unsubscribe report of the Iterable connector includes 13 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| email_unsubscribe__campaignid | TEXT | email_unsubscribe.campaignId | email_unsubscribe.campaignId |
| email_unsubscribe__channelid | TEXT | email_unsubscribe.channelId | email_unsubscribe.channelId |
| email_unsubscribe__channelids | OBJECT | email_unsubscribe.channelIds | email_unsubscribe.channelIds |
| email_unsubscribe__createdat | TEXT | email_unsubscribe.createdAt | email_unsubscribe.createdAt |
| email_unsubscribe__email | TEXT | email_unsubscribe.email | email_unsubscribe.email |
| email_unsubscribe__emaillistid | TEXT | email_unsubscribe.emailListId | email_unsubscribe.emailListId |
| email_unsubscribe__emaillistids | OBJECT | email_unsubscribe.emailListIds | email_unsubscribe.emailListIds |
| email_unsubscribe__itblinternal | OBJECT | email_unsubscribe.itblInternal | email_unsubscribe.itblInternal |
| email_unsubscribe__messageid | TEXT | email_unsubscribe.messageId | email_unsubscribe.messageId |
| email_unsubscribe__templateid | TEXT | email_unsubscribe.templateId | email_unsubscribe.templateId |
| email_unsubscribe__unsubsource | TEXT | email_unsubscribe.unsubSource | email_unsubscribe.unsubSource |
| email_unsubscribe__userid | TEXT | email_unsubscribe.userId | email_unsubscribe.userId |
| email_unsubscribe__workflowid | TEXT | email_unsubscribe.workflowId | email_unsubscribe.workflowId |
Iterable events fields
The events report of the Iterable connector includes 6 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| events___type | TEXT | events._type | events._type |
| events__createdat | TEXT | events.createdAt | events.createdAt |
| events__data | OBJECT | events.data | events.data |
| events__email | TEXT | events.email | events.email |
| events__itblinternal | OBJECT | events.itblInternal | events.itblInternal |
| events__userid | TEXT | events.userId | events.userId |
Iterable hosted_unsubscribe_click fields
The hosted_unsubscribe_click report of the Iterable connector includes 6 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| hosted_unsubscribe_click___type | TEXT | hosted_unsubscribe_click._type | hosted_unsubscribe_click._type |
| hosted_unsubscribe_click__createdat | TEXT | hosted_unsubscribe_click.createdAt | hosted_unsubscribe_click.createdAt |
| hosted_unsubscribe_click__data | OBJECT | hosted_unsubscribe_click.data | hosted_unsubscribe_click.data |
| hosted_unsubscribe_click__email | TEXT | hosted_unsubscribe_click.email | hosted_unsubscribe_click.email |
| hosted_unsubscribe_click__itblinternal | OBJECT | hosted_unsubscribe_click.itblInternal | hosted_unsubscribe_click.itblInternal |
| hosted_unsubscribe_click__userid | TEXT | hosted_unsubscribe_click.userId | hosted_unsubscribe_click.userId |
Iterable in_app_click fields
The in_app_click report of the Iterable connector includes 6 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| in_app_click___type | TEXT | in_app_click._type | in_app_click._type |
| in_app_click__createdat | TEXT | in_app_click.createdAt | in_app_click.createdAt |
| in_app_click__data | OBJECT | in_app_click.data | in_app_click.data |
| in_app_click__email | TEXT | in_app_click.email | in_app_click.email |
| in_app_click__itblinternal | OBJECT | in_app_click.itblInternal | in_app_click.itblInternal |
| in_app_click__userid | TEXT | in_app_click.userId | in_app_click.userId |
Iterable in_app_close fields
The in_app_close report of the Iterable connector includes 6 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| in_app_close___type | TEXT | in_app_close._type | in_app_close._type |
| in_app_close__createdat | TEXT | in_app_close.createdAt | in_app_close.createdAt |
| in_app_close__data | OBJECT | in_app_close.data | in_app_close.data |
| in_app_close__email | TEXT | in_app_close.email | in_app_close.email |
| in_app_close__itblinternal | OBJECT | in_app_close.itblInternal | in_app_close.itblInternal |
| in_app_close__userid | TEXT | in_app_close.userId | in_app_close.userId |
Iterable in_app_delete fields
The in_app_delete report of the Iterable connector includes 6 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| in_app_delete___type | TEXT | in_app_delete._type | in_app_delete._type |
| in_app_delete__createdat | TEXT | in_app_delete.createdAt | in_app_delete.createdAt |
| in_app_delete__data | OBJECT | in_app_delete.data | in_app_delete.data |
| in_app_delete__email | TEXT | in_app_delete.email | in_app_delete.email |
| in_app_delete__itblinternal | OBJECT | in_app_delete.itblInternal | in_app_delete.itblInternal |
| in_app_delete__userid | TEXT | in_app_delete.userId | in_app_delete.userId |
Iterable in_app_delivery fields
The in_app_delivery report of the Iterable connector includes 6 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| in_app_delivery___type | TEXT | in_app_delivery._type | in_app_delivery._type |
| in_app_delivery__createdat | TEXT | in_app_delivery.createdAt | in_app_delivery.createdAt |
| in_app_delivery__data | OBJECT | in_app_delivery.data | in_app_delivery.data |
| in_app_delivery__email | TEXT | in_app_delivery.email | in_app_delivery.email |
| in_app_delivery__itblinternal | OBJECT | in_app_delivery.itblInternal | in_app_delivery.itblInternal |
| in_app_delivery__userid | TEXT | in_app_delivery.userId | in_app_delivery.userId |
Iterable in_app_open fields
The in_app_open report of the Iterable connector includes 6 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| in_app_open___type | TEXT | in_app_open._type | in_app_open._type |
| in_app_open__createdat | TEXT | in_app_open.createdAt | in_app_open.createdAt |
| in_app_open__data | OBJECT | in_app_open.data | in_app_open.data |
| in_app_open__email | TEXT | in_app_open.email | in_app_open.email |
| in_app_open__itblinternal | OBJECT | in_app_open.itblInternal | in_app_open.itblInternal |
| in_app_open__userid | TEXT | in_app_open.userId | in_app_open.userId |
Iterable in_app_send fields
The in_app_send report of the Iterable connector includes 6 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| in_app_send___type | TEXT | in_app_send._type | in_app_send._type |
| in_app_send__createdat | TEXT | in_app_send.createdAt | in_app_send.createdAt |
| in_app_send__data | OBJECT | in_app_send.data | in_app_send.data |
| in_app_send__email | TEXT | in_app_send.email | in_app_send.email |
| in_app_send__itblinternal | OBJECT | in_app_send.itblInternal | in_app_send.itblInternal |
| in_app_send__userid | TEXT | in_app_send.userId | in_app_send.userId |
Iterable in_app_send_skip fields
The in_app_send_skip report of the Iterable connector includes 6 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| in_app_send_skip___type | TEXT | in_app_send_skip._type | in_app_send_skip._type |
| in_app_send_skip__createdat | TEXT | in_app_send_skip.createdAt | in_app_send_skip.createdAt |
| in_app_send_skip__data | OBJECT | in_app_send_skip.data | in_app_send_skip.data |
| in_app_send_skip__email | TEXT | in_app_send_skip.email | in_app_send_skip.email |
| in_app_send_skip__itblinternal | OBJECT | in_app_send_skip.itblInternal | in_app_send_skip.itblInternal |
| in_app_send_skip__userid | TEXT | in_app_send_skip.userId | in_app_send_skip.userId |
Iterable inbox_message_impression fields
The inbox_message_impression report of the Iterable connector includes 6 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| inbox_message_impression___type | TEXT | inbox_message_impression._type | inbox_message_impression._type |
| inbox_message_impression__createdat | TEXT | inbox_message_impression.createdAt | inbox_message_impression.createdAt |
| inbox_message_impression__data | OBJECT | inbox_message_impression.data | inbox_message_impression.data |
| inbox_message_impression__email | TEXT | inbox_message_impression.email | inbox_message_impression.email |
| inbox_message_impression__itblinternal | OBJECT | inbox_message_impression.itblInternal | inbox_message_impression.itblInternal |
| inbox_message_impression__userid | TEXT | inbox_message_impression.userId | inbox_message_impression.userId |
Iterable inbox_session fields
The inbox_session report of the Iterable connector includes 6 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| inbox_session___type | TEXT | inbox_session._type | inbox_session._type |
| inbox_session__createdat | TEXT | inbox_session.createdAt | inbox_session.createdAt |
| inbox_session__data | OBJECT | inbox_session.data | inbox_session.data |
| inbox_session__email | TEXT | inbox_session.email | inbox_session.email |
| inbox_session__itblinternal | OBJECT | inbox_session.itblInternal | inbox_session.itblInternal |
| inbox_session__userid | TEXT | inbox_session.userId | inbox_session.userId |
Iterable lists fields
The lists report of the Iterable connector includes 4 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| lists__createdat | TEXT | lists.createdAt | lists.createdAt |
| lists__id | TEXT | lists.Id | lists.id |
| lists__listtype | TEXT | lists.listType | lists.listType |
| lists__name | TEXT | lists.name | lists.name |
Iterable message_types fields
The message_types report of the Iterable connector includes 3 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| message_types__channelid | TEXT | message_types.channelId | message_types.channelId |
| message_types__id | TEXT | message_types.Id | message_types.id |
| message_types__name | TEXT | message_types.name | message_types.name |
Iterable purchase fields
The purchase report of the Iterable connector includes 6 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| purchase___type | TEXT | purchase._type | purchase._type |
| purchase__createdat | TEXT | purchase.createdAt | purchase.createdAt |
| purchase__data | OBJECT | purchase.data | purchase.data |
| purchase__email | TEXT | purchase.email | purchase.email |
| purchase__itblinternal | OBJECT | purchase.itblInternal | purchase.itblInternal |
| purchase__userid | TEXT | purchase.userId | purchase.userId |
Iterable push_bounce fields
The push_bounce report of the Iterable connector includes 6 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| push_bounce___type | TEXT | push_bounce._type | push_bounce._type |
| push_bounce__createdat | TEXT | push_bounce.createdAt | push_bounce.createdAt |
| push_bounce__data | OBJECT | push_bounce.data | push_bounce.data |
| push_bounce__email | TEXT | push_bounce.email | push_bounce.email |
| push_bounce__itblinternal | OBJECT | push_bounce.itblInternal | push_bounce.itblInternal |
| push_bounce__userid | TEXT | push_bounce.userId | push_bounce.userId |
Iterable push_open fields
The push_open report of the Iterable connector includes 6 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| push_open___type | TEXT | push_open._type | push_open._type |
| push_open__createdat | TEXT | push_open.createdAt | push_open.createdAt |
| push_open__data | OBJECT | push_open.data | push_open.data |
| push_open__email | TEXT | push_open.email | push_open.email |
| push_open__itblinternal | OBJECT | push_open.itblInternal | push_open.itblInternal |
| push_open__userid | TEXT | push_open.userId | push_open.userId |
Iterable push_send fields
The push_send report of the Iterable connector includes 6 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| push_send___type | TEXT | push_send._type | push_send._type |
| push_send__createdat | TEXT | push_send.createdAt | push_send.createdAt |
| push_send__data | OBJECT | push_send.data | push_send.data |
| push_send__email | TEXT | push_send.email | push_send.email |
| push_send__itblinternal | OBJECT | push_send.itblInternal | push_send.itblInternal |
| push_send__userid | TEXT | push_send.userId | push_send.userId |
Iterable push_send_skip fields
The push_send_skip report of the Iterable connector includes 6 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| push_send_skip___type | TEXT | push_send_skip._type | push_send_skip._type |
| push_send_skip__createdat | TEXT | push_send_skip.createdAt | push_send_skip.createdAt |
| push_send_skip__data | OBJECT | push_send_skip.data | push_send_skip.data |
| push_send_skip__email | TEXT | push_send_skip.email | push_send_skip.email |
| push_send_skip__itblinternal | OBJECT | push_send_skip.itblInternal | push_send_skip.itblInternal |
| push_send_skip__userid | TEXT | push_send_skip.userId | push_send_skip.userId |
Iterable push_uninstall fields
The push_uninstall report of the Iterable connector includes 6 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| push_uninstall___type | TEXT | push_uninstall._type | push_uninstall._type |
| push_uninstall__createdat | TEXT | push_uninstall.createdAt | push_uninstall.createdAt |
| push_uninstall__data | OBJECT | push_uninstall.data | push_uninstall.data |
| push_uninstall__email | TEXT | push_uninstall.email | push_uninstall.email |
| push_uninstall__itblinternal | OBJECT | push_uninstall.itblInternal | push_uninstall.itblInternal |
| push_uninstall__userid | TEXT | push_uninstall.userId | push_uninstall.userId |
Iterable sms_bounce fields
The sms_bounce report of the Iterable connector includes 6 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| sms_bounce___type | TEXT | sms_bounce._type | sms_bounce._type |
| sms_bounce__createdat | TEXT | sms_bounce.createdAt | sms_bounce.createdAt |
| sms_bounce__data | OBJECT | sms_bounce.data | sms_bounce.data |
| sms_bounce__email | TEXT | sms_bounce.email | sms_bounce.email |
| sms_bounce__itblinternal | OBJECT | sms_bounce.itblInternal | sms_bounce.itblInternal |
| sms_bounce__userid | TEXT | sms_bounce.userId | sms_bounce.userId |
Iterable sms_click fields
The sms_click report of the Iterable connector includes 6 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| sms_click___type | TEXT | sms_click._type | sms_click._type |
| sms_click__createdat | TEXT | sms_click.createdAt | sms_click.createdAt |
| sms_click__data | OBJECT | sms_click.data | sms_click.data |
| sms_click__email | TEXT | sms_click.email | sms_click.email |
| sms_click__itblinternal | OBJECT | sms_click.itblInternal | sms_click.itblInternal |
| sms_click__userid | TEXT | sms_click.userId | sms_click.userId |
Iterable sms_received fields
The sms_received report of the Iterable connector includes 6 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| sms_received___type | TEXT | sms_received._type | sms_received._type |
| sms_received__createdat | TEXT | sms_received.createdAt | sms_received.createdAt |
| sms_received__data | OBJECT | sms_received.data | sms_received.data |
| sms_received__email | TEXT | sms_received.email | sms_received.email |
| sms_received__itblinternal | OBJECT | sms_received.itblInternal | sms_received.itblInternal |
| sms_received__userid | TEXT | sms_received.userId | sms_received.userId |
Iterable sms_send fields
The sms_send report of the Iterable connector includes 6 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| sms_send___type | TEXT | sms_send._type | sms_send._type |
| sms_send__createdat | TEXT | sms_send.createdAt | sms_send.createdAt |
| sms_send__data | OBJECT | sms_send.data | sms_send.data |
| sms_send__email | TEXT | sms_send.email | sms_send.email |
| sms_send__itblinternal | OBJECT | sms_send.itblInternal | sms_send.itblInternal |
| sms_send__userid | TEXT | sms_send.userId | sms_send.userId |
Iterable sms_send_skip fields
The sms_send_skip report of the Iterable connector includes 6 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| sms_send_skip___type | TEXT | sms_send_skip._type | sms_send_skip._type |
| sms_send_skip__createdat | TEXT | sms_send_skip.createdAt | sms_send_skip.createdAt |
| sms_send_skip__data | OBJECT | sms_send_skip.data | sms_send_skip.data |
| sms_send_skip__email | TEXT | sms_send_skip.email | sms_send_skip.email |
| sms_send_skip__itblinternal | OBJECT | sms_send_skip.itblInternal | sms_send_skip.itblInternal |
| sms_send_skip__userid | TEXT | sms_send_skip.userId | sms_send_skip.userId |
Iterable sms_usage_info fields
The sms_usage_info report of the Iterable connector includes 6 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| sms_usage_info___type | TEXT | sms_usage_info._type | sms_usage_info._type |
| sms_usage_info__createdat | TEXT | sms_usage_info.createdAt | sms_usage_info.createdAt |
| sms_usage_info__data | OBJECT | sms_usage_info.data | sms_usage_info.data |
| sms_usage_info__email | TEXT | sms_usage_info.email | sms_usage_info.email |
| sms_usage_info__itblinternal | OBJECT | sms_usage_info.itblInternal | sms_usage_info.itblInternal |
| sms_usage_info__userid | TEXT | sms_usage_info.userId | sms_usage_info.userId |
Iterable templates fields
The templates report of the Iterable connector includes 8 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| templates__campaignid | TEXT | templates.campaignId | templates.campaignId |
| templates__clienttemplateid | TEXT | templates.clientTemplateId | templates.clientTemplateId |
| templates__createdat | TEXT | templates.createdAt | templates.createdAt |
| templates__creatoruserid | TEXT | templates.creatorUserId | templates.creatorUserId |
| templates__messagetypeid | TEXT | templates.messageTypeId | templates.messageTypeId |
| templates__name | TEXT | templates.name | templates.name |
| templates__templateid | TEXT | templates.templateId | templates.templateId |
| templates__updatedat | TEXT | templates.updatedAt | templates.updatedAt |
Iterable users fields
The users report of the Iterable connector includes 63 fields.
Iterable users fields (users__accepts_marketing to users__profileupdatedat)
| ID | Type | Name | Description |
|---|---|---|---|
| users__accepts_marketing | BOOLEAN | users.accepts_marketing | users.accepts_marketing |
| users__address1 | TEXT | users.address1 | users.address1 |
| users__addresses | OBJECT | users.addresses | users.addresses |
| users__admin_graphql_api_id | TEXT | users.admin_graphql_api_id | users.admin_graphql_api_id |
| users__aov | NUMERIC | users.aov | users.aov |
| users__boughtsas | BOOLEAN | users.boughtSas | users.boughtSas |
| users__businesslines | OBJECT | users.businessLines | users.businessLines |
| users__city | CITY | users.city | users.city |
| users__country | COUNTRY | users.country | users.country |
| users__default_address | OBJECT | users.default_address | users.default_address |
| users__email | TEXT | users.email | users.email |
| users__emailacquireddate | NUMERIC | users.emailAcquiredDate | users.emailAcquiredDate |
| users__emaillistids | OBJECT | users.emailListIds | users.emailListIds |
| users__emailsegmentstatus | TEXT | users.emailSegmentStatus | users.emailSegmentStatus |
| users__first_name | TEXT | users.first_name | users.first_name |
| users__firstcampaign | TEXT | users.firstCampaign | users.firstCampaign |
| users__firstmedium | TEXT | users.firstMedium | users.firstMedium |
| users__firstname | TEXT | users.firstName | users.firstName |
| users__firstordercards | OBJECT | users.firstOrderCards | users.firstOrderCards |
| users__firstorderdate | NUMERIC | users.firstOrderDate | users.firstOrderDate |
| users__firstpurchasedate | TEXT | users.firstPurchaseDate | users.firstPurchaseDate |
| users__firstsource | TEXT | users.firstSource | users.firstSource |
| users__hasaccount | BOOLEAN | users.hasAccount | users.hasAccount |
| users__hasreminder | BOOLEAN | users.hasReminder | users.hasReminder |
| users__id | TEXT | users.id | users.id |
| users__itblinternal | OBJECT | users.itblInternal | users.itblInternal |
| users__last_name | TEXT | users.last_name | users.last_name |
| users__last_order_id | TEXT | users.last_order_id | users.last_order_id |
| users__last_order_name | TEXT | users.last_order_name | users.last_order_name |
| users__lastinteractionts | TEXT | users.lastInteractionTs | users.lastInteractionTs |
| users__lastname | TEXT | users.lastName | users.lastName |
| users__ltr | NUMERIC | users.ltr | users.ltr |
| users__mostrecentcampaign | TEXT | users.mostRecentCampaign | users.mostRecentCampaign |
| users__mostrecentemaillist | TEXT | users.mostRecentEmailList | users.mostRecentEmailList |
| users__mostrecentmedium | TEXT | users.mostRecentMedium | users.mostRecentMedium |
| users__mostrecentordercards | OBJECT | users.mostRecentOrderCards | users.mostRecentOrderCards |
| users__mostrecentorderdate | TEXT | users.mostRecentOrderDate | users.mostRecentOrderDate |
| users__mostrecentsource | TEXT | users.mostRecentSource | users.mostRecentSource |
| users__orders_count | NUMERIC | users.orders_count | users.orders_count |
| users__profileupdatedat | TEXT | users.profileUpdatedAt | users.profileUpdatedAt |
Iterable users fields (users__secondmostrecentordercards to users__zip)
| ID | Type | Name | Description |
|---|---|---|---|
| users__secondmostrecentordercards | OBJECT | users.secondMostRecentOrderCards | users.secondMostRecentOrderCards |
| users__secondmostrecentorderdate | TEXT | users.secondMostRecentOrderDate | users.secondMostRecentOrderDate |
| users__secondordercards | OBJECT | users.secondOrderCards | users.secondOrderCards |
| users__secondorderdate | TEXT | users.secondOrderDate | users.secondOrderDate |
| users__shopify_created_at | TEXT | users.shopify_created_at | users.shopify_created_at |
| users__shopify_updated_at | TEXT | users.shopify_updated_at | users.shopify_updated_at |
| users__signupdate | TEXT | users.signupDate | users.signupDate |
| users__signupsource | TEXT | users.signupSource | users.signupSource |
| users__state | TEXT | users.state | users.state |
| users__subscribedmessagetypeids | OBJECT | users.subscribedMessageTypeIds | users.subscribedMessageTypeIds |
| users__tax_exempt | BOOLEAN | users.tax_exempt | users.tax_exempt |
| users__thirdmostrecentordercards | OBJECT | users.thirdMostRecentOrderCards | users.thirdMostRecentOrderCards |
| users__thirdmostrecentorderdate | NUMERIC | users.thirdMostRecentOrderDate | users.thirdMostRecentOrderDate |
| users__thirdordercards | OBJECT | users.thirdOrderCards | users.thirdOrderCards |
| users__thirdorderdate | TEXT | users.thirdOrderDate | users.thirdOrderDate |
| users__total_spent | NUMERIC | users.total_spent | users.total_spent |
| users__totalorders | NUMERIC | users.totalOrders | users.totalOrders |
| users__twelvemonthltr | NUMERIC | users.twelveMonthLtr | users.twelveMonthLtr |
| users__unsubscribedchannelids | OBJECT | users.unsubscribedChannelIds | users.unsubscribedChannelIds |
| users__unsubscribedmessagetypeids | OBJECT | users.unsubscribedMessageTypeIds | users.unsubscribedMessageTypeIds |
| users__userid | TEXT | users.userId | users.userId |
| users__verified_email | BOOLEAN | users.verified_email | users.verified_email |
| users__zip | TEXT | users.zip | users.zip |
Iterable web_push_click fields
The web_push_click report of the Iterable connector includes 6 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| web_push_click___type | TEXT | web_push_click._type | web_push_click._type |
| web_push_click__createdat | TEXT | web_push_click.createdAt | web_push_click.createdAt |
| web_push_click__data | OBJECT | web_push_click.data | web_push_click.data |
| web_push_click__email | TEXT | web_push_click.email | web_push_click.email |
| web_push_click__itblinternal | OBJECT | web_push_click.itblInternal | web_push_click.itblInternal |
| web_push_click__userid | TEXT | web_push_click.userId | web_push_click.userId |
Iterable web_push_send fields
The web_push_send report of the Iterable connector includes 6 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| web_push_send___type | TEXT | web_push_send._type | web_push_send._type |
| web_push_send__createdat | TEXT | web_push_send.createdAt | web_push_send.createdAt |
| web_push_send__data | OBJECT | web_push_send.data | web_push_send.data |
| web_push_send__email | TEXT | web_push_send.email | web_push_send.email |
| web_push_send__itblinternal | OBJECT | web_push_send.itblInternal | web_push_send.itblInternal |
| web_push_send__userid | TEXT | web_push_send.userId | web_push_send.userId |
Iterable web_push_send_skip fields
The web_push_send_skip report of the Iterable connector includes 6 fields.
| ID | Type | Name | Description |
|---|---|---|---|
| web_push_send_skip___type | TEXT | web_push_send_skip._type | web_push_send_skip._type |
| web_push_send_skip__createdat | TEXT | web_push_send_skip.createdAt | web_push_send_skip.createdAt |
| web_push_send_skip__data | OBJECT | web_push_send_skip.data | web_push_send_skip.data |
| web_push_send_skip__email | TEXT | web_push_send_skip.email | web_push_send_skip.email |
| web_push_send_skip__itblinternal | OBJECT | web_push_send_skip.itblInternal | web_push_send_skip.itblInternal |
| web_push_send_skip__userid | TEXT | web_push_send_skip.userId | web_push_send_skip.userId |
Iterable other fields
The Iterable connector has 25 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 | Account ID. | |
| account_name | TEXT | Account Name | Account name. | |
| campaigns_metrics__data | OBJECT | campaigns_metrics.data | campaigns_metrics.data | campaigns_metrics |
| data_fetched_at | 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 | Date. | |
| day_of_month | TEXT | Day of month | Day of the month | |
| list_users__email | TEXT | list_users.email | list_users.email | list_users |
| list_users__listid | TEXT | list_users.listId | list_users.listId | list_users |
| metadata__name | TEXT | metadata.name | metadata.name | metadata |
| month | TEXT | Month | Number of the month | |
| now | 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 |