E-commerce data pipeline

The brand's email, website and ad numbers sat in separate tools, and every weekly figure was a manual export. The goal: one set of numbers leadership trusts, ready every morning.

One central store for the brand's email, website and ad data, refreshed every night.

Written briefings on top of it: daily and weekly for the CEO, weekly for the COO, plus an assistant that answers questions from the same numbers.

A freshness check, so every briefing says when its data is out of date instead of quietly showing old numbers.

Delivered in May 2026: one set of numbers the leadership team reads every morning.

While checking the figures, I found $104K of revenue that an old report had been leaving out.

I designed and built it alone. The client's team owned the accounts and the database administration.