Agent Skillsdavidpc007/openclaw-marketing-skills › search-console-connect

search-console-connect

GitHub

连接Google Search Console API获取真实SEO数据,用于诊断流量下跌、发现关键词机会及内容优化建议。支持通过gcloud或服务账号配置,提供流量趋势、排名位置等详细指标分析。

skills/search-console-connect/SKILL.md davidpc007/openclaw-marketing-skills

Trigger Scenarios

流量下跌诊断 查询当前排名关键词 基于真实数据的SEO审计 搜索控制台数据分析 自然流量分析 确定需优化的页面

Install

npx skills add davidpc007/openclaw-marketing-skills --skill search-console-connect -g -y
More Options

Use without installing

npx skills use davidpc007/openclaw-marketing-skills@search-console-connect

指定 Agent (Claude Code)

npx skills add davidpc007/openclaw-marketing-skills --skill search-console-connect -a claude-code -g -y

安装 repo 全部 skill

npx skills add davidpc007/openclaw-marketing-skills --all -g -y

预览 repo 内 skill

npx skills add davidpc007/openclaw-marketing-skills --list

SKILL.md

Frontmatter
{
    "name": "search-console-connect",
    "description": "Connect to Google Search Console API to pull real organic search data — traffic trends, ranking positions, impressions, CTR, top queries, and page-level performance. Use when the user wants to audit SEO with real data, diagnose traffic drops, find quick-win keywords, or understand what's actually driving (or losing) organic traffic. Enhances seo-audit and ai-seo skills with real GSC data. Triggers on: 'why did my traffic drop', 'what keywords am I ranking for', 'SEO audit with real data', 'Search Console data', 'organic traffic analysis', 'which pages to optimize'."
}

Search Console Connect

You are an SEO analyst with direct access to the user's Google Search Console data. You pull real traffic and ranking data to replace guesswork with evidence — then tell the user exactly what to fix and in what order.

Setup (First Time)

Check for .agents/search-console-credentials.json. If missing, guide setup:

Option A: gcloud CLI (Easiest)

# Install Google Cloud SDK if not present
# Then authenticate:
gcloud auth application-default login \
  --scopes=https://www.googleapis.com/auth/webmasters.readonly

# Enable Search Console API
gcloud services enable searchconsole.googleapis.com

Credentials auto-saved to ~/.config/gcloud/application_default_credentials.json

Option B: Service Account (For Automation)

  1. Google Cloud Console → IAM → Service Accounts → Create
  2. Download JSON key
  3. In Search Console → Settings → Users and Permissions → Add user (service account email, Owner)
  4. Save key path to .agents/search-console-credentials.json:
{
  "type": "service_account",
  "key_file": "/path/to/service-account-key.json",
  "site_url": "https://yourdomain.com"
}

Data Pull

python skills/search-console-connect/scripts/pull.py \
  --site https://yourdomain.com \
  --days 90 \
  --output .agents/gsc-data.json

Fetches:

  • Top queries: impressions, clicks, avg position, CTR (last 90 days)
  • Top pages: same metrics by URL
  • Traffic trend: daily clicks over time (spot drops)
  • Position distribution: how many keywords rank 1-3, 4-10, 11-20, 21-50, 51+
  • Coverage report: indexed vs. not indexed, errors

Analysis Framework

Traffic Drop Diagnosis

If the user reports a drop, run this sequence:

  1. Date the drop — find the exact day traffic fell in the trend data
  2. Check algorithm — cross-reference with Google algorithm update history
  3. Identify affected pages — compare page performance before/after drop date
  4. Identify affected queries — same comparison at query level
  5. Pattern match — is it sitewide (technical) or topic-specific (content)?

Quick Win Detector

Find keywords where:

  • Position 4-20 AND impressions > 100/month → ranking improvement opportunity
  • High impressions, low CTR (position 1-5 but CTR < expected) → title/meta fix
  • Position 1-3 on a page with no internal links → link juice opportunity

Expected CTR benchmarks:

Position Expected CTR
1 28-35%
2 15-20%
3 10-13%
4-5 6-8%
6-10 2-4%

If actual CTR is significantly below benchmark → title tag or meta description needs work.

Content Gap Finder

Queries with:

  • Impressions > 200/month
  • Average position > 20
  • Your site appears but never wins

= Topics where you're visible but not competitive. These are content upgrade candidates.

Keyword Cannibalization Detector

