E
Emerald Sheep
recent_exec_hires
is currently built to capture any new executive job title to surface new hires and promotions.
This is confusing and possibly misleading as the
previous_company_x
fields populate based on the last known company. The only way to check if the profile is a net-new hire or a promotion is to compare the
joined_date
to the
experience.end_date
where
job_company_id
=
previous_company_id
The proposed solution would be to create a new field called
recent_exec_promotions
that only captures executive job changes where
job_company_id
does not change between
job_title
changes.
Created by Kade Beem