Skip to main content
René_Kamine
Level 2
Sep 16, 2019 1:06 AM UTC
Question

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

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.

13 replies

Josh_Pickles
Level 5
Sep 16, 2019 1:17 AM UTC

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.

Translate
René_Kamine
Level 2
Sep 16, 2019 1:34 AM UTC

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

Translate
Nadia_Milani
Level 2
Sep 17, 2019 1:46 PM UTC

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

Translate
Jay_Jiang
Level 10
Sep 16, 2019 2:01 AM UTC

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:

Translate
René_Kamine
Level 2
Sep 16, 2019 2:09 AM UTC

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

Translate
Jay_Jiang
Level 10
Sep 16, 2019 2:16 AM UTC

Yes you can set a time period in the filter area

Translate
Diana_Watts3
Level 3
Sep 16, 2019 2:12 AM UTC

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.  

Translate