Way 1: without AI (the manual way)
Honest cost: half a day every month.
- Download exports from every channel.
- Paste numbers into the report skeleton, checking each against its source.
- Re-answer "where did this number come from" for every figure.
- Rewrite the commentary from scratch.
The manual month-end is: download, paste, reformat, then write commentary while double-checking where each number came from. The walkthrough below sets up a reusable reporting run with any assistant: fix the report skeleton once, feed each month's numbers, get drafts of the commentary you then verify against the sources.
Pros of doing it manually
- Free except your time - no tools, no accounts.
- You learn the job deeply and control every detail.
- No data leaves your hands.
Cons of doing it manually
- half a day every month - every single time the job runs.
- Quality depends on your energy that day.
- More volume just means more hours; it does not scale.
Way 2: with AI, but without AI Agent Skills (DIY prompting)
A chat assistant genuinely helps here. The catch is that you become the workflow designer. What you have to figure out yourself:
- You must paste every export and last month’s format each month - nothing carries over.
- You must force source citations per number or the report is unauditable.
- You must keep the structure identical by hand, or months stop comparing.
Here is a starter prompt that works - copy it and bring the inputs listed:
Prepare this month's campaign performance report from these approved exports: [paste]. One row per campaign: spend, result, source, variance vs plan, and one question this raises. Match last month's structure: [paste]. Every number must come from the export - if something is missing, mark it MISSING.More on this prompt: the free marketing performance reporting prompt page.
Pros of DIY prompting
- Free, or nearly - any chat assistant works.
- A first draft in minutes instead of hours.
- Fully flexible: tweak the prompt for any edge case.
Cons of DIY prompting
- You become the workflow designer: prompts, test data and output rules are yours to write, test and maintain.
- Output drifts between sessions unless you re-paste the rules every run.
- Nothing is saved for you - sheets, structure and context are rebuilt each time.
Way 3: with AI Agent Skills (free, Free)
The Performance Reporting Agent is this job already designed: fixed evidence rules, output contract, test fixtures and stop points. You ask once:
Hello, prepare this month’s campaign performance report
And a finished, review-ready artifact lands in your own Drive:
| Campaign | Spend | Result | Source | Variance | Next question |
|---|---|---|---|---|---|
| Launch week LinkedIn ads | $1,850 | 34 demo bookings ($54/booking) | Ad platform export Sep 12 | 20% under target CPA | Scale budget 20%? |
| Webinar Sep 5 | $600 | 11 demos ($55/booking) | Webinar platform + CRM | On target | Repeat monthly? |
Sample data shown. Your workspace fills with your real work.
Setup takes about 10 minutes: download, hand the Included files to the assistant you already use (Instinct, ChatGPT, Claude, Gemini or any other assistant that reads files), approve the fictional-data test. Then it runs on a standing cycle or a one-line ask, and stops at every human gate. Full method.
Pros of the ready-made agent
- About 10 minutes to a tested setup, not an afternoon of prompt tuning.
- The same output shape every run - evidence rules and stop points are already designed.
- Runs on a standing cycle or a one-line ask; files land in your own Drive.
Cons of the ready-made agent
- Costs free, where DIY prompting is free.
- The output format is opinionated - you adapt the template rather than rebuild it.
- It still stops and waits for your approval at decision points; it is not zero-touch.
The honest comparison
| Way 1: manual | Way 2: DIY AI | Way 3: free agent | |
|---|---|---|---|
| Time to first result | half a day every month | An afternoon of prompt tuning | About 10 minutes, tested setup |
| Every run after | Same hours, every time | Re-paste the rules, sheet and context each run | One short ask, or a standing cycle |
| Consistency | Depends on the day | Drifts between sessions | Same output shape every run |
| Cost | Your hours | Free, plus your time | Free, files kept forever |
The manual way teaches you the job. DIY prompting is fine for a one-off. The agent wins when the job repeats every week.
More: the Performance Reporting Agent product page · the marketing performance reporting guide · AI agents for marketing teams
Questions people ask
What is the fastest way to build a monthly marketing report?
The free ready-made agent: about 10 minutes of setup, then one short ask per run. Manual takes half a day every month; DIY prompting takes an afternoon of tuning plus upkeep.
Can I build a monthly marketing report without AI?
Yes - the manual steps are on this page. Expect half a day every month each time the job runs.
Is the free agent worth it over DIY prompting?
If the job repeats weekly, yes: you stop rebuilding prompts and re-pasting context every run. For a one-off, DIY prompting is fine and free.
Last updated 13 September 2026 · Reviewed by the AI Agent Skills team.