Home / Work / Merchandise and e-commerce Play the video / 2:37

The analytics portal that says when it was last updated

Mission Control, the analytics portal Manhead Merchandise's leadership uses every day: touring, web store, and retail and licensing revenue on one screen, on live data.

The problem

Manhead sells in three places: at the merch table on tour, on its Shopify web stores, and through retail and licensing deals. That is three revenue streams in three systems.

Leadership was reading all of it in spreadsheets. They needed one screen they could trust, and trust means knowing when the numbers were last updated and where each one came from.

What I built

Three dashboards. E-commerce: a tile per warehouse with unfulfilled and pre-order counts, sales, refunds and shipping protection, top countries and top items by artist, with 15 drill-down reports behind it, each exporting to Excel.

Touring, from the point-of-sale system the crews use at every show: gross, dollars per head, sales by category, top sellers, and top markets ranked two ways, by per-head spend and by show gross, with PDF export and a monthly report. Finance: every stream month to date and year to date against the same period last year, with the forecast laid over it, and top artists by stream.

Touring syncs every 30 minutes, web store sales and unfulfilled orders every 15, and the screens show when each last synced; sync errors go to Sentry. Retail and licensing come from accounting's quarterly royalty workbooks with guards: a quarter 90% or more identical to the one before is refused, a tab with no usable rows is skipped, and the web store slice is excluded so sales are never counted twice.

New accounts wait for approval, each dashboard is switched on per person, and tour and store managers see only their own artists or stores.

What happened

Live for years and used by leadership every day. It is one of 11 live systems I run for Manhead today.

The numbers
What this proves

A multi-source analytics portal people trust, because every screen says when it was last updated.

Built with

Same problem?Send it over.

Email Eugene

Questions on this one? Reply in the thread and I'll walk you through it live.

More work

All work
Eugene Leychenko / usethefutureWant the walkthrough? Email Eugene.