Any best practices on normalizing company names? I have 26,000 compani...

·Nov 29, 2023 11:37 PM·

Any best practices on normalizing company names? I have 26,000 companies that I would like to normalize. Obv a pretty huge load. I want to turn companies like Maxxar Technologies into Maxxar, so kind of conversational company name

7 comments

· Sorted by Oldest

Clay Team
APP
·
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Arturo O.
·
·
Hey Darshan! That’s a good one, we do have a normalize company integration that could help with some formatting but that extra step may be better achieved by AI. Though I’d test it for some of the more complex names to make sure accuracy of what you’re aiming for is quite high overall
Darshan A.
·
·
Thats what I was thinking, Let me try the normalize company integration first and see
miles
·
·
We use GPT 3.5 for this; not too expensive. can share prompt if interested but it's pretty straightforward.
Darshan A.
·
·
miles - that would be great if you could share the prompt!
miles
·
·
dmed!
Darshan A.
·
·
Thanks man!

Clay Team
APP
·
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Arturo O.
·
·
Hey Darshan! That’s a good one, we do have a normalize company integration that could help with some formatting but that extra step may be better achieved by AI. Though I’d test it for some of the more complex names to make sure accuracy of what you’re aiming for is quite high overall
Darshan A.
·
·
Thats what I was thinking, Let me try the normalize company integration first and see
miles
·
·
We use GPT 3.5 for this; not too expensive. can share prompt if interested but it's pretty straightforward.
Darshan A.
·
·
miles - that would be great if you could share the prompt!
miles
·
·
dmed!
Darshan A.
·
·
Thanks man!