When no sheet has quite the columns you need, build the sheet. Tick the columns, filter the rows, download. It is a raw data sheet for Excel or Google Sheets, not a formatted report.
Columns
- Core: reference, status, registrant type, registered on, paid on.
- People: registrar and attendee names, emails and phones, and whether they registered themselves.
- Items & Money: what they bought, subtotal, discount, coupon, tax, card fee, total, amount collected, refunded.
- Check-In & Codes: whether they were admitted at the gate, when, and any guest code used.
- Session Attendance: the sessions each person checked into and out of.
- Lodging: hotel, room type, check-in, check-out, nights, occupancy, special requirements.
- Form Questions: every question on your form, internal-use ones included.
Filters
- By registrant type, and by item type or one specific item.
- By hotel, including "no lodging".
- By a form field, so you can pull just the people who answered a certain way.
The count under the columns updates as you go, so you can see how many registrations match before you download anything. Then take it as CSV or Excel.