Iterable: Events

Description

• Table that provides a comprehensive view of all events with enriched information such as the campaign, user effected, and template used.

Supported Data Sources

• Iterable

Columns

Type	Name	Description
STRING	event_id	Unique id of the event generated by Fivetran
STRING	unique_event_id	A unique surrogate key of event_id and _fivetran_user_id.
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	campaign_id	Reference to the campaign from which the event originated
STRING	content_id	Reference to the content the event is associated with
DATETIME	created_at	Creation timestamp as epoch time in milliseconds
DATE	created_on	Timestamp of when the event was created
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	additional_properties	json object containing addition event properties
STRING	event_name	Name provided to the individual event
STRING	message_bus_id	Reference to the message bus associated with the event
STRING	message_id	Reference to the message the event is associated with
STRING	message_type_id	Reference to the type of message the event is associated with
STRING	recipient_state	The state of the recipient upon receiving the event
STRING	status	Status of the event
STRING	transactional_data	Transactional data associated with the event
STRING	unsub_source	Source of the unsubscribe event
STRING	user_agent	User agent associated with the event
STRING	user_agent_device	The device of the user agent
DATETIME	_fivetran_synced	Timestamp of when the event record was synced by Fivetran
STRING	campaign_name	The name of the campaign
STRING	campaign_type	The type of campaign
BOOLEAN	is_campaign_recurring	Boolean indicating if the campaign is recurrent
STRING	recurring_campaign_name	The name of the recurring campaign (if applicable)
STRING	recurring_campaign_id	The campaign if of the recurring campaign (if applicable)
STRING	user_id	User identifier, for userID-based projects.
STRING	user_full_name	Full name of the user
STRING	message_type_name	Name of the message type
STRING	message_medium	Medium of the message
STRING	channel_id	Unique identifier of the channel
STRING	channel_name	The channel name
STRING	channel_type	The type of channel
BOOLEAN	is_app_already_running	Boolean indicating if the app is already running
STRING	badge	Badge associated with the event
INTEGER	catalog_collection_count	The count of products or items collected in a catalog associated with the event.
INTEGER	catalog_lookup_count	The count of times a catalog was looked up or queried during the event.
STRING	canonical_url_id	Reference to the url associated with the event
BOOLEAN	is_content_available	Content available from the event
STRING	device	The device associated with the event
STRING	email_id	Reference to the email associated with the event
STRING	email_subject	Subject of the email associated with the event
STRING	experiment_id	Reference to the experiment used if the event is an experiment
INTEGER	from_phone_number_id	Reference to the phone number which the event is from
INTEGER	from_smssender_id	Reference to the sms sender which the event is from
STRING	link_id	Reference to the link associated with the event
STRING	link_url	Url of the link associated with the event
STRING	locale	Locale associated with the event
STRING	payload	Payload resulted from the event
STRING	platform_endpoint	The specific platform endpoint of the event
STRING	push_message	Boolean indicating if the event is a push message
STRING	region	Region of the event
STRING	sms_message	Boolean indicating if the event is an sms message
STRING	to_phone_number	To phone number associated with the event
STRING	url	Url associated with the event
STRING	workflow_id	Reference to the workflow which the event originated
STRING	workflow_name	Name of the workflow which the event originated
STRING	city	The city associated with the event, which could be the location of the recipient.
STRING	clicked_url	The URL that was clicked by the recipient in response to the marketing message.
STRING	country	The country associated with the event, which could be the location of the recipient.
STRING	error_code	The error code or message indicating any issues or errors encountered during the event.
DATETIME	expires_at	The date and time when the event or message is set to expire or become invalid.
STRING	from_phone_number	The phone number from which the SMS message was sent.
STRING	in_app_body	The content or body of an in-app message that was sent as part of the event.
BOOLEAN	is_sms_estimation	A boolean indicating whether the SMS message is an estimation or not.
STRING	labels	Any labels or tags associated with the event, which can be used for categorization or organization.
STRING	message_status	The status of the marketing message, such as sent, delivered, opened, etc.
INTEGER	mms_send_count	The count of multimedia messages (MMS) sent as part of the event.
STRING	reason	The reason or cause associated with a specific event or action.
INTEGER	sms_send_count	The count of SMS messages sent as part of the event.
STRING	template_id	Unique identifer of the template
STRING	template_name	User defined name of the template
STRING	template_creator_user_id	Reference to the user who created the template