Find the Duplicates in Your Queue
Export a week of tickets, paste them in, and see how many are the same request arriving twice. Nothing leaves your browser.
Check your duplicate rate
Paste a ticket export with requester, subject and created date. Everything runs in your browser and nothing is uploaded or stored.
Paste at least two rows with a header. The columns can be called anything containing requester, subject and created.
Run this on your live queueHow to get the data
Any export with a requester, a subject and a created date will work. The column names can be anything containing those words, and both CSV and TSV are fine.
A week of tickets is enough to see the pattern. A month is better if your volume is low.
What it is doing
For every pair of tickets it checks three things, which is the same conservative shape the product uses by default.
A pair that passes all three is counted once, so ten tickets about one problem count as nine duplicates rather than forty-five pairs.
Reading the number
Most support queues land between 8% and 20%. If this comes back under 5%, either your export is missing the requester column or your first reply time is fast enough that nobody bothers writing twice, which is worth knowing either way.
Treat the result as a floor rather than a ceiling. This compares subject lines only, so it misses the pairs where the same person described one problem in two completely different ways, and the pairs where one colleague reported what another colleague already raised.
Once you have the percentage, put it through the duplicate ticket cost calculator to turn it into hours and money.
Why nothing is uploaded
Support exports contain customer names, email addresses and often the content of their problems. Asking somebody to upload that to a marketing site to get a number would be a poor trade.
So the parsing and the comparison happen in your browser. There is no request to a server, nothing is stored, and closing the tab is the whole cleanup process.
Frequently asked questions
Is my ticket data uploaded anywhere?+
No. Everything is parsed and compared in your browser. Nothing is sent to a server and nothing is stored.
What columns does it need?+
A requester or contact column, a subject column and ideally a created date. It finds them by name, so the exact header does not matter.
Why is my rate lower than expected?+
This compares subject lines only. Pairs worded differently, or raised by two colleagues at one company, are invisible to it and visible to the full engine.
How many tickets should I paste?+
A week is enough to see the pattern. Very large pastes will slow the browser down, since every pair is compared.
Now do it continuously
A one-off sample tells you the size of the problem. Ticket Merger runs the same comparison on every arriving ticket and merges the matches.
Start free trial14-day free trial. No credit card required.