Understanding Reports

How Reports Work in Express

What this article covers: Reports are built once for your whole account and reused on every event. This walkthrough covers where they live, how one becomes the default, and the rule that keeps a change you make on one event from reaching everybody else's.

Every event ends with someone asking for the list. Catering wants a headcount. A colleague wants to know who's coming from a client. Finance wants it in a spreadsheet. A report answers all of that without rebuilding the same export each time. You decide once which columns you want, which registrations count, and what order they come out in. Every event you run afterward can use it.

1. Start on your event's Overview screen. Find the Reports card in the Configuration row. This is a summary rather than a link to somewhere mysterious. It names the report this event is currently using. It shows how many records are pinned. It gives you the count. 2. Check the word in the card's top corner. Default means this event hasn't changed anything from the account's shared setup. Click Reports in the tab row to open the full screen. 3. Take the Reports screen in as a whole before you touch anything. The drawer on the left holds three sections, stacked one on top of the other. The three sections are Select report, Report Tuner, and Templates. 4. Across the top sit four cards: Columns, Filters, Sort, and Matching. Below those is the report builder itself. Below that is a live preview of your actual registrations. 5. At the top of the drawer, Select report names the report you're viewing, next to an ACCOUNT badge. The ACCOUNT badge is the most useful thing on this screen. A gold star marks the report every event uses unless it's told otherwise. Click Confirmed attendees to preview a different one. 6. Nothing gets saved by doing that. Switching reports here only changes what you're looking at. Columns, filters, and the live preview redraw to match. Reports are different answers to different questions. 7. Click Full attendee export for the widest report on the account. This report has fourteen columns. The preview scrolls sideways to fit them all. Reach for this one when someone wants everything. 8. Now look at the middle of the drawer, Report Tuner. Three switches are there. All three switches are off by default. Each switch has a note explaining what it does. Leave a switch off to have this event use the account template. Turn a switch on to customize the report for this event only. This customization is fenced off from every other event sharing it. Edit a report with the switches off to edit it for the whole account. Turn one switch on first to keep changes local. 9. Click All registrations to return to the default report. 10. Look at the banner across the top of the report. It reads something like "Using the account template's columns. Turn on Override columns to customize for this event." Express tells you plainly where what you're looking at came from. This ensures you never have to guess whether you're editing the shared version or your own copy. 11. The columns themselves run along the bottom. Each column is labeled with its data type. The first three columns, First name, Last name, and Email, carry a small padlock and stay in every report. Everything else is yours to add or remove. 12. Click Filters to see the next part. With no filters set, the report returns every registration. Then look at the four cards along the top again. Columns, Filters, and Sort tell you what you've configured. Matching is the one that earns its place. Matching is a live count of how many registrations this report returns right now. The real people are listed in the preview beneath it. 13. Click Sort for the last piece. This report sorts by Registered date, newest first. 14. One more thing in the drawer: Templates, at the bottom. Every report on your account shows up here with a switch. That switch decides whether it appears on this event. Pin the two or three you use most. Pinned templates are one click away in both Select report and the picker on your Registrations list. Leave the rest unpinned. Unpinned templates stay out of your way without being deleted. This matters more as your template list grows. 15. So the shape of it: your reports are built once at the account level. This is why the badge reads ACCOUNT. This is why the same reports show up on every event you open. The gold star decides which one you get by default. Report Tuner is what lets you deviate on one event without dragging everyone else along. When you flip a switch, that badge changes to CUSTOM. You always know which version you're looking at.

Building and applying a report has its own how-to. Managing the templates themselves also has its own how-to. Both how-to topics are accessible from the Manage link beside Templates. If you have additional questions, use the Help option inside Express, or contact Certain Support.

Source: https://platform-support.certain.com/hc/en-us/articles/43102971390999-Understanding-Reports

Keywords: Express, Reports, Report Tuner