Iterable: Users

Description

• Table that provides unique user enriched information.

Supported Data Sources

• Iterable

Columns

Type	Name	Description
STRING	user_id	User identifier, for userID-based projects.
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	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	first_name	First name of the user
STRING	last_name	Last name of the user
DATETIME	signup_date	Timestamp as epoch time in milliseconds of when the user signed up
STRING	signup_source	Source where the user signed up
DATETIME	updated_at	Last update timestamp as epoch time in milliseconds
STRING	phone_number	Phone number associated with the user
STRING	email_list_ids	Array of all email lists associated with the user
INTEGER	count_lists	Total count of lists associated with the user
INTEGER	count_total_campaigns	Count of all campaigns the user has been in
DATETIME	first_event_at	The first event the user ever encountered
DATETIME	last_event_at	The most recent event the user has encountered
INTEGER	total_emailclick	Total number of email clicks the user has performed
INTEGER	total_emailunsubscribe	Total unsubscription events the user has performed
INTEGER	total_emailcomplaint	Total email complaints the user has performed
INTEGER	total_customevent	Total custom events associated with the user
INTEGER	total_emailsubscribe	Total subscription events the user has performed
INTEGER	total_emailopen	Total email opened events the user has performed
INTEGER	total_pushsend	The push send events the user has experienced
INTEGER	total_smsbounce	Total sms bounces that are associated with the user
INTEGER	total_pushbounce	Total number of push bounces associated with the user
INTEGER	total_inappsendskip	Total in app send skips associated with the user
INTEGER	total_smssend	Total sms sends that the user has experienced
INTEGER	total_inappsend	Total in app sends the user has experienced
INTEGER	total_pushopen	Total push messages the user has opened
INTEGER	total_emailsend	Total emails that have been sent to the user
INTEGER	total_pushsendskip	Total push sends the user has skipped
INTEGER	total_inappopen	Total in app opens the user has performed
INTEGER	total_emailsendskip	Total email sends the user has skipped
INTEGER	total_emailbounce	Total number of emails that have bounced from the user
INTEGER	total_inappclick	Total in app clicks associated with the user
INTEGER	total_pushuninstall	Total push uninstall events the user has performed