How to clean old LinkedIn lead lists for automation
Check old LinkedIn profile URLs, update job titles and remove dead leads before you import a CSV, so outreach reaches real buyers and your account stays healthy.
Get startedShort answer
To clean an old LinkedIn lead list, check that each profile URL still opens a live profile, confirm the person still matches your buyer profile, and remove rows you cannot verify. Then update company and title fields, import only the clean rows, and send in small batches inside your account limits.
Start with the CSV before the outreach tool
Open the file before you open your outreach tool. Old lists fail in boring ways: the export date is missing, the profile URL column is mixed with company pages, or the file has one row per email address and no LinkedIn URL at all. You cannot fix any of that inside a campaign builder. You need to see the rows and decide what each column is for.
Look at the source. A list from a webinar signup is not the same as a list from LinkedIn search. Webinar lists often have personal emails and no profile URLs. Search exports usually have the URL but no email. For LinkedIn outreach, the URL is the only field you must keep. Everything else is optional context.
- 1
Find the export date
Look in the file name, the first row or the tool that produced it. If you cannot tell when someone made the list, treat it as old and verify it before import.
- 2
Keep one URL column
Use a single column named profile_url. Delete duplicate URL columns and rows that contain a company page instead of a person.
- 3
Remove empty rows
Sort by the URL column and delete blanks. A blank row can break an import or create a lead with no destination.
- 4
Save a copy
Keep the original file untouched. Clean a duplicate so you can compare results if an import goes wrong.
How to spot dead and stale profiles
A dead profile is a URL that no longer opens a person. LinkedIn may show a not found page, send you to the home feed, or show a profile with no name and no activity. A stale profile is different. The page loads, but the person no longer fits: they left the role, moved to a different function, or now sell a service you do not buy.
Both cause the same problem. You spend an invite on someone who cannot become a customer. If that happens often, fewer people accept and LinkedIn may treat your account as low quality. LinkedIn does not publish exact limits for invites or messages, so you cannot rely on a magic number to keep you safe. You have to rely on list quality and a sending pace you can defend.
Check the company page too. A person may still list a company that no longer exists or has been renamed. If the company is gone, the person is probably stale even if the profile loads.
Dead or stale profile
- URL opens a not found page
- URL redirects to the LinkedIn home feed
- Headline says Former VP of Sales
- Headline says Looking for new opportunities
- Profile has no photo, no headline and no activity
Profile worth keeping
- URL opens a named person with a current headline
- Headline matches the role you target
- Company field matches a company you sell to
- Recent activity or a current role confirms the person is active
Verify a sample before you clean the whole file
Do not clean a large file row by row until you know the file is worth saving. Take a sample from the top, middle and bottom. Open each URL and mark what you find. If most of the sample is dead or has changed jobs, stop. Start a fresh search instead of rescuing a list that has already decayed.
Use a status column so you can sort later. Keep the labels simple. Valid means the person is live and fits. Changed means the person is live but the company or title moved. Dead means the URL does not open a person. Review means you are not sure and need a second look. This column also gives you a record of what you checked, which helps if a teammate asks why a lead was removed.
If you have a teammate, split the sample. Two people can check more rows in less time, and you get a second opinion on the review rows.
- 1
Add a status column
Create a column called status and use only four values: valid, changed, dead, review.
- 2
Sample across the file
Pick rows from the start, middle and end. Do not only check the first page, because old exports often have the freshest rows at the top.
- 3
Mark the result
Write the current company and title next to each sampled row. If the profile is dead, leave the company and title blank.
- 4
Decide before you clean
If the sample has more dead or changed rows than valid rows, do not spend time cleaning the full file. Build a new list from a search that matches your buyer profile.
What to do when someone changed jobs
Job changes are the most common reason an old list fails. The person is still on LinkedIn, still active, and may still be a good buyer. Do not delete every changed row. Check the new company and title against your buyer profile first.
If the person moved into a role you sell to, update the company and title and keep the row. If they moved into a role you do not sell to, remove them. If they moved to a competitor, move them to a separate list. You may still want to reach them later, but your message has to change. A message that worked when they bought from you will not work when they sell against you.
Still in target role at a new company
- Scenario
- Update company and title, keep the lead
- Action
- The person still fits your buyer profile
Moved to a non-target role
- Scenario
- Remove the lead
- Action
- The person no longer fits the profile
Moved to a competitor
- Scenario
- Move to a separate competitor list
- Action
- The message and offer need a different angle
Profile is dead
- Scenario
- Remove the lead
- Action
- There is no person to contact
Example
- You
Saw you moved from Northwind to Acme. Are you still running the support team there?
- Prospect
I am. We are rebuilding our help center this quarter.
- Suggested reply
That is why I reached out. We help support teams cut the manual work in help center updates. Open to a short call next week?
Import and send in batches that look human
A clean list can still hurt you if you send to all of it at once. LinkedIn watches how people respond to your invites. If you send a large batch and most people ignore it, fewer people accept later. LinkedIn does not publish exact limits, so set your own daily invite and message limits and keep them steady.
Send in small batches and watch the results before you add more. If people accept and reply, keep going. If accepts stall, pause and check the list again. Do not use a big send to test a list you have not verified. That is how a good list gets a bad result.
Keep the cleaned file and the original. When a campaign does well, you can compare the two files and see which rows you removed. That record makes the next cleanup faster.
Do not import a whole old list and send every invite on day one. Clean the file, import a small batch, watch what happens, then add more only if the batch looks healthy.
Paste this job
profile_url,full_name,current_company,current_title,status,notes https://www.linkedin.com/in/example-person,Maya Chen,Acme,VP of Support,valid,moved from Northwind in March
Doing this with Kinlead
Kinlead can take a CSV of LinkedIn profile URLs into a lead group and score each lead from 0 to 100 against the customer you describe or your website. Leads below the fit line are not kept, so irrelevant rows do not enter a campaign. Any campaign can point at that group, and connection requests can carry an AI-written note under 200 characters that opens with why that person became a lead. See lead groups and scoring.
Frequently asked questions
Related
Get started with Kinlead
Prefer markdown? How to clean old LinkedIn lead lists for automation.md