How are people handing personalisation, I've been playing with GPT 4.1 over the weekend, targeting UK marketing agencies and some of the personalisations are good, but some just sound awful. I've also noticed some very questionable 'Normalisation'. such as this where it's not normalised the name at all
Use 4o or claude 3.5 haiku or 3.7 sonnet to write emails
2. The normalization is inadequate. Sharing a note on normalization on how I use javascript + AI Normalizing using javascript This is going to save you lot of credits but it would require you to give specific instructions
Prompt to make word capitalization to upper case or lower case.
Prompt to remove certain terms like .com, LLC, .co, .ai, .io
Use AI fine - Use Checkbox for cases where this has been done well
Use AI on case where it is unable to (use GPT API / Claude)
Keep the same length to max of 25 characters
Split names that have Combine First, Name and Last name to create a single full name.
Find the record after Mr., Dr., Ms, Mrs.
Exclude certain words like abc, xyz
The good part about javascript is it gives tight answers based on your prompt but it is not intelligent to take decisions on its own. Thats where AI comes in…but at a cost Normalizing using AI I restrict myself to Chagpt 4.1 nano at 0.1 credits per row and work AI through great prompts for good outputs. Chatgpt 4.1 nano, 4.1 mini ,4o mini, Claude 3 Haiku, Gemini 2.0 Flash all do the job really well. They cost below 0.5 credits per row. Use AI in content creation & manipulation mode only otherwise you would burn more credits.
Good to know, thanks Prashant M.
Is it well know that Clay normalisation isn't that good?
Jonathan M. There is a structural solution for this and thats top bucket company names into a separate table with double (formula + ai or ai two stage) with final human review with the write to look up functions and just improve the prompt over time. This requires a bit of setup but works the best IMHO. I hope this helps!
Dan K. thanks for the input, do you know if there are any videos showing how to do that?