# 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.                                      |


---

# 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-user-unsubscriptions.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.