HomeCasa Prompts

Diagnose an underperforming ad campaign from its metrics

Analyze your Meta, Google or TikTok Ads metrics, find the step where money is leaking and get prioritized hypotheses, actions and a two-week testing plan. Designed for ChatGPT, Claude, Gemini and Microsoft Copilot. It includes 5 customizable variables and you can copy it for free in one click.

Advanced · Text · Pending editorial review

Designed for:

Prompt

Act as a senior paid media analyst with experience optimizing campaigns on Meta Ads, Google Ads and TikTok Ads.

Context:
- Platform and campaign type: {{platform}}
- Objective and primary KPI: {{objective}}
- Metrics for the period (paste the exported table: spend, impressions, reach, frequency, CTR, CPC, CPM, conversions, CPA or ROAS, by campaign, ad set or ad): {{metrics}}
- Target CPA or ROAS and margin: {{target}}
- Recent changes (budget, creatives, targeting, website, price): {{changes}}

Deliverables:
1. Funnel read: calculate or check CTR, click-to-conversion rate, CPA and ROAS, and pinpoint where the problem sits (auction and reach, creative, landing page, offer or measurement).
2. Comparison across campaigns, ad sets or ads: which ones carry results and which drag them down, using figures from the table.
3. Warning signs: creative fatigue (high frequency with falling CTR), learning phase, budget spread too thin, audience overlap, tracking issues.
4. Five hypotheses ranked by likelihood, each with the data supporting it and what would contradict it.
5. Prioritized action plan (impact versus effort): what to pause, scale, test and leave alone for now.
6. A testing plan for the next two weeks: one variable per test, suggested minimum budget and the decision rule.
7. Data still needed to confirm the diagnosis.

Constraints:
- Use only the figures I give you; if you calculate something, show the math. Do not invent industry benchmarks.
- If the sample is small (few conversions), say so and avoid firm conclusions.
- Do not guarantee performance improvements.
- If the cost target or the period is missing, ask me before analyzing.

Format: a 5-line executive summary, then tables and lists per section.

How to use it

  1. Export the table from your ads manager with at least 7-14 days of data. 2. Enter your real target CPA or ROAS based on margin. 3. Start with high-impact, low-effort actions and change one thing at a time.

Usage example

Platform: Meta Ads sales campaign · Target: 28 USD CPA · Metrics: 3 ad sets, 2,000 USD spent over 14 days, frequency 4.2 · Changes: new product page a week ago.

Sample output

Executive summary

  1. Blended CPA is USD 46.51 (USD 2,000 / 43 purchases), well above the USD 28 target and the USD 36 margin: every sale loses money.
  2. No ad set hits the target.
  3. Ad set B has the best CTR and the worst CPA: it attracts clicks that do not buy.
  4. The new product page and the 30% budget increase both fall inside the period.
  5. With 43 purchases the sample is small, so conclusions are provisional.

Ad set comparison

Ad setSpendCTRPurchasesCPA (spend / purchases)
AUSD 7800.8%20USD 39.00
BUSD 6701.6%9USD 74.44
CUSD 5501.1%14USD 39.29

Hypotheses by likelihood

  1. The new page converts worse. For: the problem shows up after the change, and B gets more clicks but few sales. Against: we need the conversion rate before and after [FILL IN].
  2. The budget jump reset learning. For: a sudden 30% increase. Against: check delivery status in Ads Manager.
  3. B's creative promises something the page does not deliver. For: high CTR, few purchases.

Action plan

  • Pause or cut B until the click-to-purchase gap is understood.
  • Do not scale A or C while CPA exceeds margin.
  • Test: old page vs. new page, same traffic.

Missing data

Clicks, impressions and frequency per ad set, plus page conversion before the change…

Key facts

Category
Marketing & SEO · Advertising
Output type
Text
Level
Advanced
Designed for
ChatGPT, Claude, Gemini and Microsoft Copilot
Verified in
Pending editorial verification
Variables
Platform and campaign type, Objective and KPI, Metrics for the period, Target CPA or ROAS and margin and Recent changes
Language
English
Price
Free, no sign-up
Updated
Nov 7, 2026

Frequently asked questions

How much data do I need for a reliable diagnosis?

The more conversions, the better. With very few conversions per ad set, differences may be noise; the prompt flags this and tells you what data to collect before deciding.

Does it work for Google Ads and TikTok Ads as well as Meta?

Yes. The funnel logic (impression, click, conversion) is shared. Specify the platform and campaign type so the analysis uses each platform’s own metrics and signals.

What is this prompt for?

Analyze your Meta, Google or TikTok Ads metrics, find the step where money is leaking and get prioritized hypotheses, actions and a two-week testing plan.

Which AI tools does it work with?

It is designed for ChatGPT, Claude, Gemini and Microsoft Copilot. We have not verified it in these tools yet, so results may vary between them.

How do I customize the prompt?

Click “Customize” and fill in the variables (Platform and campaign type, Objective and KPI, Metrics for the period, Target CPA or ROAS and margin and Recent changes). The text updates instantly and you can then copy it in one click. Values are stored only in your browser.

Do I need experience to use it?

It is advanced: it is meant for people with experience in the topic who can evaluate and adjust the result.

Is this prompt free?

Yes. Every HomeCasa Prompts prompt is free, with no sign-up or subscription. You can also use them in professional projects.

Can I trust the AI output?

Treat it as a high-quality draft: always check data, figures and important claims before publishing or making decisions.

Related prompts