Skip to main
All claybooks
/
RevOps
/
Find prospects who changed companies using formulas

Find prospects who changed companies using formulas

See who on your target list has changed jobs to a new company in the last 3, 6, or 12 months.

Start building now with
No items found.
Download the template
Get started

Before we begin

‍

Have emails or LInkedIn profile URLs of target prospects and want to find out which of them is new in their role?

‍

In this Claybook, we’ll show you how to use Clay’s customizable formulas and LinkedIn enrichment to do just that. 

Information
Follow the step by steps here in Clay
Download the free template
1

First, copy this table in Clay. 

If you’re already a user, you’ll be directed to your workspace. If not, you’ll be prompted to create a free Clay account.

The interactive demos on the right will walk you through each step of this Claybook. 

2
Step 2:

Customize formulas

To change how recent you want to check for job changes, adjust the number of months in both the new role and new role + new company columns.

The former looks to see if someone changed roles within the timeframe you chose. The latter looks to see if that new role also came with a new company. 

3
Step 3:

Bulk upload LinkedIn URLs

Last, bulk upload LinkedIn URLs using a CSV and find job movers at scale. 

Don’t have LInkedIn URLs? Then find LinkedIn URLs using email addresses. 

Other popular resources

Experts

Find a Clay Expert

Explore our network of Clay experts and agencies.

View experts
Community

Join our slack community

Find help in our slack community, and support channels.

Go to slack
Cohorts

Join a cohort, learn Clay fast!

The faster way to master Clay. Sign in if you're enrolled in a cohort (current or past) or apply to an upcoming one!

Learn more about cohorts