Import a Zoom participant report
Download the participant CSV for one date from the Zoom web portal and import it, so Bottega can work out show-up and watch time.
On this page6 sections
Use this when Zoom isn't connected to Bottega, or when a date had no meeting ID. You import one file per date, after the live has ended. Each import takes about five minutes.
- You need to be an admin in Bottega, and importing must be allowed for your space. If you don't see Import Zoom report buttons, one of these is missing.
- In Zoom, you need to be the meeting host, an account admin, or have access to Usage reports.
- Check that the date has ended. Zoom only has the full participant list afterwards.
Open Meeting and webinar history
Sign in to the Zoom web portal as the host. Click your profile picture at the top right, then My account. In the side menu click Reports, then Meetings & Webinars, then Meeting and webinar history.
Account admins can use Admin Center, then Reports, Usage reports and Meeting and webinar history to see every host's meetings.
Find the date
Set the time range to cover the date (Zoom allows up to one month), or search by the meeting topic or ID.
Open the participant list
Scroll right to the Participants column and click the number. A pop-up lists everyone who joined.
Leave Show unique users unticked
Bottega needs every join and leave to count rejoins properly. You can tick Export with meeting data or leave it. Bottega skips that block either way.
Click Export
Export is at the top right of the pop-up. Zoom saves a CSV file. If the download doesn't start, click Report queue at the top right of the page and click the download icon next to the report.
For a Zoom Webinar, find it in the same report, click Export and choose the attendees report. Bottega reads that format too and leaves out the host and panelist rows.
Repeat for each date. A two-night run needs two files.
Open the run
Click the run's card. Runs without attendance show No Zoom report yet. Import it to see show-up and drop-off. and an Import Zoom report button, which takes you straight to the next step.
Click Import Zoom report
The button is at the top right. You can also click Import next to a date in the list of reports. The Import Zoom attendance window opens.
Pick the date
If the run has more than one date, click the one this file is for. Dates that already have a report carry an Imported badge.
Drop in the file
Drag the CSV onto the box that says Drop the Night 1 Zoom report here, or click browse. Bottega reads the file in your browser. Nothing is saved yet.
Check the preview
You see the file name, whether Bottega read it as Zoom meeting participants or Zoom webinar attendee report, and the time of the first join and last leave. Four tiles follow.
Tile Meaning Rows Lines in the file. Each join to leave is one row, so rejoins add rows. Participants Different people in the file. Matched Participants whose Zoom email matches a registrant of this run, with the share of registrants underneath. Unmatched Participants with a different email, or no email at all. Under the tiles, Preview · longest watchers lists people with their minutes and a Registrant or Unmatched badge. Any warnings appear below the list.
Click Import Night 1
The button reads Replace Night 1 if the date already has a report. After a few seconds you see Night 1 is in. with the final counts and the share of registrants who showed up. Click Done.
Check that it worked
- The run's card on Attendance has a Zoom report badge.
- The cohort page shows a percentage on Attended Night 1 instead of a dash.
- Attendance pills appear on the run's registrants in the list.
The run has 1,240 registrants. The Night 1 file has 903 rows from 812 participants, because some people dropped out and rejoined. The preview shows Matched 744 (60.0% of registrants) and Unmatched 68. After the import, the cohort page shows Attended Night 1 at 60.0% with 744 people. The 68 unmatched participants appear under Unmatched Zoom participants and still count in the retention chart.
In the Zoom reports card on the cohort page, click Replace to import a new file for that date. Every figure on the page is recalculated. To delete a date's attendance, click the bin icon, then Remove report. You can import the file again at any time.
| What you see | Why | What to do |
|---|---|---|
| Couldn't find the participant table. | This is a different Zoom report, such as the registration report. | Export from the Participants pop-up, which has Join Time and Leave Time columns. |
| This report starts …, but Night 1 is … | The first join is more than 6 hours from the date's start. Usually it is the other night's file. | Click Use Night 2 if it appears, or pick the right date. If the times are all shifted by a few hours, the file uses a different time zone from the webinar. |
| Rows have no email, so they can't be matched | Those people joined without signing in to Zoom, often from a phone. | Nothing to fix now. Personal join links with a Zoom connection avoid it next time. |
| Host or panelist rows left out | Bottega only counts attendees. | Nothing. This is expected. |
| Rows skipped (no join time or unreadable date) | Some rows were blank or cut off. | Check the file in a spreadsheet. A few skipped rows are normal. |
| That file is over 15 MB. | The file covers more than one meeting. | Export the Participants report for one date only. |
| Matched is much lower than you expect | People typed a different email into Zoom than on the lander. | See how matching works |
Read next
Something here out of date? Tell us and we'll fix the guide.