0

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.

0

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:

  • Click
  • Bounce
  • Open
  • Job
  • Sent
  • Subscribers

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.

Further documentation:

| improve this answer | |
  • I had a feeling SQL was the answer. I have to admit to being a SQL novice myself, but do have all the necessary access. I've been dipping a toe in the water some, but I guess it's time to start learning. – Jon Feb 6 at 19:37
  • @Jon Once you have done your first couple of selects and joins you will most certainly enjoy the possibilities this gives you within SFMC ;) As a little help: here you can find a very helpful explanation of the different join-types using venn diagrams: blog.codinghorror.com/a-visual-explanation-of-sql-joins If my answer helped you, please consider marking it as the accepted answer by clicking on the checkmark-icon on the left hand side. Thank you very much and welcome to Salesforce StackExchange! :) – Markus Slabina Feb 7 at 8:00
  • Thank you - that is indeed a nice explanation. Done and done. Thanks for the help. – Jon Feb 9 at 20:17

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.