Social Media Contests & Giveaways: Entry Rates, Cost per Entry & New Follower, Follower Retention, Prize Budgets & Fair Winner Draws
Run social media giveaways that earn their prize budget. You will turn reach and entries into entry rates, compare entry mechanics, price every entry and every new follower, separate attributable growth from normal growth, measure 30- and 90-day follower retention, plan the prize budget against a cap, draw winners fairly with RAND and weighted tickets, clean repeat and low-quality entries, score the official rules with a checklist, compare traffic sources and partner shares, read and forecast the daily entry curve, track engagement before and after, follow entrants into sales and ROI, value a retained follower, build a what-if grid and finish with a giveaway scorecard, in 20 hands-on labs, fictional outdoor-gear data, every cell checked as you go.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
About this course: Social Media Contests & Giveaways is a hands-on spreadsheet course for anyone who plans, runs or reports on social media giveaways. In 20 interactive labs you work for Kestrelwood Outdoor Co., a fictional online shop for camping and hiking gear. You calculate entry rates, compare entry mechanics, add up the full cost of a prize draw, price every entry and every attributable new follower, measure how many followers are still there after 30 and 90 days and plan a prize budget with a cap. You clean repeat and low-quality entries, draw winners fairly with random numbers and bonus tickets, work out the odds, score the official rules with a checklist and compare traffic sources and partners. Later labs forecast the daily entry curve, compare engagement before and after, follow entrants into sales and ROI, value a retained follower and build a what-if grid. A final scorecard and a 20-question exam lead to the certificate. The labs teach durable arithmetic and logic, not platform rules, which change. All companies, entries and numbers are fictional.
Lessons
- Giveaway Entry Rate: Entries ÷ Reach, Totals and the Difference Between a Pooled and an Average RateFree
- Entry Mechanics Compared: Count, Entries and Entry Rate per Mechanic with COUNTIF and SUMIFS, and a Ranking Locked
- Cost per Entry: Prize, Shipping, Ads and Staff Time Added into a Total Cost, per Giveaway and for the Programme Locked
- Cost per New Follower: Net New Followers, Normal Growth as a Baseline and the Cost per Attributable Follower Locked
- Follower Retention After the Giveaway: 30- and 90-Day Retention, Cost per Retained Follower and Lost Followers Locked
- Prize Budget: Prize Cost per Giveaway, a Cap from the Target Cost per Entry, Share of the Budget and What Is Left Locked
- A Fair Winner Draw with RAND: One Random Number per Eligible Entry, a Draw Rank and a Look-Up of the Winners Locked
- Cleaning Entries Before the Draw: Repeat Entries, Eligibility Rules with AND and the Valid Entry Count Locked
- Bonus Entries and Weighted Draws: Tickets per Entrant, First Ticket Numbers, Chance to Win and the Winning Ticket Locked
- Odds of Winning and the Value of an Entry: Chance per Entry, "1 in N", Expected Value and the Chance with Several Entries Locked
- The Rules Checklist: Points per Check, a Checklist Score, Open Must-Haves and Highlighting the Gaps Locked
- Entry Sources and Entry Quality: Valid Entries per Source, Valid Rate and Cost per Valid Entry Locked
- Spotting Low-Quality Entries: Warning Signs per Entry, Keep / Review / Remove Rules and the Cost per Clean Entry Locked
- Co-Hosted Giveaways: Cost Share, Follower Share and Cost per New Follower for Each Partner Locked
- The Entry Curve: Daily Entries, Cumulative Total, Share by Day and a Linear Forecast of the Final Total Locked
- Engagement Around a Giveaway: Engagement Rate per Post, Averages Before, During and After, and the Post-Giveaway Dip Locked
- From Entries to Customers: Code Redemption Rate, Net Revenue after Discount, Net Result, Cost per New Customer and ROI Locked
- What Is a Retained Follower Worth? Break-Even Value, Net Value over a Horizon, a Verdict and Months to Pay Back Locked
- What-If Grid: Cost per Entry for Different Prize Costs and Entry Volumes, Break-Even Entries and the Highest Affordable Prize Locked
- Final Project: A Giveaway Scorecard with Retention, Cost per Retained Follower, a Ranking, a Colour Rule and a Chart Locked
Learner reviews
Be the first to review this course.