Claude Prompts for Meta Ads Reporting and Analysis

Once you’ve connected Meta Ads to Claude (see: How to Connect Meta Ads to Claude), you can ask about your campaigns in plain language and get answers grounded in your real account data, not generic advice. The prompts below show how agencies, B2B marketers, and e-commerce teams use Windsor MCP to extract insights that used to require SQL queries or manual spreadsheet work.

🤖 For more advanced prompt ideas across Meta Ads and other data sources, browse the full Windsor AI Prompt Library.

Are you an agency? Use Claude for multi-account analysis and client reporting

Managing multiple Meta Ads accounts means juggling logins, exports, and client reports. Windsor MCP lets you analyze performance across every account you manage from a single Claude conversation.

Create a weekly client performance summary

Create a weekly performance summary for each Meta Ads account.
Include spend, conversions, CPA, ROAS, and highlight the biggest performance changes vs last week.
Add a short explanation of what likely caused the change.

Identify underperforming campaigns across accounts

Across all connected Meta Ads accounts, list campaigns where CPA increased by more than 25% in the last 14 days.
Explain possible causes and recommend optimization actions.

Get budget reallocation recommendations

Analyze campaign-level ROAS across all accounts for the last 30 days.
Suggest how to reallocate budgets to maximize overall return on ad spend.
Highlight campaigns that should receive more budget.

Perform multi-account benchmarking

Compare Meta Ads performance across all accounts by industry segment.
Which accounts have the lowest CPA and highest ROAS?
Identify patterns in targeting, creatives, or placements that might explain the differences.

Identify creative fatigue

Analyze my Meta Ads by 'Frequency' and 'CTR' for the last 14 days. List any ads where frequency is above 3.0 but CTR has dropped by 20% compared to the previous week.

Are you a B2B marketer? Estimate cost per qualified lead and pipeline impact

For B2B teams, Meta Ads performance isn’t measured in clicks or even conversions. It’s measured in qualified leads, opportunities, and closed revenue. When Windsor combines Meta Ads with CRM data from HubSpot or Salesforce, Claude can analyze the full funnel.

Calculate cost per qualified lead

Using CRM data, calculate the cost per qualified lead by Meta Ads campaign for the last 30 days.
Identify campaigns producing the highest number of qualified leads.

Analyze pipeline attribution

Match Meta Ads campaign data with CRM opportunities using UTM parameters.
Which campaigns generated the highest total pipeline value?

Evaluate lead quality

Compare Meta Ads campaigns by lead-to-opportunity conversion rate.
Which campaigns generate the highest quality leads?

Analyze sales cycles

Analyze whether leads generated from Meta Ads close faster or slower than leads from other channels.
Break down results by campaign.

Are you an e-commerce marketer? Analyze ROAS and revenue drivers

E-commerce teams want to know which campaigns drive revenue, which products perform best, and where to scale spend. Windsor MCP connects Meta Ads with Shopify, WooCommerce, or other e-commerce platforms so Claude can analyze ad spend against real revenue.

Calculate campaign-level ROAS

Match Meta Ads campaign data with Shopify revenue using UTM campaign parameters.
Calculate ROAS by campaign for the last 30 days.
Highlight campaigns with ROAS below 2 and suggest optimization ideas.

Identify wasted ad spend

List campaigns where the spend increased but the revenue decreased over the last 14 days.
Explain what might be causing the inefficiency.

Estimate product-level performance

Which products generated the most revenue from Meta Ads campaigns last month?
Break down results by campaign and ad set.

Define scaling opportunities

Identify campaigns with ROAS above 4 and stable CPA.
Recommend which campaigns could be scaled safely.

Cross-channel analysis: combine Meta Ads with revenue, CRM, and analytics data

Meta Ads data alone rarely tells the full story. The value appears when you combine ad data with business outcomes. Because Windsor connects 350+ data sources, Claude can analyze Meta Ads alongside Shopify or e-commerce revenue, CRM opportunities from HubSpot or Salesforce, GA4 conversion data, and ad performance from Google Ads, LinkedIn, or TikTok.

Calculate blended ROAS across channels

Combine Meta Ads spend with Shopify revenue and GA4 conversions.
Which campaigns generate the highest blended ROAS across all channels?

Calculate the B2B closed deal cost

Combine Meta Ads campaigns with CRM deal data.
Show cost per closed deal by campaign.

Turning analysis into deliverables

Once you have the numbers, Claude can package them into whatever format you actually need:

Any output format — daily, weekly, or monthly summaries in plain language, tables and CSV-ready outputs, or client-ready reports.
Client reports across your whole roster — filter by account ID or account name right inside your prompts to handle an entire client portfolio without extra setup.
Live dashboards that auto-refresh — ask Claude to build a dashboard artifact with the exact metrics, breakdowns, and time ranges you want to monitor; it keeps pulling fresh data from Windsor as it updates, instead of going stale like a static export.
Repeatable workflows — save your best-performing prompts and reuse them across accounts, campaigns, and time periods for daily checks, weekly optimization reports, or monthly client summaries.

FAQs

Do these prompts work without connecting my Meta Ads data first?

No. They reference real fields from your account (like spend, ROAS, and CPA), so they only work once Meta Ads is connected through Windsor MCP. Without a connection, Claude would have to guess instead of analyzing your real numbers.

Do any of these prompts change anything in my Meta Ads account?

No. Every prompt on this page is read-only — it analyzes and reports, it doesn’t change anything in your ad account. None of them will pause a campaign, change a budget, or spend money. For prompts that do take action, see How to manage Meta Ads campaigns from Claude.

How far back can Claude analyze my Meta Ads data?

As far back as your connected Meta Ads history goes. Most prompts above default to 14 or 30-day windows, but you can ask for any range.

Can Claude combine Meta Ads with CRM or e-commerce data automatically?

Yes, if those sources are also connected to Windsor. Claude can match Meta Ads campaigns with Shopify revenue, HubSpot or Salesforce opportunities, or GA4 conversions using shared fields like UTM parameters, without you building the join yourself.

Can agencies use these prompts across multiple client accounts at once?

Yes. Connect each client’s Meta Ads account to Windsor separately, then filter by account ID or account name directly inside your prompts to analyze your entire client roster in one conversation.

Can Claude create a live, auto-refreshing dashboard from these prompts?

Yes. Ask Claude to build a dashboard artifact defining the metrics, breakdowns, and time ranges you want to track; it keeps pulling fresh data from Windsor as your campaigns update, instead of going stale like a static export.

Does this work the same way in ChatGPT?

Yes. These prompts run through the same Windsor MCP connection, which works the same way across Claude, ChatGPT, and other MCP-compatible assistants.