Overview
- Client
- Onfy
- Industry
- Online pharmacy marketplace
- Engagement type
- CRM clean-up, AI dedupe agent and lead sourcing
- Team
- Brand partnerships, selling to pharma and health brands
- CRM
- HubSpot
The problem
Onfy is a Berlin marketplace for pharmacy products. Its partnerships team sells advertising and campaigns to pharma and health brands, and HubSpot was supposed to be where all of that lived.
Years of imports and hand entry had other plans. About 1,900 companies and 2,500 contacts, plenty of them saved twice. 1,400 contacts without a job title. A few German companies that had somehow moved to New York. So the team kept the real pipeline in a spreadsheet and looked everyone up on LinkedIn by hand.
And at most target brands, Onfy knew one person in trade marketing and nobody who owned the media budget.
What we built
Three things, in order.
The clean-up. We compared every company and contact with every other one, including the duplicates HubSpot can't spot, and someone at Onfy approved each merge. Nothing got lost on the way: every deal, note and email moved to the record that stayed. We tidied 914 messy names, titles and websites while we were at it.
The AI dedupe agent. It checks new records every hour and the whole CRM every night. When it finds a likely duplicate, it asks in Slack which one to keep. It remembers every past decision, so it never asks twice.
New people to talk to. Starting from Onfy's list of target brands, we found the people who actually own the budgets (trade marketing, retail media, paid social and brand), checked they're still in the job, found a verified work email and made sure they weren't already in HubSpot.
Next up: outreach to those 817 people. Reply rates go here once they're in.
The results
| Measure | Result |
|---|---|
| Duplicates merged | 453 |
| Company records | 1,929 → 1,581 (18% fewer) |
| HubSpot's own duplicate list | 76 → 0 |
| Messy records tidied | 914 |
| New decision-makers at target brands | 817 (722 with a verified email) |
| Contacts in HubSpot | +32% |
The stack
HubSpot, Clay, Slack, Claude Code.