Split promotions from recent_exec_hires into a new field
being researched
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_internal_changes
that only captures executive job changes where job_company_id
does not change between job_title
changes.S
Sam Rounds
Merged in a post:
Separate field for internal executive job changes
S
Sam Rounds
Today, the Recent Exec Hires and Recent Exec Departures fields in PDL's company dataset include internal role changes.
This feature request is to instead break out any executive level job changes at the company to a separate field.
S
Sam Rounds
marked this post as
being researched
B
Ben Eisenberg
Merged in a post:
Confusion between executive arrival and departure
M
Maroon Peafowl
Photo Viewer
View photos in a modal
S
Sam Rounds
marked this post as
doing soon
We're making this change/addition in early 2024. More to come soon!
A
Aegean blue Jaguar
Sam Rounds Hi Sam, was this ever completed?
S
Sam Rounds
Hi Aegean blue Jaguar - no. The Recent Exec Hires field still includes both internal promotions and external hires.