We are creating an automation that enriches decision makers in a clay...

·

We are creating an automation that enriches decision makers in a clay table and equally splits them into two seperate linkedin automation campaigns through expandi. We are unable to find a way to split the contacts into multiple campaigns though. Any ideas?

25 comments

· Sorted by Oldest

Clay Team
APP
·
Hey hey! Can you drop the URL for your table here? (if applicable) 🫶 Don't worry, only admins will be able to open your table 😉
Clay Team
APP
·
Hey Sergio! Good one— are there any specific criteria that you're splitting them by, or just equal split overall?
Sergio Apollo
·
Equal split
Sergio Apollo
·
No criteria
Sergio Apollo
·
Arturo (Clay)
Eric Nowoslawski
·
I literally make a formula saying "output a random number between 1 and 2" and then I make a conditional run for each campaign being either a 1 or a 2
Sergio Apollo
·
This is smart hahah
Clay Team
APP
·
Cool! So it's probably best to have a formula column that assigns a number to each lead, either 1 or 2, and have two export columns that each run only when that criteria is met in campaign 1 or campaign 2.Not perfect but it's automatic
Sergio Apollo
·
I was thinking to make a formula if row is even or odd but didnt work
Eric Nowoslawski
·
it's like kind of dumb, which makes it smart haha
Clay Team
APP
·
ahhh, there you go. Eric beat me to it lol
Sergio Apollo
·
Thank you guys !! Eric Nowoslawski Arturo (Clay)
Sergio Apollo
·
I feel like the (clay) parenthesis should still be around Erics name haha !!
Clay Team
APP
·
My sneaky way to even it out a bit further is to: 1. first assign a random number, 1 or 2, 2. then I use a Lookup Record to count how many of each (1s or 2s are in that column) 3. if that count is an odd number, then I use a final formula to spit out the opposite number to "even it out"
Clay Team
APP
·
Let me know if that makes sense or need help setting it up!