Is there away to schedule a report which contains all the email sends and it has be sent to a particular email ids on weekly basis in marketing cloud

Question

I need help to create report for all the journeys which we have triggered and this report has to be mailed to a particular set of email ids automatically on weekly basis. Is there a way.. pls guide.

How I used to do till now:

I used to manually generate "Journey Builder Email Send Summary" report under Analytics Builder -> Report and take data from this report and put it in excel in an easily readable format and send this.

Can this be automated to get all the email sends report and send.

Please assist.

Answer 1

This is something you can achieve if you have Intelligence Reports for Engagement (formerly Marketing Cloud Datorama Reports).

Intelligence Reports for Engagement—This standard version is included in Pro editions and higher.

Go to Analytics Builder > Intelligence Reports > Reports tab > Create report.

Select the columns needed. Here is an example based on your comment:

For information:

There are two types of data elements available: dimensions and measurements.

Dimensions: Qualitative, non-numerical data (data you can’t count) like, campaign name, campaign ID, and so on.

Measurements: Quantitative, numerical data (data you can count) like, number of clicks, emails opened, and so on.

Once done with this part, you can move on to the scheduling. You can mail this report to a list of emails on a weekly basis.

You can play with many parameters as you can see in the images, like choosing the Time period, selecting which day of the week to mail the report as well as the delivery hour,...

Resources:

• https://help.salesforce.com/s/articleView?id=sf.mc_dat_datorama_reports.htm&type=5
• https://trailhead.salesforce.com/content/learn/modules/datorama-reports-for-marketing-cloud/get-to-know-datorama-reports-for-marketing-cloud?trail_id=measure-your-marketing-impact