How to Analyse Performance of Festive & Event Posts

🎯 Objective:

To evaluate the effectiveness of festive and event-based content across all platforms by tracking defined metrics and identifying top-performing themes for quarterly strategy improvement.

🛠️ Tools Required:

Google Sheet – Performance Tracker
Robin Reach – Platform-level analytics
Native Insights – Instagram, Facebook, LinkedIn, X (Twitter), Threads
Slack / Email – For report sharing and review

👥 Roles & Responsibilities:

Role	Responsibility
Social Media Executive	Gathers and logs performance data into the tracker
Marketing Manager	Reviews insights, identifies winners/losers, and updates strategy if needed

📅 Frequency:

Quarterly Review (Once every 3 months)
Data for each festive/event post to be reviewed and consolidated quarterly

📋 Step-by-Step Process:

✅ Step 1: Maintain Festive Post Tracker in Google Sheets

Create a tab named:
📄 Festive & Event Post Performance – Q[1/2/3/4] 2025

Columns to include:

Column Name	Description
Festival Name	Diwali, Holi, etc.
Date Posted	DD-MM-YYYY
Platform	IG / FB / X / LI / Threads
Format	Feed / Story / Reel
Reach	Total users reached
Engagement	Likes + Comments + Shares
Saves	Number of saves/bookmarks
Link Clicks	If CTA was present
Follower Growth	New followers gained within 48h
Creative Link	Canva file link
Caption	Copy used
Notes	High-performing elements or reasons for underperformance

✅ Step 2: Gather Metrics

Log into Robin Reach for consolidated post performance or Native Insights

✅ Step 3: Enter Data in Sheet

For each post:
- Add one row per platform (e.g., Diwali post across 5 platforms = 5 rows)
- Ensure creative link and caption are attached
- Add notes on any anomalies (e.g., boosted, manually uploaded, etc.)

✅ Step 4: Quarterly Comparative Analysis

At the end of each quarter:

Sort by Engagement and Reach to find:
- Top 3 Highest Performing Posts
- 3 Lowest Performing Posts
Compare by:
- Format (static vs. reel)
- Platform (e.g., IG vs. X)
- Hook style (Offer-based vs. Emotional)
- Festival type (Cultural vs. Global vs. Environmental)

✅ Step 5: Share Insights with Marketing Manager

Prepare a 1-pager or summary at the end of the sheet:
- What worked (hooks, visuals, platforms)
- What didn’t work (timing, CTA, visuals)
- Recommendations for next quarter
Share via Slack or Email with subject:
🧾 Qx Festive Post Performance Summary – [Quarter Range]

✅ Notes:

Ignore boosted posts in comparative analysis unless all posts are paid
Reels/Stories should be tracked separately when native data is available
Focus more on actionable insights rather than just numbers
Adjust creative or caption strategy based on learnings (e.g., more local hooks, bolder CTA, time changes)