Email sent, opened, and click totals by email send date filtered by Lists
resolver
I'm looking to create a report to show emails sent, opened, and click totals by email send date and also using the email list as another filter. How can I do this in the custom reporting?
I'm not sure how exactly you need this report to be structured or how you'll be using it, but I have some thoughts on a custom report structure that will hopefully get you started!
You can try creating a custom report for contacts, marketing email, and marketing email analytics:
You can then add filters for the marketing email send date and the contact list membership to pull in emails sent within a specific timeline and contacts within specific lists. I think this may be the most helpful to build out in a table format, broken out by marketing email, with displayed properties like these:
There is a Report Total row at the end up the table, so that will hopefully give you the aggregated email performance metrics you're after!
Just in case it's helpful, you could also consider creating a contact report, with the needed list membership filter applied, and then pull in "Last marketing email click date," "Recent sales email clicked date," and the like to get a sense for how recently email engagement is occurring for a particular list.
I'm not sure how exactly you need this report to be structured or how you'll be using it, but I have some thoughts on a custom report structure that will hopefully get you started!
You can try creating a custom report for contacts, marketing email, and marketing email analytics:
You can then add filters for the marketing email send date and the contact list membership to pull in emails sent within a specific timeline and contacts within specific lists. I think this may be the most helpful to build out in a table format, broken out by marketing email, with displayed properties like these:
There is a Report Total row at the end up the table, so that will hopefully give you the aggregated email performance metrics you're after!
Just in case it's helpful, you could also consider creating a contact report, with the needed list membership filter applied, and then pull in "Last marketing email click date," "Recent sales email clicked date," and the like to get a sense for how recently email engagement is occurring for a particular list.