# Iterable: User Unsubscriptions

## Description

* Table that generates the total channel and message types a user has chosen to unsubscribe.

## Supported Data Sources

* <img src="https://fivetran.com/integrations/iterable/resources/iterable.svg" alt="" data-size="line"> Iterable

## Columns

| Type     | Name                            | Description                                                                                                                                                                                                  |
| -------- | ------------------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ |
| 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   | channel\_id                     | Unique identifier of the channel which the user is unsubscribed                                                                                                                                              |
| STRING   | message\_type\_id               | Unique identifer of the message type which the user is unsubscribed                                                                                                                                          |
| DATETIME | updated\_at                     | Timestamp of when the user unsubscribed from the channel or message type                                                                                                                                     |
| STRING   | channel\_name                   | The name of the channel which the user is unsubscribed                                                                                                                                                       |
| STRING   | message\_type\_name             | The name of the message type which the user is unsubscribed                                                                                                                                                  |
| STRING   | channel\_type                   | The channel type which the user is unsubscribed                                                                                                                                                              |
| STRING   | message\_medium                 | The medium type the message was provided which the user is unsubscribed                                                                                                                                      |
| BOOLEAN  | is\_unsubscribed\_channel\_wide | Boolean indicating if the user unsubscribed at the channel level (i.e. unsubscribed to all message types) or if they unsubscribed from only an individual message type.                                      |
