Marketo: Email Sends

Description

• Each record is a sent email in Marketo to a user.

Supported Data Sources

• Marketo

Columns

Type	Name	Description
DATETIME	activity_timestamp	The timestamp the email was sent.
INTEGER	activity_type_id	The ID of the activity type.
INTEGER	campaign_id	The ID of the email's campaign.
INTEGER	campaign_run_id	The ID of the email's campaign run.
INTEGER	choice_number	The choice number of the current step that triggered the activity.
INTEGER	email_template_id	The ID of the email's template.
INTEGER	activity_id	The ID of the activity.
INTEGER	lead_id	The ID of the lead related to the activity.
STRING	primary_attribute_value	The primary attribute of the activity.
INTEGER	primary_attribute_value_id	The ID of the primary attribute of the activity.
INTEGER	step_id	The Id of the current step in the flow.
STRING	email_send_id	The inferred ID for the email sent.
INTEGER	activity_rank	Assigned rank for a given email_send_id, determined by ascending order of activity_timestamp. Earliest activity_timestamp gets rank 1.
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.
BOOLEAN	was_opened	Whether the email send was opened.
BOOLEAN	was_bounced	Whether the email send bounced.
BOOLEAN	was_clicked	Whether the email send was clicked.
BOOLEAN	was_delivered	Whether the email send was delivered.
BOOLEAN	was_unsubscribed	Whether the email send resulted in the user unsubscribing.
STRING	campaign_type	The type of the email send's campaign.
INTEGER	program_id	The ID of the email send's program.
BOOLEAN	is_operational	Whether the email send was operational.