Webinar & Virtual Event Funnels: Registrations, Show-Up Rates, Replays, Engagement and Cost per Lead
Plan and analyse online events: registrations by source, show-up rates by how early people signed up, reminder effects, replay views, engagement scores, pipeline and cost per attendee and lead, with every cell checked as you go.
One-time payment · lifetime access · lessons, labs, exam and certificate included · no subscription.
About this course
In this course you analyse the webinar series of a fictional software company in a spreadsheet. You turn page views, registrations, live attendees and leads into step rates, sum registrations and spend per channel with SUMIFS and work out the cost per registrant. You sort registrants into lead-time buckets with IFS, measure show-up rates with AVERAGEIFS and test the effect of an extra reminder. You add replay viewers to the live audience, build a weighted engagement score with SUMPRODUCT, follow leads into opportunities and won revenue with COUNTIFS, plan registrations backwards from a lead target with ROUNDUP and WORKDAY, and finish with a ranked series dashboard and a chart.
Lessons
- The Webinar Funnel: Page Views, Registrations, Attendees and Leads Pro
- Registration Sources: Registrations, Spend and Cost per Registrant by Channel Pro
- Show-Up Rates: Lead-Time Buckets and the Reminder Effect Pro
- Replays: Combined Reach, Replay Leads and Plays per Viewer Pro
- Engagement Scores: Weighted Points and Hot, Warm and Cold Attendees Pro
- From Leads to Pipeline: Opportunities, Won Revenue and Cost per Lead Pro
- Reverse Planning: Registrations Needed for a Lead Target and the Series Calendar Pro
- Capstone: Series Dashboard with Show-Up Rates, Cost per Lead, Ranks and a Chart Pro