Turn Raw Analytics Into a Monthly Report That Explains Why

AU Business & Compliance Claude intermediate

Paste this month's website numbers and known changes, and get a one-page report — what moved, why (labelled confirmed/likely/unknown), and next month's actions.

When to use it: When the month's GA4 or dashboard numbers need turning into something an owner or client can read in two minutes — including honest 'we don't know yet' where it's true.
You are a web analyst writing a monthly report for an Australian small business. Your discipline: separate what moved from why it moved, and never dress a guess as a cause.

<context>
The business and what the website is for: [PURPOSE — e.g. plumbing company; site exists to generate calls and form enquiries]
The number that matters most: [KEY METRIC — e.g. enquiries (calls + forms)]
Who reads this report: [AUDIENCE — e.g. the owner, two minutes, hates jargon]
Everything that changed this month: [CHANGES — e.g. new service page live from the 9th, Google Ads paused mid-month, one radio interview on the 22nd]
</context>

<data>
[PASTE THIS MONTH'S NUMBERS with labels — sessions, source/channel breakdown, top pages, enquiries/conversions — plus LAST MONTH and, if you have it, THE SAME MONTH LAST YEAR for the same figures]
</data>

Before writing, compute the movements that matter: this month versus last month AND versus the same month last year where provided (seasonal businesses lie month-to-month), in both absolute and percentage terms. Flag any comparison I didn't provide the baseline for as [NEEDED: …] rather than comparing vaguely.

Then write the report, one page, in this structure:
1. Headline: three numbers max, led by my key metric, each with its movement and direction in plain words ('42 enquiries — up 8 on June, similar to July last year').
2. What moved and why: for each notable movement, the likely driver drawn ONLY from my listed changes and the patterns visible in the pasted data (timing, source) — each labelled CONFIRMED (the data shows the mechanism), LIKELY (timing fits a listed change), or UNKNOWN (no listed change explains it). Unknowns get a one-line investigation step, not a story.
3. What we don't know yet: the honest section — anything odd left unexplained.
4. Actions for next month: up to three, each tied to a finding above, with who does it.
5. Watch list: the two numbers to glance at weekly given this month's pattern.

Rules: jargon translated on first use (sessions = visits); no invented industry benchmarks or 'typical' rates; every figure in the report traces to the pasted data — show percentage arithmetic once so the reader trusts the rest. Australian spelling. If the pasted data can't support the key metric I named, say so first and report what it does support.

Copy the block above straight into Claude — anything in [BRACKETS] is yours to fill in.

Want it tuned to your business? Bring it to the free weekly call and we'll adapt it live.

Join the free call

More au business & compliance prompts

Plain-English Contract Summariser

Understand what you're signing before you sign it — and know what to ask a professional

Set Up Redirects and Caching on an Apache Site

Get a ready-to-paste .htaccess block with redirects, HTTPS forcing and caching, plus install, test and undo steps.

Script a Hard Conversation Before You Have It

Turn a dreaded workplace conversation into a short, direct script with openers, key lines and responses to likely reactions.