πŸ“€Exporting Your Data

Learn how to export your sales data, patron lists, tickets, registrations, and checkout field submissions from your CrowdWork dashboard.

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.

circle-info

This guide is for venues and ticket sellers. If you are a customer looking to remove your data, please contact our support team from the email address associated with your account.


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 Dashboardarrow-up-right | Registrations Dashboardarrow-up-right

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.

chevron-rightTicket & Registration Export β€” Column Referencehashtag

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 Fieldsarrow-up-right 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 Dashboardarrow-up-right | Students Dashboardarrow-up-right

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

circle-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.

chevron-rightCustomer Export β€” Column Referencehashtag
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

chevron-rightStudent Export β€” Column Referencehashtag
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 Submissionsarrow-up-right

  1. Go to Dashboard β†’ Checkout Fields β†’ Submissions

  2. Optionally filter by field or event

  3. Click the Export CSV button

circle-check
chevron-rightCustom Field Submissions Export β€” Column Referencehashtag

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 Dashboardarrow-up-right

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.

circle-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 Permissionsarrow-up-right for details.


Quick Reference

What You Want to Export
Where to Go

Tickets for a specific show

Dashboard β†’ Showsarrow-up-right β†’ [Show Name] β†’ Admissions β†’ Export CSV

Registrations for a specific class

Dashboard β†’ Classesarrow-up-right β†’ [Class Name] β†’ Admissions β†’ Export CSV

All customers (show ticket buyers)

All students (class registrants)

Custom checkout field responses

Sales reports and revenue totals


Task
Where to Find It

View sales charts and revenue reports

Collect additional info from patrons at checkout

Manage who can access exports and analytics

Give a stakeholder analytics-only access

View and manage individual admissions

Last updated

Was this helpful?