ChatGPT Prompts for Facebook Ads Reporting and Analysis

Most “ChatGPT prompts for Facebook Ads” lists online ask you to paste a CSV export or invent numbers from memory, or worse, skip the data entirely and just generate ad copy blind. Once your account is connected through Windsor MCP (see: How to Connect Facebook Ads to ChatGPT), every prompt below runs against your live campaign, ad set, and ad-level data, no exports, no re-uploading a file every time the numbers change.

This guide goes deeper on Facebook Ads specifically than the Facebook Ads section of the AI Prompt Library (7 starter prompts across every connector Windsor supports); use that one for a quick cross-channel overview, use this one when Facebook Ads reporting is the main job. See the full AI Prompt Library.

Performance review and executive summaries

Monthly performance review

Summarize my Facebook Ads performance over the last 30 days. Include
total spend, impressions, clicks, CTR, CPA, and ROAS, broken down by
campaign. Present the results in a table and highlight the top- and
lowest-performing campaigns based on ROAS.

Week-over-week trend check

Show me a week-over-week comparison of CPA and CTR across all my
Facebook Ads campaigns for the last 2 months. Flag any weeks with
significant changes and explain possible reasons.

Executive summary for a stakeholder update

Act as a Senior Media Buyer. Write a 3-paragraph executive summary of
my Facebook Ads performance for the last week. Focus on the 'bottom
line': what worked, what failed, and the three specific actions I
need to take on Monday morning to improve ROAS.

Diagnosing underperformance

Rank ad sets by ROAS

Analyze my Facebook Ads data for the last 30 days and rank all ad
sets by ROAS from highest to lowest. Flag the bottom three and
suggest why they may be underperforming.

Find zero-conversion spend

List all active Facebook campaigns that have spent over $100 in the
last 14 days but have generated 0 conversions. Rank them by total
spend and suggest whether I should pause them or pivot the targeting.

Catch the click-without-convert gap

A high CTR with a low conversion rate usually means the ad is attracting the wrong click, or the landing page isn’t delivering on what the ad promised. This is one of the fastest ways to catch a mismatch competitors’ generic prompt lists talk about auditing manually; here it’s a single query against real numbers.

Find every ad from the last 30 days with CTR in the top 25% for the
account but a conversion rate in the bottom 25%.

For each one, show CTR, conversion rate, CPA, and the landing page
URL. Is there a pattern in which landing pages or offers show up
repeatedly on this list?

Creative and fatigue analysis

Detect creative fatigue

Review my active Facebook Ads and identify any creatives where
frequency is rising, and CTR is dropping. List the affected ads and
suggest new angles to test.

Identify winning creative hooks

Analyze my top 5 Facebook Ads by CTR from the last 30 days. Based on
their ad name and headline fields, identify common themes or hooks
that are resonating with my audience. Suggest 3 new creative angles
I should test in my next campaign.

Find campaigns still improving

Fatigue detection only tells half the story. It’s just as useful to know which campaigns are still trending upward, so you know where not to touch anything yet.

Looking at ROAS trends over the last 60 days, which campaigns show
consistent week-over-week growth rather than a plateau or decline?
What do they have in common in terms of audience, placement, or
creative format?

Audience and placement

Break down audience segments

Break down my Facebook Ads performance for the last 30 days by geo,
age, gender, and device. Highlight the segments with the lowest CPA
and the highest conversion rate.

Compare placement efficiency

Break down my Meta Ads performance by placement (Instagram Stories,
Facebook Feed, Reels, etc.). Compare the CPM and conversion rate for
each. Which placement is currently providing the best value for
money for my account?

Budget strategy and forecasting

Reallocate toward what’s working

Based on my Facebook Ads ROAS data from the last 30 days, recommend
how I should reallocate my budget across campaigns to improve
overall return on ad spend.

Model a budget change before making it

Before committing to a reallocation, it’s often worth asking ChatGPT to reason through the trade-off first, especially when a change is large enough that getting it wrong is expensive.

Based on the last 30 days of performance, what would likely happen
to overall ROAS and total conversions if I doubled the daily budget
on my best-performing ad set? What's the biggest risk in doing that?

Forecast next month’s performance

Using CPC and CTR trends from the last 60 days, forecast my likely
cost per result for next month if spend stays flat. Flag any
campaigns where the trend line suggests performance will keep
declining if nothing changes.

Related reading

• Ready to act on what you find here? ‘How to manage Facebook Ads campaigns from ChatGPT’ covers pausing underperformers, reallocating budget, and boosting posts directly, the write-action side of this same data.
• Want the same kind of content-strategy prompts for Instagram? See ‘ChatGPT prompts for Instagram content strategy’.
• Analyzing organic Facebook performance too? See ‘How to Connect Facebook Page Insights to ChatGPT’.
• Still deciding how to connect your account? ‘Ways to connect Facebook Ads to ChatGPT, compared‘ walks through Windsor MCP, manual CSV export, and Zapier/Make side by side.
• Haven’t connected yet? Start with ‘How to Connect Facebook Ads to ChatGPT Automatically‘.