Emory Healthcare - Custom-Built SFMC Calendar

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

I built an internal calendar app that gives the marketing team a single view of every email and journey going out across the health system. Before this, there was no easy way to see what was scheduled, what overlapped, or which patients were getting hit by multiple campaigns at once. Now it all lives on one screen.

It runs entirely inside Salesforce Marketing Cloud as a custom Cloud Page. I designed the whole data pipeline: nightly automations pull journey and campaign data into cached data extensions, and a one click Sync refreshes it on demand. A separate admin page lets the team control how everything displays (service lines, color coding, categories, manual campaigns, exclusions) without touching any code.

The most interesting part was the overlap and saturation logic: figuring out, across thousands of sends, which patients were receiving too many messages in a given window, and surfacing that clearly on the calendar. I also wired in campaign metrics, so the team can click any day and see how a campaign actually performed on opens, clicks, and sends.