Tabellab
Marketing Analytics Intermediate

Push Notifications & In-App Messaging: Opt-In Rates, Send-Time Tests, Open & Direct Conversion, Frequency Caps, Opt-Out & Uninstall Risk and Triggered Retention

Run a push and in-app messaging programme by the numbers. You will measure opt-in rates by platform, test when to ask for permission, check delivery, open and direct conversion rates and in-app message formats, run send-time tests and decide whether a lift is real, track opt-outs and uninstalls, find the best frequency cap and apply it to a send plan, rank competing messages, separate incremental from reported orders with holdouts, measure message-triggered retention, price the audience you lose, forecast the reachable audience, clean the token list, build a cap-versus-send-time scenario grid and finish with a full programme dashboard, in 20 hands-on labs, fictional Sablewood Kitchen 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

This course teaches you to run a push notification and in-app messaging programme with a spreadsheet. The fictional company is Sablewood Kitchen, a meal-planning and grocery app, and every lab uses a new data set from its programme. In the 20 hands-on labs you calculate opt-in rates by platform, compare ways of asking for permission, check delivery, open and direct conversion rates, compare in-app message formats, rank send hours and test whether a lift is real. You then count opt-outs and uninstalls, evaluate a frequency-cap test, apply caps to a send plan, rank competing messages, use holdouts to separate incremental from reported orders, measure retention, price the audience you lose, forecast the reachable audience, clean the token list and build a scenario grid. A final dashboard joins it all. The Coach checks every formula as you type. All companies, campaigns and numbers are fictional and illustrative.

Lessons

  1. Opt-In Rates by Platform: Prompt Rate, Opt-In of Prompted Users, Opt-In of All Users and the Blended Push AudienceLabFree
  2. Permission Prompt Timing: Opt-In Rate, Lift in Percentage Points, Relative Lift and Extra Opt-Ins per 10,000 UsersLab Locked
  3. Delivery Rate and Reach: Sent vs Delivered, Not-Delivered Counts, an Alert Level and Delivery by PlatformLab Locked
  4. Open Rate and Direct Conversion: Opens per Delivered, Orders per Open, Revenue per 1,000 Delivered and Triggered vs BroadcastLab Locked
  5. In-App Messages: Tap Rate, Dismiss Rate, Orders per 1,000 Impressions, Ranking and a Dismiss-Rate LimitLab Locked
  6. Send-Time Test by Hour: Open Rate, Orders per 1,000 Delivered, Ranking, the Best Hour and the Shape of the DayLab Locked
  7. Opt-Out Rates: Opt-Outs per 1,000 Delivered, a Review Limit, Weighted Programme Rate and Conditional FormattingLab Locked
  8. Uninstall Risk: Uninstall Rate by Exposure Band, Excess over a Baseline, Extra Uninstalls and a Warning CurveLab Locked
  9. Frequency Caps: Contribution per User, Opt-Out Cost per User, Net Value per User and the Best Weekly CapLab Locked
  10. Applying Caps to a Send Plan: Cap Lookup by Tier, MIN Rule, Suppressed Messages and Capped SegmentsLab Locked
  11. Message Priority: Expected Value per Send, Ranking Competing Messages, a Slot Cap and the Value of What Is Left OutLab Locked
  12. Is the Lift Real? Pooled Rate, Standard Error, z Value, p-Value and Verdict for Send-Time TestsLab Locked
  13. Holdout Tests: Treated vs Holdout Rate, Incremental Buyers, Incremental Share of Reported Orders and Cost per Incremental BuyerLab Locked
  14. Message-Triggered Retention: Retention Curves, Lift in Points, Relative Lift and Extra Retained UsersLab Locked
  15. Triggered vs Broadcast Messages: Incremental Contribution, Cost, Net, Ranking and Return per $1 by KindLab Locked
  16. Net Campaign Value: Contribution, Opt-Out Cost, Stop-or-Keep Decision and Break-Even Excess Opt-OutsLab Locked
  17. Reachable Audience Forecast: Closing Base, Average Loss Rate, FORECAST.LINEAR for New Opt-Ins and a Twelve-Month LineLab Locked
  18. Token Hygiene: Days Since Last Open, Token Classification, Reachable Count and Share and a Formula RuleLab Locked
  19. Scenario Grid: Weekly Net Value by Cap and Send-Time Uplift, Mixed References, Best Cap per Scenario and a Heat MapLab Locked
  20. Final Project: Push Programme Dashboard with Rates, Incremental Contribution, Opt-Out Cost, Net, Cumulative Net and a Combo 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