Need help with defining some engagement metrics

Hi Rob

If you expect an answer, you should rather post you questions to products rather than to the Champions group. See Getting the most of the community when you have a Marketo question

1) How many times a month on average did we deliver an email to an email address?

Impossible to get from Marketo directly if you want this per email address or event globally. You will need to either go to RCE or extract the "email sent" activity data to excel, using the API. The closest you can have in MLM is email performance report.

You could also create some smart lists:

• sent email at least once in past month -> a N1 number of leads
• sent email at least twice in past month -> a N2 number of leads
• sent email at least three times in past month -> a N3 number of leads
• ... until you get no result

Then the total of email sent will be T = N1 + 2 x N2 + 3 x N3 + ... + n x Nn and the average will be T/N1

For the future, you should consider a counter field that you would reset each month and increment by +1 each time an email is delivered to a lead. For this, just use a score field and a smart campaign that add +1 to this score on each email is delivered. Then you will just have to export the list N1 above with this field and you will get the info you need.

2) Can we find the top most engaged email addresses as define as having most recent clicks?

Some smart lists based on the "clicked link in email" should to the job. you will be able to add constraints for the date and the number of times.

For the future, create a datetime field and a smart campaign that set this field to {{system.datetime}} each time a lead clicks in a email. then you will get the result you need with a smart list.

3) Can we find the top most engaged email addresses as define as having most recent opens?

Same as 2). Attention "open" detection is not reliable. It relies on downloading an image, which is not the default behavior in Outlook for instance. You may end up with lead who apparently have not opened and yet have clicked.

4) Display the top email addresses with the highest score.

Easy, just use a smart list, extract it and sort it

5) Show the highest email delivery rates by email type.

You will have to rely on you naming convention to define the type. then use the email performance report.

-Greg