See why rows fail, then fix the cause.
Match rate, rejected rows by reason and duplicate outlets for each distributor, on one screen, linked straight to the match queue.
3,742 matched of 4,112 accepted
Names that collapse to one keyMatch queue
Hudson Medical Pharmacy, HUDSON MEDICAL PHARMACY, Hudson Medical-Pharmacy
Main Street Pharmacy (Midtown), Main Street Pharmacy Midtown
Liberty Drugs, Liberty Drugs.
Three questions about every feed.
How much of it matched? The match rate shows lines resolved to a territory out of lines accepted, for a period. Why were rows refused? The rejection breakdown counts each batch's rejected rows by reason: a missing required field, a value that is not a number, or a date that does not fit the format.
Are your masters drifting? Duplicate outlets lists names that collapse to the same key, with every variant, so you can merge them before they split sales.
Straight to the fix.
Each card links to the match queue, and the distributor picker links to the distributor's own page. A match rate that cannot be computed reads "n/a", never a made-up number.
Questions people ask.
What counts as a rejected row?
How is the match rate calculated?
Who can open the workbench?
Works well with.
Match queue
A two-pane review queue for outlet names that did not match on ingest. Approve a candidate, override the territory, or reject, from the keyboard.
Read moreDistributor data ingest
Distributors send sell-out and stock by API push, the upload API or email. Every file is checked, stamped with where it came from, and kept as received.
Read moreSee it on your own team.
Tell us your fleet and we will size a proposal. Complete roll-out may take up to 4 months, counted from signed requirements and first payment.