WhatsApp PersonalBusiness
Recruitly LogoRecruitly
How-to

How to clean up messy job titles and locations in your CRM

Emojis and slogans in job titles, countries written five ways, cities with no map pin: each one hides good candidates from search. How to tidy titles and locations in bulk without changing what they mean, and fill the parts that are missing.

Ask AI about this

ChatGPT
Perplexity
Grok
Claude
Google AI

You clean up messy job titles and locations by tidying how each value is written without changing what it means, in bulk, and by filling the parts that are missing. In Recruitly the Data Agent strips emojis, hashtags and LinkedIn slogans from job titles, fixes names written in capitals, standardises country names and skill names, fills missing cities and countries from the CV, LinkedIn or the company's office, adds the map pin radius search needs, and fixes addresses that contradict themselves. Preview shows every change on five records first, for free.

Why are job titles and locations so messy in recruitment CRMs?

Because they arrive from everywhere and nobody types them the same way twice. Titles come from CVs, LinkedIn headlines, job boards and recruiters' notes. LinkedIn headlines in particular carry emojis, hashtags and a sales line after a vertical bar. Locations arrive as "London", "London, UK", "Greater London" or just a postcode, with the country as UK, U.K., England, GB or nothing at all.

BEFOREAFTERJob title🚀 CEO | Helping startups scale #growthCEONameSEAN O'BRIENSean O'BrienCountryUKUnited KingdomSkillsJS, javascript, Python3JavaScript, PythonPlaceholderNotice period: N/ANotice period: emptyLocationCity Leeds, country blank, no map pinLeeds, United Kingdom, on the map
Each tidy-up changes how a value is written, never what it means. The person is still the CEO and still in Leeds, but now a search for either finds them.

What do messy titles and locations cost?

They cost you the candidates search should have found. A search for "CEO" does not reliably match a title that starts with a rocket emoji and ends with a hashtag. A radius search around Leeds never returns a candidate whose city is in a note and who has no map pin. A filter by country misses everyone saved as "UK" when it asks for United Kingdom. Every one of those is a good candidate who never reaches a shortlist, and a recruiter who learns to stop trusting the search.

Messy values also look careless when they leave the building. A record with a name in capitals, or a campaign that greets someone as "Dear SEAN", is a small thing that says a lot.

How do I clean up messy job titles?

Run the Data Agent with the Job Titles tidy-up ticked. It works through every record in a saved search, takes out emojis, hashtags and LinkedIn slogans, and keeps only the actual job title. Tick Capitalisation as well and names written in capitals are fixed too.

It changes how the title is written, not the title itself. It does not promote anyone, merge two different roles into one, or decide that "Talent Partner" means "Recruiter". If you want a person's current title brought up to date, tick Enrich from LinkedIn as well, and the record takes the title from their live profile.

Which tidy-ups can the Data Agent do?

Eight, and you tick the ones you want. Each one reformats values that are already there, so it is the one part of the Data Agent that rewrites existing fields, and each only changes how a value is written.

Tidy-upWhat it doesWhat it leaves alone
Job TitlesRemoves emojis, hashtags and LinkedIn slogans such as "CEO | Helping companies..."The actual title
CapitalisationFixes name casing, including McDonald, O'Brien and van der Berg, and names in ALL CAPSSpelling
PlaceholdersEmpties N/A, TBD, "-", "none", "unknown" and "not specified"Real values
WhitespaceTrims and collapses extra spacesEverything else
SkillsRemoves duplicate skills and standardises names: JS to JavaScript, Python3 to PythonSkills the person has
AddressesStandardises country names (UK to United Kingdom) and fills the country codeThe place itself; it never moves an address
DatesPuts dates in one formatThe dates
DuplicatesRemoves repeated entries in work history, education, skills and tagsOne copy of each

How do I fix messy and missing locations?

Tick the Addresses tidy-up and the Location card together. The tidy-up standardises how countries are written, so "UK" becomes "United Kingdom" with its country code, and filters by country work. The Location card fills what is missing and adds the map pin.

Location actionWhat it does
Fill missing city, state, countryFrom the CV, notes and conversations on the record; fills blanks only
Fill from LinkedInFrom the LinkedIn profile, when it describes the same place as the record
From the company (contacts and leads)The contact's office, or the company's head office
Add map coordinatesSo radius searches find the record
PostcodeOnly when it is written in the record, never guessed
Fix itRewrites an address that contradicts itself to the best-supported place

The Location card fills blank fields only: after it runs, any address value that was already on the record is put back exactly as it was, unless you also ticked the Addresses tidy-up. Every filled value records where it came from, so a recruiter can see that "Leeds" came from the CV. Data Health shows how many records are missing a city and how many have no map coordinates, which is how you know where to start.

Why does the map pin matter so much?

Because radius search uses the map pin, not the words. A record that says Leeds but has no coordinates is invisible to "within 20 miles of Leeds", which is the search most recruiters run for local roles. Adding coordinates to every record with a known place is the single change that most improves location search.

How do I keep titles and locations clean from now on?

Run the same tidy-ups on new records automatically. A super user can set a Data Agent job on a saved search of new records to repeat every day, week or month, so each record is tidied the day after it arrives. Is there a tool that cleans my CRM automatically? covers the rest of the routine, and how to fill in missing data on your CRM records covers every other field.

Your own lists matter too. Industries, sectors and tags are matched to the lists your agency keeps, so a clean, short list of sectors gives the Data Agent a clean target and your recruiters a filter they will use.

How much does it cost to clean up titles and locations?

$0.005 a record, whichever tidy-ups and location actions you tick. Tidying 20,000 candidates costs $100. Every agency gets $10 of Data Agent credit on first use, enough for 2,000 records. See the pricing page.

Will tidying change the meaning of a job title?

No. The tidy-up removes decoration such as emojis, hashtags and LinkedIn slogans. The title that remains is the person's own. To change a title to their current one, use the LinkedIn refresh.

Can I see the changes before they are made?

Yes. Preview runs on up to five records, writes nothing, charges nothing, and shows each change before and after with its source.

job titleslocationsdata cleaningradius searchData Agent
Recruitment software for agencies

The product this came out of

Nineteen modules on one record: sourcing, screening, campaigns, calls, e-signature and billing, without a second system to keep in step. Free to start, no card, no call.