Iterable: Campaigns

Description

• Table that provides aggregations for campaigns at the experiment grain.

Supported Data Sources

• Iterable

Columns

Type	Name	Description
STRING	campaign_id	Unique identifier of the campaign record
STRING	campaign_name	User defined name of the campaign.
DATETIME	updated_at	Last update timestamp as epoch time in milliseconds
STRING	campaign_state	State of the campaign. Can be Draft, Ready, Scheduled, Running, Finished, Starting, Aborted or Recurring
STRING	campaign_type	The campaign type. Can be Blast or Triggered
INTEGER	send_size	Size of the campaign. Number of individuals included in the campaign
DATETIME	start_at	Start timestamp as epoch time in milliseconds
DATETIME	ended_at	Ended timestamp as epoch time in milliseconds
DATETIME	created_at	Creation timestamp as epoch time in milliseconds
STRING	created_by_user_id	Reference to the user who created the campaign
STRING	template_id	Reference to the campaign template
STRING	recurring_campaign_id	Unique identifier of the recurring campaign (if applicable)
STRING	recurring_campaign_name	Name of the recurring campaign (if applicable)
STRING	recurring_campaign_state	State of the recurring campaign (if applicable)
INTEGER	recurring_campaign_send_size	Size of the recurring campaign. Number of individuals included in the recurring campaign (if applicable)
DATETIME	recurring_campaign_start_at	Timestamp of when the recurring campaign started (if applicable)
BOOLEAN	is_campaign_recurring	Boolean indicating if the campaign is a recurring campaign
STRING	experiment_id	Reference to the experiment used if the event is an experiment
INTEGER	count_unique_users	Count of total unique users within the campaign/experiment
INTEGER	total_emailclick	Total email clicks within the campaign/experiment
INTEGER	unique_total_emailclick	Unique email clicks within the campaign/experiment
INTEGER	total_emailunsubscribe	Total email unsubscribe events within the campaign/experiment
INTEGER	unique_total_emailunsubscribe	Unique total email unsubscribe events within the campaign/experiment
INTEGER	total_emailcomplaint	Total email complaints within the campaign/experiment
INTEGER	unique_total_emailcomplaint	Unique total email complaints within the campaign/experiment
INTEGER	total_customevent	Total custom events within the campaign/experiment
INTEGER	unique_total_customevent	Unique total custom events within the campaign/experiment
INTEGER	total_emailsubscribe	Total email subscribe events within the campaign/experiment
INTEGER	unique_total_emailsubscribe	Unique total email subscribe events within the campaign/experiment
INTEGER	total_emailopen	Total email open events within the campaign/experiment
INTEGER	unique_total_emailopen	Unique total email open events within the campaign/experiment
INTEGER	total_pushsend	Total push send event within the campaign/experiment
INTEGER	unique_total_pushsend	Unique total push send events within the campaign/experiment
INTEGER	total_smsbounce	Total sms bounce events within the campaign/experiment
INTEGER	unique_total_smsbounce	Unique total sms bounce events within the campaign/experiment
INTEGER	total_pushbounce	Total push bounce events within the campaign/experiment
INTEGER	unique_total_pushbounce	Unique total push bounce events within the campaign/experiment
INTEGER	total_inappsendskip	Total in app send skip events within the campaign/experiment
INTEGER	unique_total_inappsendskip	Unique total in app send skip events within the campaign/experiment
INTEGER	total_smssend	Total sms send events within the campaign/experiment
INTEGER	unique_total_smssend	Unique total sms send events within the campaign/experiment
INTEGER	total_inappsend	Total in app send events within the campaign/experiment
INTEGER	unique_total_inappsend	Unique total in app send events within the campaign/experiment
INTEGER	total_pushopen	Total push open events within the campaign/experiment
INTEGER	unique_total_pushopen	Unique total push open events within the campaign/experiment
INTEGER	total_emailsend	Total email send events within the campaign/experiment
INTEGER	unique_total_emailsend	Unique total email send events within the campaign/experiment
INTEGER	total_pushsendskip	Total push send skip events within the campaign/experiment
INTEGER	unique_total_pushsendskip	Unique total push send skip events within the campaign/experiment
INTEGER	total_inappopen	Total in app open events within the campaign/experiment
INTEGER	unique_total_inappopen	Unique total in app open events within the campaign/experiment
INTEGER	total_emailsendskip	Total email send skip events within the campaign/experiment
INTEGER	unique_total_emailsendskip	Unique total email send skip events within the campaign/experiment
INTEGER	total_emailbounce	Total email bounce events within the campaign/experiment
INTEGER	unique_total_emailbounce	Unique total email bounce events within the campaign/experiment
INTEGER	total_inappclick	Total in app click events within the campaign/experiment
INTEGER	unique_total_inappclick	Unique total in app click events within the campaign/experiment
INTEGER	total_pushuninstall	Total push uninstall events within the campaign/experiment
INTEGER	unique_total_pushuninstall	Unique total push uninstall events within the campaign/experiment
INTEGER	count_send_lists	Count of send lists within the campaign/experiment
INTEGER	count_suppress_lists	Count of suppress lists within the campaign/experiment
STRING	template_name	Name of the template associated with the campaign/experiment
STRING	template_creator_user_id	The creator user id of the template associated with the campaign/experiment
STRING	message_medium	The medium which the message was provided
STRING	message_type_name	The message type name associated with the campaign/experiment
STRING	channel_name	The channel name associated with the campaign/experiment
STRING	channel_id	The channel identifier associated with the campaign/experiment
STRING	channel_type	The channel type associated with the campaign/experiment