Need Help Streamlining Company Name Cleanup Process

Joel H. · 2025-08-14 14:01:37.853837+00

Hi all. Having issues trying cleanup / shorthand a company name? Every 5 or so results is giving this long-winded answer? Any help is greatly appreciated! See attached

Need Help Streamlining Company Name Cleanup Process | Clay

9 comments

· Sorted by Oldest

Clay
APP
·
·
Use our Normalize Company Names function to clean up company names automatically: 1. Navigate to "Add enrichment" panel 2. Select "Normalize" in the left sub-navigation 3. Choose "Normalize Company Names" 4. Select your company name column as input 5. Optionally enable "Normalize Case" for proper capitalization 6. Run across your rows This removes suffixes like "Inc.", "LLC" and cleans up formats like "Cora, a company of blank" to just "Cora." The function is credit-free and handles most standardization needs automatically.
Sources: Data Cleaning + Normalization [Clay 101] - Clay University Clay formatters overview | Documentation | Clay University Normalize Company Name with Clay Formatters
Joel H.
·
·
Im using Open AI and a prompt. How do I optimize this so we dont get the entries with errors?
Joel H.
·
·
https://app.clay.com/workspaces/637258/workbooks/wb_0t0y8hlHVx6zqTmng3Y/tables/t_0t0y8i2WSMq8fC6sveY/views/gv_0t0y8i2SjNrgGs8ggrN
Stefano
·
·
Hi, for prompt optimisation I recommend trying to approaches: 1) Utilize the "Help me" AI feature. This option can assist in crafting a more refined and effective prompt, which is likely to produce better results. The AI will analyze the context of your query and suggest wording or structures that are optimized for the system, helping to guide you toward more accurate and relevant answers. The button is shown below:
(33 kB)
2) Consider using an external tool like ChatGPT. You can explain to ChatGPT what you're trying to accomplish, and it can help by offering suggestions on how to improve your prompt or rephrase it in a way that is more likely to yield the best results. This method can be especially useful for understanding how to communicate your request more clearly or efficiently. Let me know if this helps!
Joel H.
·
·
Stefano Thanks so much. Ill try the help me function
Joel H.
·
·
Stefano when I go to edit enrichment, I cant see the button, where is it?
Loading attachments
Joel H.
·
·
?
Joel H.
·
·
?
Stefano
·
·
Hi Joel, if you go to "configure" button you should then be able to use the "generate" button to modify your prompt!
(131 kB)

Clay
APP
·
·
Use our Normalize Company Names function to clean up company names automatically: 1. Navigate to "Add enrichment" panel 2. Select "Normalize" in the left sub-navigation 3. Choose "Normalize Company Names" 4. Select your company name column as input 5. Optionally enable "Normalize Case" for proper capitalization 6. Run across your rows This removes suffixes like "Inc.", "LLC" and cleans up formats like "Cora, a company of blank" to just "Cora." The function is credit-free and handles most standardization needs automatically.
Sources: Data Cleaning + Normalization [Clay 101] - Clay University Clay formatters overview | Documentation | Clay University Normalize Company Name with Clay Formatters
Joel H.
·
·
Im using Open AI and a prompt. How do I optimize this so we dont get the entries with errors?
Joel H.
·
·
https://app.clay.com/workspaces/637258/workbooks/wb_0t0y8hlHVx6zqTmng3Y/tables/t_0t0y8i2WSMq8fC6sveY/views/gv_0t0y8i2SjNrgGs8ggrN
Stefano
·
·
Hi, for prompt optimisation I recommend trying to approaches: 1) Utilize the "Help me" AI feature. This option can assist in crafting a more refined and effective prompt, which is likely to produce better results. The AI will analyze the context of your query and suggest wording or structures that are optimized for the system, helping to guide you toward more accurate and relevant answers. The button is shown below:
(33 kB)
2) Consider using an external tool like ChatGPT. You can explain to ChatGPT what you're trying to accomplish, and it can help by offering suggestions on how to improve your prompt or rephrase it in a way that is more likely to yield the best results. This method can be especially useful for understanding how to communicate your request more clearly or efficiently. Let me know if this helps!
Joel H.
·
·
Stefano Thanks so much. Ill try the help me function
Joel H.
·
·
Stefano when I go to edit enrichment, I cant see the button, where is it?
Loading attachments
Joel H.
·
·
?
Joel H.
·
·
?
Stefano
·
·
Hi Joel, if you go to "configure" button you should then be able to use the "generate" button to modify your prompt!
(131 kB)