The ads dashboard that updates itself with Claude, Quentin IA Marketing

Claude + Marpipe = an ads dashboard that runs itself

Marpipe MCP is the bridge that lets Claude pull data from your ad accounts (Meta, Google Ads, GA4, TikTok). Once it's connected, you describe the dashboard you want in plain English, and Claude codes it as a live artifact — animated, with a date selector and a shareable public URL.

No Looker Studio, no Supermetrics connector to pay for, no copy-pasting numbers into a Google Sheet. You ask the question, Claude fetches, codes, and publishes.

Claude AI Lab

The Claude AI Lab is my Skool community where I share my Claude systems and the more advanced modules. Entry is free.

Join the Lab →

5 min

full setup

prompt to generate the dashboard

URL

public, shareable with the client

In practice, in a single conversation you get animated scorecards (CPM, CTR, ROAS, leads), daily charts, tables by placement / audience / device, a 7d / 14d / 30d date selector, and a public link to send the client instead of your slides.

The thing to understand

The free Marpipe account is enough to get started. No credit card. The connection to Claude happens over OAuth, in 2 clicks, and you can hook up as many ad accounts as you want.

Connect Marpipe to Claude

🔗 marpipe.com

⚙️5 steps to connect Marpipe to Claude

Create your free Marpipe account. Head to marpipe.com and create an account. The free plan is enough to get started and connect your first ad accounts.

Connect your ad accounts. In Marpipe, go to the Connections tab. Connect Meta, Google Ads, GA4 or TikTok via OAuth. It's secure — Marpipe only reads the data, it can't change anything.

Generate your Marpipe MCP server. Still in Marpipe, go to the MCP tab, click New MCP server, and give it a name (e.g. Claude). You get an endpoint URL and a token to hand to Claude.

Connect Marpipe to Claude. On claude.ai, click Settings → Connectors → Add custom connector. Fill in — Name: Marpipe, Server URL: the endpoint you got from Marpipe, Authentication: OAuth (or token, depending on the Marpipe option).

Authorize and switch to "Always allow". Claude redirects you to the Marpipe page to authorize. Once authorized, go back to Settings → Connectors, click Configure next to Marpipe, and set the permissions to Always allow. Claude can then call Marpipe without asking you every time.

Check that it works

Ask Claude: "List my Meta ad accounts via Marpipe MCP." If it returns a real list, you're good. You can move on to the dashboard prompt.

4 copy-paste prompts for your dashboard

📋Prompt 01 · The base dashboard — generate a full Meta Ads dashboard

"Create a dashboard as a live artifact for my Meta Ads account [ACCOUNT NAME]. Fetch the data via Marpipe MCP for 3 date ranges: last 7 days, last 14 days, last 30 days. Hardcode all the data into the dashboard. Layout: a date selector at the top, 6 scorecards (CPM, CTR, CPC, ROAS, leads, spend), a daily bar chart, and 3 breakdown tables (placement, age, audience). Look and feel: black background, orange accents, clean and minimal design."

🎨Prompt 02 · Quick customization — change the colors or add your branding

"Take the dashboard. Change the orange accents to electric blue (#2563eb), dark gray background (#0f172a), white text. Add my logo top left: [LOGO URL]."

🔀Prompt 03 · Multi-platform — add Google Ads with a toggle

"Add Google Ads to the dashboard. Fetch the data for the [GOOGLE ADS ACCOUNT NAME] account via Marpipe MCP, same date ranges. Add a toggle top right to switch between Meta and Google Ads. The scorecards and charts should adapt accordingly."

🔗Prompt 04 · Client sharing — publish and send the link

"Publish this dashboard as a public artifact. Give me the URL and a short 3-line paragraph in English to send to the client with context on the key numbers from the last 30 days."

Claude + Marpipe = an ads dashboard that runs itself

Connect Marpipe to Claude

4 copy-paste prompts for your dashboard

Want to go further?