How to Build a CMO Dashboard with Claude Code and First-Party Data

A CMO’s step-by-step walkthrough for building a free, interactive CMO dashboard using Claude Code and first-party data.

Most CMO dashboards are built backwards. They start with whatever vanity data the platforms will give you, Google Ads impressions, LinkedIn CPCs, HubSpot email open rates, and then someone assembles those numbers into a slide deck that gets nodded at for twenty minutes before the CEO asks the one question your deck doesn’t have an answer to: “So where is pipeline actually coming from?”

Marketing teams already have the data to answer that question correctly; it’s just scattered across six systems that have never been asked to talk to each other. What I built is a first-party data dashboard that pulls from sources you actually own, computes the metrics that connect directly to revenue, and doesn’t require a data engineering team to stand up or maintain. The build partner was Claude Code, and the total cost to get a working prototype running was zero.

This post walks through how to build one yourself, step by step. We’ll cover why first-party data produces fundamentally different answers than platform-reported metrics, how to map your owned data sources to executive-level KPIs, the exact Claude Code prompt sequence I used to go from a blank spec to a working…