Back to Portfolio
Custom PHP Application · Internal Tool

NEXUS

A unified marketing intelligence platform that pulls six data sources into one dashboard — built to replace spreadsheet pulls and platform-hopping with a single weekly source of truth.

The Problem

Every week, the marketing team at Jekyll+Hyde Labs needed to review performance across podcasts, email, social, and web — but the data lived in six different platforms. Getting a complete picture meant opening GA4, YouTube, Mailchimp, Blubrry, Libsyn, and LinkedIn separately, pulling numbers manually, and either keeping it all in your head or dumping it into a spreadsheet.

The process was slow, error-prone, and made it nearly impossible to spot patterns across channels. Good insights were getting lost because the data was too fragmented to review together.

What It Does

NEXUS aggregates live data from all six platforms into a single dashboard, purpose-built for the weekly internal marketing meeting. The team opens one screen and immediately sees how recently published assets are performing — podcast downloads, email open rates, site traffic, video views, and LinkedIn engagement — all in one place.

A cross-channel view overlays data from all sources on a shared timeline with adjustable date ranges (30, 60, or 90 days), making it easy to benchmark current performance against past periods and spot correlations across channels — why a podcast title drove a traffic spike, why an email subject line outperformed, or which content formats are gaining momentum.

The team brings AI into the weekly meeting to analyze what the dashboard surfaces — turning raw cross-channel data into actionable discussion rather than a numbers readout. NEXUS remains in active use and continues to evolve as the team's data needs grow.

NEXUS cross-channel dashboard view
GA4 YouTube Mailchimp Blubrry Libsyn LinkedIn

How It's Built

NEXUS is a custom PHP application (v1.4.7) deployed on Laravel Forge. GA4, Mailchimp, YouTube, and Blubrry connect via live REST APIs with a caching layer to keep the dashboard responsive — GA4 and Mailchimp cache for 5 minutes, YouTube for 12 hours. LinkedIn data is uploaded as a JSON export, and Libsyn historical data is imported via CSV, keeping the platform flexible for sources that don't expose a real-time API.

Each platform has its own dedicated client class handling authentication, data fetching, and normalization. A cross-channel view ties everything together, merging timeseries data across all sources into a single unified display.

Backend Custom PHP
Hosting Laravel Forge
Live APIs GA4, YouTube, Mailchimp, Blubrry
File Imports LinkedIn (JSON), Libsyn (CSV)
NEXUS overview dashboard NEXUS platform detail view

Outcome

What used to require manual data pulls across six platforms — or live tab-switching during a meeting — now runs off a single screen. The weekly marketing meeting is faster, more focused, and grounded in a complete picture of performance rather than whatever someone managed to pull together beforehand.

Having all channel data in one place has changed how the team discusses performance — patterns that were invisible when data lived in separate platforms are now obvious on a shared timeline. NEXUS remains an active internal tool and continues to grow as new data needs emerge.