Iterable: User Campaign

Description

• Table that provides total and unique metrics for a user associated with particular campaigns.

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	user_id	User identifier, for userID-based projects.
STRING	campaign_id	The unique identifier of the campaign which the user metrics are associated
STRING	experiment_id	The unique experiment variation of the campaign
STRING	user_email	Email of the user if it exists.
STRING	user_full_name	The users first and last name
STRING	campaign_name	The name of the campaign which the user metrics are associated
STRING	template_id	The unique identifier of the template used within the campaign
STRING	template_name	The name of the template used for the campaign
STRING	recurring_campaign_id	The unique identifier of the recurring campaign which the campaign is tied to
STRING	recurring_campaign_name	The name of the recurring campaign which the campaign is tied to
DATETIME	first_event_at	Timestamp of the first campaign/experiment event associated with the user
DATETIME	last_event_at	Timestamp of the most recent campaign/experiment event associated with the user
INTEGER	total_emailclick	Total email clicks events the user took within the campaign/experiment
INTEGER	total_emailunsubscribe	Total email unsubscription events the user performed within the campaign/experiment
INTEGER	total_emailcomplaint	Total email complaint events the user performed within the campaign/experiment
INTEGER	total_customevent	Total custom events associated with the user within the campaign/experiment
INTEGER	total_emailsubscribe	Total email subscription events associate with the user within the campaign/experiment
INTEGER	total_emailopen	Total email open events the user performed within the campaign/experiment
INTEGER	total_pushsend	Total push send events the user performed within the campaign/experiment
INTEGER	total_smsbounce	Total sms bounce events associated with the user within the campaign/experiment
INTEGER	total_pushbounce	Total push bounce events associated with the user within the campaign/experiment
INTEGER	total_inappsendskip	Total in app send skip events the user performed within the campaign/experiment
INTEGER	total_smssend	Total sms send events associated with the user within the campaign/experiment
INTEGER	total_inappsend	Total in app send events associated with the user within the campaign/experiment
INTEGER	total_pushopen	Total push open events the user performed within the campaign/experiment
INTEGER	total_emailsend	Total email send event associated with the user within the campaign/experiment
INTEGER	total_pushsendskip	Total push send skip events associated with the user within the campaign/experiment
INTEGER	total_inappopen	Total in app open events associated with the user within the campaign/experiment
INTEGER	total_emailsendskip	Total email send skip events associated with the user within the campaign/experiment
INTEGER	total_emailbounce	Total email bounce events associated with the user within the campaign/experiment
INTEGER	total_inappclick	Total in app click events associated with the user within the campaign/experiment
INTEGER	total_pushuninstall	Total push uninstall events associated with the user within the campaign/experiment