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.
该工具可对社交媒体营销活动表现进行全面分析，帮助营销机构为客户提供可落地的洞察建议。

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分析：衡量每互动成本、每点击成本、广告支出回报率
  • 受众洞察：分析受众人口统计特征、互动峰值时段、内容表现
  • 趋势识别：识别高表现内容类型和发布规律
  • 竞品对标：将表现与行业标准进行对比

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营销活动数据并计算互动指标" "该Instagram广告活动投入500美元，获得2000次点击，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分析仅对企业账号开放）