Jarek Orenowicz

Yeah got to do some additional scoring. Thank!

thanks... this one I know 🙂 but it'll create a new table, and i want results in the row that im processin... or am i missing smth..?

Mateusz Sekta skop tyłki, bracie

so here's an interesting one... i actually am able to do this with apollo.io running this query: Excluded Companies: [this company name], Past Companies: [this company name] [* edit *] actually i can further improve it by setting time in current role, this way I can filter out employees who churned outside of the time window I will check their API and see if this can be done from Clay.

Daniel Kupka (Clay) & Gui Stetelle thanks for your insights, I dare to say these do not address the issue 🙂 now bear with me I will explain why. the change in employee number is not retention. there may be no change in # employees QoQ or YoY, whilst the churn may be enormous (or none, for that matter). So i was thinking along these lines:

now, this has obvious limitations, as it makes no economic sense to inspect potentially hundreds of contacts to get just one number. hence my question, opinions welcome :)