Hosts
Section 9: Advanced Features
๐ฝ 9.5 Exporting Data
you can download member and participant information documents, allowing you to manage them with 3rd party applications, or to keep them stored for administrative tasks when downloading csv files from different tabs within the dashboard, each tab presents different types of information events & classes downloading this csv file will contain all relevant user information, such as their name, email and phone you'll also see ticket price, ticket tier, waiver status, questionnaire answers, coupons used, among other items events & classes csv content breakdown ticket id 8 digit unique number for each ticket order id id that identifies a whole purchase (may contain multiple ticket ids) order amount base ticket price value (it does not include application fees) purchaser displays the purchaser's username (transferred tickets will store this) purchaser emai l displays the main purchaser's email event name displays the associated event with this order event address displays the public location set by the host status displays the ticket status, confirmed or canceled tier displays the ticket tier (for free events, this will be blank) coupon displays if a promo code was used, and its name checked in displays whether the ticket has been redeemed by the user (true = used, false = not used) paid date indicates the exact purchase date and time waiver signed displays the waiver status for this user (true = signed, false = not signed) full name displays the end customer's name (may be different from purchaser's name) email displays end customer's email phone number displays the end customer's phone membership the membership csv will contain data such as, name, email, paid amoun, membership frequency, status, last transaction time, among others memberships csv content breakdown member id a unique code to identify the specific member name displays the member's full public name email displays the member's email address frequency displays the user's payment frequency paid amount displays the total membership revenue (it does not include application fees) coupons indicates if promo codes were used for this transaction status displays the membership status for a specific user (active or canceled) last transaction time indicates the latest membership payment wallet the wallet csv will display a breaddown of every purchase, with user information, ticket prices, application fees, service fees and retained revenue, among others wallet csv content breakdown order id a unique code to identify the specific transaction paid date displays the payment's date and time purchaser displays the main ticket/order purchaser purchaser email displays the main ticket/order purchaser's email transaction type shows the order's activity type (event or membership) event name & tier for event transcations, it indicates the event name and the ticket tier selected by the user order paid amount displays the total amount paid by the user (includes application fees) coupons indicates if promo codes were used for this transaction sweatpals service fee indicates the charged amount in sweatpals fees stripe fee indicates the charged amount in stripe fees retained revenue shows the total ticket revenue, without application fees payment method / notes displays the method used to purchase the ticket, such as card payment , free registration or coupon promocode discounts indicates if a promo code was applied to the purchase, it also indicates the promo code name, and its value tracking link discounts indicates if a tracking link was used on the purchase, it also displays the discount amount in the case this link provided a discount how to explore a csv list what apps should i use to open and manage csv lists? a we recommend popular spreadsheets applications, such as google sheets, excel or numbers but any app that can manage csv is good do csv files update when users cancel their tickets? a yes, if a user cancels their ticket, this particular order will not show up (or show up as canceled) when you download a new copy for that particular csv list