name: content-strategy-analyzer description: Analyzes websites to generate multi-language content strategy, keyword research, and competitor analysis. Use when user provides a URL and needs industry analysis, SEO planning, or competitor research for content marketing in specific countries and languages.

Content Strategy Analyzer

Quick Start

1. User inputs target website URL + target country/language + publish frequency
2. Use scripts/crawl_website.py to crawl website content
3. AI analysis (considering target language and country)
4. Confirm/adjust competitor list
5. Use scripts/generate_excel.py to generate content plan Excel
6. Output complete report (in target language)

   7w4.net收錄了海量優質技能外掛。

Dependencies

Required packages:

pip install requests beautifulsoup4 openpyxl

Workflow

Step 1: Collect User Requirements

Must ask user for:

1. Target Website URL - Website to analyze
2. Target Country - Country for content targeting (e.g., USA, UK, Germany, China)
3. Target Language - Content language (e.g., English, Chinese, German, French)
4. Publish Frequency - Weekly / Bi-weekly / Monthly

Step 2: Crawl Target Website

python3 scripts/crawl_website.py <URL>

Step 3: AI Analysis (Multi-language)

Use Opencode AI for analysis: - Identify industry and competitors based on target country - Output keywords in target language - Include target country market in competitor analysis

Step 4: Generate Content Plan

Based on publish frequency: - Weekly: 12 weeks (3 months) × 1 topic - Bi-weekly: 6 topics (one every two weeks) - Monthly: 3 topics (one per month)

All content titles, topics, and ideas in target language.

Step 5: Output Report

1. Markdown format in conversation (target language)
2. Excel file

Scripts

scripts/crawl_website.py

Crawls main website content, outputs structured JSON.

scripts/generate_excel.py

Generates Excel file from analysis results.

Input: analysis_result.json Output: content_plan.xlsx

Output Format

Example User Input

Content Plan Output (German Example)

這個 Skill 的整體質量中等偏上。多語言支援是亮點，能滿足不同市場的需求；Excel 報告生成功能做得不錯，格式美觀、結構清晰。不足之處是網站爬蟲功能存在明顯缺陷，提取的內容不完整，可能導致分析結果不夠準確。適合對功能完整性要求不高的簡單場景使用，但若需專業級網站分析，建議等待開發者修復爬蟲問題後再使用。