Below are the measures and dimensions Alight Analytics considers standard for Marketo - Email Performance dataset. There is a one day lag on Marketo and data is pulled for seven days.
|Report Date||Date||The date the activity occurred.|
|Email Name||Dimension||Name of the email that was sent|
|Email Delivered||Whole Number||Marketo Email is delivered to a lead/contact|
|Email Opens||Whole Number||User opens Marketo Email|
|Email Clicks||Whole Number||User clicks on a link in a Marketo Email|
|Hard Bounced||Whole Number||Marketo Email is bounced for a lead|
|Soft Bounced||Whole Number||Campaign Email is bounced soft for a lead|
|Unsubscribe||Whole Number||Person unsubscribed from Marketo Emails|
|Description||Dimension||A description of the email sent|
|Email ID||Whole Number||The id of the email sent|
|Insert Date||DateTime||Internal use: when the row was inserted in the table|
|ChannelMix Profile||Dimension||When needed, distinguishes between Marketo accounts - Contents defined by Alight.|
A few things to note about some of the metrics in this dataset. There is a slight difference between the way that the Marketo API reports things and the way that the Email Performance Report from Marketo reports some metrics. Deliveries for instance from the API reports when an email is delivered to a lead, if the email bounces after it records a delivery, the API records a record for each activity. The email performance report will remove any deliveries from the data if there is a bounce reordered after the email is delivered. So the deliveries from the API appear to be slightly inflated because of the way these are reported.