Case 2 · Executive BI at Black Clover
One number leadership can trust
The measurement only matters if leadership reads the same number. I built the pipelines, the warehouse move, the real-time MER dashboards, and the executive reporting under it.
Head of Business Intelligence & Performance Marketing · Black Clover · Feb 2025 – present
martysmithson04@gmail.comLinkedIn (opens in a new tab)Resume PDFMcfly Analytics Shopify App (opens in a new tab)
Pipelines
SQL/ETL pipelines integrate the ad platforms with Oracle NetSuite, so spend and sales meet in one place.
Warehouse
I replaced Domo with Google Cloud Run at a fraction of the cost. Same warehouse work.
Access
Identity is fail-closed: the field can read the number and cannot rewrite it. A Cloud Run partner portal serves executives, rep leads, and reps on live NetSuite with tiered access.
The read
Real-time MER dashboards and executive reporting that unifies paid and organic KPIs into a single source of truth for leadership.
Why the plumbing is part of measurement
A mix model or a geo test is only as good as the sales and spend it reads. Getting ad-platform data and NetSuite into the same pipeline is what lets cash MER be a number, not a debate.
Moving off Domo
I moved the warehouse work from Domo to Google Cloud Run. The work stayed the same; the cost dropped to a small fraction of what it was.
Who sees which number
The partner portal runs on Cloud Run against live NetSuite. Executives, rep leads, and reps each get tiered access. Identity is fail-closed, so people can read the number they are allowed to see and cannot rewrite it.
The executive read
Real-time MER dashboards put spend next to cash so overspend shows up while it can still be fixed, and the dashboards reduced spend leakage. Executive reporting brings paid and organic KPIs into one source of truth, so leadership argues about the decision instead of the data.
No internal system names, figures, or screenshots from Black Clover appear here. The MER demo is synthetic.
Related