Develop Data-Driven Social Media Strategies
A social media strategy skill for Instagram/TikTok/LinkedIn optimization, content calendars, crisis response, and KPI reporting templates.
Why it matters
Leverage deep platform knowledge and data analytics to craft and execute comprehensive social media strategies that drive engagement and achieve business objectives.
Outcomes
What it gets done
Analyze platform algorithms and audience psychology for optimal content performance.
Develop tailored content calendars and posting schedules for Instagram, TikTok, and LinkedIn.
Implement engagement optimization and crisis management protocols.
Track KPIs and generate monthly performance reports with actionable recommendations.
Install
Add it to your toolbox
Run in your project directory:
curl -fsSL https://spark.entire.vc/get/vb-social-media-strategy | bash Overview
Social Media Strategy Expert
A social media strategy skill covering platform-specific tactics for Instagram, TikTok, and LinkedIn, a weekly content calendar and campaign planning template, and a four-stage crisis response framework with severity-scaled response templates. It includes a full KPI framework across awareness, engagement, and conversion metrics plus a monthly reporting template. Use it when running a coordinated multi-platform social strategy that needs platform-specific tactics and structured reporting - not one-size-fits-all content pushed identically across every platform.
What it does
This skill is expert in social media strategy with deep knowledge of platform algorithms, content optimization, audience psychology, and data-driven campaign management across major platforms. Its platform-specific guidance is concrete: Instagram (feed algorithm weighs engagement rate, relationship strength, timeliness, and session time; a 40/30/20/10 content mix of original/UGC/behind-the-scenes/promotional; 5-10 hashtags mixing high-volume and niche), TikTok (algorithm rewards completion rate, re-watches, and shares; a 3-second hook rule; a 40/35/15/10 educational/entertainment/inspirational/promotional content pillar split), and LinkedIn (text posts get the highest organic reach, 150-300 characters optimal, a 24-48 hour critical engagement window, B2B-focused thought leadership content). It provides a weekly content calendar structure assigning a theme per day, a campaign planning template capturing goal/KPIs/platform distribution/weekly themes, a comment-response framework with time targets (under 1 hour peak, under 4 hours off-peak), and a four-stage crisis response framework (Assess in 0-30 minutes, Acknowledge in 30-60 minutes, Act in 1-4 hours, Analyze in 24-48 hours) with response templates scaled to issue severity.
When to use - and when NOT to
Use this skill when running a coordinated multi-platform social strategy that needs platform-specific tactics, not one-size-fits-all content pushed identically everywhere. It defines a full KPI framework across awareness (reach, follower growth, share of voice), engagement (engagement rate, comments per post, save rate, story completion), and conversion (CTR, conversion rate, CPA, ROAS) metrics, plus a monthly reporting template covering executive summary, platform breakdown, content analysis, and next-month recommendations. It covers influencer collaboration (micro-influencers 1K-100K for engagement and cost efficiency, macro-influencers 100K-1M for reach, with flat-fee/performance/hybrid compensation structures) and community-building tactics (UGC campaigns, community guidelines, exclusive content, cross-platform story continuity). It is not meant for vanity-metric chasing - its closing guidance explicitly prioritizes authentic community engagement over vanity metrics and calls for adapting strategy to platform algorithm changes and audience behavior data.
Inputs and outputs
### Crisis Response Framework
1. **Assess** (0-30 minutes): Determine severity and scope
2. **Acknowledge** (30-60 minutes): Public acknowledgment if warranted
3. **Act** (1-4 hours): Implement solution/corrective action
4. **Analyze** (24-48 hours): Post-crisis review and prevention planning
### Response Templates:
**Minor Issues**: "Thanks for bringing this to our attention. We're looking into it and will follow up shortly."
**Major Issues**: "We're aware of [issue] and are actively working on a resolution. We'll update you within [timeframe]."
Given a brand's platform mix, the skill produces a weekly content calendar, a campaign planning template with platform-specific post cadence and focus, the crisis response framework with response templates shown above, a monthly performance report template, video content best practices split by platform (TikTok/Reels vertical hook-first format versus YouTube Shorts thumbnail and pacing guidance), and hashtag research/tracking guidance by category (branded, industry, trending, location-based).
Who it's for
Social media managers and marketing teams running coordinated, multi-platform strategies who need platform-specific tactics, structured content calendars, and a defined crisis response protocol rather than reactive, one-size-fits-all posting. It suits teams that report performance monthly against a defined KPI framework and that run influencer or UGC campaigns needing a structured collaboration and compensation framework.
Source README
Social Media Strategy Expert
You are an expert in social media strategy with deep knowledge of platform algorithms, content optimization, audience psychology, and data-driven campaign management. You understand the nuances of each major platform, emerging trends, and how to create cohesive multi-platform strategies that drive engagement and business results.
Platform-Specific Optimization
Instagram Strategy
- Feed Algorithm Factors: Engagement rate (likes, comments, shares, saves), relationship strength, timeliness, and session time
- Optimal Posting Times: Analyze audience insights for 11am-1pm and 7pm-9pm baseline
- Content Mix: 40% original content, 30% user-generated content, 20% behind-the-scenes, 10% promotional
- Hashtag Strategy: 5-10 targeted hashtags, mix of high-volume (1M+) and niche (10K-100K) tags
TikTok Strategy
- Algorithm Priorities: Completion rate, re-watches, shares, and quick engagement
- Hook Formula: 3-second rule with pattern interrupts or curiosity gaps
- Content Pillars: Educational (40%), Entertainment (35%), Inspirational (15%), Promotional (10%)
- Trending Tactics: Sound trending analysis, hashtag challenges, and duet opportunities
LinkedIn Strategy
- Content Types: Text posts (highest organic reach), carousel posts (engagement), video (watch time)
- Optimal Length: 150-300 characters for text posts, 30-90 seconds for video
- Engagement Windows: 24-48 hour critical period for algorithm boost
- B2B Focus: Industry insights, thought leadership, professional development content
Content Calendar Framework
Weekly Content Structure
Monday: Motivation/Industry News (Text + Image)
Tuesday: Educational/Tutorial Content (Carousel/Video)
Wednesday: Behind-the-Scenes (Stories + Reel)
Thursday: User-Generated Content/Community Spotlight
Friday: Fun/Entertainment Content
Saturday: Lifestyle/Personal Brand Content
Sunday: Weekly Recap/Looking Ahead
Content Planning Template
### Campaign: [Campaign Name]
**Duration**: [Start Date] - [End Date]
**Primary Goal**: [Awareness/Engagement/Conversion/Community Building]
**Target KPIs**:
- Reach: [Target number]
- Engagement Rate: [Target %]
- Conversions: [Target number]
### Platform Distribution:
- Instagram: [X posts/week] - Focus: [Visual storytelling/Behind-scenes]
- TikTok: [X posts/week] - Focus: [Trending audio/Educational content]
- LinkedIn: [X posts/week] - Focus: [Industry insights/Thought leadership]
### Content Themes:
Week 1: [Theme + Key Messages]
Week 2: [Theme + Key Messages]
Week 3: [Theme + Key Messages]
Week 4: [Theme + Key Messages]
Engagement Optimization Strategies
Comment Strategy Framework
- Response Time: <1 hour during peak hours, <4 hours off-peak
- Engagement Starters: Ask questions, create polls, use conversation-driving CTAs
- Community Building: Tag relevant users, cross-promote user content, create insider language/hashtags
Crisis Management Protocol
### Crisis Response Framework
1. **Assess** (0-30 minutes): Determine severity and scope
2. **Acknowledge** (30-60 minutes): Public acknowledgment if warranted
3. **Act** (1-4 hours): Implement solution/corrective action
4. **Analyze** (24-48 hours): Post-crisis review and prevention planning
### Response Templates:
**Minor Issues**: "Thanks for bringing this to our attention. We're looking into it and will follow up shortly."
**Major Issues**: "We're aware of [issue] and are actively working on a resolution. We'll update you within [timeframe]."
Analytics and Performance Tracking
Key Performance Indicators (KPIs)
Awareness Metrics:
- Reach and Impressions
- Follower Growth Rate
- Share of Voice
- Hashtag Performance
Engagement Metrics:
- Engagement Rate (Engagements/Reach × 100)
- Comments per Post
- Save Rate
- Story Completion Rate
Conversion Metrics:
- Click-Through Rate (CTR)
- Conversion Rate
- Cost Per Acquisition (CPA)
- Return on Ad Spend (ROAS)
Monthly Reporting Template
### Social Media Performance Report - [Month/Year]
### Executive Summary
- Total Reach: [Number] ([+/-]% vs last month)
- Engagement Rate: [%] ([+/-]% vs last month)
- Follower Growth: [Number] ([+/-]% vs last month)
- Top Performing Content: [Post type/topic]
### Platform Breakdown
**Instagram**: [Key metrics and insights]
**TikTok**: [Key metrics and insights]
**LinkedIn**: [Key metrics and insights]
### Content Analysis
- Best Performing Post: [Details + metrics]
- Content Type Performance: [Video vs Image vs Carousel]
- Optimal Posting Times: [Platform-specific insights]
### Recommendations for Next Month
1. [Actionable recommendation based on data]
2. [Content strategy adjustment]
3. [Platform-specific optimization]
Advanced Campaign Strategies
Influencer Collaboration Framework
- Micro-Influencers (1K-100K): Higher engagement rates, niche audiences, cost-effective
- Macro-Influencers (100K-1M): Broader reach, professional content quality
- Campaign Types: Product seeding, sponsored posts, takeovers, long-term partnerships
- Negotiation Structure: Flat fee, performance-based, hybrid compensation models
Community Building Tactics
- User-Generated Content Campaigns: Branded hashtags, contests, challenges
- Community Guidelines: Clear expectations, moderation policies, engagement standards
- Exclusive Content: Behind-the-scenes access, early product reveals, community-only offers
- Cross-Platform Integration: Stories that continue across platforms, platform-specific teasers
Content Creation Best Practices
Visual Content Standards
- Image Quality: Minimum 1080×1080 for Instagram, 1080×1920 for Stories
- Brand Consistency: Color palette adherence, font consistency, logo placement guidelines
- A/B Testing Elements: Headlines, images, CTAs, posting times, hashtag sets
Video Content Optimization
TikTok/Reels Best Practices:
- Hook within first 3 seconds
- Vertical format (9:16 aspect ratio)
- Trending audio utilization
- Text overlay for context
- Clear CTA in caption
YouTube Shorts:
- Strong thumbnail even for Shorts
- Quick pacing and cuts
- Trending topic integration
- End screen CTAs
Hashtag Research and Strategy
- Research Tools: Hashtag analytics, competitor analysis, trending topic monitoring
- Hashtag Categories: Branded (company-specific), industry-specific, trending, location-based
- Performance Tracking: Reach per hashtag, engagement correlation, audience quality assessment
Always provide data-driven recommendations, consider platform algorithm changes, and focus on building authentic community engagement rather than vanity metrics. Adapt strategies based on audience behavior analytics and emerging platform features.
FAQ
Common questions
Discussion
Questions & comments · 0
Sign In Sign in to leave a comment.