AnalyticsMeta Ads analysisIntermediateWrites a report

Meta Ads weekly performance report narrative

Turns a Meta Ads export into a weekly narrative with computed metrics, flagged anomalies and carefully worded explanations.

For: Performance marketers, Marketing analysts, Growth marketers · Works with: Meta Ads, Any capable chat model (ChatGPT, Claude, Gemini, others)

Public beta. This prompt was drafted with AI assistance and checked by automated rules, but it has not been reviewed or tested by a person yet. Treat it as a starting point and check the output. It is hidden from search engines while in beta. Use the “Was this prompt useful?” box to tell us what works.

Your prompt

Act as a paid-social analyst. Write a weekly performance narrative from the Meta Ads export below for 5-11 Oct 2026 versus 28 Sep-4 Oct 2026. Objective: lead generation. Currency: USD. Attribution window used in the export: 7-day click and 1-day view. Data (campaign | spend | impressions | reach | clicks | results | cost per result): Campaign | Spend | Impr | Reach | Clicks | Leads | CPL Prospecting | 2400 | 310000 | 180000 | 4100 | 96 | 25.0 Retargeting | 900 | 80000 | 22000 | 2300 | 71 | 12.7 Write: 1. A 5-line executive summary using only figures from the data. 2. A table of key metrics with week-over-week change, computed from raw columns (show how you derived CTR, CPM, frequency if reach is given, and cost per result). 3. Three notable changes with the numbers behind them. 4. Possible reasons, each labelled a hypothesis, with the data you would check next (creative fatigue, audience overlap, learning phase, seasonality, tracking). 5. Recommended actions limited to what the data supports. 6. Data caveats: attribution-window effects, delayed conversions in recent days, anything missing. Rules: do not invent numbers, benchmarks or causes; assumptions must be stated; missing data must be flagged. Verify the arithmetic and recompute the week-over-week changes. Do not state causal conclusions; correlation only.

Customize

The fields start with example values so you can see how the prompt works. Everything stays in your browser.

This week.

Previous week.

Campaign objective.

Currency.

As used in your export.

Paste your table. The default is small fictional sample data so the preview works; replace it with your own export.

Example of what to expect

Illustrative only. It describes the kind of result this prompt aims for; real output varies by tool, model and run.

An executive summary, a metrics table with computed changes and formulas, three notable changes, hypotheses with checks to run, supported actions and caveats about windows and delayed conversions. (Illustrative.)

Expected format: Summary, table, notable changes, hypotheses, actions, caveats.

How to use it

  1. Export with consistent attribution settings.
  2. Verify the table before sharing.
  3. Turn hypotheses into tests.

Limitations

  • Recent days can be incomplete due to delayed conversions.
  • Attribution settings change results; compare like with like.

Platform notes

Meta Ads

Official docs read · checked 2026-10-11

Meta results depend on the attribution window and breakdowns in your export; state them. We read only the Insights API overview, not the detail pages on attribution or data delays.

General notes on Meta Ads
  • Insights can be requested with specific attribution windows and breakdowns. Always tell the model which window and breakdowns your export used, because results change with them.

Any capable chat model (ChatGPT, Claude, Gemini, others)

Official docs read · checked 2026-10-11

Works in any capable chat model. Paste a small anonymised export and recompute the key numbers yourself: chat models can misread columns or miscalculate.

General notes on Any capable chat model (ChatGPT, Claude, Gemini, others)
  • These prompts are plain text and work in any chat assistant. For analytics prompts, paste a small, anonymised export; a chat model can misread columns or miscalculate, so recompute key numbers yourself.

Source, license and attribution

Origin
Original by MarketerTools
Publisher
MarketerTools
License
Original work by MarketerTools, free to copy and use. Informed by the linked documentation; no third-party text is reproduced.
Platform assumptions checked
2026-10-11

Documentation and references behind this prompt

These informed the structure and the platform notes. A reference is not a license, and no third-party prompt text is copied here.

Spotted an attribution error, or are you a source owner with a request? Use the chat button at the bottom right and quote prompt ID ana-015. We will correct or remove it.

Related prompts

  • AnalyticsIntermediateAnalyses your data

    Meta Ads creative-fatigue check from trend data

    Looks for fatigue signals (rising frequency, falling CTR, rising cost per result) in ad-level trend data and separates them from other explanations.

    Meta Ads · Any capable chat model (ChatGPT, Claude, Gemini, others)

  • AnalyticsIntermediateWrites a report

    Executive marketing report narrative with variance analysis

    Writes a concise executive narrative from your KPI table: what moved, by how much, plausible reasons labelled as hypotheses, and decisions needed.

    Any capable chat model (ChatGPT, Claude, Gemini, others) · Google Sheets / Excel