See who was most engaged in a webinar

Using my Livestorm data, build an engagement report for the most recent session of [WEBINAR NAME] that already took place. Leave out team members, guest speakers and anyone with my company's email domain, and say how many people you left out. Only rank people who attended. 1. For each attendee, get their time present (attendance rate), chat messages, Q&A questions, question upvotes and poll votes. Count chat messages from the session's chat, matched to each author through the person linked to each message, rather than the per-person counter, which can read zero. Ignore messages posted after the session ended. If a host reposted an attendee's chat question in the Q&A, credit the attendee. 2. Score them with this rule: [SCORING RULE]. Break ties on time present. If no poll votes or upvotes were recorded, say so rather than showing a column of zeros. 3. Pick the top [5] as giveaway winners, and say why each one won. Don't contact anyone. Give me: - the headline numbers: registered participants, attendees, show-up rate, the average share of the session attendees stayed for, chat messages, questions, poll voters and replay views - the top 10 in a table with their name, company (from the form or their email domain), score and each metric, winners highlighted - the best question of the session: the most upvoted, or your pick with a one-line reason - a 5-line recap I can paste into Slack, with the numbers, the winners and the top question If you can build a one-page report I can share, do it, and use first names with a last initial in anything shared widely.