0

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

1
  • 1
    Unfortunately, campaign/tags information is not available via Query. You can try Tracking extract. It does have a Campaign ID attribute that might be of help
    – Maneesh
    Feb 7, 2019 at 3:47

1 Answer 1

2

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'.

enter image description here

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.

4
  • Where do you find this "view" i haven't seen this inside the marketing cloud. Is this inside the marketing cloud? Feb 7, 2019 at 8:02
  • 1
    Yes this is in Marketing Cloud. You can find it in Analytics Builder->Reports. Under Report categories in the Overview page, you will find 'Discover' option. Under that you can opt for 'Blank Template for Email Sending Performance' report.
    – Krati Garg
    Feb 7, 2019 at 10:19
  • FYI for others: You need to setup discovers which takes up to 24h and after that this options (might) become usable. Feb 7, 2019 at 10:23
  • Thanks for that, i dont know how i missed it. Was using reports just kept missing the Campaign name field
    – Andyw
    Feb 7, 2019 at 22:51

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.