This resource was originally posted on DEV by LearningCurv Marketing Automation Consultant Ed Gray.
Reporting in Salesforce Marketing Cloud can be challenging for new users. The “reports” available through Analytics Builder are limiting and difficult to work with. But with a little knowledge of SQL and Data Views, creating data tables tailored to a business use case becomes possible.
Below is an example of a report created to track the basic “health” of a business unit: subscriber growth and the number of emails sent, opened, clicked and bounced. It’s completely based upon Marketing Cloud’s Data Views, so the exact same SQL queries should work for any account.
Some queries could be combined or separated depending on the number of records in the business unit—this was developed for a client with more than 1.2 million records and never took more than a few minutes.
Follow the steps below to learn how to go beyond the standard reports provided in Marketing Cloud.