social-media-analyzerSocial media campaign analysis and performance tracking. Calculates engagement rates, ROI, and benchmarks across platforms. Use for analyzing social media performance, calculating engagement rate, measuring campaign ROI, comparing platform metrics, or benchmarking against industry standards.
Install via ClawdBot CLI:
clawdbot install alirezarezvani/social-media-analyzerCampaign performance analysis with engagement metrics, ROI calculations, and platform benchmarks.
Analyze social media campaign performance:
| Field | Required | Description |
|-------|----------|-------------|
| platform | Yes | instagram, facebook, twitter, linkedin, tiktok |
| posts[] | Yes | Array of post data |
| posts[].likes | Yes | Like/reaction count |
| posts[].comments | Yes | Comment count |
| posts[].reach | Yes | Unique users reached |
| posts[].impressions | No | Total views |
| posts[].shares | No | Share/retweet count |
| posts[].saves | No | Save/bookmark count |
| posts[].clicks | No | Link clicks |
| total_spend | No | Ad spend (for ROI) |
Before analysis, verify:
Engagement Rate = (Likes + Comments + Shares + Saves) / Reach Γ 100| Metric | Formula | Interpretation |
|--------|---------|----------------|
| Engagement Rate | Engagements / Reach Γ 100 | Audience interaction level |
| CTR | Clicks / Impressions Γ 100 | Content click appeal |
| Reach Rate | Reach / Followers Γ 100 | Content distribution |
| Virality Rate | Shares / Impressions Γ 100 | Share-worthiness |
| Save Rate | Saves / Reach Γ 100 | Content value |
| Rating | Engagement Rate | Action |
|--------|-----------------|--------|
| Excellent | > 6% | Scale and replicate |
| Good | 3-6% | Optimize and expand |
| Average | 1-3% | Test improvements |
| Poor | < 1% | Analyze and pivot |
Calculate return on ad spend:
| Metric | Formula |
|--------|---------|
| Cost Per Engagement (CPE) | Total Spend / Total Engagements |
| Cost Per Click (CPC) | Total Spend / Total Clicks |
| Cost Per Thousand (CPM) | (Spend / Impressions) Γ 1000 |
| Return on Ad Spend (ROAS) | Revenue / Ad Spend |
| Action | Value | Rationale |
|--------|-------|-----------|
| Like | $0.50 | Brand awareness |
| Comment | $2.00 | Active engagement |
| Share | $5.00 | Amplification |
| Save | $3.00 | Intent signal |
| Click | $1.50 | Traffic value |
| ROI % | Rating | Recommendation |
|-------|--------|----------------|
| > 500% | Excellent | Scale budget significantly |
| 200-500% | Good | Increase budget moderately |
| 100-200% | Acceptable | Optimize before scaling |
| 0-100% | Break-even | Review targeting and creative |
| < 0% | Negative | Pause and restructure |
| Platform | Average | Good | Excellent |
|----------|---------|------|-----------|
| Instagram | 1.22% | 3-6% | >6% |
| Facebook | 0.07% | 0.5-1% | >1% |
| Twitter/X | 0.05% | 0.1-0.5% | >0.5% |
| LinkedIn | 2.0% | 3-5% | >5% |
| TikTok | 5.96% | 8-15% | >15% |
| Platform | Average | Good | Excellent |
|----------|---------|------|-----------|
| Instagram | 0.22% | 0.5-1% | >1% |
| Facebook | 0.90% | 1.5-2.5% | >2.5% |
| LinkedIn | 0.44% | 1-2% | >2% |
| TikTok | 0.30% | 0.5-1% | >1% |
| Platform | Average | Good |
|----------|---------|------|
| Facebook | $0.97 | <$0.50 |
| Instagram | $1.20 | <$0.70 |
| LinkedIn | $5.26 | <$3.00 |
| TikTok | $1.00 | <$0.50 |
See references/platform-benchmarks.md for complete benchmark data.
python scripts/calculate_metrics.py assets/sample_input.jsonCalculates engagement rate, CTR, reach rate for each post and campaign totals.
python scripts/analyze_performance.py assets/sample_input.jsonGenerates full performance analysis with ROI, benchmarks, and recommendations.
Output includes:
See assets/sample_input.json:
{
"platform": "instagram",
"total_spend": 500,
"posts": [
{
"post_id": "post_001",
"content_type": "image",
"likes": 342,
"comments": 28,
"shares": 15,
"saves": 45,
"reach": 5200,
"impressions": 8500,
"clicks": 120
}
]
}See assets/expected_output.json:
{
"campaign_metrics": {
"total_engagements": 1521,
"avg_engagement_rate": 8.36,
"ctr": 1.55
},
"roi_metrics": {
"total_spend": 500.0,
"cost_per_engagement": 0.33,
"roi_percentage": 660.5
},
"insights": {
"overall_health": "excellent",
"benchmark_comparison": {
"engagement_status": "excellent",
"engagement_benchmark": "1.22%",
"engagement_actual": "8.36%"
}
}
}The sample campaign shows:
references/platform-benchmarks.md contains:
Generated Mar 1, 2026
A local retail store runs a holiday Instagram campaign with multiple posts. They need to calculate engagement rates to see which content resonated most, compare performance against industry benchmarks, and determine if their ad spend yielded a positive ROI to inform future budget decisions.
A digital marketing agency manages social media for a tech startup across Facebook, LinkedIn, and Twitter. They use this skill to aggregate metrics from all platforms, generate standardized reports with ROI calculations, and provide actionable recommendations to optimize client campaigns based on benchmark comparisons.
An influencer on TikTok and Instagram collaborates with brands and needs to analyze post-by-post engagement metrics like virality and save rates. They use the skill to demonstrate value to sponsors by calculating ROI from sponsored content and benchmarking their performance against platform averages to justify rates.
A large corporation runs simultaneous campaigns on LinkedIn and Facebook to promote a new product. They leverage this skill to compare CTR and engagement rates across platforms, identify top-performing content types, and allocate resources efficiently based on ROI analysis and platform-specific benchmarks.
A non-profit organization launches a social media campaign to raise awareness on Facebook and Instagram. They use the skill to track engagement rates and reach, calculate cost per engagement to assess budget efficiency, and benchmark against industry standards to gauge campaign effectiveness for grant reporting.
Offer this skill as part of a subscription-based social media analytics platform. Users pay monthly for access to automated reports, benchmark comparisons, and ROI calculations, with tiered pricing based on data volume or number of platforms analyzed.
Digital marketing agencies integrate this skill into their service packages to provide detailed performance analyses for clients. It enhances value propositions by delivering data-driven insights, with revenue generated through bundled service fees or as a standalone consulting offering.
Freelancers and independent consultants use this skill to offer social media analysis as a service. They charge per campaign or hourly for generating reports, calculating ROI, and providing optimization recommendations, leveraging the skill to streamline their workflow and attract small business clients.
π¬ Integration Tip
Integrate this skill with data sources like social media APIs (e.g., Meta Business Suite, LinkedIn Analytics) to automate input data collection, reducing manual entry and ensuring real-time analysis for faster decision-making.
Terminal Spotify playback/search via spogo (preferred) or spotify_player.
Search GIF providers with CLI/TUI, download results, and extract stills/sheets.
Download videos from YouTube, Bilibili, Twitter, and thousands of other sites using yt-dlp. Use when the user provides a video URL and wants to download it, extract audio (MP3), download subtitles, or select video quality. Triggers on phrases like "δΈθ½½θ§ι’", "download video", "yt-dlp", "YouTube", "Bη«", "ζι³", "ζει³ι’", "extract audio".
Search and add movies to Radarr. Supports collections, search-on-add option.
Control Spotify playback on macOS. Play/pause, skip tracks, control volume, play artists/albums/playlists. Use when a user asks to play music, control Spotify, change songs, or adjust Spotify volume.
Search and add TV shows to Sonarr. Supports monitor options, search-on-add.