skills.rest
peter-tu-zynkr
peter-tu-zynkrCOMMUNITY
Explore all skills by this author →
GitHub

seo-program-planner

Orchestrates program-scale SEO strategy planning into a 14-section plan Doc and 9-tab keyword Sheet.

21|3|Updated Mar 6, 2026
Search Tags:#content strategy#keyword research#openpyxl#seo#google sheets#aeo#backlog planning
One-click install
npx skills add https://github.com/peter-tu-zynkr/zynkr-skill-builder --skill seo-program-planner-peter-tu-zynkr
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: seo-program-planner
Source: https://github.com/peter-tu-zynkr/zynkr-skill-builder/tree/main/skills/1-brand-marketing/seo-program-planner
Command: npx skills add https://github.com/peter-tu-zynkr/zynkr-skill-builder --skill seo-program-planner-peter-tu-zynkr

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve? Planning SEO for an entire product or website is usually ad-hoc and unrepeatable. This Skill turns whole-program SEO strategy into a structured, gated workflow that produces two durable deliverables: a 14-section plan Google Doc and a 9-tab keyword/topic Google Sheet, then hands the resulting topic backlog to a per-article writing pipeline. ## Core Features & Use Cases - Ten-stage orchestration: Reuses existing single-topic seo-* skills (persona builder, question miner, angle finder, keyword mapper, classifier, demand validator) at program scale, then adds program-level synthesis for pillars, IA decisions, money pages, AEO citation gaps, CTA ladders, KPIs, and governance. - Dual deliverables: Assembles a 14-section plan Doc via import_to_google_doc into a Drive strategy bucket and builds a 9-tab .xlsx workbook with openpyxl, imported to Google Sheets as the machine-readable backlog. - HITL gates and guardrails: Stops for confirmation at every stage, enforces shipped-capability-only marketing, signal-based demand claims, and zh-TW house style. - Use Case: Hand it a product URL and money pages, and it reverse-engineers personas, builds a program-wide keyword pool, sequences a win-first topic backlog, and files the plan Doc and keyword Sheet to Drive before handing topics to seo-article-pipeline. ## Quick Start Ask the assistant to plan the complete SEO program for your product or website, providing the live URL, money pages, target audience, and category point of view.

Frequently Asked Questions about seo-program-planner

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

FAQPage Schema
How do I plan an SEO strategy for an entire website?▼

Provide the product intake (live URL, money pages, audience, category POV) and the planner runs ten gated stages: persona reverse-engineering, program-wide keyword research, pillar and IA synthesis, backlog convergence, and deliverable assembly into a plan Doc and keyword Sheet.

What is the difference between seo-program-planner and seo-article-pipeline?▼

seo-program-planner operates upstream at program scale, producing the strategy, keyword pool, and topic backlog for a whole product. seo-article-pipeline consumes one backlog topic at a time and writes it through to publish.

How does the keyword Sheet get created in Google Sheets?▼

The planner builds a nine-tab .xlsx workbook locally with openpyxl, one worksheet per tab with styled headers, then imports it via import_to_google_sheets into the designated Drive folder and records the Sheet id in the plan Doc appendix.

Does the planner invent search volume numbers for keywords?▼

No. Demand is recorded only as signal plus basis, such as forum threads or support tickets. Any unverified demand figure is tagged 待驗證, and fabricating search volumes is treated as the highest-severity error.

What happens if a money page is not indexable?▼

The tech-SEO recon stage checks noindex headers, SSR versus client rendering, meta, canonical, schema, and sitemap presence. Pages failing hard-block checks are flagged for remediation and excluded as conversion targets until fixed.

When should I not use program-scale SEO planning?▼

Skip it when you only need one article written from an already-chosen topic; that belongs to seo-article-pipeline. It is also unnecessary when you only need keyword expansion for a single topic, which seo-keyword-mapper handles.

Related Skills

Explore More Marketing & Sales Skills→
lucasreydmanlucasreydman

lloyd

Generate a structured summary of live L.L.O.Y.D. configuration and skills.

Community
Intermediate
TereseSongTereseSong
1

wechat-article-writer

Automate WeChat Official Account article creation from research to publication.

Community
Advanced
portermetricsampleportermetricsample
17

seo-lever-finder

Generate prioritized SEO content strategies from Product, Audience, Use case, and Competitor levers.

Community
Intermediate
KaiBoo404KaiBoo404

content-strategy

Plan content strategy by outlining pillars, topic clusters, and editorial calendars.

Community
Advanced