pain-point-marketing-loop/SKILL.md
Use when implementing low-cost user acquisition through social media pain point analysis, content creation, and traffic conversion loops
npx skillsauth add atxinsky/skills pain-point-marketing-loopInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
Systematic methodology for identifying user pain points through social media analysis, creating targeted solutions, and building conversion funnels with minimal cost. Core principle: Find real pain → Create authentic solutions → Convert through value exchange.
When NOT to use:
# Search social platforms for pain points
keywords = ["35岁", "焦虑", "工作累回家更累", "中年危机"]
platforms = ["小红书", "知乎", "抖音", "B站"]
# Collect high-engagement comments (likes > threshold)
pain_points = collect_comments(keywords, min_likes=10, count=100)
# Feed to AI for pain point extraction
prompt = f"分析这些用户评论,找出最痛的三点:\n{pain_points}"
top_pain_points = ai_analyze(prompt, model="claude-3")
# Generate comprehensive solutions
for pain in top_pain_points:
report = ai_generate_solution_report(pain, format="PDF")
mindmap = ai_generate_mindmap(pain, format="XMind")
# Reply to original comments with personalized solutions
for comment in high_engagement_comments:
personalized_reply = customize_solution(comment, user_profile)
reply_to_comment(comment, personalized_reply)
# Free value exchange builds trust
if user_requests_resource:
send_free_resource(user)
add_to_nurture_list(user)
# 2-3 days later, soft promotion
post_friends_circle(soft_ad_copy, target_audience)
| Demographic | Common Pain Points | Solution Type | |------------|-------------------|---------------| | 35岁职场人 | 工作疲惫、家庭压力、精力不足 | 精力恢复、时间管理 | | 宝妈 | 育儿焦虑、自我价值、社交孤立 | 亲子关系、自我成长 | | 创业者 | 资金压力、决策焦虑、人脉拓展 | 商业思维、资源整合 | | 学生党 | 学习压力、职业迷茫、人际关系 | 学习方法、生涯规划 |
痛点提取Prompt:
分析以下用户评论,找出最普遍、最深刻的三个痛点:
[粘贴评论内容]
请按重要性排序,给出具体表现和影响。
解决方案报告Prompt:
基于这个痛点:[痛点描述]
创建一个详细的解决方案报告,包含:
1. 痛点分析
2. 科学解决方案
3. 实施步骤
4. 预期效果
5. 注意事项
评论回复模板: "看到你的分享,很有共鸣。我也经历过类似的情况。最近整理了一份关于[解决方案]的资料,帮我改善了很多。[个性化建议]。如果需要,可以私信我免费领取。"
Problem: "我觉得你说的对,我也这样" - 被平台限流 Fix: 个性化回复,提具体建议或共鸣点
Problem: 直接推销产品,用户反感 Fix: 先提供价值,建立信任,2-3天后软推广
Problem: 只收集20条评论,痛点不准 Fix: 最少100条,覆盖不同时间段和平台
Problem: 发了资料就没了,用户流失 Fix: 建立用户群或邮件列表,持续提供价值
Case Study - 精力恢复报告:
Key Success Factors:
development
Use this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scratch or from other data sources; or convert between tabular file formats. Trigger especially when the user references a spreadsheet file by name or path — even casually (like "the xlsx in my downloads") — and wants something done to it or produced from it. Also trigger for cleaning or restructuring messy tabular data files (malformed rows, misplaced headers, junk data) into proper spreadsheets. The deliverable must be a spreadsheet file. Do NOT trigger when the primary deliverable is a Word document, HTML report, standalone Python script, database pipeline, or Google Sheets API integration, even if tabular data is involved.
testing
Use when creating new skills, editing existing skills, or verifying skills work before deployment
development
Use when you have a spec or requirements for a multi-step task, before touching code
documentation
Create detailed implementation plan with bite-sized tasks