social-media-analyzer

Calculate engagement rates, ROI, and benchmark social media campaign metrics.

Updated Mar 12, 2026
One-click install
npx skills add https://github.com/Fantasia1999/claude-skills-zh --skill social-media-analyzer-fantasia1999
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: social-media-analyzer
Source: https://github.com/Fantasia1999/claude-skills-zh/tree/main/translations/marketing-skill/social-media-analyzer
Command: npx skills add https://github.com/Fantasia1999/claude-skills-zh --skill social-media-analyzer-fantasia1999

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires pandas, numpy, and includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

This Skill analyzes social media campaign performance, calculates engagement rates and ROI, and provides benchmarks for improvement.

Core Features & Use Cases

  • Engagement Metrics: Calculates likes, comments, shares, reach, and engagement rates.
  • ROI Calculation: Determines the return on investment for paid social media campaigns.
  • Platform Benchmarking: Compares performance against industry averages for platforms like Instagram, Facebook, and TikTok.
  • Use Case: Analyze a recent Instagram ad campaign to understand its engagement rate, calculate its ROI, and see how it stacks up against the platform's average performance.

Quick Start

Analyze the performance of the provided Instagram posts, including engagement rate and ROI if spend is available.

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 and ROI for my ad campaigns?

To calculate social media engagement rate and ROI, input post metrics like likes, comments, reach, shares, and total ad spend. The tool processes this data to compute performance values and compare them against platform benchmarks for actionable insights.

What is social media benchmarking and how does it evaluate campaign performance?

Social media benchmarking is the process of comparing your calculated engagement rates and ROI against platform industry averages. It evaluates campaign performance by identifying whether your metrics fall above or below standard benchmarks for platforms like Instagram, Facebook, and TikTok.

Can I analyze Instagram and TikTok ad performance using Python and pandas?

Yes, you can analyze Instagram and TikTok ad performance using Python scripts powered by pandas and numpy. The analysis requires inputting available post metrics to calculate engagement rates and determine the return on investment for paid campaigns.

How do I measure social media ROI when total ad spend data is available?

To measure social media ROI when ad spend data is available, provide total ad spend alongside organic post metrics. The calculation evaluates the financial return of your paid campaigns and generates recommendations for performance optimization.

What is the best way to track social media performance metrics across multiple platforms?

The best way to track social media performance metrics is to aggregate post metrics including likes, comments, shares, reach, and clicks. Using Python scripts to process this data allows you to calculate engagement rates and compare results against specific platform benchmarks.

Why do I need numpy and pandas for social media analytics?

You need numpy and pandas for social media analytics because these Python libraries provide the core data manipulation and numerical calculation capabilities required to process large sets of post metrics and compute complex engagement rate and ROI formulas.