Tabellab

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.

20 lessons 20 labs Certificate

  • 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

  1. Giveaway Entry Rate: Entries ÷ Reach, Totals and the Difference Between a Pooled and an Average RateLabFree
  2. Entry Mechanics Compared: Count, Entries and Entry Rate per Mechanic with COUNTIF and SUMIFS, and a RankingLab Locked
  3. Cost per Entry: Prize, Shipping, Ads and Staff Time Added into a Total Cost, per Giveaway and for the ProgrammeLab Locked
  4. Cost per New Follower: Net New Followers, Normal Growth as a Baseline and the Cost per Attributable FollowerLab Locked
  5. Follower Retention After the Giveaway: 30- and 90-Day Retention, Cost per Retained Follower and Lost FollowersLab Locked
  6. Prize Budget: Prize Cost per Giveaway, a Cap from the Target Cost per Entry, Share of the Budget and What Is LeftLab Locked
  7. A Fair Winner Draw with RAND: One Random Number per Eligible Entry, a Draw Rank and a Look-Up of the WinnersLab Locked
  8. Cleaning Entries Before the Draw: Repeat Entries, Eligibility Rules with AND and the Valid Entry CountLab Locked
  9. Bonus Entries and Weighted Draws: Tickets per Entrant, First Ticket Numbers, Chance to Win and the Winning TicketLab Locked
  10. Odds of Winning and the Value of an Entry: Chance per Entry, "1 in N", Expected Value and the Chance with Several EntriesLab Locked
  11. The Rules Checklist: Points per Check, a Checklist Score, Open Must-Haves and Highlighting the GapsLab Locked
  12. Entry Sources and Entry Quality: Valid Entries per Source, Valid Rate and Cost per Valid EntryLab Locked
  13. Spotting Low-Quality Entries: Warning Signs per Entry, Keep / Review / Remove Rules and the Cost per Clean EntryLab Locked
  14. Co-Hosted Giveaways: Cost Share, Follower Share and Cost per New Follower for Each PartnerLab Locked
  15. The Entry Curve: Daily Entries, Cumulative Total, Share by Day and a Linear Forecast of the Final TotalLab Locked
  16. Engagement Around a Giveaway: Engagement Rate per Post, Averages Before, During and After, and the Post-Giveaway DipLab Locked
  17. From Entries to Customers: Code Redemption Rate, Net Revenue after Discount, Net Result, Cost per New Customer and ROILab Locked
  18. What Is a Retained Follower Worth? Break-Even Value, Net Value over a Horizon, a Verdict and Months to Pay BackLab Locked
  19. What-If Grid: Cost per Entry for Different Prize Costs and Entry Volumes, Break-Even Entries and the Highest Affordable PrizeLab Locked
  20. Final Project: A Giveaway Scorecard with Retention, Cost per Retained Follower, a Ranking, a Colour Rule and a ChartLab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy