seo-report — SEO Reporting & Insights

Report Types

A. Weekly Digest

Lightweight summary for staying on top of SEO performance.

#### Template Structure

# SEO Weekly Digest — [Date Range]

## Quick Stats
| Metric | This Week | Last Week | Change |
|--------|-----------|-----------|--------|
| Organic Sessions | | | ↑/↓ % |
| Avg Position | | | ↑/↓ |
| Keywords in Top 10 | | | +/- |
| New Backlinks | | | +/- |
| Pages Indexed | | | +/- |

## Ranking Changes
### Top 5 Climbers 📈
| Keyword | Was | Now | Change | URL |
### Top 5 Decliners 📉
| Keyword | Was | Now | Change | URL |

## Competitor Activity
- [Competitor A]: [summary of notable changes]
- [Competitor B]: [summary of notable changes]

## New Content Performance
| Title | Published | Indexed | Position | Impressions |

## Technical Issues
- [List any new crawl errors, CWV changes, or security alerts]

## Action Items This Week
1. [ ] [Priority action with assigned owner]
2. [ ] [Second priority action]
3. [ ] [Third priority action]

B. Monthly Report

Comprehensive performance analysis with trends and ROI.

#### Template Structure

# SEO Monthly Report — [Month Year]

## Executive Summary
[2-3 sentences on overall performance, key wins, concerns]

## KPI Dashboard
| KPI | Target | Actual | MoM | YoY | Status |
|-----|--------|--------|-----|-----|--------|
| Organic Sessions | | | % | % | 🟢/🟡/🔴 |
| Organic Revenue | | | % | % | 🟢/🟡/🔴 |
| Keywords Top 3 | | | +/- | +/- | 🟢/🟡/🔴 |
| Keywords Top 10 | | | +/- | +/- | 🟢/🟡/🔴 |
| Referring Domains | | | +/- | +/- | 🟢/🟡/🔴 |
| Domain Rating | | | +/- | — | 🟢/🟡/🔴 |
| SEO Health Score | | | +/- | +/- | 🟢/🟡/🔴 |

## Organic Traffic Analysis
- Session trend chart (daily, 30-day)
- Source/device breakdown
- Top landing pages by traffic
- New vs returning user ratio

## Keyword Performance
- Position distribution: #1-3 / #4-10 / #11-20 / #21-50 / #50+
- Striking distance opportunities
- New keyword entries
- Lost keywords

## Content Performance
| Content Piece | Sessions | Avg Position | CTR | Conversions |
- Top 10 performers
- Underperforming content (high impressions, low CTR)
- Content ROI: published this month vs traffic generated

## Backlink Report
- New referring domains acquired
- Lost referring domains
- DR/DA trend
- Notable high-quality links gained

## Competitor Analysis
| Metric | You | Comp A | Comp B | Comp C |
- Share of Voice comparison
- Notable competitor moves

## Technical SEO Health
- CWV status (pass/fail per metric)
- Index coverage trend
- Crawl error summary
- Page speed trends

## Recommendations
### Priority 1 (This Week)
### Priority 2 (This Month)
### Priority 3 (Next Month)

C. Quarterly Strategy Review

High-level strategic assessment for leadership.

#### Template Structure

# SEO Quarterly Review — Q[N] [Year]

## Goal Achievement
| Goal | Target | Actual | Status |
| Organic traffic growth | +20% | | |
| Top 10 keywords | 150 | | |
| DR improvement | +5 | | |

## Strategy Effectiveness
- What worked: [strategies that drove results]
- What didn't: [strategies that underperformed]
- External factors: [algorithm updates, market shifts]

## Market Position
- Industry benchmark comparison
- Competitive landscape shifts
- Emerging opportunities

## Investment Summary
| Category | Budget | Spent | ROI |
|----------|--------|-------|-----|
| Content production | | | |
| Link building | | | |
| Technical improvements | | | |
| Tools & platforms | | | |

## Next Quarter Strategy
- Priority initiatives
- Resource requirements
- Expected outcomes
- Risk factors

D. Dashboard Template (Looker Studio)

Real-time SEO dashboard configuration guide.

#### 7 Core Widgets

#### Data Source Configuration

Data Source Mapping

Which source for which report section

Cross-Source Reconciliation

When data conflicts:

• Traffic: GA4 is source of truth (session-based)
• Rankings: GSC is primary (impressions-weighted), SERP API for spot-check
• CWV: CrUX field data for ranking (75th percentile), PSI lab for debugging
• Backlinks: Cross-validate DataForSEO with GSC Links Report

Automation Opportunities

Report Scheduling

Automated Data Collection

Schedule:
  Daily: GSC Search Performance API → rankings DB
  Daily: GA4 Data API → traffic DB
  Weekly: DataForSEO Backlinks → backlinks DB
  Weekly: CrUX API → performance DB
  Weekly: Competitor sitemap diff → changes DB

Report Quality Checklist

• [ ] All metrics have source attribution
• [ ] Period-over-period comparisons included
• [ ] Competitor context provided
• [ ] Actionable recommendations (not just data)
• [ ] Each recommendation has priority and owner
• [ ] Charts have labeled axes and date ranges
• [ ] Executive summary leads with business impact

Output Format

Generate requested report type with:

1. Report Header (type, date range, prepared for)
2. Executive Summary (3-5 key takeaways)
3. Data Tables (formatted with trends and RAG status)
4. Visualizations (described for chart implementation)
5. Recommendations (prioritized with impact estimates)
6. Appendix (methodology, data sources, definitions)