skills.rest
bhaktofmahakal
bhaktofmahakalCOMMUNITY
Explore all skills by this author →
WebsiteGitHub

social-media-analyzer

Analyzes social media campaign metrics and calculates engagement rates, CTR, and ROI.

2|1|Updated Jan 29, 2026
Search Tags:#social media#benchmarking#marketing analytics#roi#campaign analysis#engagement rate
One-click install
npx skills add https://github.com/bhaktofmahakal/ai-counsellor-hf --skill social-media-analyzer-bhaktofmahakal
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: social-media-analyzer
Source: https://github.com/bhaktofmahakal/ai-counsellor-hf/tree/main/.claude/skills/social-media-analyzer
Command: npx skills add https://github.com/bhaktofmahakal/ai-counsellor-hf --skill social-media-analyzer-bhaktofmahakal

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) components.

What problem does it solve? Marketing teams struggle to turn raw social media campaign data into actionable insights, often manually calculating engagement rates, ROI, and benchmarks across multiple platforms. ## Core Features & Use Cases - Multi-Platform Metrics Calculation: Computes engagement rate, CTR, reach, and impressions for Facebook, Instagram, Twitter, LinkedIn, and TikTok campaigns. - ROI & Cost Analysis: Calculates cost per engagement, cost per click, and ROI percentage from ad spend data. - Benchmark Comparison & Recommendations: Compares performance against industry benchmarks and generates optimization recommendations. - Use Case: A marketing agency exports Instagram campaign data (likes, reach, clicks, $500 spend) and receives a full performance report showing 8.36% engagement rate, 660% ROI, top-performing posts, and scaling recommendations. ## Quick Start Analyze this Instagram campaign data with $500 ad spend and calculate the engagement rate, ROI, and top performing posts.

Frequently Asked Questions about social-media-analyzer

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I calculate social media engagement rate?▼

Engagement rate is calculated by dividing total engagements (likes, comments, shares, saves) by total reach, then multiplying by 100. The calculate_metrics.py script automates this per post and across entire campaigns.

How to calculate ROI for a social media ad campaign?▼

ROI is computed by subtracting ad spend from estimated engagement value, dividing by spend, and multiplying by 100. The calculator uses an average value of $2.50 per engagement and also reports cost per engagement and cost per click.

What social media platforms does this analysis support?▼

The analyzer supports Facebook, Instagram, Twitter, LinkedIn, and TikTok, each with platform-specific industry benchmarks for engagement rate and CTR. Campaign data must be exported manually or via API since direct platform access is not included.

What input data format is needed for campaign analysis?▼

Input requires JSON or CSV with platform name, total ad spend, and per-post metrics including likes, comments, shares, saves, reach, impressions, and clicks. A sample_input.json file demonstrates the expected structure.

What are the limitations of social media benchmark comparisons?▼

Industry benchmarks are general guidelines that vary by niche, and historical data does not guarantee future performance. Organic reach calculations may shift with platform algorithm changes, and some platforms like TikTok restrict analytics to business accounts.

Related Skills

Explore More Marketing & Sales Skills→
hongmaple0820hongmaple0820
9

social-media-analyzer

Analyze social media campaign engagement, ROI, and platform benchmarks.

Community
Intermediate
faionfaionfaionfaion
4

faion-ppc-manager

Manage and optimize PPC campaigns across Google Ads and Meta Ads.

Community
Advanced
AradotsoAradotso
8

powerbi-campaign-roi-analyzer

Analyzes social campaign ROI and audience demographics using Power BI dashboards.

Official
Advanced
Growth4U-systemsGrowth4U-systems

metricool

Schedule and manage social media posts via the Metricool API.

Official
Intermediate