Client Report + Deck Generator

Automated client reporting with KPI narratives and deck-ready slide outlines.

Stop spending hours pulling numbers from Ads Manager and formatting slides. This skill pulls live performance data via Glued MCP, builds a narrative around what happened and why, and outputs a structured deck outline — ready for your next client call or QBR.

---

What it does

1. Resolve workspace — Identifies the target Meta ad account via Glued MCP's list_workspaces tool.

1. Pull KPI snapshot — Calls get_workspace_dashboard for account-level performance metrics for the selected date range.

1. Pull campaign and creative breakdowns — Uses query_ad_report for campaign-level detail and get_top_assets for top-performing creatives.

1. Build narrative — Generates a structured analysis: what happened, why it happened, and what changes next period.

1. Build deck outline — Creates explicit slide objectives and content structure for presentation use.

1. Export (optional) — Pushes to Google Slides and stores artifacts on Google Drive if connectors are available.

---

Output

output/
├── report.md          # Full narrative report with KPI scorecard and recommendations

├── report.json        # Structured data for programmatic consumption

└── deck_outline.md    # Slide-by-slide outline with objectives (if format=deck)

---

What the analysis actually looks like

Each report includes:

• Executive summary — 3-bullet overview for stakeholders who won't read further
• KPI scorecard — Current period vs prior period comparison
• Top positive drivers — What's working and why
• Top negative drivers — What's underperforming and root causes
• Creative and LP learnings — Which creatives and landing pages are performing
• Next-period action plan — Specific recommendations tied to owner and target date

---

What this replaces

Before	After
Manually pulling metrics from Ads Manager	Automated KPI snapshot via Glued MCP
Spreadsheet math for period-over-period comparisons	Built-in consistent comparison windows
Writing narrative commentary from scratch each week	AI-generated narrative tied to actual data
Formatting slides by hand	Deck outline with explicit slide objectives
Forgetting attribution lag caveats	Automatic lag and delayed conversion warnings
Generic recommendations	Specific, owner-assigned action items with target dates

---

Who this is for

• Agency account managers who need consistent, professional client reports every week without the manual grind
• Performance marketers who want data-driven narratives instead of raw metrics dumps
• Marketing directors preparing QBR decks who need structured slide outlines fast
• Freelance media buyers who want to deliver agency-quality reports to clients

---

Requirements

Requirement	Details
Glued MCP	Connected Meta ad account with workspace access
Claude Code	Runtime environment (also compatible with Codex)
Google Slides API (optional)	For automatic deck export
Google Drive (optional)	For storing report artifacts

No API keys or environment variables required — all data access goes through Glued MCP tools.

---

Skill structure

client-report-deck-generator/
├── SKILL.md    # Skill definition with procedure, narrative structure, and guardrails

└── README.md   # This file

---

How it works under the hood

Single-agent skill using three Glued MCP tools:

MCP Tool	Purpose
list_workspaces	Resolve workspace ID if not provided
get_workspace_dashboard	Pull account-level KPI snapshot
query_ad_report	Get campaign and creative breakdowns
get_top_assets	Identify top-performing creatives

Date ranges supported: last_7_days, last_30_days, this_month, last_month

Output formats: deck (includes slide outline) or doc (report only)

Guardrails: Avoids overclaiming causality. Adds attribution lag caveats. Ties every recommendation to a specific owner and target date.

---

For agency teams and media buyers who want client-ready reports in minutes, not hours.