name: reddit-bot triggers: "reddit, subreddit, reddit comment, reddit marketing, reddit analytics, reddit post, reddit engagement, reddit bot, comment performance, carpet bomb, sniper strategy" description: "Reddit marketing automation — comment engagement, subreddit discovery, Supabase analytics, and performance tracking."
Reddit Bot Skill
Auto-activate for Reddit marketing tasks, analytics checks, or subreddit discovery.
Quick Operations
| What | Command |
|---|---|
| Status overview | "Check Reddit bot status" |
| Active targets | Query targets table (is_active=true) |
| Run analytics | "Pull Reddit analytics from Supabase" |
| Discover subs | "Find trending subreddits for our niche" |
| Run manual mode | python reddit_bot.py → manual mode |
| Run agent mode | python reddit_bot.py → agent mode |
| Run dynamic mode | python reddit_bot.py → dynamic mode |
| Check performance | check_comment_performance(days_back=7) |
Supabase Tables
| Table | Purpose |
|---|---|
targets | Subreddits + threads to monitor |
comments | Every comment posted (dedup: submission_id) |
comment_performance | Time-series engagement snapshots |
Analytics Views
v_latest_performance | v_subreddit_performance | v_strategy_performance | v_keyword_performance
Key Metrics
engagement_ratio= comment_score / thread_num_commentscontroversy_engagement= engagement_ratio × (1 + controversiality)- Watch for
comment_is_visible = false— adjust approach
Strategy Modes
- Manual: Keyword-match scan on curated subreddits
- Agent: Discovery + sniper on rising/hot posts
- Dynamic: Deduplicated union of both (no double-posting)
→ Full docs: .claude/commands/reddit-bot.md