wowprompt

Monthly website traffic report from analytics exports

Turns raw analytics and search exports into a one-page monthly website report: what changed, why it changed, which pages and channels drove it, and what to do next month. Use it for a monthly review with a manager or client who wants answers rather than charts.

A one-page report with headline numbers against last month and last year, a channel table, top and falling pages, three reasons for the change, and next steps
The output this prompt produced, unedited.

The prompt

Layer 1: the data

  • This month and last month by channel: [paste rows: channel, users, sessions, conversions]
  • Same month last year, if available: [paste, or none]
  • Top landing pages, both months: [paste rows: page, sessions, conversions]
  • Search query data, if available: [paste top queries with clicks and impressions]
  • Conversion goal: [e.g. contact form sent, purchase, sign-up]
  • Things that happened this month: [e.g. a sale, a new blog section, tracking change, site down for a day]

Layer 2: the analysis

  1. Compare every number with last month and, where given, with the same month last year.
  2. Split the overall change into channel contributions so the parts add up to the total.
  3. Find the five pages that gained most and the five that lost most.
  4. Match changes to the events listed; mark each link as confirmed or likely.
  5. Check for tracking problems: a channel dropping to zero, or conversions changing while sessions do not.

Layer 3: the report

  1. Headline: three numbers with change, written as sentences a manager can read in ten seconds.
  2. | Channel | Users | Change vs last month | Conversions | Conversion rate |
  3. Pages that drove the change, gainers and losers.
  4. Three reasons for the change, each backed by a number.
  5. Next month: three actions with an owner and the number each should move.

Rules

  • No chart descriptions, no jargon such as "engagement uplift"; plain sentences.
  • Do not invent numbers for missing data; say it is missing.
  • Keep the whole report to one page of text.
website traffic reportmonthly analytics reportga4 reporttraffic sourceslanding page performancemarketing report

How to run this

Copy the prompt and paste it into Gemini, then set the aspect ratio to 3:4. No reference photo is needed for this one.

The prompt is written in Markdown with each part under its own heading, which is what the copy action hands over. Change one section at a time, keeping the rest intact, so you can tell which change did the work.

Related prompts

All productivity