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.
Hand the extracted package to your coding agent with a concrete install brief instead of figuring it out manually.
I downloaded a skill package from Yavira. Read SKILL.md from the extracted folder and install it by following the included instructions. Tell me what you changed and call out any manual steps you could not complete.
I downloaded an updated skill package from Yavira. Read SKILL.md from the extracted folder, compare it with my current installation, and upgrade it while preserving any custom configuration unless the package docs explicitly say otherwise. Summarize what changed and any follow-up checks I should run.
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.