The Event Export report creates an Excel-friendly list of events for a selected date range. Choose which event date to use and what information to include in the export.
Description
Use the Event Export report to create a flat list of events. You can choose to base the date range on the show start date or the event start date, and select a view that includes revenue, event details, or event information without shipping details.
Available Filters
Use the following filters to choose which events appear in the export and what information is included.
| Field Name | Available Values | Default |
|---|---|---|
| Status(es) | Payment Pending Confirmed Cancelled Closed |
Payment Pending Confirmed Closed |
| Date Parameter to Use | Show Event |
Not specified. Show uses the show start date; Event uses the event start date. |
| Starting Date | Any date | None |
| Ending Date | Any date | None |
| Created Start Date | Any date | None |
| Created End Date | Any date | Current date |
| Modified Start Date | Any date | None |
| Modified End Date | Any date | Current date |
| Suppliers | All active suppliers | All active suppliers. If you select specific suppliers, events are included based on whether those suppliers are associated with them. |
| View | Events With Revenue All Events All Events - No Shipping Details |
Not specified |
Filter Details
Status(es): Filters events by order status. Payment Pending, Confirmed, and Closed are selected by default.
Date Parameter to Use: Determines which event date is used with the Starting Date and Ending Date filters. Select Show to use the show start date or Event to use the event start date.
Starting Date and Ending Date: Set the date range for the selected date parameter. No dates are selected by default.
Created Start Date and Created End Date: Set the date range for when events were created. The start date is blank by default, and the end date is the current date.
Modified Start Date and Modified End Date: Set the date range for when events were modified. The start date is blank by default, and the end date is the current date.
Suppliers: Selects which active suppliers to include. All active suppliers are included by default. When you select specific suppliers, events are included based on whether those suppliers are associated with each event.
View: Selects the information included in the export:
- Events With Revenue: Includes events with orders and revenue columns.
- All Events: Includes all events and every field in the event detail form.
- All Events - No Shipping Details: Includes events and the Storefront lockdown date, without shipping details.
Exporting the Report
After running the report, click the blue disk icon in the report parameter area and choose Excel to export the results.
Sample Report
Open the Event Export Spreadsheet to see an example of the exported report.