Hello! I am looking for a way to equally split lists within the hubspot platform. I recently came across the random sample function, which is close to what I'm looking for, but not exactly. Let's say I have a list of 100 contacts - I would like a way to split that (randomly if possible) into 4 equal segments of 25 contacts each, or 25% of the total amount. I want to ensure that each of those 4 segments do not overlap with each other. If I were to take 25% random samples of the same master list in hubspot, there will be crossover, which means I could accidentally be reaching out to the same contact twice. Currently, my workaround is time consuming: downloading the master list and finding methods to split CSV files online. Since some of these lists can be hundreds of thousands of records long, doing it manually on my computer is not possible, as CSV files of that size are known to crash even a robust set up, which my home computer is not. Thank you!
...read more