Skip to main content
Jun 20, 2017 4:53 PM UTC
Solved

How can I track lead journey through campaigns?

Could you, please, help me with following task: for example, I send out 150 emailings to 50000 people during the year. I need to find out, how many people have opened all 150 emails, how many only 70. So I'd like to group leads by the level of their interest in my emailings. I'd like to filter out the most active leads, which are the campaign members of all campaigns and I'd like also to find out, what groups of not really active leads I have in the database (for example, there are 150 leads, who has opened only 3 emailings during the year, but all these emailings are devoted to one topic - this information could be really important for me).

Thank you in advance!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Gerard_Donnell4
Gerard_Donnell4Accepted solution
Level 9
Jun 20, 2017 6:36 PM UTC

Hi Jakob,

Do you have Revenue Explorer as part of your licence?  This could be done very easily with its reporting features.  You would just create an email analysis report.  In the filter at the top drag email name field and add all your emails. Then in the left hand side you would drag out the fields you want to report on, such as Full Name, Opened, Clicked etc.  You can also add column and row totals as well.

If you do have the feature let me know and I can provide more detailed notes.

Thanks,

Gerard

6 replies

Gerard_Donnell4
Gerard_Donnell4Accepted solution
Level 9
Jun 20, 2017 6:36 PM UTC

Hi Jakob,

Do you have Revenue Explorer as part of your licence?  This could be done very easily with its reporting features.  You would just create an email analysis report.  In the filter at the top drag email name field and add all your emails. Then in the left hand side you would drag out the fields you want to report on, such as Full Name, Opened, Clicked etc.  You can also add column and row totals as well.

If you do have the feature let me know and I can provide more detailed notes.

Thanks,

Gerard

Translate
Jun 21, 2017 11:54 AM UTC

Thank you very much, Gerard!

To my regret, I don't have such feature as Revenue Explorer. Is there any other way to find out these things?

Thanks, Jakob.

Translate
Gerard_Donnell4
Level 9
Jun 21, 2017 12:46 PM UTC

Hi Jakob,

Without revenue explorer there wouldn't be a way to pull this data at a lead level.  The main Marketo system would be able to give you the email performance for each email but not which specific leads opened them. The only other way to find that out would be by making smart lists or going through lead activity logs and both would be impossible to do with that many leads and emails.

You could create a smart list for specific groups of email based around the "Opened Email" filter and just repeat it for the number of emails in a given topic. See screen shot below.  You could then do the same thing using the "Not Opened Email" filter.  These would at least let you see a list of the people who opened them all or opened none.

Thanks,

Gerard

Translate