Marketo: Email Templates

Description

• Each record is the most recent version of an email template.

Supported Data Sources

• Marketo

Columns

Type	Name	Description
DATETIME	created_timestamp	Timestamp the email template was created.
STRING	description	Description of the email template.
STRING	folder_name	The name of the email template's folder.
INTEGER	folder_id	The ID of the email template's folder.
STRING	folder_type	The type of the email template's folder.
INTEGER	folder_value	The value of the email template's folder.
STRING	from_email	The 'From' address of the email.
STRING	from_name	The 'From' name of the email.
INTEGER	email_template_id	ID of the email template
STRING	email_template_name	Name of the email template.
BOOLEAN	is_operational	Whether the email is operational. Operational emails bypass unsubscribe status. Defaults to false.
INTEGER	program_id	The ID of the email template's program.
BOOLEAN	publish_to_msi	Whether the email is published to Marketo Sales Insight.
STRING	reply_email	Reply-To address of the Email.
STRING	email_template_status	Status filter for draft or approved versions.
STRING	email_subject	Subject line of the email.
INTEGER	parent_template_id	ID of the parent template.
BOOLEAN	is_text_only	Setting to include text-only version of email when sent.
DATETIME	updated_timestamp	Timestamp the email template was last updated.
STRING	email_template_url	URL of the email template in the Marketo UI.
INTEGER	version_type	The type version of the email, either '1' or '2'.
BOOLEAN	has_web_view_enabled	Whether 'View as Webpage' function is enabled for the email.
STRING	workspace_name	Name of the workspace.
INTEGER	inferred_version	Incrementing integer version of the email template.
INTEGER	total_count_of_versions	Count of records for a given email_template_id.
DATETIME	valid_from	When the version of the email template was is valid from.
DATETIME	valid_to	When the version of the email template was is valid to.
BOOLEAN	is_most_recent_version	Whether it is the most recent version of the email template.
STRING	email_template_history_id	ID of the version of the email template.
INTEGER	count_sends	Count of total sends from related email sends.
INTEGER	count_opens	Count of total opens from related email sends.
INTEGER	count_bounces	Count of total bounces from related email sends.
INTEGER	count_clicks	Count of total clicks from related email sends.
INTEGER	count_deliveries	Count of total deliveries from related email sends.
INTEGER	count_unsubscribes	Count of total unsubscribes from related email sends.
INTEGER	count_unique_opens	Count of unique opens from related email sends.
INTEGER	count_unique_clicks	Count of unique clicks from related email sends.