# Exporting Your Data
CrowdWork lets you export your data as CSV files from several places in the dashboard — for accounting, mailing lists, attendance records, and more. This page covers all the available exports and where to find them.
{% hint style="info" %}
**This guide is for venues and ticket sellers.** If you are a customer looking to remove your data, please [contact our support team](https://docs.crowdwork.com/contacting-support) from the email address associated with your account.
{% endhint %}
***
## Exporting Tickets or Registrations
You can export a list of all tickets or registrations for a specific show or class, including patron names, email addresses, ticket tiers, order dates, and custom checkout field responses.
> **Direct links:** [Tickets Dashboard](https://crowdwork.com/dashboard/tickets) | [Registrations Dashboard](https://crowdwork.com/dashboard/registrations)
**To export tickets or registrations for a specific event:**
1. Go to **Dashboard → Shows** (or **Classes**) and click on the event name
2. Use the **Filter By Name** dropdown to select a specific event.
1. Optionally, use the **Filter By Date** dropdown to select a specific occurrence, or leave as-is to include all
2. Optionally, use the Date Range options to filter by **Date Purchased** or **Event Dates**
3. Click the **Export CSV** button
The downloaded file includes one row per admission with patron details, financial data, and any custom checkout field responses collected at checkout. The Tickets and Registrations exports share the same column structure.
Ticket & Registration Export — Column Reference
**Admission & Event Details**
| Column | Description |
| -------------- | ------------------------------------------------------------------------------------------------- |
| `admission id` | Unique identifier for this individual ticket or registration |
| `order id` | Identifier for the order this admission belongs to — multiple admissions can share the same order |
| `event name` | Name of the show or class |
| `event time` | Scheduled date and time of the event occurrence |
| `tier name` | Name of the ticket or registration tier purchased |
| `tier cost` | Face-value price of the tier |
**Patron Information**
| Column | Description |
| -------------- | ---------------------------------------------------------------------------- |
| `patron name` | Name of the patron on this admission |
| `patron email` | Patron's email address |
| `patron phone` | Patron's phone number, if provided |
| `newsletter` | Whether the patron opted into your newsletter at checkout (`true` / `false`) |
**Purchase Details**
| Column | Description |
| -------------------- | ------------------------------------------------------------------- |
| `pay what you want?` | Whether this tier uses Pay What You Want pricing (`true` / `false`) |
| `purchased at` | Date and time the admission was purchased |
| `status` | Current status of the admission: `paid`, `refunded`, or `standby` |
| `source` | How the admission was created: `online`, `pos`, or `manual` |
| `used` | Whether the ticket has been checked in / scanned (`true` / `false`) |
| `internal tags` | Tags visible only to your staff in the Dashboard |
| `public tags` | Tags visible to patrons |
**Financial — Pricing & Discounts**
| Column | Description |
| ------------------- | ---------------------------------------------------------------------------- |
| `subtotal` | Base ticket price before any discounts or fees are applied |
| `discount used?` | Whether a discount code was applied (`true` / `false`) |
| `discount code` | The discount code used, if any |
| `discount amount` | Dollar amount discounted from the tier cost |
| `membership amount` | Discount amount applied via a membership, if any |
| `credit amount` | Account credit applied to this admission, if any |
| `surcharge` | Surcharge amount added when fees are passed through to the patron |
| `donation` | Donation amount collected at checkout, if your theatre has donations enabled |
**Financial — Fees**
| Column | Description |
| ---------------- | ---------------------------------------------------------------------------------------------------------------- |
| `CrowdWork fees` | CrowdWork's service fee on this admission |
| `processor fees` | Payment processor fee (e.g. Square) on this admission |
| `total fees` | Combined total of CrowdWork fees and processor fees |
| `fees handled` | How fees were handled at time of purchase: `passed_through` (patron pays fees) or `absorbed` (theatre pays fees) |
**Financial — Totals**
| Column | Description |
| -------------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| `net total` | The admission total after discounts and credits are subtracted and surcharges are added, but before fees and donations. Formula: `subtotal - discount amount - membership amount - credit amount + surcharge` |
| `refund amount` | Total amount refunded on this admission, if any |
| `total without fees` | The order-level total before fees were added |
| `total charged` | Amount the patron actually paid, including any passed-through fees |
| `deposited` | Amount deposited to your account — what your theatre receives after fees (if absorbed) and donations are included. This column does account for refunds |
**Understanding the `deposited` column**
The `deposited` column is your best at-a-glance number for what lands in your account. It starts from the net total, adds donations, subtracts fees if your theatre absorbs them, and accounts for any refunds.
**About the `refunded` status**
The status column only shows `refunded` when a full refund has been issued. Partial refunds will still show `paid` as the status — check the `refund amount` column to see if a partial refund was applied.
**Order Metadata**
| Column | Description |
| ---------------------------- | ----------------------------------------------------------------------------------------------------- |
| `payment plan?` | Whether this admission was purchased via a payment plan (`true` / `false`) |
| `bundle purchase?` | Whether this admission was part of a bundle purchase (`true` / `false`) |
| `payment type` | How the patron paid: `free`, `card`, `cash`, or `manual` |
| `original bundled tier cost` | Original individual tier price when purchased as part of a bundle; `$0.00` when not a bundle purchase |
**Custom Checkout Fields**
Any custom checkout fields you have created will appear as additional columns at the end of the export. Each field name becomes its own column header, and the patron's response appears as the value. See [Custom Checkout Fields](https://docs.crowdwork.com/for-theatres/custom-checkout-fields) for details on creating and managing these fields.
***
## Exporting Your Customer or Student List
You can export your full patron list — or a filtered subset — as a CSV. This is useful for newsletters, mailing lists, and patron outreach.
> **Direct links:** [Customers Dashboard](https://crowdwork.com/dashboard/customers) | [Students Dashboard](https://crowdwork.com/dashboard/students)
**To export all customers or students:**
1. Go to **Dashboard → Customers** (or **Students**)
2. Optionally use the **Filters** to narrow results by date, event, or other criteria
3. Click the **Export CSV** button
{% hint style="info" %}
**Customers vs. Students:** Customers are patrons who have purchased show tickets. Students are patrons who have registered for classes. Each has its own list and export. If you need both, export them separately and combine as needed.
{% endhint %}
Customer Export — Column Reference
| Column | Description |
| --------------------- | -------------------------------------------------------------------- |
| `id` | Unique identifier for this customer record |
| `customer name` | Patron's name |
| `customer email` | Patron's email address |
| `phone` | Patron's phone number, if provided |
| `newsletter` | Whether the patron has opted into your newsletter (`true` / `false`) |
| `total purchases` | Total number of show ticket purchases by this patron |
| `total donations` | Total donation amount from this patron across all purchases |
| `first show purchase` | Date and time of this patron's first ticket purchase |
Student Export — Column Reference
| Column | Description |
| ---------------------- | -------------------------------------------------------------------- |
| `id` | Unique identifier for this student record |
| `student name` | Patron's name |
| `student email` | Patron's email address |
| `phone` | Patron's phone number, if provided |
| `newsletter` | Whether the patron has opted into your newsletter (`true` / `false`) |
| `total registrations` | Total number of class registrations by this patron |
| `first class purchase` | Date and time of this patron's first class registration |
***
## Exporting Custom Checkout Field Submissions
If you collect additional information from patrons during checkout using Custom Checkout Fields, you can export all responses from the Submissions page.
> **Direct link:** [Checkout Field Submissions](https://crowdwork.com/dashboard/custom-fields/responses)
1. Go to **Dashboard → Checkout Fields → Submissions**
2. Optionally filter by field or event
3. Click the **Export CSV** button
{% hint style="success" %}
**Also included in ticket and registration exports:** Custom checkout field responses are included in the Tickets and Registrations CSV exports as well — so if you're already pulling an event-level report, you don't need a separate export.
{% endhint %}
Custom Field Submissions Export — Column Reference
Each row represents one field response from one patron. If a patron answered multiple fields during checkout, each answer appears as its own row.
| Column | Description |
| ------------------- | ------------------------------------------------------------- |
| `id` | Unique identifier for this submission |
| `event name` | Name of the show or class this submission is associated with |
| `event time` | Scheduled date and time of the event occurrence |
| `event type` | Whether the event is a `show` or `class` |
| `customer name` | Patron's name (populated when the event is a show) |
| `customer email` | Patron's email (populated when the event is a show) |
| `customer phone` | Patron's phone (populated when the event is a show) |
| `student name` | Patron's name (populated when the event is a class) |
| `student email` | Patron's email (populated when the event is a class) |
| `student phone` | Patron's phone (populated when the event is a class) |
| `ticket id` | Associated ticket admission ID (populated for shows) |
| `registration id` | Associated registration admission ID (populated for classes) |
| `submitted at` | Date and time the field response was submitted |
| `field name` | Name of the custom checkout field |
| `field description` | Description text of the custom checkout field, if any |
| `field required` | Whether the field was required at checkout (`true` / `false`) |
| `value` | The patron's response |
***
## Viewing Sales Reports and Analytics
For a visual overview of your sales performance — revenue totals, ticket counts by show, and trends over time — use the Analytics dashboard.
> **Direct link:** [Analytics Dashboard](https://crowdwork.com/dashboard/analytics)
Go to **Dashboard → Analytics** to view your sales reports and charts. Analytics access is available to Admin users by default, and can be granted to other users through Custom Permissions.
{% hint style="info" %}
**Need to share analytics access?** You can give a board member or stakeholder read-only access to your Analytics without sharing any other data. See [Custom Permissions](https://docs.crowdwork.com/for-theatres/managing-staff-and-users/custom-permissions) for details.
{% endhint %}
***
## Quick Reference
| What You Want to Export | Where to Go |
| ---------------------------------- | --------------------------------------------------------------------------------------------------------------------------------------- |
| Tickets for a specific show |
