topical-map

Builds SEO topical maps through a 10-step workflow with Excel exports and content tracking.

Updated Feb 5, 2026
One-click install
npx skills add https://github.com/binhnndigital/batch-watermark --skill topical-map-binhnndigital
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: topical-map
Source: https://github.com/binhnndigital/batch-watermark/tree/main/skills/topical-map
Command: npx skills add https://github.com/binhnndigital/batch-watermark --skill topical-map-binhnndigital

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, openpyxl, and includes scripts (resource) components.

What problem does it solve? Planning a comprehensive SEO content strategy requires structuring dozens of articles into a coherent topical map, tracking which articles are written, and ensuring proper internal linking—work that is error-prone when done manually in spreadsheets. ## Core Features & Use Cases - 10-Step Guided Workflow: Walks from business input gathering through Core/Outer section generation, coverage review, master plan creation, and data-driven content production. - Excel-Based Project Management: Exports core-section.xlsx, outer-section.xlsx, and master-plan.xlsx with Title, Description, Main Keyword, URL, and Internal Links columns. - Context Loading Scripts: Python utilities load project context from Excel, find articles by fuzzy title matching, auto-detect projects, and check writing progress. - Use Case: A content marketer building topical authority for a coffee e-commerce site uses this Skill to generate a 50+ article map, export the master plan, then write each article with the correct keyword, meta description, and internal links pulled directly from the Excel files. ## Quick Start Ask the AI to create a topical map for your business by providing your product, target audience, revenue model, and unique selling proposition.

Frequently Asked Questions about topical-map

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I create a topical map for SEO?

Follow the 10-step workflow: provide your business model, audience, revenue mechanism, and USP, then confirm the proposed Central Entity. The Skill generates Core and Outer sections, exports them to Excel, and builds a master plan with internal links before content production begins.

How many articles should an SEO topical map include?

The Outer Section must contain a minimum of 50 articles to establish topical authority and semantic breadth. The coverage review step checks whether the map meets this threshold and suggests additional angles if it falls short.

How do I track which articles are already written?

Run the check_progress function with your project name. It compares the master-plan.xlsx URLs against markdown files in the project's content folder and reports completed count plus the next titles to write.

What Python dependencies does the topical map script need?

The load_project_context.py script requires pandas for reading Excel files, plus openpyxl as pandas' Excel engine. It also uses standard library modules os, glob, and difflib for file handling and fuzzy title matching.

Can the script find an article if I only remember part of the title?

Yes, find_article_context and find_project_by_title use fuzzy matching via difflib SequenceMatcher with a 0.6 similarity threshold, plus exact and substring matching, to locate articles from partial titles.