Emory Healthcare - KPI Dashboard

​

Built with: Salesforce Marketing Cloud, custom Cloud Pages, SSJS, AMPscript, SQL (Query Activities), and the SFMC REST and SOAP APIs.

​

Salesforce Marketing Cloud does have built in reporting, but it's clunky and not something the team wanted to open every day. So I built a clean, simple dashboard on top of the same data: one screen that shows how their email is actually performing (sends, opens, clicks, bounces, and unsubscribes), rolled up by campaign, category, and service line. Instead of digging through native reports, they get one always current view of the whole program.

​

It runs entirely inside Salesforce Marketing Cloud as a custom Cloud Page. I built the data pipeline behind it: nightly automations aggregate raw send and tracking data into a summary data extension, and a Sync button refreshes the most recent activity on demand. A separate admin page lets the team map campaigns to categories and service lines and manage exclusions, so the rollups stay accurate even as campaign naming changes over time.

​

The hardest part was making the numbers trustworthy at scale. I reworked the nightly refresh to process data in weekly chunks and switched it to an upsert model, which stopped it from double counting and from failing on high volume days. The frontend is a single Cloud Page I designed for a clean, focused UI, rendered with AMPscript and SSJS, with the interactive metrics, filters, and drilldowns built in vanilla JavaScript, CSS, and HTML.

(Image below has sensitive info redacted)