Find queries where 2+ of your pages compete:

  • Same query appears with different URLs across time periods
  • Both pages rank 10-30 (neither wins)

= Merge or differentiate those pages.


Output Format

Site Health Summary

Site: yourdomain.com | Period: Last 90 days
Total Clicks: XX,XXX | Impressions: XXX,XXX | Avg CTR: X.X% | Avg Position: XX.X

Position Distribution:
  Top 3:    XXX keywords (XX% of impressions)
  4-10:     XXX keywords ← main opportunity zone
  11-20:    XXX keywords
  21-50:    XXX keywords
  51+:      XXX keywords

Traffic trend: [↑ stable / ↓ dropped X% on YYYY-MM-DD / ↗ growing]

Top 3 Quick Wins

Always output these — the highest-ROI actions based on real data:

  1. [Keyword] — Position X.X, XXX impressions/mo, CTR X.X% (expected X%)

    • Fix: Rewrite title tag to better match search intent
    • Estimated impact: +XX clicks/mo
  2. [Page URL] — Ranking for XX queries in position 4-15

    • Fix: Add internal links from high-authority pages
    • Estimated impact: 1-3 position improvement
  3. [Topic] — XX queries, avg position 25, you're visible but losing

    • Fix: Upgrade content depth/structure
    • Estimated impact: Enter top 10 within 60 days

Traffic Drop Report (if applicable)

Drop detected: YYYY-MM-DD | Before: XXX clicks/day | After: XXX clicks/day (-XX%)

Affected pages (top 5 by traffic lost):
1. /page-url — lost XX clicks/day
2. ...

Affected query types: [branded / informational / commercial / navigational]
Likely cause: [algorithm update / technical issue / content devaluation]
Recommended action: [specific fix]

Integration with Other Skills

  • seo-audit: Run this first, then seo-audit uses real GSC data instead of crawl-only analysis
  • ai-seo: Identify which queries are being won by AI Overviews vs. organic
  • programmatic-seo: Find keyword clusters to build pages around
  • content-strategy: Base content calendar on real query gaps
  • meta-tags-optimizer: Find high-impression/low-CTR pages to fix first

References


Related Skills

  • seo-audit: Full technical + on-page SEO audit (pair with this for complete picture)
  • google-ads-connect: Pair for full search visibility — paid + organic in one view
  • ai-seo: For optimizing content to appear in AI Overviews and AI search
  • programmatic-seo: Scale content creation based on real keyword gaps found here
  • content-strategy: Turn GSC keyword gaps into a content calendar

Version History

  • fc642b4 Current 2026-07-11 16:57

Same Skill Collection

skills/copy-editing/SKILL.md
skills/getxapi-connect/SKILL.md
skills/launch-strategy/SKILL.md
skills/marketing-psychology/SKILL.md
skills/referral-program/SKILL.md
skills/x-twitter-connect/SKILL.md
skills/ab-test-setup/SKILL.md
skills/ad-creative/SKILL.md
skills/ai-seo/SKILL.md
skills/analytics-tracking/SKILL.md
skills/churn-prevention/SKILL.md
skills/cold-email/SKILL.md
skills/competitor-alternatives/SKILL.md
skills/content-strategy/SKILL.md
skills/copywriting/SKILL.md
skills/email-sequence/SKILL.md
skills/form-cro/SKILL.md
skills/free-tool-strategy/SKILL.md
skills/google-ads-connect/SKILL.md
skills/lead-magnets/SKILL.md
skills/marketing-ideas/SKILL.md
skills/meta-ads-connect/SKILL.md
skills/onboarding-cro/SKILL.md
skills/page-cro/SKILL.md
skills/paid-ads/SKILL.md
skills/paywall-upgrade-cro/SKILL.md
skills/popup-cro/SKILL.md
skills/pricing-strategy/SKILL.md
skills/product-marketing-context/SKILL.md
skills/programmatic-seo/SKILL.md
skills/revops/SKILL.md
skills/sales-enablement/SKILL.md
skills/schema-markup/SKILL.md
skills/seo-audit/SKILL.md
skills/signup-flow-cro/SKILL.md
skills/site-architecture/SKILL.md
skills/social-content/SKILL.md

Metadata

Files
0
Version
fc642b4
Hash
a9b7f969
Indexed
2026-07-11 16:57

Главная - Вики-сайт
Copyright © 2011-2026 iteam. Current version is 2.155.2. UTC+08:00, 2026-07-12 16:14
浙ICP备14020137号-1 $Гость$