Macha
Studies · AI Analysis

Ask one question of five thousand tickets.

A Study points an AI extractor at a set of records, fills in the columns you defined, and hands you a grid. One row per record, one column per thing you wanted to know.

Refund drivers · Q3 4,812 processed Complete
Group by Root cause
Ticket Root cause short text Refund requested boolean Product area single select Sentiment single select
#20831 Carrier lost the parcel, no scan for 5 days Yes Shipping Frustrated
#20847 Wrong size shipped, warehouse pick error Yes Fulfilment Neutral
#20852 Discount code expired before checkout No Billing Neutral
#20861 Duplicate charge on a retried payment Yes Billing Negative
#20874 analysing…
50 of 4,812 loaded Columns Scope: 4,812 tickets · 1 Jul – 30 Sep Model: GPT-5 mini

A spreadsheet you never had to fill in, about work you already did.

Instead of opening one ticket at a time and asking, you point a Study at a set of records, describe the columns you want, and every record is analysed in parallel. Doing it by hand is a week. Doing it through chat is one conversation per ticket.

01

One · Input

The records

A Zendesk search query and an optional date range decide what is in scope. Any expression you would type into Zendesk search works here.

tags:refund status:solved 1 Jul – 30 Sep
02

Two · Schema

The columns

Each column has a type, a label and optional guidance telling the model how to fill it. This is the part that turns a vague question into a repeatable one.

boolean single select long text
03

Three · Output

The grid

One row per record, filled in and sortable. Browse it, filter it, export it, or push it back into Macha as a knowledge source.

filter CSV export to knowledge

Questions worth pointing a Study at.

Every one of these is a question a support lead already has and usually cannot answer, because answering it means reading a few thousand tickets.

Revenue

What are we actually refunding for?

Run it over every ticket that mentions a refund and get the real driver behind each one, not the macro that closed it.

Columns it fills

root cause refund given amount band

Deflection

Which tickets should never have reached a human?

Classify a quarter of volume by whether an existing help centre article already answered it. That list is your automation backlog.

Columns it fills

answerable from KB article match confidence

Product

What is support telling us about the product?

Tag every ticket with the feature area and whether it is a bug, a gap or a misunderstanding, then hand product a ranked list instead of anecdotes.

Columns it fills

feature area issue type severity

Compliance

Did we say anything we should not have?

Audit outbound replies for promises about delivery dates, refunds or medical or financial claims, and get the exact ticket back with the quote.

Columns it fills

promise made quote risk

Quality

Where does the queue actually go wrong?

Score resolution quality and first-contact outcome across a month, then compare weeks, brands or teams on the same rubric.

Columns it fills

resolved reopened why

Voice of customer

What are people asking for that we do not sell?

Extract every explicit request for a product, size, region or integration you do not offer yet, with the wording the customer used.

Columns it fills

request category verbatim

The schema is the whole trick.

A column is not just a label. It has a type, so the output is machine-usable, and it can carry guidance in your own words so the model fills it the way you would.

Column guidance, in plain English

“Mark this true only if the customer explicitly asked for money back. Someone complaining about a delay is not a refund request.”

boolean

True or false. The one to reach for when you are counting things.

single select

One value from a list you define. Keeps categories tidy enough to group by.

multi select

Several values from your list, for tickets that are genuinely about two things.

number

A figure pulled out of the text — an amount, a count, a number of days.

short text

A phrase. Good for a root cause or a name you want to read at a glance.

long text

A paragraph, when the answer needs the reasoning and not just the label.

Then do something with it.

A finished Study is not a report you read once. It is a dataset, and it can go straight back into the product.

1

Read it in the grid

Sort and filter in place. The columns you defined are the columns you filter on, so the answer is two clicks away.

2

Export to CSV

Take it to a spreadsheet, a BI tool or a board deck. It is ordinary tabular data with no lock-in.

3

Feed it to your agents

Push the result back into Macha as a knowledge source, so the analysis you just ran informs the answers your agents give tomorrow.

Questions about Studies.

Short answers. If something is missing, ask us — we will tell you straight.

Zendesk tickets today, matched by a Zendesk search query with an optional date range. More record sources are coming.
Chat answers one record at a time, in prose. A Study runs the same extraction across every record in scope and returns structured columns you can sort, filter, count and export.
The model you choose sets the credit cost per record, so a cheaper model over a wide scope is a real option. You see the estimate before launching, and it is calculated from the exact query the run will use — so the number you see is the number you process.
You pick which ticket fields the model sees. Subject and description are enough for most extractions; the full comment thread and custom fields are available but flagged as expensive, because they add an API call and grow the prompt.
Yes. A Study is a saved configuration, not a one-off job, so monthly audits and recurring classification are just a re-run.

Pronto para turbinar seu time com IA?

Comece em minutos. Conecte suas ferramentas, configure seus agentes e deixe a IA cuidar do resto.

500 créditos grátis · sem limite de tempo, sem cartão de crédito