Back to Details

social-media-analyzer

Compare original and translation side by side

🇺🇸

Original

English
🇨🇳

Translation

Chinese

Social Media Campaign Analyzer

社交媒体营销活动分析工具

This skill provides comprehensive analysis of social media campaign performance, helping marketing agencies deliver actionable insights to clients.
本Skill可对社交媒体营销活动表现进行全面分析，帮助营销机构为客户提供可落地的洞察建议。

Capabilities

核心能力

  • Multi-Platform Analysis: Track performance across Facebook, Instagram, Twitter, LinkedIn, TikTok
  • Engagement Metrics: Calculate engagement rate, reach, impressions, click-through rate
  • ROI Analysis: Measure cost per engagement, cost per click, return on ad spend
  • Audience Insights: Analyze demographics, peak engagement times, content performance
  • Trend Detection: Identify high-performing content types and posting patterns
  • Competitive Benchmarking: Compare performance against industry standards
  • 多平台分析：追踪Facebook、Instagram、Twitter、LinkedIn、TikTok等平台的表现
  • 参与度指标计算：计算参与率、触达量、曝光量、点击率
  • ROI分析：衡量每次参与成本、每次点击成本、广告支出回报率
  • 受众洞察：分析受众 demographics（人口统计特征）、参与高峰时段、内容表现
  • 趋势识别：定位高表现内容类型和发布规律
  • 竞品基准对比：将表现与行业标准进行对比

Input Requirements

输入要求

Campaign data including:
  • Platform metrics: Likes, comments, shares, saves, clicks
  • Reach data: Impressions, unique reach, follower growth
  • Cost data: Ad spend, campaign budget (for ROI calculations)
  • Content details: Post type (image, video, carousel), posting time, hashtags
  • Time period: Date range for analysis
Formats accepted:
  • JSON with structured campaign data
  • CSV exports from social media platforms
  • Text descriptions of key metrics
需提供的营销活动数据包括：
  • 平台指标：点赞、评论、分享、收藏、点击量
  • 触达数据：曝光量、独立触达量、粉丝增长量
  • 成本数据：广告支出、营销活动预算（用于ROI计算）
  • 内容详情：帖子类型（图片、视频、轮播图）、发布时间、话题标签
  • 时间范围：分析的日期区间
支持的格式：
  • 结构化营销活动数据的JSON文件
  • 社交媒体平台导出的CSV文件
  • 关键指标的文字描述

Output Formats

输出格式

Results include:
  • Performance dashboard: Key metrics with trends
  • Engagement analysis: Best and worst performing posts
  • ROI breakdown: Cost efficiency metrics
  • Audience insights: Demographics and behavior patterns
  • Recommendations: Data-driven suggestions for optimization
  • Visual reports: Charts and graphs (Excel/PDF format)
分析结果包含：
  • 表现仪表盘：带趋势的核心指标汇总
  • 参与度分析：表现最佳与最差的帖子
  • ROI细分：成本效率指标
  • 受众洞察：人口统计特征与行为模式
  • 优化建议：基于数据的营销优化方案
  • 可视化报告：图表与图形（Excel/PDF格式）

How to Use

使用方式

"Analyze this Facebook campaign data and calculate engagement metrics" "What's the ROI on this Instagram ad campaign with $500 spend and 2,000 clicks?" "Compare performance across all social platforms for the last month"
"分析这份Facebook营销活动数据并计算参与度指标" "这个投入500美元、获得2000次点击的Instagram广告活动ROI是多少？" "对比过去一个月所有社交平台的营销表现"

Scripts

脚本文件

  • calculate_metrics.py
    : Core calculation engine for all social media metrics
  • analyze_performance.py
    : Performance analysis and recommendation generation
  • calculate_metrics.py
    ：所有社交媒体指标的核心计算引擎
  • analyze_performance.py
    ：表现分析与优化建议生成工具

Best Practices

最佳实践

  1. Ensure data completeness before analysis (missing metrics affect accuracy)
  2. Compare metrics within same time periods for fair comparisons
  3. Consider platform-specific benchmarks (Instagram engagement differs from LinkedIn)
  4. Account for organic vs. paid metrics separately
  5. Track metrics over time to identify trends
  6. Include context (seasonality, campaigns, events) when interpreting results
  1. 分析前确保数据完整（缺失指标会影响准确性）
  2. 对比相同时间区间的指标以保证公平性
  3. 考虑平台专属基准（Instagram的参与度与LinkedIn存在差异）
  4. 区分自然流量与付费流量指标
  5. 长期追踪指标以识别趋势
  6. 解读结果时结合场景（季节性、营销活动、事件等）

Limitations

局限性

  • Requires accurate data from social media platforms
  • Industry benchmarks are general guidelines and vary by niche
  • Historical data doesn't guarantee future performance
  • Organic reach calculations may vary by platform algorithm changes
  • Cannot access data directly from platforms (requires manual export or API integration)
  • Some platforms limit data availability (e.g., TikTok analytics for business accounts only)
  • 需要来自社交媒体平台的准确数据
  • 行业基准为通用指南，不同细分领域存在差异
  • 历史数据无法保证未来表现
  • 自然触达量的计算可能随平台算法更新而变化
  • 无法直接从平台获取数据（需手动导出或API集成）
  • 部分平台限制数据获取（如仅TikTok商业账号可查看分析数据）