AI-powered data analysis and exports
Ask questions about your members in plain language, follow up on the answer, and save it as a report you can run again.
With AI Member Analysis you can ask questions about your members in plain language, such as "How many crew members have a food ticket?", and get the answer straight away. You can follow up on the answer, narrow it with filters and save it as a report you can run again.
Who can use it?
- AI data analysis has to be part of your Crewstack package, and it is switched on for each event. If it isn't switched on for you, contact support@crewstack.io.
- Once it's on, everyone with the Admin or Super admin role can use it. Team leaders and guest list admins can't.
You'll find it under Reports > AI Member Analysis.
How to ask a question
- Type your question in the field at the top. You can also click one of the examples under the field. Two are shown straight away, and … more examples expands the rest. They are built from your own teams, member types and tickets.
- Click Analyze. It usually takes a few seconds.
- Read the answer. You get a short text and either a single number or a table. A count per team, member type or day is shown as a chart, and Table switches to the table.

Under the field you can see how many analyses the event has used today, for example "3 of 50 analyses used today, 47 left". The number is for the whole event, not just you. Once they're used up, you can ask more questions the next day.
Follow up on the answer
Once you have an answer, the field asks a follow-up about it. Type, for example, "only those on Bar" or "which of them have paid?", and click Ask. The answer builds on the previous one, so you don't have to write the whole question again.
- Asked so far: shows the questions behind the answer. Click an earlier question to see that answer again. If you follow up from there, you continue from that answer.
- Ask next: under the field gives up to three suggestions for the next question. Click one to ask it.
- If you want to ask about something else entirely, click Ask as a new question instead of Ask. Then the previous answer isn't used.
- New question in Asked so far: starts over with an empty field.

Earlier questions on the right shows up to five of the questions you've asked. Click one to ask it again. The list disappears when you leave the page.
Filters on the answer
Above the answer you see the filters the question used, such as Member type: Crew. Hover over a filter to see whether it was checked against the event's setup or is in the AI's own words.
If the answer is a list of people, you can narrow it without asking the AI again:
- Click Add filter.
- Choose a member type, a team, a product or Has paid.
The list is narrowed straight away, and it doesn't count as a question. Remove the filter again with its cross.
If you can follow up on the answer, the filters from the question have a cross too. If you remove one of them, the AI is asked again without the filter, and that counts as a question.

Below the answer
- How this was calculated: click to expand a plain-language explanation of what was searched for. Check it if the answer looks wrong.
- Member data as of …: how recent the data behind the answer is. Member data is updated when a member changes and rebuilt every night.
- Was this answer right?: give the answer a thumbs up or down. With a thumbs down you can write what was wrong. It helps us improve member analysis.
If the table lists people (one row per person), you can click a name to open their profile, and Open in the member list opens the member list with exactly those people. There you can, for example, send them a message. Tables with counts per team or member type have no links.
Save as report
You can save an answer you'll need again:
- Click Save as report below the answer.
- Type a name in Report name and click Save.
The report is listed under Saved reports on the right. It is shared with all the event's admins who can use member analysis. Click the report's name to run it again. It runs on the current member data without asking the AI, so it doesn't count as a question. You can also follow up on its answer.
To delete a report, click the bin and Delete for everyone. It disappears for all the event's admins.
Export as CSV
If the answer is a table, you can click Export CSV and open the file in Excel or Google Sheets.
- The page shows the first 500 rows. The CSV file contains up to 50,000 rows.
- An answer that is a single number can't be exported.
- The export fetches the data again at the moment you click. If more than an hour has passed, you'll see Export failed. Please run the analysis again. Ask the question again and export right away.
What can you ask about?
The analysis knows about your members in the event you're in:
- name, e-mail, phone, member type and role
- teams, and who is a team leader or team group leader
- registration date, waiting list and payment
- shifts: times, number of shifts and hours, attendance and whether the shift was completed
- tickets and products, and how many they hold
- your own data fields that you're allowed to see
- ticket check-in
Good questions are specific and name teams, member types and tickets as they are called in your setup:
- "How many crew members are on each team?"
- "Show everyone on 'Bar crew' who hasn't accepted their shift plan"
- "Who is on shift between 10 and 14 on 3 July?"
- "How many crew members didn't show up for a shift yesterday?"
- "Show team leaders without a phone number"
- "How many have 'Food ticket', split by member type?"
- "How many have registered per week since 1 March?"
- "Who is on the waiting list, and when did they register?"
What it can't do
- It can only read data. It can't change, move or delete anything.
- It only knows the event you're in, not your previous years.
- It can't answer questions about guest lists, messages, files or news. If you ask about something the member data can't answer, you get the message "I can't answer that from the member data" and suggestions under Try instead:.
- Schedules aren't known by name. Ask by date and time or by team instead.
- If you use a name it can't find, such as a team that doesn't exist, it tells you with the message I could not find … and leaves it out of the answer.
- A question can be at most 500 characters.
- It's in beta. Click BETA next to the heading to read more. Answers aren't guaranteed to be correct, so treat them as guidance and check How this was calculated before using a number for anything important.
What is sent to OpenAI?
No personal data about your members is sent to OpenAI, only your question and the names of your fields, teams, member types and products. The analysis uses a language model from OpenAI to understand the question and build a query, which runs in Crewstack.
Sent to OpenAI:
- your question, exactly as you typed it
- the names of the event's member types, teams, tickets and products and custom data fields, in all of the event's languages, with Crewstack's internal ids
- a description of what kinds of information exist about a member (e.g. "name", "number of shifts"), without the values
- today's date, the event's time zone and languages
- when you follow up: up to three of the previous questions, the query that produced the answer, and the names of the filters you added yourself
- if the first attempt is rejected: a new attempt with the rejected query and the error text (string values removed from database errors)
Stays in Crewstack:
- all information about individual members: names, e-mails, phone numbers, answers in data fields, shifts, tickets and payments
- the result. The query runs in Crewstack, and the number or table is only sent to your browser. OpenAI never sees the answer.
- filters you add and saved reports you run again. They run in Crewstack without asking the AI.
Access to sensitive data fields
The analysis respects Visible to. You can only see the data fields you can also see on the person's profile. If, for example, you have created a data field for health information and limited it to Member + super admins, an admin can't see the answers in that field in the analysis.
Check this if the answer is wrong
- "No members matched": write the team, member type or ticket exactly as in your settings, and check the date.
- Error: click Try again. Phrase the question more simply or split it in two.
- The number looks too high or too low: open How this was calculated and see whether, for example, people on the waiting list or without a completed registration were counted. Say so in the question, e.g. "only those with a completed registration".
- The answer builds on the previous question, but it shouldn't: click Ask as a new question or New question.
- "This answer can no longer be followed up": the answer is too old to build on. Your question is still in the field, so click Analyze to ask it as a new question.
- Times: include the year and time of day. Times are read in the event's time zone.
Didn't find the answer? Write to support@crewstack.io.