Report Generation

Master Audit Report — Compilation Skill

Executive Summary

The master report is the culmination of all 21 audit phases — the client's definitive reference document for the next 6–12 months of SEO work. A well-structured master report delivers: clear business impact framing (not just technical findings), a prioritized action plan with effort estimates, measurable KPIs, and a roadmap stakeholders can act on. In 2025, the master report must explicitly address AI visibility (AI Overviews, ChatGPT, Perplexity) as a separate strategic dimension — clients increasingly ask "why aren't we showing up in AI answers?"

2025 master report requirements:

• Include SEO Health Index = (LOCAL-IMPACT × 0.55) + (SERP-TRUST × 0.45) as the headline metric
• AI Overviews section mandatory: AIO appears for 20–35% of local service queries
• All CWV data must use 2025 thresholds: INP < 200ms (replaced FID March 2024)
• Include GBP performance data: review velocity, Q&A status, photo count vs. 100+ benchmark
• ChatGPT/Perplexity visibility test results must appear in AI visibility section

Tools for This Phase

Step 1: Read Project Context + Compile All Findings

# Compile all phase findings into structured master report data
python3 scripts/report_compiler.py --project {PROJECT_DIR} --output {AUDIT_DIR}/master-report.md

Then read all individual phase files to enrich the compiled report:

