Back to Details

gsc-assistant

Compare original and translation side by side

🇺🇸

Original

English
🇨🇳

Translation

Chinese

GSC Assistant Skill

GSC 索引助手技能

Purpose

用途

This skill helps manage Google Search Console indexing status by maintaining two markdown tracking files:
  1. indexed.md - All indexed pages in two tables:
    • "Indexed Public" - URLs confirmed in GSC export data
    • "Indexed With Lag" - URLs confirmed via URL Inspection (not yet in export)
  2. to-index.md - Pages awaiting indexing:
    • Difference between sitemap and total indexed URLs
    • Prioritized by categories (configurable)
    • Tracks submission dates
本技能通过维护两个Markdown跟踪文件，帮助管理Google Search Console（GSC）的索引状态：
  1. indexed.md - 包含两个表格的所有已索引页面：
    • "公开已索引" - 已在GSC导出数据中确认的URL
    • "延迟已索引" - 通过URL Inspection确认已索引（尚未出现在导出数据中）的URL
  2. to-index.md - 待索引页面：
    • 站点地图与总已索引URL的差值
    • 按类别划分优先级（可配置）
    • 跟踪提交日期

When to Use This Skill

使用场景

  • User asks about "indexing status" or "GSC indexing"
  • User wants to "compare sitemap with indexed pages"
  • User mentions "URL inspection" or "false positives"
  • User needs to "track submissions" or "indexing progress"
  • User asks to "move indexed pages" or "update indexing status"
  • User wants to "generate indexing report"
  • 用户询问"索引状态"或"GSC索引"相关问题
  • 用户想要"对比站点地图与已索引页面"
  • 用户提及"URL Inspection"或"误判项"
  • 用户需要"跟踪提交情况"或"索引进度"
  • 用户要求"迁移已索引页面"或"更新索引状态"
  • 用户想要"生成索引报告"

Key Concepts

核心概念

GSC Data Lag

GSC 数据延迟

Google Search Console export data has approximately 2 weeks lag. Pages that show as indexed in URL Inspection may not appear in the export yet. These are tracked separately as "Indexed With Lag".
Google Search Console的导出数据存在约2周的延迟。通过URL Inspection显示已索引的页面可能尚未出现在导出数据中，这类页面会被单独归类为"延迟已索引"进行跟踪。

False Positives

误判项

When checking to-index pages via URL Inspection:
  • If indexed: Mark as "false positive - indexed" in Submitted column
  • Pre-processing moves these to indexed.md (Indexed With Lag table)
  • The "Detected" date is inferred from when the entry was added to to-index
当通过URL Inspection检查待索引页面时：
  • 若已索引：在"已提交"列标记为"false positive - indexed"
  • 预处理会将这些页面移至indexed.md的"延迟已索引"表格
  • "检测日期"为该条目被添加至to-index.md的日期

Priority Categories

优先级分类

to-index.md organizes pages by priority:
  • Priority 1: High-value content series
  • Priority 2: Recent content (current/previous year)
  • Priority 3: Specific content collections
  • Lower priorities: Archive pages, pagination, etc.
to-index.md按优先级对页面进行分类：
  • 优先级1：高价值内容系列
  • 优先级2：近期内容（当年/上一年）
  • 优先级3：特定内容合集
  • 低优先级：归档页面、分页页面等

File Schemas

文件结构

indexed.md

indexed.md

markdown
undefined
markdown
undefined

Indexed Pages

Indexed Pages

Indexed Public (GSC Export)

Indexed Public (GSC Export)

Last updated: YYYY-MM-DD Source: gsc-export.csv
#URLLast Crawled
1https://example.com/page-1/2025-12-01
2https://example.com/page-2/2025-12-02
Last updated: YYYY-MM-DD Source: gsc-export.csv
#URLLast Crawled
1https://example.com/page-1/2025-12-01
2https://example.com/page-2/2025-12-02

Indexed With Lag (URL Inspection Confirmed)

Indexed With Lag (URL Inspection Confirmed)

Pages confirmed indexed via URL Inspection but not yet in GSC export
#URLDetectedConfirmed
1https://example.com/new-page/12 Dec 202512 Dec 2025
undefined
Pages confirmed indexed via URL Inspection but not yet in GSC export
#URLDetectedConfirmed
1https://example.com/new-page/12 Dec 202512 Dec 2025
undefined

to-index.md

to-index.md

markdown
undefined
markdown
undefined

Pages To Index

Pages To Index

Generated: YYYY-MM-DD Total: X pages
Generated: YYYY-MM-DD Total: X pages

Priority 1: [Category Name]

Priority 1: [Category Name]

#URLSubmitted
1https://example.com/important-page/12 Dec
2https://example.com/another-page/-
#URLSubmitted
1https://example.com/important-page/12 Dec
2https://example.com/another-page/-

