CRM & sales ops21 categories
Normalise these company names
A list to import where the same company appears as four different strings.
Normalise the company names below. Strip legal suffixes into a separate column rather than deleting them, fix casing, standardise ampersands and punctuation, and trim stray whitespace. Return a table: original, normalised name, suffix, and a flag where you are unsure. Never guess at an expansion of an abbreviation you do not recognise — flag it instead. Names:
Making it yours
- Paste your own material where the prompt asks for it. Everything above that line is instruction, not content.
- Delete any rule that does not apply to you. A shorter prompt that fits beats a thorough one that does not.
- If the answer comes back vague, add a line saying what you do not want. Constraints work better than encouragement.
Data hygiene. Duplicates, inconsistent fields, messy imports, and records that technically exist but say nothing.
Related prompts
Find the duplicate accounts in this exportThe same company in the CRM three times, spelled three ways, with activity split across all of them.Map these columns to CRM fields before importingA spreadsheet from a trade show or an old system that has to land in the CRM without wrecking it.Which of these records are actually worth keepingThousands of contacts where most have a name, an email, and nothing else.Clean up this picklistAn industry or lead-source field with 60 values, half of them typos of the other half.Write the data quality rules for this objectDeciding what "complete" means for a record, before arguing about it in a meeting.Decide which value survives a mergeTwo records for the same company that disagree on half their fields.
Keep this one
Phrasery saves prompts with a right-click and puts them back the same way. Add this to your own library in one click.
Add to your browser — free