Select Data Tools from the menu on the left hand side of the page and Click on the Create New Export button, selecting the Data Export option. This will open the data export editor where you create your custom export.
Overview of Steps
- Export Title
- Select Activities
- Select Registrations
- Select Data Fields
- Create Filters (optional)
- External Links (optional)
- Webhook Integration (optional)
Export Title
Give you data an export a title by entering text in the text box and Clicking the Save icon to the right.
Select Activities
To select activities, Click the blue Select Activities button. To add activities, Select a Year and then Select an Event. All activities from the event will show in the Unselected Activities box. To add an activity to the Selected Activities box Click on the Activity. To take an activity out of the download, Click on the Activity in the Selected Activities box.
Selecting All of an Event’s Activities
You can add all or specific activities from an event. To add all or unselect all activities from an event, Click on the Event title in either the Unselected Activities or Selected Activities boxes.
Adding Activities from Different Events or Different years
Data Export lets you add multiple events and activities, which can also be from multiple years. To add activities from different years, use the year drop down menu to Select a new year and use the event drop down menu to Select another Event. Then Click on Activities from the event to add to the export.
Select Registrations
Export Options
This series of checkboxes lets you decided what types of registrations you want to include in your data export. If you select them all, you can include all types. You can select any variation of the following to include in your export.
- Include Valid Registrations
- Include Incomplete QuickReg (More information on QuickReg HERE)
- Include Voided Reg
Test Cards
This allows you to decide if you want registrations made with the test card included in your download. Here you can only select one the following:
- Include Test Card Registrations
- Exclude Test Card Registrations
- Test Card Registrations Only
Learn more about test card registrations HERE
Date Range
The date range allows you to set a certain time period you want to export data from. Note, the All Time range will only show “all time” for the specific year of each event’s activities you have selected.
- All Time
- Yesterday
- Week to Date
- Last Week (Sun-Sat)
- Last Seven Days
- Month to Date
- Last Month
- Custom
*Once you have made your registration selections for the export Click Save.
Select Data Fields
Data fields that can be added to the export include any data a participant entered during registration.
There are four different categories of data fields
- Transaction Info
- Any information regarding the actual transaction such as event, confirmation number, date, time and discount code.
- Participant Info
- Any information that the participant would have entered in registration that was in the registration template at set up. For example: email, name, address, etc.
- Custom Questions
- Any custom questions created for your specific registration.
- Merchandise
- Any merchandise offered in the registration path will.
Once you pick a category to select from, you can Click the Select All button to select all data fields, or you can select them one by one. To unselect you can use the Unselect All button.
Arrange data fields
Before exporting, you can use the arrows, or click and drag data fields in the Selected Data Fields box to arrange their order.
Create Filters
To further organize your data before export, you have the option to add filters to the data. By doing this, you can add one or multiple filters.
Click on the Create Filters button, and then Select Add Filter. Fill in the filter information and Click Save.
Filter options are based on questions asked during registration and what responses registrants gave.
Filters work as “and” not “or”. Therefore if you add multiple filters the system will look for registrations that fulfill all filters.
External Links
External links allow you to share a data export via link that will update anytime the link is reopened. This way, current data can be shared without having to download and send a report. Anyone with the link can reload the link and have up to date data.
See more on external links HERE.
Webhook Integration
Webhook Integration is a way to send data from one service to another. So, when you create a data export you can create a Webhook that sends the data from that export to an external service on certain actions (ie: new registration).