---
title: "How do you answer a ticket sales question no report covers? | Ticket Fairy Guides"
description: "Start with the event report that matches your question, filter the Orders table when you need a narrower view, then export those rows for further analysis."
canonical: "https://www.ticketfairy.com/guides/answer-custom-ticket-sales-questions"
---

1. [Ticket Fairy](https://www.ticketfairy.com/)
2. [Guides](https://www.ticketfairy.com/guides)
3. How do you answer a ticket sales question no report covers?

Solving event ticketing problems

# How do you answer a ticket sales question no report covers?

Promoters and finance teams often have a ticket sales question that no standard report answers on its own. You can still reach the figure from the orders and tickets behind it, by starting with the closest report, filtering the orders down to the rows you mean and exporting those rows.

Start with the event report that matches your question, filter the Orders table when you need a narrower view, then export those rows for further analysis.

For:  Answering a ticket sales question with the orders and tickets behind it

Takes:  6 minutes

Start with the dashboard report closest to your question. Event statistics cover sales over time, traffic, buyer demographics, referrals and check-ins. If you need the transactions behind a total, filter **Orders** and export those rows.

For every ticket on an event, see the guide to downloading your ticket buyers. Choose tickets only or tickets and add-ons, keep working while your file is prepared, then download it from the Orders export dialog. Marketing readers download the same files from Marketing Assets. Fai can prepare the same file once you approve it.

For questions that need a different view, work from the orders table: filter it to the orders you need and export those rows to CSV, or export every ticket rather than every order when you need ticket-level detail. Remove duplicate people before using that file to count attendees. The export opens in a spreadsheet, a BI tool or a finance system.

You can also ask in words. Fai in the dashboard, your own assistant over MCP and the command line can all get your dashboard figures. Ask "which age band bought the most, and how does that compare with last time" instead of building a spreadsheet.

## How Ticket Fairy helps

- ### [The statistics your event already has](https://www.ticketfairy.com/guides/read-your-audience-demographics)

  You get Performance, Orders, Traffic, Demographics, Psychographics, Geographics, Influencers, Check-In and Devices. Each answers a different question about your event.
- ### The orders table, filtered

  Filter **Orders** by ticket type, status, add-on, discount code or search. The table and export then contain the matching orders.
- ### Export to CSV, orders or tickets

  **Export to CSV** takes the orders as you have filtered them. **Export ticket buyers** prepares the event's ticket file, with your choice of tickets only or tickets and add-ons and CSV layout. **Export Filtered Tickets** takes the tickets that match the table filters. Use ticket exports for ticket-level analysis, and remove duplicate people before counting attendees.
- ### [Ask for the same figures in plain language](https://www.ticketfairy.com/guides/see-how-visitors-find-your-event-page)

  Fai gets these figures inside the dashboard, your own AI assistant gets the same figures over our MCP server, and the command line prints them as JSON for a script that runs every morning.

## Set it up

- [Check whether a report already answers it](#step-1)
- [Filter the orders table to the orders you need](#step-2)
- [Export the rows you need](#step-3)
- [Schedule a recurring report](#step-4)

## Before you start

- You need an owner, admin, **Stats** or support login on the event to open **Orders**. To export its tickets or add-ons, you need an owner or admin login; a marketing login, which has no **Orders**, downloads the same files from **Download your ticket buyers** on the event's **Marketing Assets** page. A **Limited Stats** login can use the event reports but not the orders table, and a limited support login sees orders only after a search.
- Your event has at least one completed ticket sale that has not been canceled or refunded. Unpaid and abandoned checkouts do not fill the sales or buyer reports.

1. ## Check whether a report already answers it

   Open **Statistics** on your event and start with **Performance** for ticket sales and sales over time. Separate reports cover traffic sources, buyer ages and locations, referrals and check-ins.
         ![The event Performance overview, with tickets sold, revenue and the sales curve across the run](https://www.ticketfairy.com/embeds/posters/marketing-analytics--analytics-overview.png)    Statistics, Performance.
2. ## Filter the orders table to the orders you need

   Open **Orders** and narrow it to one ticket type, one add-on, one order status, one discount code, or a search. The rows left in the table are the orders your question is about, one row per order rather than one per person.

   **Note:** Use the event's sales-over-time report when the question is about a particular date range, and use **Orders** when you need the transactions behind the total.
          ![Ticket Fairy Orders table with search, status filters, export controls and order rows](https://www.ticketfairy.com/embeds/posters/marketing-orders--filters-and-export.png)    Event, Orders.
3. ## Export the rows you need

   Choose an order export for one row per transaction, or a ticket export for one row per ticket.

   - **Export to CSV**: One row per filtered order.
   - **Export Filtered Tickets**: One row per ticket.
   **Tip:** One order can include several tickets, so export orders to count transactions and export tickets for ticket-level analysis. For a ticket export, remove duplicate people before using it to count attendees.
4. ## Schedule a recurring report

   Where the same question comes back every week, ask it from the command line with JSON output and let a script run it. You get the same figures the dashboard shows, so you never have to reconcile two answers.

## Try these steps on your own event

Create a free account, build your event and follow the steps above in your own dashboard. It takes a few minutes and you do not need to book a sales call.

    Your email address    [Create a free account](https://manage.ticketfairy.com/welcome) [Book a demo](https://www.ticketfairy.com/event-ticketing/book-a-demo)

No setup fees. No required monthly ticketing fee. No credit card required.

## Or have it done for you

Ask Fai or your own assistant for event statistics, or use the command line to return them as JSON for a scheduled report.

### In your dashboard, with Fai

Compare this event with the last one I ran and tell me what sold, where the buyers came from, and which age band bought the most

### From your own assistant, over MCP

Connect your assistant to [our MCP server](https://www.ticketfairy.com/mcp-server) and ask it:

Keep `--read-only` in your MCP configuration. This task only reads data, so your assistant does not need tools that make changes.

Find my event and compare its sales, traffic, age groups and top referring sites over the same dates

## From your terminal

Install the CLI from [our CLI page](https://www.ticketfairy.com/cli), sign in with `ticketfairy auth login`, and choose the brand you are working on with `ticketfairy brand use <BRAND_ID>`. `ticketfairy brand list` and `ticketfairy event list` show the IDs the other commands use.

Sign in with the same account you use in the dashboard. The commands below return a sales summary without downloading individual orders, so they work well in scheduled reports.

### What has sold, as the summary at the top of Performance

ticketfairy event stats \<EVENT\_ID\> --metric sales

### The same numbers per ticket type

ticketfairy event stats \<EVENT\_ID\> --metric performance --output json

## Let Fai do it for you

Fai works inside your Ticket Fairy dashboard. Create your account, open Fai and paste the prompt above.

   [Create a free account](https://manage.ticketfairy.com/welcome) [Book a demo](https://www.ticketfairy.com/event-ticketing/book-a-demo)

No setup fees. No required monthly ticketing fee. No credit card required.

## Questions you might have

How do I answer a question that spans several reports?:  Start with the relevant report, filter **Orders** to inspect the transactions behind it, and export the result when you want to combine it with other data. You can also ask Fai, your own assistant over MCP, or the command line to get the same figures.

What is the difference between an orders export and a tickets export?:  An order export has one row per transaction; a ticket export has one row per ticket. One order can include four tickets for three attendees, and one attendee can hold more than one ticket. Remove duplicate people before using either export to count attendees.

Can I get ticket sales into our BI tool?:  Yes. Export the matching rows as CSV for a one-off, and for something that runs on a schedule use the command line with JSON output, which returns the same figures shown in the dashboard.

Who can see these reports?:  You can open the reports on an owner, admin, **Stats** or **Limited Stats** login, so a team member can view the reports without letting them change the event. You need an owner, admin, **Stats** or support login to open the orders table, and an owner or admin login to export its tickets or add-ons. A marketing login downloads the same files with **Tickets** or **Tickets and add-ons** under **Download your ticket buyers** on the event's **Marketing Assets** page.

Do the reports include refunded orders?:  You choose. Filter the orders table to include or exclude refunded and canceled orders, and decide which of the two your question means before you export.

## Still have a question?

Book a demo and we will answer it on a call, on your kind of event. Or create your account and see it for yourself.

   [Book a demo](https://www.ticketfairy.com/event-ticketing/book-a-demo) [Create a free account](https://manage.ticketfairy.com/welcome)

No setup fees. No required monthly ticketing fee. No credit card required.

## Related guides

- [More ways to use Ticket Fairy](https://www.ticketfairy.com/features/sales-reports)
- [Download your ticket buyers](https://www.ticketfairy.com/guides/download-your-ticket-buyers)
- [Understand who buys tickets to your event](https://www.ticketfairy.com/guides/read-your-audience-demographics)
- [See how visitors find your event page](https://www.ticketfairy.com/guides/see-how-visitors-find-your-event-page)
- [Understand who buys tickets across your events](https://www.ticketfairy.com/guides/understand-who-buys-tickets-across-your-events)
- [Invite promoters to your collective so they can sell tickets for your events](https://www.ticketfairy.com/guides/invite-people-to-your-collective)
- [How do you keep a high-demand on-sale running smoothly?](https://www.ticketfairy.com/guides/keep-a-high-demand-on-sale-running-smoothly)
- [How do you manage many events without repeating the same work?](https://www.ticketfairy.com/guides/run-many-events-on-one-platform)
- [What should you compare when choosing a ticketing platform?](https://www.ticketfairy.com/guides/compare-ticketing-platforms)
- [What is social ticketing, and how do referral rewards work?](https://www.ticketfairy.com/guides/social-ticketing-and-referral-rewards)
- [What marketing tools should a ticketing platform give you?](https://www.ticketfairy.com/guides/ticketing-platform-marketing-tools)
- [How do you manage accreditation and backstage passes for your event?](https://www.ticketfairy.com/guides/manage-event-accreditation)
- [How do you manage tickets for a multi-day event?](https://www.ticketfairy.com/guides/manage-tickets-for-a-multi-day-event)
- [How do you set up a payment plan so buyers pay for tickets in installments?](https://www.ticketfairy.com/guides/let-buyers-pay-for-tickets-in-instalments)
- [Can you sell tickets directly from your own website?](https://www.ticketfairy.com/guides/sell-tickets-on-your-own-website)
- [Can ticket buyers join your email list automatically?](https://www.ticketfairy.com/guides/add-ticket-buyers-to-your-email-list)
- [How can fan club members get presale access?](https://www.ticketfairy.com/guides/give-fan-club-members-presale-access)
- [What can you find out about the people who buy your tickets?](https://www.ticketfairy.com/guides/what-you-can-learn-about-your-ticket-buyers)
- [How do you run a guest list for your event without a spreadsheet?](https://www.ticketfairy.com/guides/run-a-guest-list-without-a-spreadsheet)
- [Can you hold and spend your ticket money without a separate bank?](https://www.ticketfairy.com/guides/hold-and-spend-your-ticket-money-in-one-place)
- [Can you run a festival's marketing and production from one dashboard?](https://www.ticketfairy.com/guides/run-a-festival-from-one-dashboard)
- [How do you sell more tickets without spending more on ads?](https://www.ticketfairy.com/guides/sell-more-tickets-without-more-ad-spend)
- [How do you keep touts and bots off your tickets?](https://www.ticketfairy.com/guides/keep-touts-off-your-tickets)
- [Every Ticket Fairy guide](https://www.ticketfairy.com/guides)

## Do this on your own event

Create your account, build your event and follow the steps in your own dashboard. You do not need to book a sales call.

  [Create a free account](https://manage.ticketfairy.com/welcome) [Book a demo](https://www.ticketfairy.com/event-ticketing/book-a-demo)

## Sell tickets with Ticket Fairy

Everything in these guides is in your dashboard from the day you sign up.

- Set up your event in minutes
- Free events are free
- Fai, your co-pilot, is built in

 [Create a free account](https://manage.ticketfairy.com/welcome)

No setup fees. No required monthly ticketing fee. No credit card required.

## See it on a call

Book a demo and we will show you how Ticket Fairy handles your kind of event.

 [Book a demo](https://www.ticketfairy.com/event-ticketing/book-a-demo) [More ways to use Ticket Fairy](https://www.ticketfairy.com/features/sales-reports)

### Tips for selling more tickets

Practical advice from working organizers, and every new guide as it is published.

We respect your privacy. Unsubscribe anytime.

---

This page is on Ticket Fairy, a ticketing, marketing and operations platform for live events and the venues that host them: festivals, club nights, concerts, conferences and tours, and night clubs, beach clubs and concert venues. It grows revenue with fan rewards that turn an audience into a sales channel, and runs the money side with payments and payouts, Vault business banking, and working capital advanced against ticket sales. [How Ticket Fairy ticketing works](https://www.ticketfairy.com/event-ticketing) · [Ticket Fairy for AI assistants](https://www.ticketfairy.com/llms.txt)