4 Replies Latest reply on Feb 20, 2017 1:39 PM by Nate Oosterhouse

# Splitting target lists into 10% random samples

Hello all,

I am in need of some help and am in a hurry.

We have a campaign going out tomorrow and my boss just said he wants to send it out to a random groups that are 10% of the original target list size.  So send to 10% on this day....wait for their instruction and send to the next 10% on which ever day they specify.

So how can I generate random sets of targets from the list into 1/10th of the original target size.  Essentially split the targets into tenths randomly but each tenth cannot contain the same targets as another tenth.

Thanks!

• ###### Re: Splitting target lists into 10% random samples

Ultimately what you want to do is create 10 static lists that are comprised of a random 10% sample of your total list.  First, create those 10 lists in your program.  Then create a smart campaign to place the leads in those lists:

Smart List:

• Member of Master List

Flow step: Add to List (9 choices + default):

• Choice 1: If Random = 10, List Name: YourList1
• Choice 2: If Random = 10, List Name: YourList2
• Choice 3: If Random = 10, List Name: YourList3
• ...
• Default: List Name: YourList10

Now you have 10 lists - comprised of equal random samples of your master list - that you will use during each of the requested email sends.

3 of 3 people found this helpful
• ###### Re: Splitting target lists into 10% random samples

Hi Dan!

No one from the original target list will be in more than one of those static lists correct?

• ###### Re: Splitting target lists into 10% random samples

That's correct, Nate.

2 of 2 people found this helpful
• ###### Re: Splitting target lists into 10% random samples

Dan you are awesome.  This is an enormous help!