Iterable: List User History

Description

• Table that recreates the list_user_history source table. Additionally, this table provides an is_current field to identify the current lists associated with the user. Additionally, the grain of this table is at the user/list/updated_at grain.

Supported Data Sources

• Iterable

Columns

Type	Name	Description
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	_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	user_id	User identifier, for userID-based projects.
STRING	user_email	Email of the user if it exists.
STRING	user_first_name	First name of the user
STRING	user_last_name	Last name of the user
DATETIME	user_signup_date	Timestamp as epoch time in milliseconds of when the user signed up
STRING	user_signup_source	Source where the user signed up
DATETIME	user_updated_at	Last update timestamp as epoch time in milliseconds
INTEGER	list_id	The list associated with the user
BOOLEAN	is_current	Boolean indicating if the current list is active
STRING	list_name	Name of the list associated with the user
STRING	list_type	Type of list associated with the user
DATETIME	list_created_at	Date the list was created