AnalyticsReporting and spreadsheetsIntermediateWrites 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.

For: Performance marketers, Marketing analysts, Growth marketers · Works with: Any capable chat model (ChatGPT, Claude, Gemini, others), Google Sheets / Excel

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 head of marketing analytics writing for executives. Create a one-page marketing performance report for Q3 2026 from the KPI table below. Audience: CEO and CFO. Business priorities: profitable growth and lower payback period. Targets: CAC under 150, MER above 3.0, signups 12,000. KPI table (metric | this period | last period | target): Metric | This period | Last period | Target Signups | 11200 | 10400 | 12000 CAC | 158 | 149 | 150 MER | 2.8 | 3.1 | 3.0 Context I can share (campaigns, events, outages): launched a new paid social campaign in August; a tracking outage on 14-15 September. Write: 1. A 3-sentence headline summary using only table figures. 2. A variance table: for each metric, absolute and percentage change versus last period and versus target, computed from the table, with a status (on track, watch, off track) based on the targets I provided (state the rule you apply). 3. The three most important movements, each with the figures and a clearly labelled hypothesis (not a conclusion) based on my context, plus the check that would confirm it. 4. Risks and data caveats (definition changes, incomplete periods, attribution differences). 5. Decisions or approvals needed from the executives, phrased as options with trade-offs. 6. A short list of what we will measure next period. Rules: state your assumptions; do not invent numbers, causes, benchmarks or quotes. If data is missing or not provided, flag it instead of filling the gap. Recompute every variance and verify before finalising. Keep correlation and causation separate; use plain language and no jargon.

Customize

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

Reporting period.

Who reads it.

What matters.

Targets you set.

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

Known events.

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.

A three-sentence summary, a computed variance table with on-track/watch/off-track statuses by a stated rule, three key movements with labelled hypotheses, caveats, decisions as options and next-period measurements. (Illustrative.)

Expected format: One-page report: summary, variance table, movements, risks, decisions, next steps.

How to use it

  1. Verify the variance table in a spreadsheet.
  2. Remove any hypothesis you cannot support.
  3. Have an analyst review before sending.

Limitations

  • Narratives can sound more certain than the data allows; check wording.
  • The model only knows your table and context.

Platform notes

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 sample and recompute the key numbers yourself: chat models can misread columns or miscalculate, and they cannot run your statistical tests reliably.

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.

Google Sheets / Excel

Not verified: third-party guidance only · checked 2026-10-11

Test any formulas on a small range first; syntax depends on locale and version.

General notes on Google Sheets / Excel
  • Formulas are written for common functions in both products. Locale settings (decimal and argument separators) can change what you must type.

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-040. We will correct or remove it.

Related prompts

  • AnalyticsIntermediateWrites a report

    GA4 weekly channel performance summary from an export

    Summarises a GA4 channel export into a short report of what changed, with every figure computed from your data and every explanation labelled as a hypothesis.

    Google Analytics 4 · Any capable chat model (ChatGPT, Claude, Gemini, others)

  • AnalyticsIntermediateWrites 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.

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

  • AnalyticsIntermediateBuilds a checklist

    Blended efficiency (MER) and dashboard specification

    Designs a small, honest dashboard spec for blended efficiency metrics, with metric definitions, data sources and the questions each chart answers.

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

  • AnalyticsIntermediateWrites formulas

    Spreadsheet formulas for marketing KPIs (Sheets and Excel)

    Gets working formulas for KPIs from your actual column layout, with error handling, a test case and explanations you can audit.

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