Report guide · REP-015 · v1.0
Pegasus · Monthly performance report for an agency client
Eight slides: spend, channels and next actions.
Instructions for your AI; check sections, output files and controls before copying.
What it includes
6 sections, in this order
- 01Cover and the month in 3 figures: spend, attributed orders and ROAS against target
- 02Results by channel against budget, targets and prior month
- 03Funnel by channel and results by campaign
- 0413-month trend with the store's revenue
- 05Learnings with figures and sources, and next steps with an owner and a date
- 06Appendix: definitions, attribution, reconciliations and controls
Controls 6/6
What it checks before writing a single figure
C1Complete data: a single month, no repeated campaigns, clicks ≤ impressions and orders ≤ sessions in every channel.
C2Reconciled spend: platform spend adds up to the month's media invoices (N/A without invoices).
C3Attribution without double counting: analytics add up to the store's totals, paid channels never exceed them and the platforms' excess is reported in %.
C4CPA or ROAS jumps above 50% and measurement changes: the AI asks and states them as a limitation.
C5Figures table valid for the kit: numeric values, no repeated lines and valid units (cuadre.py validar).
C6Traceable figures: every figure in the PowerPoint exists in calculo.json with the same rounding (cuadre.py verificar).
If the script ran
Repporti controls 6/6 · REP-015 v1.0 · RS2026.10 · {fecha} · fingerprint {hash}
If it did not run
UNVERIFIED: code not run. Review Control in Excel.
What the prompt contains, block by block
Prompt outline
- 0Before you paste your filesFixed639
- 1Role, audience and business context769
- 2Parameters669
- 3Repporti standard367
- 4Data contract1,193
- 5Questions first475
- 6Validation with a hard stop1,101
- 7Calculation by code1,098
- 7-bisNo-code modeFixed459
- 8Formulas1,205
- 9Structure1,361
- 10Writing without «AI slop» and without invention1,069
- 11Theme and notation918
- 12QA, traceability and seal993
Core available in: Spanish · English
It comes out adapted to your report profile
Repporti Standard
Your profile sets country, framework, language, currency, scale and year-end.
See the Repporti StandardHow to use it
From the trial balance to the report in three steps
- 01Configure and copy
- 02Paste into your AI
- 03Review and deliver
Anonymize before pasting
- Company → alias; tax identifier → ID-XX.
- People → codes. Keep the mapping on your device.
- Use business AI, API or disable training.
Made for whoever delivers the report
Who it is for
- Area
- Marketing and agencies
- Frequency
- Monthly
- Industry
- Agencies, Retail and wholesale
Which AI it works with
Compatibility
| Level | AI | |
|---|---|---|
| With code execution | ChatGPT · Claude | Requires file analysis and Python execution for cuadre.py. |
| No-code mode | Copilot · Gemini | Excel with Control sheet; UNVERIFIED until cuadre.py runs. |
Questions
About this report guide
Why doesn't it use the conversions each platform reports?
Because each platform claims the sale with its own rule and the same purchase gets counted two or three times. The report uses the client's store or CRM analytics and shows, in %, how much the platforms over-attribute.
Does it work if my client measures leads, not sales?
Yes. Swap orders for leads: CPA becomes cost per lead and, without revenue, ROAS shows as «N/A». Everything else works the same.
Does the AI invent recommendations?
No. Next steps come from your notes (the agency's proposals) and each one carries its estimated impact from the month's figures, flagged as an estimate, with an owner and a date.
Is the agency fee included in ROAS?
No. ROAS is calculated on media spend. If you want to show the client's total cost, the fee goes on a separate line.
What if my AI cannot run code?
It switches to no-code mode: it builds the Excel file with formulas and a Control sheet, and the cover and footer say «NOT VERIFIED». You can run cuadre.py on your computer and get the seal later.
Marketing and agencies