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

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

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)

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"

Scripts

• calculate_metrics.py : Core calculation engine for all social media metrics

• analyze_performance.py : Performance analysis and recommendation generation

Best Practices

• Ensure data completeness before analysis (missing metrics affect accuracy)

• Compare metrics within same time periods for fair comparisons

• Consider platform-specific benchmarks (Instagram engagement differs from LinkedIn)

• Account for organic vs. paid metrics separately

• Track metrics over time to identify trends

• Include context (seasonality, campaigns, events) when interpreting results

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)