← 返回 Skills 市场
yanzt

Content Strategy Analyzer

作者 yanzt · GitHub ↗ · v1.0.0
cross-platform ⚠ suspicious
419
总下载
0
收藏
0
当前安装
1
版本数
在 OpenClaw 中安装
/install content-strategy-analyzer
功能描述
Analyzes websites to generate multi-language content strategy, keyword research, and competitor analysis. Use when user provides a URL and needs industry ana...
使用说明 (SKILL.md)

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)

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 \x3CURL>

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

Parameter Value
URL https://example.com
Country Germany
Language German
Frequency Weekly

Content Plan Output (German Example)

Month Week Theme Title Type
Month 1 Week 1 Market Launch ... Article
安全使用建议
Before installing or running this skill, consider the following: - Clarify how the 'AI analysis' step is implemented: does it call an external 'Opencode AI' API? If so, ask the author for the endpoint and which credentials (API key) are required and why. The skill currently does not declare any env vars for that, which is an incoherence. - Review the two included scripts yourself. They are small and straightforward: crawl_website.py issues an HTTP GET to the target URL and saves a JSON, generate_excel.py reads local JSON and writes an Excel file. There is no hidden network exfiltration in the scripts as provided. - Note the crawler does not respect robots.txt or perform rate limiting. If you plan to crawl third-party sites, ensure you have permission and run it responsibly (or modify the script to check robots.txt and throttle requests). - Because the SKILL.md is vague about how keyword and competitor analysis are generated, confirm whether the agent will use your account/model (and any associated billing) or call an external API. If the agent will call an external service, restrict or inspect outbound network access and do not provide secrets until you verify the service. - If you will run this skill in a shared environment, consider executing it inside a sandbox/container and inspecting network traffic to confirm no unexpected endpoints are contacted. - If you need the full promised feature (multi-country AI-driven competitor analysis), request that the skill author either include the integration code (with secure credential handling) or update the documentation to explain how the AI analysis step is performed.
功能分析
Type: OpenClaw Skill Name: content-strategy-analyzer Version: 1.0.0 The skill is classified as suspicious due to significant vulnerabilities in its scripts. `scripts/crawl_website.py` is vulnerable to Server-Side Request Forgery (SSRF) as it fetches content from an arbitrary user-supplied URL without validation, potentially allowing access to internal network resources. `scripts/generate_excel.py` is vulnerable to path traversal, as it accepts arbitrary file paths for both input and output files via command-line arguments, which could lead to unauthorized reading or writing of files on the system.
能力评估
Purpose & Capability
The skill claims to perform AI analysis using 'Opencode AI' (identify industry/competitors, generate keywords by country/language), but none of the provided code calls any external AI API or mentions endpoints/credentials. The two included Python scripts only crawl the provided URL and generate an Excel from local JSON. Either the SKILL.md overclaims capabilities or it omits the integration code/credential requirements.
Instruction Scope
Runtime instructions are mostly constrained: ask user for URL/country/language/frequency, run crawl_website.py to save website_data.json, then run generate_excel.py to make an Excel. The 'AI analysis' step is vague and unspecified (no prompts, no API calls), giving the agent wide discretion about how to perform the analysis. The crawler does not check robots.txt or rate limiting, and some extraction fields are unimplemented (headings/content_blocks are empty), which are implementation details rather than direct red flags.
Install Mechanism
No install spec is provided (instruction-only), and the declared Python dependencies (requests, beautifulsoup4, openpyxl) are reasonable and proportional to crawling and Excel generation. No remote downloads or execution of external archives are present.
Credentials
The skill declares no required environment variables or credentials, yet the documentation explicitly names an external AI service ('Opencode AI') for analysis. If that service requires an API key or endpoint, the skill should declare and justify those env vars. Currently there's a mismatch between claimed use of an external AI provider and the lack of any credential/config requirements.
Persistence & Privilege
The skill does not request persistent installation, does not set always:true, and does not modify other skills or system-wide settings. It runs local scripts and writes local files (website_data.json, content_plan.xlsx) only, which is expected for its purpose.
如何使用
  1. 确保已安装 OpenClaw(本地或 Docker 部署)
  2. 在对话框中输入安装命令:/install content-strategy-analyzer
  3. 安装完成后,直接呼叫该 Skill 的名称或使用 /content-strategy-analyzer 触发
  4. 根据 Skill 的参数说明提供必要输入,即可获得结构化输出
版本历史
v1.0.0
Initial release - multi-language content strategy analyzer
元数据
Slug content-strategy-analyzer
版本 1.0.0
许可证
累计安装 0
当前安装数 0
历史版本数 1
常见问题

Content Strategy Analyzer 是什么?

Analyzes websites to generate multi-language content strategy, keyword research, and competitor analysis. Use when user provides a URL and needs industry ana... 它是一个面向 Claude Code / OpenClaw 的 AI Agent Skill 插件,目前累计下载 419 次。

如何安装 Content Strategy Analyzer?

在 OpenClaw 或 Claude Code 对话框中运行命令「/install content-strategy-analyzer」即可一键安装,无需额外配置。

Content Strategy Analyzer 是免费的吗?

是的,Content Strategy Analyzer 完全免费(开源免费),可自由下载、安装和使用。

Content Strategy Analyzer 支持哪些平台?

Content Strategy Analyzer 跨平台运行,可在任意部署了 OpenClaw / Claude Code 的环境中使用(cross-platform)。

谁开发了 Content Strategy Analyzer?

由 yanzt(@yanzt)开发并维护,当前版本 v1.0.0。

💬 留言讨论