Is it possible to write a SQL Query to extract send data that includes Tags and/or Campaign names

Question

We are trying to do some reporting based on emails with specific tags or associated to specific campaigns over the past 12 months. I have tired to use the Analytics builder > Reports to get the data however there doesn't seam to be a option to add a tag or campaign column.

We need Email Name, Email Subject, Send Year, Send Month, Sends and either campaign name or tag. I assume tag would be harder as you could have multiple unless you restrict to tag = "specific name".

So as the data cant be gained via the Reports dashboard, i wondered if anyone has done it via a SQL query or is this data not obtainable?

Thanks Andy

Answer 1

You can create a custom report to achieve this. You need to select 'Discover' from report category and search for 'Blank Template for Email Sending Performance'.

Here you can drag and drop the campaign name, email name, send month and send year in 'Rows'.

You can schedule this report to be delivered to your email ID or FTP location or can be downloaded too as per your requirement.

Please note that you might not find this type of report in your marketing cloud instance. In that case, you can raise a support ticket and they can get it enabled for you.

Answer 2

Discover has been retired. Use Intelligence reports to track through campaign.

https://help.salesforce.com/s/articleView?id=sf.mc_rn_january_2021_discover_reports_retires.htm&type=5