Requirements
- Target platform
- OpenClaw
- Install method
- Manual import
- Extraction
- Extract archive
- Prerequisites
- OpenClaw
- Primary doc
- SKILL.md
Social 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.
Social 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.
This item's current download entry is known to bounce back to a listing or homepage instead of returning a package file.
Use the source page and any available docs to guide the install because the item currently does not return a direct package file.
I tried to install a skill package from Yavira, but the item currently does not return a direct package file. Inspect the source page and any extracted docs, then tell me what you can confirm and any manual steps still required.
I tried to upgrade a skill package from Yavira, but the item currently does not return a direct package file. Compare the source page and any extracted docs with my current installation, then summarize what changed and what manual follow-up I still need.
Campaign performance analysis with engagement metrics, ROI calculations, and platform benchmarks.
Analysis Workflow Engagement Metrics ROI Calculation Platform Benchmarks Tools Examples
Analyze social media campaign performance: Validate input data completeness (reach > 0, dates valid) Calculate engagement metrics per post Aggregate campaign-level metrics Calculate ROI if ad spend provided Compare against platform benchmarks Identify top and bottom performers Generate recommendations Validation: Engagement rate < 100%, ROI matches spend data
FieldRequiredDescriptionplatformYesinstagram, facebook, twitter, linkedin, tiktokposts[]YesArray of post dataposts[].likesYesLike/reaction countposts[].commentsYesComment countposts[].reachYesUnique users reachedposts[].impressionsNoTotal viewsposts[].sharesNoShare/retweet countposts[].savesNoSave/bookmark countposts[].clicksNoLink clickstotal_spendNoAd spend (for ROI)
Before analysis, verify: Reach > 0 for all posts (avoid division by zero) Engagement counts are non-negative Date range is valid (start < end) Platform is recognized Spend > 0 if ROI requested
Engagement Rate = (Likes + Comments + Shares + Saves) / Reach × 100
MetricFormulaInterpretationEngagement RateEngagements / Reach × 100Audience interaction levelCTRClicks / Impressions × 100Content click appealReach RateReach / Followers × 100Content distributionVirality RateShares / Impressions × 100Share-worthinessSave RateSaves / Reach × 100Content value
RatingEngagement RateActionExcellent> 6%Scale and replicateGood3-6%Optimize and expandAverage1-3%Test improvementsPoor< 1%Analyze and pivot
Calculate return on ad spend: Sum total engagements across posts Calculate cost per engagement (CPE) Calculate cost per click (CPC) if clicks available Estimate engagement value using benchmark rates Calculate ROI percentage Validation: ROI = (Value - Spend) / Spend × 100
MetricFormulaCost Per Engagement (CPE)Total Spend / Total EngagementsCost Per Click (CPC)Total Spend / Total ClicksCost Per Thousand (CPM)(Spend / Impressions) × 1000Return on Ad Spend (ROAS)Revenue / Ad Spend
ActionValueRationaleLike$0.50Brand awarenessComment$2.00Active engagementShare$5.00AmplificationSave$3.00Intent signalClick$1.50Traffic value
ROI %RatingRecommendation> 500%ExcellentScale budget significantly200-500%GoodIncrease budget moderately100-200%AcceptableOptimize before scaling0-100%Break-evenReview targeting and creative< 0%NegativePause and restructure
PlatformAverageGoodExcellentInstagram1.22%3-6%>6%Facebook0.07%0.5-1%>1%Twitter/X0.05%0.1-0.5%>0.5%LinkedIn2.0%3-5%>5%TikTok5.96%8-15%>15%
PlatformAverageGoodExcellentInstagram0.22%0.5-1%>1%Facebook0.90%1.5-2.5%>2.5%LinkedIn0.44%1-2%>2%TikTok0.30%0.5-1%>1%
PlatformAverageGoodFacebook$0.97<$0.50Instagram$1.20<$0.70LinkedIn$5.26<$3.00TikTok$1.00<$0.50 See references/platform-benchmarks.md for complete benchmark data.
python scripts/calculate_metrics.py assets/sample_input.json Calculates engagement rate, CTR, reach rate for each post and campaign totals.
python scripts/analyze_performance.py assets/sample_input.json Generates full performance analysis with ROI, benchmarks, and recommendations. Output includes: Campaign-level metrics Post-by-post breakdown Benchmark comparisons Top performers ranked Actionable recommendations
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: Engagement rate 8.36% vs 1.22% benchmark = Excellent (6.8x above average) CTR 1.55% vs 0.22% benchmark = Excellent (7x above average) ROI 660% = Outstanding return on $500 spend Recommendation: Scale budget, replicate successful elements
references/platform-benchmarks.md contains: Engagement rate benchmarks by platform and industry CTR benchmarks for organic and paid content Cost benchmarks (CPC, CPM, CPE) Content type performance by platform Optimal posting times and frequency ROI calculation formulas
Engagement rate below platform average → Content isn't resonating. Analyze top performers for patterns. Follower growth stalled → Content distribution or frequency issue. Audit posting patterns. High impressions, low engagement → Reach without resonance. Content quality issue. Competitor outperforming significantly → Content gap. Analyze their successful posts.
When you ask for...You get..."Social media audit"Performance analysis across platforms with benchmarks"What's performing?"Top content analysis with patterns and recommendations"Competitor social analysis"Competitive social media comparison with gaps
All output passes quality verification: Self-verify: source attribution, assumption audit, confidence scoring Output format: Bottom Line → What (with confidence) → Why → How to Act Results only. Every finding tagged: 🟢 verified, 🟡 medium, 🔴 assumed.
social-content: For creating social posts. Use this skill for analyzing performance. campaign-analytics: For cross-channel analytics including social. content-strategy: For planning social content themes. marketing-context: Provides audience context for better analysis.
Data access, storage, extraction, analysis, reporting, and insight generation.
Largest current source with strong distribution and engagement signals.