Is there a report to show how many emails are sent to each person? | Community
Skip to main content
René_Kamine
New Participant
September 16, 2019
Question

Is there a report to show how many emails are sent to each person?

  • September 16, 2019
  • 3 replies
  • 12405 views

Hi

Does anyone know of a way to see how many emails each person in Marketo is receiving?

I know I can look at a person's activity log but that would take a very long time to do that individually for every person. I'd like to see a report that shows every person within a filtered segment (or the entire database) & how many emails they receive in any given time period eg per week.

Is that possible?

Cheers

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

3 replies

Diana_Watts3
New Participant
September 16, 2019

We've got something similar in our instance. It involved creating a new custom score field called 'Email Count'. A listener campaign was set up whereby if an email is delivered, add +1 to the count. Then, wait 7 days until 11pm, and minus 1 from the count. That way, at any given time you have a clear idea of the number of emails sent to that person in the last 7 days.  

Jay_Jiang
New Participant
September 16, 2019

If you don't have RCE, you'll need to create custom fields to track email names or counter fields to track number of emails sent - as suggested by Josh.

If you have RCE you can get such reports:

Count of Sent:

By email name:

René_Kamine
New Participant
September 16, 2019

Hi @Jay Jiang‌

I've actually just sent my CSM an email about the Revenue Explorer license. MKTO support also mentioned the reports that it can produce may answer my question. I was hoping there could be another option that doesn't require an additional license. Seems there are with a bit of effort.

Does the reports Revenue Explorer produce allow you to select a time period, including dates in the past? I'm guessing it does but just to double check.

Cheers

Jay_Jiang
New Participant
September 16, 2019

Yes you can set a time period in the filter area

Josh_Pickles
New Participant
September 16, 2019

The standard reporting options within Marketo are very simple and don't offer too much flexibility in terms of this. 

For clarity, are you looking for a total count (e.g. Email1: 3 emails; Email 2: 5 emails) or the names etc (Email 1: Newsletter, Webinar Registration, Webinar Reminder; Email 2 : Newsletter...)?

If you're looking for a total count, you could create a webhook that "counts" every time an email is sent and adds this value into a field within Marketo. This field could be wiped out each week, and values added to a Historical field so you can track previous weeks/months etc.

If you're wanting to identify the names of emails a lead has been sent, you could create a field within Marketo (e.g. Email Historical) that a Smart Campaign adds a value to every time an email is sent. That value could be the date and name of the email the lead has received. You could then create a Smart List of everybody who has had the "Email Historical" field updated in the past X days to see what has been run.

It's not simple, but these are the most straightforward options I could come up with.

René_Kamine
New Participant
September 16, 2019

Thanks @Josh Pickles‌

This is most helpful! I'm liking your 2nd & 3rd options. Though just confirming, both options won't allow me to see historical data of past eDMs sent. Is that correct? It would only be for future emails sent once the process has been set up?

Cheers

Nadia_Milani
New Participant
September 17, 2019

You would need to create the logic/smart campaign, then you can see the results. So "moving forward".