Marketing AI Skill

Seo Performance Dashboard

Track and report on SEO metrics, rankings, organic traffic growth, technical health score, backlink growth, and conversion rates from organic search. Use when building SEO dashboards, tracking keyword rankings, monitoring organic traffic, analyzing SEO ROI,...

SEO Performance Dashboard

Comprehensive tracking and reporting of SEO metrics, rankings, and organic traffic growth.

Workflow

  1. Connect data sources: Google Search Console, Google Analytics 4, ranking tools, backlink tools.
  2. Define SEO KPIs: Organic traffic, keyword rankings, backlink growth, technical health, conversions.
  3. Build dashboard views: Executive summary, keyword tracking, technical health, backlink profile, content performance.
  4. Configure automated ranking tracking: Daily position updates for target keywords.
  5. Set up technical SEO monitoring: Core Web Vitals, crawl errors, index coverage, site speed.
  6. Track backlink profile: New/lost links, domain authority trends, toxic link detection.
  7. Generate weekly SEO reports and monthly comprehensive analysis.
  8. Correlate SEO efforts with business outcomes: Leads, revenue, customer acquisition.

Dashboard Structure

SEO DASHBOARD — EXECUTIVE VIEW
================================

  ┌─────────────────────────────────────────────────────────────────┐
  │ SEO PERFORMANCE — May 2024                                      │
  │ Tracking: 1,250 Keywords  │  Domain Rating: 42 (▲ 3)            │
  ├─────────────────────────────────────────────────────────────────┤
  │                                                                  │
  │  85,200         12,500        2,840        3.2%        $127K    │
  │  Organic Traffic│ Keywords   │ Top 10     │ Conv. Rate │ Rev.   │
  │  ▲ 12.3%        │ (tracked)  │ Keywords   │            │        │
  │  vs. Apr        │            │ ▲ 180      │ ▲ 0.4%     │ ▲ 15%  │
  │                  │            │ vs. Apr    │ vs. Apr    │ vs. Apr│
  │                                                                  │
  ├─────────────────────────────────────────────────────────────────┤
  │  RANKING DISTRIBUTION:                                          │
  │  Positions 1-3:  ██████████████░░░░░░░░░░░░  420 (34%) ▲ 45    │
  │  Positions 4-10: ████████████░░░░░░░░░░░░░░  380 (31%) ▲ 80    │
  │  Positions 11-30: ████████░░░░░░░░░░░░░░░░░  280 (22%) ▼ 30   │
  │  Positions 31-100: ████░░░░░░░░░░░░░░░░░░░░  120 (10%) ▼ 50   │
  │  Not ranking:    ██░░░░░░░░░░░░░░░░░░░░░░░░   50 (4%)  ▼ 25   │
  │                                                                  │
  ├─────────────────────────────────────────────────────────────────┤
  │  TECHNICAL HEALTH: ████████████████████░░░░░░  82/100           │
  │  Core Web Vitals: LCP 2.1s ✅ | CLS 0.05 ✅ | INP 180ms ✅     │
  │  Crawl Errors: 3 (▼ 12 from last month)                         │
  │  Index Coverage: 98.2% (▲ 0.5%)                                 │
  │                                                                  │
  └─────────────────────────────────────────────────────────────────┘

SEO DASHBOARD — KEYWORD TRACKING:

  ┌──────────────────┬────────┬────────┬────────┬────────┬──────────┐
  │ Keyword          │ Pos    │ Change │ Volume │ Diff.  │ Trend    │
  ├──────────────────┼────────┼────────┼────────┼────────┼──────────┤
  │ "best [product]" │ 3      │ ▲ 2    │ 8,100  │ 67     │ ↗▲▲▲▲   │
  │ "[product] review│ 5      │ ▲ 3    │ 5,400  │ 52     │ ↗▲▲▲▲   │
  │ "[category] tool │ 2      │ ▲ 1    │ 12,000 │ 71     │ ↗▲▲▲▲   │
  │ "[brand] pricing │ 1      │ ─ 0    │ 3,600  │ 28     │ ─────   │
  │ "alternative to  │ 8      │ ▲ 4    │ 2,900  │ 45     │ ↗▲▲▲▲   │
  │ "[competitor]"   │        │        │        │        │          │
  │ "how to [task]"  │ 12     │ ▲ 8    │ 14,800 │ 38     │ ↗↗▲▲▲   │
  │ "[product] cost" │ 7      │ ▼ 1    │ 1,900  │ 33     │ ↘▼────   │
  └──────────────────┴────────┴────────┴────────┴────────┴──────────┘

  Trend legend: ↗ = improving, ─ = stable, ↘ = declining
  Bar density = velocity of change (more bars = faster change)

SEO DASHBOARD — CONTENT PERFORMANCE:

  ┌────────────────────────────┬────────┬────────┬────────┬──────────┐
  │ Page / URL                 │ Traffic│ Bounce │ Avg Pos│ Conv.    │
  ├────────────────────────────┼────────┼────────┼────────┼──────────┤
  │ /blog/best-[product]-2024  │ 8,400  │ 32%    │ 3      │ 4.2%     │
  │ /blog/[product]-review     │ 5,200  │ 28%    │ 5      │ 3.8%     │
  │ /blog/[category]-guide     │ 4,100  │ 35%    │ 7      │ 2.9%     │
  │ /product/[main-product]    │ 12,600 │ 25%    │ 2      │ 8.5%     │
  │ /pricing                   │ 6,800  │ 22%    │ 1      │ 12.1%    │
  │ /blog/[topic]-tutorial     │ 3,200  │ 38%    │ 11     │ 1.8%     │
  └────────────────────────────┴────────┴────────┴────────┴──────────┘

KPI Framework