• {AUDIT_DIR}/intake-data.md
• {AUDIT_DIR}/competitor-profiles.md
• {AUDIT_DIR}/local-impact-scores.md
• {AUDIT_DIR}/serp-trust-scores.md
• All other {AUDIT_DIR}/*.md files

Master Report Structure

Section 1: Executive Summary (3-5 paragraphs)

• Business overview and market position
• Overall site health narrative (not just score — what it means for the business)
• Top 3 critical issues that are costing rankings/leads RIGHT NOW
• Top 3 opportunities with highest revenue potential
• Overall trajectory: what 6-12 months of action can achieve

Section 2: Overall Site Health Score

Overall Site Health: [X]/100   Grade: [A-F]
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━
Technical:    [X]/100    Local SEO:    [X]/100
On-Page:      [X]/100    AI Visibility: [X]/100
Content:      [X]/100    Authority:     [X]/100
Speed/CWV:    [X]/100    Reputation:    [X]/100
━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━

Section 3: Proprietary Framework Scores

LOCAL-IMPACT Score: [X]/100 — Grade: [X]

(Load from {AUDIT_DIR}/local-impact-scores.md)

Dimension Breakdown:
L  Listing Quality       [XX/30]  ████████░░  [X%]
O  Online Reviews         [XX/30]  ███████░░░  [X%]
C  Citation Consistency   [XX/30]  █████░░░░░  [X%]
A  Authority Signals      [XX/30]  ████████░░  [X%]
L2 Local Content          [XX/15]  ██████░░░░  [X%]
I  Integrated Visibility  [XX/15]  ███████░░░  [X%]
P  Performance            [XX/15]  ████████░░  [X%]
T  Tracking               [XX/15]  █████░░░░░  [X%]

Veto Checks: [status of all 6 vetoes]

Or compute with: python3 scripts/score_calculator.py --local-impact {AUDIT_DIR}/local-impact-scores.md

SERP-TRUST Score: [X]/100 — Grade: [X]

(Load from {AUDIT_DIR}/serp-trust-scores.md)

Dimension Breakdown:
T  Technical Foundation   [XX/40]  ████████░░  [X%]
R  Ranking Signals        [XX/40]  ███████░░░  [X%]
U  User Experience        [XX/40]  █████░░░░░  [X%]
S  Search Authority       [XX/40]  ████████░░  [X%]
T2 Trust & AI Readiness   [XX/40]  ██████░░░░  [X%]

Veto Checks: [status of all 7 vetoes]

Or compute with: python3 scripts/score_calculator.py --serp-trust {AUDIT_DIR}/serp-trust-scores.md

SEO Health Index: [X]/100 — Grade: [X]

SEO Health Index = (LOCAL-IMPACT [X] × 0.55) + (SERP-TRUST [X] × 0.45) = [X]/100
Status: Excellent | Good | Fair | Poor | Critical

Or compute with: python3 scripts/score_calculator.py --both --li-file {AUDIT_DIR}/local-impact-scores.md --st-file {AUDIT_DIR}/serp-trust-scores.md

Section 4: Critical Issues — Fix Immediately

All CRITICAL priority issues from all phases, consolidated:

Expand each critical issue with:

• Root cause
• Specific fix steps
• Expected improvement when fixed
• Effort required

Section 5: Priority Matrix (Impact × Effort Quadrant)

HIGH IMPACT, LOW EFFORT (Do First — Quick Wins):
  • [issue/opportunity]
  • [issue/opportunity]
  • [issue/opportunity]

HIGH IMPACT, HIGH EFFORT (Strategic Priorities):
  • [issue/opportunity]
  • [issue/opportunity]

LOW IMPACT, LOW EFFORT (Fill When Available):
  • [issue/opportunity]

LOW IMPACT, HIGH EFFORT (Deprioritize):
  • [issue/opportunity]

Section 6: Quick Wins — Implement Today/This Week

Maximum 15 quick wins, ordered by impact:

Section 7: 30-Day Action Plan (Weekly Breakdown)

Week 1 — Critical Fixes:

• [Critical issue 1] — Owner: [team/contractor] — Expected: [X improvement]
• [Critical issue 2]
• [Quick wins batch]

Week 2 — Technical & On-Page:

• [Technical fix]
• [On-page optimization batch]
• [Content update]

Week 3 — Local & Content:

• [GBP optimization]
• [Citation submissions]
• [New content piece]

Week 4 — Authority & Measurement:

• [Link building outreach]
• [Analytics/tracking setup]
• [Review generation system launch]

Section 8: 90-Day Strategic Plan

Month 1: Foundation — Fix critical issues, establish tracking, launch content engine Month 2: Acceleration — Content at scale, link acquisition, local authority building Month 3: Optimization — Refine based on data, scale what's working, close keyword gaps

Section 9: 6-Month Roadmap

Quarterly milestone targets with specific KPIs:

• [KPI 1]: [current] → [target at month 3] → [target at month 6]
• [KPI 2]: [current] → [target] → [target]
• Rankings, traffic, leads, review count/rating, LOCAL-IMPACT score

Section 10: 12-Month Vision

Where can this business be in 12 months with consistent execution?

• Market position vs. current top competitors
• Estimated traffic increase (%)
• Estimated lead volume increase
• LOCAL-IMPACT score projection
• Topical authority level

Section 11: KPI Tracking Framework

Section 12: Resource & Budget Recommendations

By priority:

1. Immediate fixes (can be done in-house): [list] — [est. hours]
2. Technical implementation (developer needed): [list] — [est. cost]
3. Content creation: [X pieces/month] — [in-house vs. content agency cost]
4. Link building / PR: [budget recommendation]
5. Tools needed: [specific tools + costs]
6. Total estimated investment: [$X-Y/month]

Section 13: Competitor Summary

LOCAL-IMPACT + SERP-TRUST competitor scores included if scored.

Section 14: Phase-by-Phase Detail Summary

One paragraph + key findings per phase, with score and status.

PDF Export

After compiling master report, generate the final PDF:

# Convert HTML master report to PDF
python3 scripts/generate_pdf.py --html {REPORTS_DIR}/master-report.html

# Or use Chrome directly
"/Applications/Google Chrome.app/Contents/MacOS/Google Chrome" \
  --headless=new --disable-gpu --no-sandbox --print-to-pdf-no-header \
  --print-to-pdf="{REPORTS_DIR}/master-report.pdf" \
  "file:///absolute/path/{REPORTS_DIR}/master-report.html"

PDF Design for Master Report:

• Professional cover page with all scores and business info
• Executive dashboard with gauge charts for all key scores
• Phase-by-phase summary with color-coded status badges
• Roadmap timeline visualization
• Priority matrix quadrant chart

Write final report HTML to {REPORTS_DIR}/master-report.html. Write final PDF to {REPORTS_DIR}/master-report.pdf. Write markdown to {AUDIT_DIR}/master-report.md.

Report Quality Checklist (Before Delivering)

Priority Matrix

Output

Write to {AUDIT_DIR}/master-report.md with YAML frontmatter:

---
skill: output/report-generation
phase: final
date: [YYYY-MM-DD]
business: [Business Name]
url: [URL]
seo_health_index: [X/100]
local_impact_score: [X/100]
serp_trust_score: [X/100]
phases_completed: [X/21]
critical_issues: [X]
high_issues: [X]
quick_wins: [X]
---

Key consumers:

• output/pdf-report — master-report.md → HTML → PDF conversion
• Client/stakeholder — primary deliverable for strategy alignment
• Future audit sessions — baseline for progress measurement