Priority 2: [Category Name]

Priority 2: [Category Name]

#URLSubmitted
1https://example.com/recent-post/-
undefined
#URLSubmitted
1https://example.com/recent-post/-
undefined

Workflow

工作流程

Initial Setup

初始设置

  1. Import GSC export CSV to create indexed.md (Indexed Public table)
  2. Extract sitemap URLs
  3. Calculate difference (sitemap - indexed = to-index)
  4. Categorize to-index pages by priority
  5. Generate to-index.md
  1. 导入GSC导出的CSV文件，创建indexed.md的"公开已索引"表格
  2. 提取站点地图中的URL
  3. 计算差值（站点地图URL - 已索引URL = 待索引URL）
  4. 按优先级对待索引页面进行分类
  5. 生成to-index.md

Regular Updates

常规更新

  1. Pre-processing: Scan to-index.md for "false positive - indexed" entries
  2. Move false positives to indexed.md (Indexed With Lag table)
  3. Set "Detected" date from when entry was in to-index
  4. Set "Confirmed" date to current date
  5. Remove from to-index.md
  6. Update counts and statistics
  1. 预处理：扫描to-index.md中的"false positive - indexed"条目
  2. 将误判项移至indexed.md的"延迟已索引"表格
  3. 将"检测日期"设置为该条目在to-index.md中的添加日期
  4. 将"确认日期"设置为当前日期
  5. 从to-index.md中删除该条目
  6. 更新计数和统计数据

Manual Operations

手动操作

  • Mark submissions: Update "Submitted" column with date
  • Check status: Use URL Inspection, mark result
  • Refresh data: Import new GSC export, recalculate
  • 标记提交：在"已提交"列更新日期
  • 检查状态：使用URL Inspection，标记结果
  • 刷新数据：导入新的GSC导出文件，重新计算

Configuration

配置

Create working files in project directory:
project/
├── gsc-export.csv          # GSC indexed pages export
├── sitemap.xml             # Site sitemap (or use dist/sitemap.xml)
├── indexed.md              # Tracking file (generated)
└── to-index.md             # Tracking file (generated)
在项目目录中创建工作文件：
project/
├── gsc-export.csv          # GSC indexed pages export
├── sitemap.xml             # Site sitemap (or use dist/sitemap.xml)
├── indexed.md              # Tracking file (generated)
└── to-index.md             # Tracking file (generated)

Commands

命令

Generate Initial Files

生成初始文件

"Generate indexing tracking files from GSC export and sitemap"
"Generate indexing tracking files from GSC export and sitemap"

Pre-process False Positives

预处理误判项

"Process false positives and update indexed list"
"Process false positives and update indexed list"

Update Submission Status

更新提交状态

"Mark [URL] as submitted on [date]"
"Mark [URL] as submitted on [date]"

Refresh From New Export

从新导出文件刷新

"Update indexed list from new GSC export"
"Update indexed list from new GSC export"

Generate Statistics

生成统计数据

"Show indexing progress statistics"
"Show indexing progress statistics"

Statistics Output

统计输出

INDEXING STATUS SUMMARY
=======================

Indexed Public (GSC):     789 pages
Indexed With Lag:          12 pages
Total Indexed:            801 pages

Sitemap Total:          2,054 pages
To Index:               1,253 pages

Progress:                 39.0%

By Priority:
- Priority 1: 55 remaining (4 false positives moved)
- Priority 2: 7 remaining
- Priority 3: 290 remaining
INDEXING STATUS SUMMARY
=======================

Indexed Public (GSC):     789 pages
Indexed With Lag:          12 pages
Total Indexed:            801 pages

Sitemap Total:          2,054 pages
To Index:               1,253 pages

Progress:                 39.0%

By Priority:
- Priority 1: 55 remaining (4 false positives moved)
- Priority 2: 7 remaining
- Priority 3: 290 remaining

Example Usage

使用示例

User: "I just checked some URLs in GSC URL Inspection and marked them as false positive - indexed. Process those and update the tracking files."
Claude will:
  1. Scan to-index.md for entries with "false positive - indexed"
  2. Extract those URLs and their original detection dates
  3. Add them to indexed.md Indexed With Lag table
  4. Remove them from to-index.md
  5. Update row numbers and counts
  6. Report changes made
用户："我刚刚在GSC URL Inspection中检查了一些URL，并将它们标记为false positive - indexed。请处理这些条目并更新跟踪文件。"
Claude将执行以下操作：
  1. 扫描to-index.md中的"false positive - indexed"条目
  2. 提取这些URL及其原始检测日期
  3. 将它们添加至indexed.md的"延迟已索引"表格
  4. 从to-index.md中删除这些条目
  5. 更新行号和计数
  6. 报告所做的更改