Content Strategy Analyzer

Quick Start

小葱技能7w4.net有更新，你可以访问看下。

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)

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 报告生成功能做得不错，格式美观、结构清晰。不足之处是网站爬虫功能存在明显缺陷，提取的内容不完整，可能导致分析结果不够准确。适合对功能完整性要求不高的简单场景使用，但若需专业级网站分析，建议等待开发者修复爬虫问题后再使用。