# Random Split List

**URL:** <https://community.hubspot.com/t/random-split-list/18977>\
**Category:** HubSpot Ideas\
**Tags:** segments, marketing-email\
**Created:** [February 23, 2020, 3:20pm UTC](https://community.hubspot.com/t/random-split-list/18977 "2020-02-23T15:20:22Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![vdecker1](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/vdecker1/32/76463_2.png) [@vdecker1](https://community.hubspot.com/u/vdecker1)\
**Post date:** [February 23, 2020, 3:20pm UTC](https://community.hubspot.com/t/random-split-list/18977/1 "2020-02-23T15:20:22Z")

</div>

I’m looking to create a random split list off of my master list, like A/B or A/B/C so I can test things like send times. Right now the only way I can think to do this is to export the list, add a column with a value, re-import and then segment. Would be great if the system could allow you to split the list into how ever many sub-segments you want and have it random.

---

<div class="post-metadata">

**Author:** ![chrisp\_aus](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/chrisp_aus/32/29368_2.png) [@chrisp\_aus](https://community.hubspot.com/u/chrisp_aus)\
**Post date:** [May 13, 2020, 7:43am UTC](https://community.hubspot.com/t/random-split-list/18977/2 "2020-05-13T07:43:04Z")

</div>

It would be good to be able to create groups based on the last numeral of the ContactID number. This would presumably be random and a good way to split lists. E.g. add to list where last numeral of ContactID is 0,1,2,3,4 would select 50% of the group.

---

<div class="post-metadata">

**Author:** ![chrisp\_aus](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/chrisp_aus/32/29368_2.png) [@chrisp\_aus](https://community.hubspot.com/u/chrisp_aus)\
**Post date:** [May 13, 2020, 7:57am UTC](https://community.hubspot.com/t/random-split-list/18977/3 "2020-05-13T07:57:45Z")

</div>

Just tested this with my database. Hubspot seems to have disproportionately allocated the ContactID numbers in my account. IDs ending in 1 make up 22% of the total while each of the other numerals make up 9%.

---

<div class="post-metadata">

**Author:** ![TheBenjamin](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/thebenjamin/32/51304_2.png) [@TheBenjamin](https://community.hubspot.com/u/TheBenjamin)\
**Post date:** [November 19, 2020, 4:44pm UTC](https://community.hubspot.com/t/random-split-list/18977/4 "2020-11-19T16:44:33Z")

</div>

This may be the brute force / naive way to do it but I created four **Active** lists based on first character of an email address. The lists did not come out to 25% each but if I want to do a pure A/B test (50% each) then I can combine two of these lists to get about equal split:

- A E I M Q U Y 3 7 ! % ( +
- B F J N R V Z 4 8 @ ^ ) =
- C G K O S W 1 5 9 # & - ?
- D H L P T X 2 6 0 $ \* \_ ~

Also not sure if it makes a difference but I entered each letter twice -- once upper and then again as lowercase.

Honestly, this is a hack and HS should really support this out of the box. But hey, there’s a f\*king global pandemic and widespread unemployment, life isn’t too bad if my biggest problem today is hacking together an A/B list.

---

<div class="post-metadata">

**Author:** ![MWestlake](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/mwestlake/32/2490_2.png) [@MWestlake](https://community.hubspot.com/u/MWestlake)\
**Post date:** [December 15, 2020, 10:19pm UTC](https://community.hubspot.com/t/random-split-list/18977/5 "2020-12-15T22:19:35Z")

</div>

Yes!! Would also love this feature. Such a pain to export, randomize, and reimport.

---

<div class="post-metadata">

**Author:** ![Saper](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/saper/32/61905_2.png) [@Saper](https://community.hubspot.com/u/Saper)\
**Post date:** [March 4, 2021, 8:37am UTC](https://community.hubspot.com/t/random-split-list/18977/6 "2021-03-04T08:37:28Z")

</div>

Again a simple yet vital functionality missing. It’s amazing that HubSpot doesn’t provide flexibility on such simple and essential things. How difficult can it be to enable such list splits for multivariate testing? In some cases, offering only A/B testing is just like a kindergarten level when the situation calls for a proper multivariate test.

---

<div class="post-metadata">

**Author:** ![ChaosFreak](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/chaosfreak/32/56997_2.png) [@ChaosFreak](https://community.hubspot.com/u/ChaosFreak)\
**Post date:** [April 30, 2021, 9:03pm UTC](https://community.hubspot.com/t/random-split-list/18977/7 "2021-04-30T21:03:49Z")

</div>

Everyone seems to have different specific requirements, but the general solution would be as follows:

Allow us to split any contact list (the primary list) into multiple sub-lists, and assign a percentage or total number of contacts to each sub-list. Each sub-list would be automatically populated with a random sample of the primary list. You can also specify sub-list “groups” where the sub-lists in the group are guaranteed not to overlap at all (i.e. not to contain the same contact).

Example:

Primary List contains 100,000 contacts.

Example 1: I want to create four sub-lists, with 10%, 30% and 60% of the primary list.

Example 2: I want to create one sub-list with only 33% of the primary list (there should be no limitation that sub-lists add up to 100%, you can choose less if you want)

Example 3: I want to create five sub-lists with 150 contacts each.

Example 4: I want to create a sub-list with 3790 contacts, one with 15,333 contacts and one with 21,222 contacts (you get it--it should be flexible and not have silly, unnecessary restrictions)

---

<div class="post-metadata">

**Author:** ![hchristian](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/hchristian/32/102437_2.png) [@hchristian](https://community.hubspot.com/u/hchristian)\
**Post date:** [July 9, 2021, 9:34pm UTC](https://community.hubspot.com/t/random-split-list/18977/8 "2021-07-09T21:34:54Z")

</div>

Upvoting on behalf of a customer. This is a great idea!

---

<div class="post-metadata">

**Author:** ![PhilZ87](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/philz87/32/7115_2.png) [@PhilZ87](https://community.hubspot.com/u/PhilZ87)\
**Post date:** [July 23, 2021, 1:23pm UTC](https://community.hubspot.com/t/random-split-list/18977/9 "2021-07-23T13:23:04Z")

</div>

I could copy my comments from all the other ideas as always…

Essential, standard feature, all competitors have it…etc. etc…

I know HubSpot won’t work on this anyway. But since this is the only way to voice our dissatisfaction, I’ll guess i do it.

---

<div class="post-metadata">

**Author:** ![ChrisLumi](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/chrislumi/32/35926_2.png) [@ChrisLumi](https://community.hubspot.com/u/ChrisLumi)\
**Post date:** [December 2, 2021, 9:24am UTC](https://community.hubspot.com/t/random-split-list/18977/10 "2021-12-02T09:24:30Z")

</div>

I’ve (sort of) managed this.  
Option 1.) A workflow that all contacts go through. If their first name begins with the character ACEGI etc. they get assigned A in an AB property.  
Option 2.) Set up Identical AB emails as form fill follow-ups then assign the property based upon which Hubspot decided they get. You can also weight how many of your contacts get on each list way.  
But yes a more robust solution would be ideal.

---

<div class="post-metadata">

**Author:** ![kassieteagarden](https://avatars.discourse-cdn.com/v4/letter/k/ba9def/32.png) [@kassieteagarden](https://community.hubspot.com/u/kassieteagarden)\
**Post date:** [February 8, 2022, 11:40pm UTC](https://community.hubspot.com/t/random-split-list/18977/11 "2022-02-08T23:40:50Z")

</div>

I would really love to be able to create a list of ‘[Sales Rep Name] Contacts’ and then create a sub-list of ‘[Sales Rep Name] Customers’ and another sub-list of ‘[Sales Rep Name] Prospects’… this should be easy enough.. I’m surprised HubSpot doesn’t have this.. Act-On does..

---

<div class="post-metadata">

**Author:** ![NBedo](https://avatars.discourse-cdn.com/v4/letter/n/a5b964/32.png) [@NBedo](https://community.hubspot.com/u/NBedo)\
**Post date:** [February 24, 2022, 6:18pm UTC](https://community.hubspot.com/t/random-split-list/18977/12 "2022-02-24T18:18:50Z")

</div>

Yes, this would be very helpful!

---

<div class="post-metadata">

**Author:** ![danmartin](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/danmartin/32/44503_2.png) [@danmartin](https://community.hubspot.com/u/danmartin)\
**Post date:** [March 31, 2022, 12:58am UTC](https://community.hubspot.com/t/random-split-list/18977/13 "2022-03-31T00:58:10Z")

</div>

This would be an absolutely amazing feature to have! We’d like to survey our own contact base, but don’t need to email tens of thousands of people - just a sample size that meet a certain set of parameters. Building a list, exporting it, randomising it, and reimporting it is a bit tiresome.

---

<div class="post-metadata">

**Author:** ![ABork](https://avatars.discourse-cdn.com/v4/letter/a/4da419/32.png) [@ABork](https://community.hubspot.com/u/ABork)\
**Post date:** [March 31, 2022, 5:02pm UTC](https://community.hubspot.com/t/random-split-list/18977/14 "2022-03-31T17:02:39Z")

</div>

Upvoting this! Pardot has a similar feature. It would be awesome to be able to randomly split lists either 50/50 or a percentage variation without export/import hassle. This would be great for A/B tests or phased batching email sends.

---

<div class="post-metadata">

**Author:** ![Vivre](https://avatars.discourse-cdn.com/v4/letter/v/e99b99/32.png) [@Vivre](https://community.hubspot.com/u/Vivre)\
**Post date:** [May 24, 2022, 4:16am UTC](https://community.hubspot.com/t/random-split-list/18977/15 "2022-05-24T04:16:57Z")

</div>

I would use this feature for sure! Pretty please can we have it?

---

<div class="post-metadata">

**Author:** ![SRKelly](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/srkelly/32/103093_2.png) [@SRKelly](https://community.hubspot.com/u/SRKelly)\
**Post date:** [June 16, 2022, 2:23pm UTC](https://community.hubspot.com/t/random-split-list/18977/16 "2022-06-16T14:23:16Z")

</div>

We need this as well and I also like the proposed solution of sub lists (pasting it again here)

[ChaosFreak](https://community.hubspot.com/t5/user/viewprofilepage/user-id/92134)

‎Apr 30, 2021 5:03 PM

Everyone seems to have different specific requirements, but the general solution would be as follows:

Allow us to split any contact list (the primary list) into multiple sub-lists, and assign a percentage or total number of contacts to each sub-list. Each sub-list would be automatically populated with a random sample of the primary list. You can also specify sub-list “groups” where the sub-lists in the group are guaranteed not to overlap at all (i.e. not to contain the same contact).

Example:

Primary List contains 100,000 contacts.

Example 1: I want to create four sub-lists, with 10%, 30% and 60% of the primary list.

Example 2: I want to create one sub-list with only 33% of the primary list (there should be no limitation that sub-lists add up to 100%, you can choose less if you want)

Example 3: I want to create five sub-lists with 150 contacts each.

Example 4: I want to create a sub-list with 3790 contacts, one with 15,333 contacts and one with 21,222 contacts (you get it--it should be flexible and not have silly, unnecessary restrictions)

---

<div class="post-metadata">

**Author:** ![mlvanhorn](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/mlvanhorn/32/102498_2.png) [@mlvanhorn](https://community.hubspot.com/u/mlvanhorn)\
**Post date:** [November 28, 2022, 8:27pm UTC](https://community.hubspot.com/t/random-split-list/18977/17 "2022-11-28T20:27:51Z")

</div>

Agreed, being able to randomly split lists would be extremely useful for A/B testing

---

<div class="post-metadata">

**Author:** ![Mike\_Donnelly](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/mike_donnelly/32/104979_2.png) [@Mike\_Donnelly](https://community.hubspot.com/u/Mike_Donnelly)\
**Post date:** [January 6, 2023, 10:18pm UTC](https://community.hubspot.com/t/random-split-list/18977/18 "2023-01-06T22:18:50Z")

</div>

Community - If this is still needed (we needed it for our own marketing efforts), we built a free tool in the HubSpot app marketplace called Split Test Automation. If you have any questions, please feel free to reach out mike[at][theseventhsense.com](http://theseventhsense.com)

> **[HubSpot Marketplace](https://ecosystem.hubspot.com/marketplace/apps/marketing/marketing-automation/split-test-automation-by-seventh-sense-456464)**

---

<div class="post-metadata">

**Author:** ![maldao](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/maldao/32/41549_2.png) [@maldao](https://community.hubspot.com/u/maldao)\
**Post date:** [February 7, 2023, 1:14pm UTC](https://community.hubspot.com/t/random-split-list/18977/19 "2023-02-07T13:14:39Z")

</div>

I have a list with 25.000 contacts.

I want to create five sub-lists with 5000 contacts each

Need to test days!

monday 5000  
tuesday 5000  
wednesday 5000  
thursday 5000  
friday 5000

---

<div class="post-metadata">

**Author:** ![Mike\_Donnelly](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/mike_donnelly/32/104979_2.png) [@Mike\_Donnelly](https://community.hubspot.com/u/Mike_Donnelly)\
**Post date:** [February 7, 2023, 1:49pm UTC](https://community.hubspot.com/t/random-split-list/18977/20 "2023-02-07T13:49:22Z")

</div>

Hey @maldao - The first example in this article explains how you can do this easily with split test automation: [Want to answer your burning email marketing questions with HubSpot?](https://www.theseventhsense.com/blog/split-test-automation-use-cases)

[Next page](https://community.hubspot.com/t/random-split-list/18977.md?page=2)
