Ran the CSV through our deduper first. Categorisation was granular enough to segment by sub-vertical without regex. Recommended.
Thanks so much for the feedback, great to see the data drove real campaign lift. Let us know if you'd like the file regenerated with extra columns next time.