SOLVED

Splitting target lists into 10% random samples

Go to solution
Nate_Oosterhous
Level 7

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!

1 ACCEPTED SOLUTION

Accepted Solutions
Dan_Stevens_
Level 10 - Champion Alumni

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.

View solution in original post

6 REPLIES 6
Dan_Stevens_
Level 10 - Champion Alumni

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.

Nate_Oosterhous
Level 7

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?

Dan_Stevens_
Level 10 - Champion Alumni

Re: Splitting target lists into 10% random samples

That's correct, Nate.

Nate_Oosterhous
Level 7

Re: Splitting target lists into 10% random samples

Dan you are awesome.  This is an enormous help!

NathanDropboxOP
Level 1

Re: Splitting target lists into 10% random samples

Ive tried this but the static lists are still empty?

Nathanel Johnson
Marketing Ops
Darshil_Shah1
Level 10 - Community Advisor + Adobe Champion

Re: Splitting target lists into 10% random samples

Can you please share the snapshots of your campaign setup and the results tab?