Build a marketing dashboard with Claude Code and BigQuery

In this series, our CEO builds, end to end, a digital marketing dashboard that consolidates Meta Ads, Google Ads, Pinterest Ads and Google Analytics 4: spend comes from the platforms, revenue and purchases from GA4, and attribution gets resolved by crossing UTMs.

The full stack: Detrics feeds BigQuery with each platform’s raw data, Claude Code creates the master table that consolidates everything, builds the dashboard (Next.js, Tailwind, Recharts) and deploys it on Vercel. The code lives in a public repo so you can clone it and start from there.

What you’ll have when you finish

• Your ad platforms’ and GA4’s raw data synced to BigQuery with Detrics.
• A master table consolidating spend, purchases and revenue with real attribution via UTMs.
• Your own web dashboard, built and modified by prompting Claude Code.
• The live deployment on Vercel, with the data always fresh.

What you need

• A Detrics account with your sources connected.
• A Google Cloud project with billing enabled.
• Claude Code with the BigQuery MCP configured.

Video links

• Demo dashboard (the end result): dashboard-demo-playground.vercel.app
• Dashboard code: github.com/detrics/dashboard-marketing-digital-bigquery
• Guide to connect BigQuery to Claude: support.detrics.io/bigquery/connect-to-claude
• Detrics: app.detrics.io

You can watch the full video straight through, or go chapter by chapter: each one has its summary, the transcript and the prompts used in the video.