Iterable: User Unsubscriptions

Description

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

Supported Data Sources

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