One of the most common questions email marketers want an answer to is “What day of the week should I be sending my email?” If your email program has been running for a bit and you’d like to start investigating that data, here’s how you can get that information with your Salesforce Integration. This solution is for orgs that are connected Sales or Service Cloud and all work is done within Sales/Service Cloud. This solution is especially helpful if your Marketing Cloud does not have Discover reports enabled.
Create a custom field
The first step in this process is creating a formula field to store your data. You’ll need to create this text field on the Individual Email Results custom object. You can name this “Day of Send” or “Day of Week” or whatever makes the most sense to you.
Your formula should look like this:
CASE(MOD( DATEVALUE( et4ae5__DateSent__c ) – DATE(1900, 1, 7), 7),
0, “Sunday”,
1, “Monday”,
2, “Tuesday”,
3, “Wednesday”,
4, “Thursday”,
5, “Friday”,
6, “Saturday”,
NULL)
Create custom reports
Once you’ve created your Day of the Week field, you can start using this field in custom reports that use the individual email result object. Using groups and summaries, you’ll have new capabilities to report on how your different emails perform on different days of the week.