Blog · Board and management reporting
Webinar sales conversion rates connect event registrants, attendees, qualified leads, and later customers. Use matched event and CRM exports to calculate each stage with a fixed follow-up window and reconcile the resulting bookings.
Webinar sales conversion rates measure how a defined event cohort progresses from registration to attendance, qualification, and later sales. Match event records to CRM records, fix the outcome window, and label the denominator for every rate. A high attendance rate and a high registration-to-sale rate describe different parts of the journey.
Use one row per person per event, identified by a stable contact key. Keep the registration timestamp, event date, attendance evidence, qualification date, and matched sales outcome. A company domain alone cannot show which registrant attended or became qualified.
For the worked example, attendance means the person joined the live event under the company's documented attendance rule. Qualification requires sales acceptance after attendance. A sale means a newly opened, event-sourced opportunity that reached closed-won within the event's follow-up window. Existing open opportunities are reported separately as influenced pipeline and do not enter this sourced-sale numerator.
The business also needs a crediting rule when someone attends several events. Assign each sourced opportunity to one event before adding booked amounts across events. Otherwise, the same sale can make several events appear to have generated the same dollars.
This example counts eligible outcomes from the event date through 60 calendar days afterward, including both boundary dates. An event on July 1, 2026, is observed through August 30, 2026; an event on July 15, 2026, through September 13, 2026. A report prepared on October 15, 2026, can compare both completed windows.
Prepare an Events sheet with event ID, contact key, event date, attended flag, qualified flag, buyer flag, and credited bookings. Prepare a separate CRM summary with one row per event-contact key, including the qualification and buyer flags and eligible booked amount.
That CRM summary must come from checked opportunity rows. Retain opportunity IDs, created dates, close dates, status, credited event, and amount so the summary can be traced back. A buyer flag is one even if a contact has several eligible wins; booked amounts may contain several distinct opportunities.
If event ID is in A2 and contact key in B2, make a composite key in H2:
=A2&"|"&B2
After preparing the same unique key in CRM!A2:A1000, pull its qualified flag from column B:
=XLOOKUP(H2,CRM!A$2:A$1000,CRM!B$2:B$1000,"Unmatched",0)
Google's XLOOKUP documentation specifies an exact match with match mode zero. Use the same pattern to retrieve the buyer flag and eligible booked amount from their respective summary columns. Review every unmatched key; an absent contact match is not proof of no sale.
Do not use a lookup against repeated raw opportunity keys and accept the first returned amount. Summarize eligible unique opportunities first, with the crediting rule and date window applied. A match establishes record identity; the source and date checks establish eligibility.
For a prepared file in Events!A2:G501, put the event ID in summary cell A2. Count registrations and attendance:
=COUNTIF(Events!A$2:A$501,$A2)
=COUNTIFS(Events!A$2:A$501,$A2,Events!D$2:D$501,1)
Use column E instead of D for qualified counts and column F for buyer counts. Google's COUNTIFS documentation explains counting against multiple criteria. The prepared flags must already enforce the sequential attendance, qualification, and sale definitions.
Attendance rate = Attendees / Registrants
Qualification rate = Qualified attendees / Attendees
Qualification-to-sale rate = Qualified attendees who become buyers / Qualified attendees
Registration-to-sale rate = Registrants who become eligible buyers / Registrants
A US software-services company has these completed cohorts. The two event populations do not overlap in this illustration, and every credited opportunity belongs to one buyer and one event.
| Event | Registrants | Attendees | Qualified attendees | Buyers | Bookings (USD) |
|---|---|---|---|---|---|
| July 1 | 200 | 120 | 48 | 12 | 120,000 |
| July 15 | 300 | 150 | 45 | 9 | 108,000 |
| Total | 500 | 270 | 93 | 21 | 228,000 |
With those counts in columns B:E, calculate the four rates:
=IF(B2=0,"",C2/B2)
=IF(C2=0,"",D2/C2)
=IF(D2=0,"",E2/D2)
=IF(B2=0,"",E2/B2)
| Event | Attendance | Qualification | Qualification to sale | Registration to sale |
|---|---|---|---|---|
| July 1 | 60.0% | 40.0% | 25.0% | 6.0% |
| July 15 | 50.0% | 30.0% | 20.0% | 3.0% |
| Total | 54.0% | 34.4% | 22.6% | 4.2% |
Rates are rounded to one decimal place after calculation. The combined registration-to-sale rate is 21 / 500 = 4.2%, rather than the unweighted event average of (6% + 3%) / 2 = 4.5%.
The sequential counts partition the registrants into groups:
| Final position in the defined path | Calculation | Registrants |
|---|---|---|
| Did not attend | 500 - 270 | 230 |
| Attended, did not qualify | 270 - 93 | 177 |
| Qualified, did not become an eligible buyer | 93 - 21 | 72 |
| Became an eligible buyer | From buyer count | 21 |
| Total | 230 + 177 + 72 + 21 | 500 |
That partition describes this attendance-based path. A non-attendee who later buys must be reported separately under an explicitly different path; silently counting that person as an attendee would break the stage definition. The stage conversion glossary explains why sequential counts need compatible populations.
Tie the 21 buyers to their eligible opportunity IDs. Tie $120,000 plus $108,000 to the $228,000 credited bookings total, counting each opportunity amount once. Bookings per registrant are 228,000 / 500 = $456; that is an attributed commercial measure, not proof of incremental revenue. Recognized revenue requires the accounting records and applicable recognition policy, so do not relabel closed-won amounts as recognized revenue.
The July 1 event has stronger conversion at every reported stage. Review invitation sources, attendance evidence, qualification reasons, and follow-up records before attributing the gap to the presentation. A different audience or existing relationship can explain part of the result.
Use win rate versus conversion rate when moving from registrants to opportunity outcomes. For a different handoff, meeting-to-opportunity conversion examines whether recorded meetings become pipeline. SEO conversion rates compare organic landing sessions with outcomes and require their own session denominator.
Covirage is not affiliated with Google.
Bring a sample of your own registration, attendance, and matched CRM exports with the follow-up and crediting rules. Covirage maps the columns; its tools compute and check the counts, rates, and booked totals, and the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, then set up your business and bring your file.
See Covirage for sales insights for the supporting workflow.
Use registrants to measure the full registration-to-sale path and attendees to measure outcomes among people who attended. Both can be useful, but they answer different questions. Label every rate and keep the population and follow-up window consistent when comparing events.
Choose a window that fits the company's sales process and keep it fixed across the events being compared. Show newer cohorts as immature until that window ends. A short observation period can undercount later wins even when attendance and qualification are already complete.
No. A sourcing rule assigns credit for reporting, while a causal claim needs stronger evidence. Registrants may already know the company or have an open deal. Separate new sourced opportunities from existing pipeline and describe the attribution rule beside the results.