| name | seo-report |
| description | SEO reporting and analytics dashboard generation. Creates weekly digests, monthly performance reports, quarterly strategy reviews, and real-time dashboard templates. Use when user says "SEO report", "weekly digest", "monthly report", "dashboard", "SEO metrics", "performance summary".
|
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
| Widget | Data Source | Visualization | Refresh |
|---|
| Organic Traffic Trend | GA4 | Line chart (30/90/365 day) | Daily |
| Keyword Position Distribution | GSC | Stacked bar chart | Weekly |
| CWV Status | CrUX | Gauge chart (3 metrics) | Weekly |
| Content Performance | GA4 + GSC | Scatter plot (impressions vs clicks) | Daily |
| Backlink Growth | DataForSEO/Ahrefs | Line chart + area | Weekly |
| Competitor SOV | SERP API | Pie chart | Weekly |
| Alert Counter | Monitoring system | Scorecard (4 severity levels) | Real-time |
Data Source Configuration
| Source | Connection | Refresh Rate |
|---|
| Google Search Console | GSC connector (native) | Daily |
| Google Analytics 4 | GA4 connector (native) | Daily |
| CrUX | CrUX BigQuery dataset | Weekly |
| PageSpeed Insights | Custom API connector | On-demand |
| Backlink data | DataForSEO API → Sheets | Weekly |
| SERP data | Bright Data → Sheets | Weekly |
Data Source Mapping
Which source for which report section
| Report Section | Primary Source | Secondary Source | Frequency |
|---|
| Traffic overview | GA4 | GSC (impressions) | Daily |
| Keyword positions | GSC | SERP API (validation) | Weekly |
| Content performance | GA4 + GSC (join) | — | Weekly |
| Backlink metrics | DataForSEO | GSC Links Report | Weekly |
| CWV performance | CrUX (field) | PSI (lab) | Weekly |
| Competitor data | SERP API | Bright Data | Weekly |
| Revenue/conversions | GA4 | CRM data | Monthly |
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
| Report | Audience | Delivery | Format |
|---|
| Weekly digest | SEO team | Monday AM | Markdown/Slack |
| Monthly report | Marketing leadership | 1st of month | PDF/Slides |
| Quarterly review | Executive team | Quarter start | Presentation |
| Alert notifications | SEO team | Real-time | Slack/Email |
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
Output Format
Generate requested report type with:
- Report Header (type, date range, prepared for)
- Executive Summary (3-5 key takeaways)
- Data Tables (formatted with trends and RAG status)
- Visualizations (described for chart implementation)
- Recommendations (prioritized with impact estimates)
- Appendix (methodology, data sources, definitions)
