Iterable
## Columns
| Type | Name | Description |
| -------- | --------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| STRING | event\_id | Unique id of the event generated by Fivetran |
| STRING | unique\_event\_id | A unique surrogate key of event\_id and \_fivetran\_user\_id. |
| STRING | \_fivetran\_user\_id | A Fivetran-created unique identifier for the new Iterable schema in Aug 2023, for users, derived from hashing user\_id and/or email, depending on project type. |
| STRING | unique\_user\_key | The unique identifier of the user. With the new schema (Aug 2023), it is the \_fivetran\_user\_id. This is a hash of user\_id and/or email, depending on project type. If using the old schema, it is email. |
| STRING | campaign\_id | Reference to the campaign from which the event originated |
| STRING | content\_id | Reference to the content the event is associated with |
| DATETIME | created\_at | Creation timestamp as epoch time in milliseconds |
| DATE | created\_on | Timestamp of when the event was created |
| STRING | email | The user's email. User identifier, for email-based projects. Previously was the unique identifier for user records, for the old Iterable schema before the August 2023 updates. |
| STRING | additional\_properties | json object containing addition event properties |
| STRING | event\_name | Name provided to the individual event |
| STRING | message\_bus\_id | Reference to the message bus associated with the event |
| STRING | message\_id | Reference to the message the event is associated with |
| STRING | message\_type\_id | Reference to the type of message the event is associated with |
| STRING | recipient\_state | The state of the recipient upon receiving the event |
| STRING | status | Status of the event |
| STRING | transactional\_data | Transactional data associated with the event |
| STRING | unsub\_source | Source of the unsubscribe event |
| STRING | user\_agent | User agent associated with the event |
| STRING | user\_agent\_device | The device of the user agent |
| DATETIME | \_fivetran\_synced | Timestamp of when the event record was synced by Fivetran |
| STRING | campaign\_name | The name of the campaign |
| STRING | campaign\_type | The type of campaign |
| BOOLEAN | is\_campaign\_recurring | Boolean indicating if the campaign is recurrent |
| STRING | recurring\_campaign\_name | The name of the recurring campaign (if applicable) |
| STRING | recurring\_campaign\_id | The campaign if of the recurring campaign (if applicable) |
| STRING | user\_id | User identifier, for userID-based projects. |
| STRING | user\_full\_name | Full name of the user |
| STRING | message\_type\_name | Name of the message type |
| STRING | message\_medium | Medium of the message |
| STRING | channel\_id | Unique identifier of the channel |
| STRING | channel\_name | The channel name |
| STRING | channel\_type | The type of channel |
| BOOLEAN | is\_app\_already\_running | Boolean indicating if the app is already running |
| STRING | badge | Badge associated with the event |
| INTEGER | catalog\_collection\_count | The count of products or items collected in a catalog associated with the event. |
| INTEGER | catalog\_lookup\_count | The count of times a catalog was looked up or queried during the event. |
| STRING | canonical\_url\_id | Reference to the url associated with the event |
| BOOLEAN | is\_content\_available | Content available from the event |
| STRING | device | The device associated with the event |
| STRING | email\_id | Reference to the email associated with the event |
| STRING | email\_subject | Subject of the email associated with the event |
| STRING | experiment\_id | Reference to the experiment used if the event is an experiment |
| INTEGER | from\_phone\_number\_id | Reference to the phone number which the event is from |
| INTEGER | from\_smssender\_id | Reference to the sms sender which the event is from |
| STRING | link\_id | Reference to the link associated with the event |
| STRING | link\_url | Url of the link associated with the event |
| STRING | locale | Locale associated with the event |
| STRING | payload | Payload resulted from the event |
| STRING | platform\_endpoint | The specific platform endpoint of the event |
| STRING | push\_message | Boolean indicating if the event is a push message |
| STRING | region | Region of the event |
| STRING | sms\_message | Boolean indicating if the event is an sms message |
| STRING | to\_phone\_number | To phone number associated with the event |
| STRING | url | Url associated with the event |
| STRING | workflow\_id | Reference to the workflow which the event originated |
| STRING | workflow\_name | Name of the workflow which the event originated |
| STRING | city | The city associated with the event, which could be the location of the recipient. |
| STRING | clicked\_url | The URL that was clicked by the recipient in response to the marketing message. |
| STRING | country | The country associated with the event, which could be the location of the recipient. |
| STRING | error\_code | The error code or message indicating any issues or errors encountered during the event. |
| DATETIME | expires\_at | The date and time when the event or message is set to expire or become invalid. |
| STRING | from\_phone\_number | The phone number from which the SMS message was sent. |
| STRING | in\_app\_body | The content or body of an in-app message that was sent as part of the event. |
| BOOLEAN | is\_sms\_estimation | A boolean indicating whether the SMS message is an estimation or not. |
| STRING | labels | Any labels or tags associated with the event, which can be used for categorization or organization. |
| STRING | message\_status | The status of the marketing message, such as sent, delivered, opened, etc. |
| INTEGER | mms\_send\_count | The count of multimedia messages (MMS) sent as part of the event. |
| STRING | reason | The reason or cause associated with a specific event or action. |
| INTEGER | sms\_send\_count | The count of SMS messages sent as part of the event. |
| STRING | template\_id | Unique identifer of the template |
| STRING | template\_name | User defined name of the template |
| STRING | template\_creator\_user\_id | Reference to the user who created the template |
---
# Agent Instructions: Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/iterable-events.md?ask=