- Master databases — open when configuring the system
<aside>
📊
Monthly SEO reporting with citation evidence — not a general agency CRM
Turn rankings, organic traffic, conversions, and answer-engine citation checks into one client-ready narrative, with the evidence and next action kept beside the result.
</aside>
Start here
Use the fictional sample accounts first. They demonstrate growing, flat, and at-risk reporting conversations; replace them after you understand the workflow.
- [ ] Add a client. Add or rename one row in Clients.
- [ ] Log the month. Create one current-month row in Monthly Reports, add 3–10 buyer-intent queries in GEO / Citation Tracker, and relate each query to the client and the report.
- [ ] Write the report. Complete the five-sentence narrative and choose one next-month priority.
First useful output: one finished monthly report with a Health Score, a Health Band, and a Citation Share you can defend.
Sending it to a client: copy the approved narrative and selected numbers into a new standalone page. Do not share a database view.
A report is complete when
- The active client has exactly one report for the month.
- Sessions, rankings, conversions or leads, citation share, and next-month focus are present.
- At least three answer-engine queries are tracked with evidence links.
- Anything sent to the client is a standalone page with only that client's approved narrative and numbers.
Scope at a glance
Included
- Three related databases for Clients, Monthly Reports, and GEO / Citation checks.
- Formula-backed monthly health scoring and relation-backed citation share.
- Fictional sample data, a five-sentence narrative pattern, and a standalone-report rule for client delivery.
- Optional agent-ready workflows for setup, monthly close, and evidence review.
Boundaries
- Monthly metrics and answer-engine checks are entered manually by default.
- No integrations or workflow files are included. A Search Console or GA4 sync you build yourself will not automate ChatGPT, Perplexity, Gemini, or Google AI Overview checks.
- This is a focused reporting and evidence system, not a CRM, invoicing suite, or project-management OS.
Best for
- SEO agencies, search strategists, fractional CMOs, and independent consultants who need a repeatable client reporting cadence.
Core concept: one client → many monthly reports → tracked queries
The system has three connected databases and one narrative layer.
- A Client has many Monthly Reports (one row per client per month).
- A Client has many Tracked Queries in the GEO / Citation Tracker.
- Each Monthly Report carries a written Report Narrative (the human story) plus rolled-up numbers.
Rule of thumb: numbers live in databases, the story lives in the narrative block. Clients read the story; the data backs it up.
System map
Pages
- Reporting Dashboard (this page)
- 01 — Agent Setup (subpage: reconnect an AI agent to your copy)
- 02 — Monthly Close (subpage: the monthly reporting runbook)
- 03 — GEO Citation Evidence Audit (subpage: the evidence standard for citation checks)
Databases
1) Clients