Back to prompt library
Analytics

Meta Ads MCP Monday Morning Report

Pull yesterday's spend, ROAS, and CTR for every active campaign and flag anything underperforming versus the 7-day average. Designed for use with the Meta Ads MCP connector in Claude or ChatGPT.

Works best with: Claude / ChatGPT (via Meta Ads MCP connector)

The prompt

prompt.txt
Using the official Meta Ads MCP connector with read-only reporting access, pull yesterday's spend, ROAS and CTR for every active campaign in my Meta Ads account. Flag anything that is down more than [THRESHOLD]% from the 7-day average. For each flagged campaign, include: (1) the metric that dropped, (2) the percentage change, (3) plausible contributing factors from the available data, and (4) the additional check needed before acting. Sort results by spend descending. Do not create, edit, pause, or publish anything.

Variables to replace

Replace the bracketed placeholders with your specific information before running the prompt.

[THRESHOLD]Replace with your threshold

When to use this prompt

Running a weekly performance audit across all active Meta campaigns using the Meta Ads MCP connector. Replaces manual Ads Manager navigation for the Monday morning check-in.

Put this prompt to work

Run it inside a repeatable workflow

Pair this reporting prompt with the workflow that automates the recurring review.

See the AI Reporting Workflow

Tags

Meta AdsMCPAnalyticsReportingCampaign Performance