Is there a way to build a report showing basic email metrics (email name, subject, open rates, clicks, etc.) along with the From Name used for each email?
Nothing in the reports catalog seems to offer this, nor does Discover.
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.Sign up to join this community
You can build a custom report using Automation Studio and SQL activities. The required data can be gathered from the Marketing Cloud Data views. The most relevant data views for you might be:
Regarding your specific request for the "FromName", this is one of the columns present on the Data View: Job.
In order to have the report as CSV file, you can use the data extension data extract activity in Automation Studio. If this isn't already provisioned, you need to open a support case and ask for it's activation. You can then download the file from the enhanced FTP or use the AMPscript function
AttachFile in order to send the report via email.