Is there a way to pull in the email sent date or SL into the Marketo email reports? | Community
Skip to main content
August 15, 2017
Question

Is there a way to pull in the email sent date or SL into the Marketo email reports?

  • August 15, 2017
  • 3 replies
  • 8142 views

Is there a way to pull in the email sent date or SL into the Marketo email reports?

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

3 replies

Devraj_Grewal
Level 10
August 15, 2017

Felicia,

It is not a standard metric in an email performance report, but you can pull in the "First Activity" and "Last Activity" standard columns, "First Activity" being the date of first engagement with the email.

August 15, 2017

Hi Devraj,

Thank you for getting back to me. Do you know if there is a way to pull in the email subject lines into the report?

thanks,

Felicia

Devraj_Grewal
Level 10
August 15, 2017

Unfortunately, no, but you can vote for this idea here:

Andy_Caron3
Level 3
August 15, 2017

Hi Felicia,

I would start by asking what you're looking to do with that information?

Couple thoughts here without the actual use case:

1) Are you also using SFDC? Automating completed activities for "email sent / delivered" for the lead/contact is fairly easy to do as a part of your other workflows in a smart campaign. You can then pull an activity report in SFDC which by default will have the date and time for that activity. Be cautious though. Syncing everything can slow down your systems or max out your API calls.

2) Alternatively, you can look at the results of your Send Smart Campaigns already performing other tasks for that send program, like updating the Program Status to Delivered or Opened. Downloading the results, playing with the data a bit and/or using a quick pivot table will allow you to see the time and date stamp of each activity for each lead. The time logged is going to be the time at which they completed that flow step, not when it was triggered, so depending on how many flow steps and any wait steps might be delayed by a minute, but it's going to get you very close.

Andy Caron
August 17, 2017

Hi Andy,

Unfortunately, we do not use SFDC, we are using Microsoft Dynamics. I have tried quite a few times and it seems there is no way to pull records based on email activity. It's all very disjointed.

My purpose for both these features was to analyze the variations of open rates and engagement based on different days of the week, and also by subject lines.

I think the download would work if I matched it against an export of the front end data.

Thanks again!

Felicia

Andy_Caron3
Level 3
August 17, 2017

Felicia,

You could also look at using nested Send Programs for your outbound communications. This would give you visuals and automatic engagement scores. Additionally, it breaks out the open times into groups. You'd still have to synthesize that data outside of Marketo to compare days of the week, but it would show you spikes in opens related to time of day. I also recommend playing with A/B testing on your emails for more subject line data.

Andy

Andy Caron
Dan_Stevens_
Level 10
August 17, 2017

Are you looking to do something like this:

If so, this is very easy to create using the Email Analysis report in RCE.

September 21, 2017

Hi, Dan, yes that was something I was looking to do. I have to admit I've inherited Marketo from a predecessor, and she was never able to figure out how to make the revenue cycles work properly. Is there a way to create this report without having our revenue cycles set up?

Dan_Stevens_
Level 10
September 21, 2017

Sure, the Email Analysis report is not dependent on having your Revenue Model defined.  All that's required is that you've purchased the Revenue Cycle Explorer (now called "Advanced Analytics") add-on from Marketo.