keyword-research

What problem does it solve? Keyword research often produces scattered, inconsistently formatted results that are hard to act on. This Skill enforces a locked-in workflow that turns a single seed keyword into a strictly structured Excel workbook with prioritized keywords, topic clusters, and competitor gap analysis. ## Core Features & Use Cases - Structured Keyword Expansion: Generates exactly 300 keywords organized into 5 topic clusters, each with search intent, volume, keyword difficulty, CPC, parent topic, content type, and priority rating. - Competitor Landscape Analysis: Profiles the top 20 organic competitors with traffic share, traffic value, and domain rating, plus 20 keyword gap opportunities with recommended actions. - Deterministic Excel Output: A bundled Python script produces a three-tab .xlsx workbook with color-coded priority and difficulty columns, a cluster summary with totals, and strategic recommendations. - Use Case: A content marketer provides the seed keyword "email marketing software", selects the United States as the target country, and receives a formatted workbook ready to drive a content calendar and SEO strategy. ## Quick Start Conduct keyword research for the keyword "email marketing software" targeting the United States and create the keyword research Excel workbook.