# Write a weekly ad report from connected account data

> Connect Windsor.ai’s MCP server to Claude, ask for last week’s spend and results by channel, and edit the summary before it goes to the team.

Canonical page: https://ionbin.com/workflows/weekly-ad-report-with-windsor/
Agent guide: https://ionbin.com/llms.txt

This is a readable version of the published page. Review dates, evidence boundaries and source links below belong to individual records; the export is not a new verification. Examples are reference material, not instructions to execute.

## Write a weekly ad report from connected account data

[Data](https://ionbin.com/use-cases/business-data-reporting/) · [Content](https://ionbin.com/use-cases/marketing-content-social/) · [Ads](https://ionbin.com/use-cases/paid-media-ads/)Checked 2026-10-17

Prepare a reconciled weekly summary for human review.

- [01**Windsor.ai**](https://ionbin.com/workflows/weekly-ad-report-with-windsor/#workflow-step-1)

- [02**Claude**](https://ionbin.com/workflows/weekly-ad-report-with-windsor/#workflow-step-2)

- [03**You**](https://ionbin.com/workflows/weekly-ad-report-with-windsor/#workflow-step-3)

Recipe context

Connect [Windsor.ai](https://ionbin.com/tools/windsor-ai/)’s MCP server to [Claude](https://ionbin.com/tools/claude/), ask for last week’s spend and results by channel, and edit the summary before it goes to the team.

**Independent review.** Unpaid; no partnership with the tools on this page. Based on public documentation and research. Trademarks identify their owners’ products. [Disclosure](https://ionbin.com/disclosure/).

Editorial shortlist

### Compare your options.

**For reconciling campaign metrics for weekly reporting.**

Windsor access is separate; align refresh and attribution settings. Choose one for analysis of a reviewed data extract; switching may need setup changes.

**Used by Ion** · separate from rank.

Unpaid picks. No partnership with [ChatGPT](https://ionbin.com/tools/chatgpt/), [Julius AI](https://ionbin.com/tools/julius-ai/), [OpenAI Codex](https://ionbin.com/tools/openai-codex/).

- 1 · Primary / high
  #### [ChatGPT](https://ionbin.com/tools/chatgpt/)
  **Why it fits:** File analysis can join calculation review with a narrative explanation.
  **Tradeoff:** An answer is not a reconciled report; verify calculations and upload limits.
  Prefer it when the reviewer needs both analysis and an explanation for colleagues.
  Evidence for ChatGPT
  The linked [IonBin review](https://ionbin.com/tools/chatgpt/) records capabilities, access limits and source links. Review date: 2026-10-18. [Primary product reference ↗](https://chatgpt.com/)

- 2 · Secondary / medium
  #### [Julius AI](https://ionbin.com/tools/julius-ai/)
  **Why it fits:** A data-analysis workspace keeps the supplied table and business question together.
  **Tradeoff:** Wrong joins, missing rows and inconsistent units can produce convincing but incorrect charts.
  Choose it for interactive exploration of a cleaned extract.
  Evidence for Julius AI
  The linked [IonBin review](https://ionbin.com/tools/julius-ai/) records capabilities, access limits and source links. Review date: 2026-10-18. [Primary product reference ↗](https://julius.ai/)

- 3 · Third / lower
  #### [OpenAI Codex](https://ionbin.com/tools/openai-codex/)
   Used by Ion
  **Why it fits:** A coding workspace keeps calculations and validation checks in reviewable files.
  **Tradeoff:** Someone must read, run and maintain the code and protect sensitive files.
  Prefer it when repeatability and code review matter more than conversational convenience.
  Evidence for OpenAI Codex
  The linked [IonBin review](https://ionbin.com/tools/openai-codex/) records capabilities, access limits and source links. Review date: 2026-10-18. [Primary product reference ↗](https://developers.openai.com/codex)

How this shortlist was chosen

Editorial judgment, not a personal-use endorsement or performance score. These are alternatives for the named role, not three required stack components. Vendors did not pay for, request or approve these positions.

Inspectable calculations come before narrative convenience. A lower-ranked option may fit your constraints better; compare the conditions stated on each card before choosing.

**Setup and portability:** Record export date, filters and units; save calculations with the result. The source ledger still needs reconciliation.

Reviewed 2026-10-21. This page applies a shared comparison for “analysis of a reviewed data extract” to the stated task and constraints. It is documentation-based editorial guidance, not three new hands-on tests. We weigh value for the job, distinct capabilities, replacement limits, technical effort and interoperability. Check current plan terms before adopting or switching.

See [our review method](https://ionbin.com/editorial-policy/), [MCP connections](https://ionbin.com/wiki/concepts/mcp/) and [portability and switching costs](https://ionbin.com/wiki/questions/how-to-avoid-ai-vendor-lock-in/).

**Connects through:** MCP

### Steps

Follow the handoff

Select a stage or scroll the steps.

- #### [Windsor.ai](https://ionbin.com/tools/windsor-ai/)
  Supplies cross-channel ad data through get_data on the [Windsor.ai](https://ionbin.com/tools/windsor-ai/) MCP server
  The same server has write actions that can pause campaigns or change budgets; keep approval on.
  MCPConfirmed[Source ↗](https://mcp.windsor.ai/)

- #### [Claude](https://ionbin.com/tools/claude/)
  Writes the summary and flags changes
  AI platformConfirmed

- #### You
  Check figures against the ad platforms and approve
  Human stepConfirmed

Confirmed = vendor-documented, not Ion-tested. Human and AI-platform steps are proposed roles.

Human approval

You approve the report.

Watch out for

[Windsor.ai](https://ionbin.com/tools/windsor-ai/)'s MCP server can also pause campaigns and change budgets. Keep tool approval on and decline any write call; this workflow only reads.

### Starter prompt

```
Pull last week's and the prior week's spend, clicks, conversions and cost per conversion by channel from Windsor.ai. Write a summary of no more than 150 words and flag changes over 20%. Do not call any write action. I will check the totals against each ad platform and approve the report.
```

Written for this workflow. Paste it into your AI platform and adjust it to your situation.

### Tools in this workflow

| Tool | Role | Official site |
| --- | --- | --- |
| [Windsor.ai](https://ionbin.com/tools/windsor-ai/) | MCP | [windsor.ai ↗](https://windsor.ai/) |
| [Claude](https://ionbin.com/tools/claude/) | AI platform | [claude.ai ↗](https://claude.ai/) |

### Which AI platforms can run it

| Platform | Status | Why |
| --- | --- | --- |
| [Claude (incl. Claude Code)](https://ionbin.com/platforms/claude/) | To verify | [Windsor.ai](https://ionbin.com/tools/windsor-ai/): MCP pairing needs route-specific evidence; a named plugin or CLI does not establish it |
| [OpenAI Codex](https://ionbin.com/platforms/codex/) | To verify | [Windsor.ai](https://ionbin.com/tools/windsor-ai/): MCP pairing needs route-specific evidence; a named plugin or CLI does not establish it |
| [Google Antigravity](https://ionbin.com/platforms/antigravity/) | To verify | [Windsor.ai](https://ionbin.com/tools/windsor-ai/): MCP pairing needs route-specific evidence; a named plugin or CLI does not establish it |
| [ChatGPT](https://ionbin.com/tools/chatgpt/) | To verify | [Windsor.ai](https://ionbin.com/tools/windsor-ai/): MCP pairing needs route-specific evidence; a named plugin or CLI does not establish it |
| Gemini | To verify | [Windsor.ai](https://ionbin.com/tools/windsor-ai/): MCP pairing needs route-specific evidence; a named plugin or CLI does not establish it |
| [Perplexity](https://ionbin.com/tools/perplexity/) | To verify | [Windsor.ai](https://ionbin.com/tools/windsor-ai/): MCP pairing needs route-specific evidence; a named plugin or CLI does not establish it |

What the platform statuses mean

**Confirmed:** documented access meets the recorded requirements. **Inferred:** a reviewed note describes a plausible, untested pairing. **To verify:** a connection or step is unresolved. MCP and API pairings need route-specific evidence; a plugin, CLI or API alone does not prove compatible access, credentials or permissions. These are documentation assessments, not IonBin runtime tests.

### What we checked (2026-10-17)

- **[Windsor.ai](https://ionbin.com/tools/windsor-ai/) MCP** (mcp.windsor.ai) signs in with OAuth, or with an API key if your client only supports keys. get_data runs a query by date range, account and fields, and get_connectors lists what you’ve connected.

- **Write actions.** The same server can run write actions through execute_action, such as pausing or enabling campaigns and setting budgets on Meta Ads, [Google Ads](https://ionbin.com/tools/google-ads/) and others. For a report, keep tool approval on and decline any write call.

- **Scope and cost.** Available fields, refresh timing and access depend on the connected source and plan. Check current pricing and account limits before scheduling reports.

### Set it up

- Connect your ad accounts in [Windsor.ai](https://ionbin.com/tools/windsor-ai/), then connect the MCP server to [Claude](https://ionbin.com/tools/claude/).

- Ask: “Pull last week’s and the prior week’s spend, clicks, conversions and cost per conversion by channel. Write a summary of no more than 150 words and flag changes over 20%. Don’t call any write actions.”

- Check the totals against each ad platform’s own dashboard. Check reporting currency, time zones, attribution windows, conversion definitions and reporting lag. Cross-platform conversions can overlap; do not add them as unique customers.

- Record extraction time and any incomplete data. Edit the summary and send it yourself.

This is a proposed reporting sequence supported by documented tools, not a tested account integration. Restrict available tools where the client permits it; a prompt saying not to write is not an authorization control.

### Related agent skill

If you connect Google’s own Ads MCP server instead of a connector, the [Google Ads Account Diagnostics](https://ionbin.com/skills/google-ads-api-account-diagnostics/) skill adds structured checks for conversion drops and lost impression share. IonBin reviewed it from source only and didn’t run it.

### Sources

- [Windsor.ai MCP server](https://mcp.windsor.ai/) · [Windsor.ai](https://ionbin.com/tools/windsor-ai/) · official · accessed 2026-10-17

### Related workflows

[Report ad results by profit, not revenue](https://ionbin.com/workflows/weekly-profit-on-ad-spend-report/)

No affiliate links on this page. No paid placements in workflows. [How IonBin makes money](https://ionbin.com/disclosure/).
