Skip to content
→Run this on autopilot — free
Workflow · Automation

Turn your Google Ads and Meta Ads performance into a PowerPoint deck with Claude Cowork

Time to first output: 10 minutes to run, once Claude Cowork and GoMarble MCP are connected

Pranshu in ↗

Growth, GoMarble · Updated 2026-09-01 · 7 min read

Try GoMarble free →

What it does?

The prompt pulls 7-day vs previous-7-day Google and Meta performance via GoMarble MCP inside Claude Cowork and turns it directly into a structured PowerPoint presentation — no manual slide-building.

What you need

  • → Google Ads Customer ID
  • → Meta Ads Account ID (act_ID)
  • → Claude Cowork access (the page notes this needs macOS and a Claude Max plan)

First, connect Claude Cowork to GoMarble MCP

GoMarble MCP connects Claude with live Google Ads and Meta Ads data, letting Claude pull real-time performance metrics directly inside Claude Cowork.

1

Sign in and connect your ad accounts

Go to apps.gomarble.ai and log in with your work email, then connect your ad accounts in "Integrations".

2

Go to Claude integrations settings

Go to claude.ai/settings/integrations.

3

Add a custom connector

Click "Add Custom Connector" and enter the details below.

Name

GoMarble AI

URL

https://apps.gomarble.ai/mcp-api/sse

4

You're all set

Save the connector and you're ready to run the reporting prompt in Claude Cowork.

See the Official Claude Cowork Guide (support.claude.com) and GoMarble's detailed walkthrough (gomarble.ai/mcp-thankyou) for more setup detail. This page's own setup instructions link to claude.ai/settings/integrations specifically (Claude Cowork's connector settings).

The prompt

Once GoMarble MCP is connected, open Claude Cowork, paste this prompt, and wait while Claude pulls the data and builds the presentation.

Lead-magnet prompt · free

Use GoMarble MCP to pull Google Ads [CUSTOMER_ID] and Meta Ads [ACT_ID] performance data:

Date range: Last 7 days vs previous 7 days

Breakdown: Campaign → Ad Set/Ad Group → Top Creatives

Metrics: Spend, Impressions, Reach, CPM, Frequency, CTR, CPC, Purchases, Revenue, CPA, ROAS

Include: % change for all metrics

First, confirm the ad accounts are accessible via GoMarble MCP, then pull all required data.

Create a PowerPoint presentation with:

Executive Summary slide — Key wins, concerns, and top-line metrics at a glance

Platform Overview slides — Side-by-side Google Ads vs Meta Ads performance comparison

Campaign Deep-Dive slides — Performance tables by campaign with period-over-period changes

Creative Performance slides — Top and bottom performing creatives with metrics

Efficiency Analysis slide — CPM and CPA trends with visual charts

Fatigue Signals slide — Campaigns/creatives showing high frequency + declining CTR

Recommendations slide — Actionable next steps based on data insights

Highlight throughout:

Best/worst campaigns by ROAS (use color coding: green for winners, red for underperformers)

CPM and CPA efficiency changes (arrows or % badges showing improvement/decline)

Fatigue signals (flag creatives with frequency >3 and CTR dropping >15%)

Design: Clean, data-forward slides with tables, simple charts, and clear callouts. Minimal text, maximum clarity.

Process:

Use GoMarble MCP to list and confirm available ad accounts

Pull performance data from both platforms via GoMarble MCP tools

Calculate period-over-period % changes

Generate the PowerPoint presentation with all slides

What you get back

  • →
    Format: A PowerPoint presentation generated inside Claude Cowork, comparing the last 7 days vs the previous 7 days across Google Ads and Meta Ads. Slides:
    • – Executive Summary
    • – Platform Overview
    • – Campaign Deep-Dive
    • – Creative Performance
    • – Efficiency Analysis
    • – Fatigue Signals
    • – Recommendations
Upgrade

Want this automated?

Run the prompt above every Monday morning automatically. GoMarble Agents don't just deliver the report (Slack / email / in-app) — they can execute the recommended changes directly in your ad account, too. Offload the whole recurring task and stop doing it manually.

Try GoMarble Agents free →

FAQ

Do I need Claude Cowork specifically, or does regular Claude work?
The prompt is written for Claude Cowork's PowerPoint generation; the page notes this setup needs macOS and a Claude Max plan.
What data does the presentation compare?
Google Ads and Meta Ads performance for the last 7 days vs. the previous 7 days, broken down by Campaign → Ad Set/Ad Group → Top Creatives.
What slides does the generated deck include?
Executive Summary, Platform Overview, Campaign Deep-Dive, Creative Performance, Efficiency Analysis, Fatigue Signals, and Recommendations.
How does it flag creative fatigue in the deck?
It flags creatives with frequency above 3 and CTR dropping more than 15%.
What if I don't have macOS or Claude Max?
The page suggests using GoMarble AI directly to generate and schedule marketing reports and presentations across Meta, Google, TikTok, LinkedIn, GA4, and Shopify without this setup.
Does it pull data from platforms beyond Google and Meta Ads?
As written, the prompt only pulls Google Ads and Meta Ads data via GoMarble MCP.
Where can I learn more about Claude Cowork itself?
The official Claude Cowork guide is linked on the page at support.claude.com/en/articles/13345190-getting-started-with-cowork.

Skip the prompt — let GoMarble do this for you.

Sign up, connect your ad accounts, and claude cowork + gomarble presentation runs on every account, every week, automatically.