Email Open Rates Based on Delivery Time | Community
Skip to main content
A
Amanda_Grambsch
New Participant
May 14, 2024
Solved

Email Open Rates Based on Delivery Time

  • May 14, 2024
  • 1 reply
  • 1629 views

Is there a way to run a report based on what time all historic emails were sent to analyze open and click through rates based on delivery time other than in Revenue Explorer? I'm trying to find the information in email insights but it will only show detailed info by day and I am looking to go back a full year. 

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

Amanda,

the first problem you'll have is that Marketo is only guaranteed to retain email sends data for 90 days.  You can see the activity data retention policy here

 

This is why many businesses extract their activity data and place it in an external database.  If you are doing this, it'd be comparatively straightforward to do the analysis there using SQL.

 

Cheers

Jo

1 reply

Jo_Pitts1
Jo_Pitts1Accepted solution
Community Manager
May 15, 2024

Amanda,

the first problem you'll have is that Marketo is only guaranteed to retain email sends data for 90 days.  You can see the activity data retention policy here

 

This is why many businesses extract their activity data and place it in an external database.  If you are doing this, it'd be comparatively straightforward to do the analysis there using SQL.

 

Cheers

Jo

    Darshil_Shah1
    Darshil_Shah1
    Community Manager
    May 16, 2024

    Jo's right, Amanda! Even if Marketo retained the high-volume activities beyond 90 days, Marketo's OOTB Analytics reports might not be best for visually seeing patterns w.r.t. open/click based on the send time. Also, opens and clicks are susceptible to bot activities, but you should be fine with the bot activity filter turned on (i.e., Marketo marking the activities with bot as "Is Bot Activity = True" or by just filtering those by selecting not to log bot activity in the first place). You should export the activities on a rolling basis based on your send volume using Marketo's Bulk Extract APIs (not via the regular APIs, as those can easily eat up your API quota if you have fairly moderate to high email send volumes).

    Terms & ConditionsAccessibility statement

    Loading footer...