SEO KPI DEFINITIONS AND BENCHMARKS
=====================================

PRIMARY KPIs:

  Organic Traffic:
    → Total sessions from organic search (GA4)
    → Benchmark growth: 10-30% annually for active SEO programs
    → Breakdown: New users vs. returning users
    → Quality signal: Engagement time > 45 seconds indicates relevant traffic

  Keyword Rankings:
    → Track positions for target keywords daily
    → Focus metrics: Top 3 count, Top 10 count, Top 30 count
    → Visibility score: Weighted ranking score (position 1 = 100, position 10 = 50)
    → Average position: Less useful than distribution (skewed by long-tail)

  Organic Conversions:
    → Goal completions from organic traffic
    → Conversion rate: Organic conversions / Organic sessions × 100
    → Benchmark: 2-5% for content sites, 3-8% for product pages
    → Revenue: Attributed revenue from organic search

  Click-Through Rate (Search Console):
    → CTR = Clicks / Impressions × 100
    → Benchmark by position:
       Position 1: 31.7% average CTR
       Position 2: 24.7% average CTR
       Position 3: 18.6% average CTR
       Position 4: 13.6% average CTR
       Position 5: 9.5% average CTR
       Position 10: 3.9% average CTR
    → Action: If CTR < benchmark for position → optimize title/meta

SECONDARY KPIs:

  Domain Authority / Domain Rating:
    → Moz DA: 1-100 (check monthly, slow-moving)
    → Ahrefs DR: 1-100 (check monthly)
    → Benchmark: > 30 competitive, > 50 authoritative
    → Growth: 1-3 points per month with active link building

  Backlink Profile:
    → Total backlinks (raw count)
    → Referring domains (more important than total links)
    → New links per month: 10-50 for active programs
    → Lost links per month: Track and investigate
    → Domain authority of linking domains: Focus on DA 30+ links

  Technical Health:
    → Core Web Vitals: LCP < 2.5s, CLS < 0.1, INP < 200ms
    → Crawl errors: Target 0 (critical), < 10 (acceptable)
    → Index coverage: Target > 95%
    → HTTPS: All pages served over HTTPS
    → Mobile usability: Target 0 errors

  Content Metrics:
    → Pages indexed: Total pages in Google index
    → Content freshness: % of pages updated in last 90 days
    → Word count average: 1,500+ words for top-ranking content
    → Internal links: Average internal links per page (target: 5-15)
    → Content gap: Keywords where competitors rank and you don't

Reporting

MONTHLY SEO REPORT TEMPLATE
==============================

EXECUTIVE SUMMARY:
  Reporting Period: May 2024
  Overall SEO Performance: [Summary in 3-4 sentences]
  Key Win: [Top achievement — e.g., "Keyword X reached #1 position"]
  Key Challenge: [Primary issue — e.g., "Core Web Vitals regression on mobile"]
  Revenue Impact: $[amount] attributed to organic search (▲ [X]% vs. prior month)

TRAFFIC PERFORMANCE:
  Organic sessions: [number] (▲ [X]% vs. prior month, ▲ [X]% vs. same month last year)
  Organic users: [number]
  New vs. returning: [X]% new, [X]% returning
  Avg. engagement time: [X] seconds (▲/▼ [X]%)
  Pages per session: [X] (▲/▼ [X]%)
  Bounce rate: [X]% (▲/▼ [X]%)

KEYWORD RANKINGS:
  Total keywords tracked: [number]
  Keywords in top 3: [number] (▲ [X])
  Keywords in top 10: [number] (▲ [X])
  Keywords in top 30: [number] (▲ [X])
  Average position: [X] (▲ [X])
  Biggest gains: [keyword] moved from #[X] to #[Y]
  Biggest losses: [keyword] dropped from #[X] to #[Y]
  New keywords ranking: [number] keywords entered top 100

SEARCH CONSOLE DATA:
  Total impressions: [number] (▲ [X]%)
  Total clicks: [number] (▲ [X]%)
  Average CTR: [X]% (▲ [X]pp)
  Average position: [X] (▲ [X])
  Top queries by clicks: [list top 5]
  Top pages by impressions: [list top 5]

TECHNICAL SEO:
  Core Web Vitals: LCP [X]s | CLS [X] | INP [X]ms
  Crawl errors: [number] (▲/▼ [X])
  Index coverage: [X]% ([number] pages indexed)
  Site speed: Desktop [X]s | Mobile [X]s
  Mobile usability errors: [number]
  SSL/HTTPS: [All pages secured / issues found]

BACKLINK PROFILE:
  Total backlinks: [number] (▲ [X])
  Referring domains: [number] (▲ [X])
  New referring domains: [number]
  Lost referring domains: [number]
  Domain Rating: [X] (▲ [X])
  Top new backlinks: [list 5 highest-DA new links]
  Toxic links detected: [number] (disavowed: [number])

CONTENT PERFORMANCE:
  Top 5 pages by organic traffic: [list with traffic and position]
  New content published: [number] pieces
  Content updates completed: [number] pieces
  Best-performing new content: [page] — [X] sessions in first month
  Underperforming content: [pages] — low traffic despite good rankings

CONVERSIONS AND REVENUE:
  Organic conversions: [number] (▲ [X]%)
  Organic conversion rate: [X]% (▲ [X]pp)
  Organic leads: [number] (if B2B)
  Organic revenue: $[amount] (▲ [X]%)
  Estimated value of organic traffic: $[amount] (based on equivalent paid CPC)

NEXT MONTH PRIORITIES:
  1. [Priority] — Expected impact: [metric improvement]
  2. [Priority] — Expected impact: [metric improvement]
  3. [Priority] — Expected impact: [metric improvement]

Integration Points

Edge Cases