A Quick and Easy Way to A/B Split Your Marketing Automation Database

April 19, 2022
Pardot A/B Testing, Unfettered Marketing

Sometimes it’s helpful to be able to split our data into a couple of chunks to make it more manageable. Maybe we want to A/B test a subject line, or simply to candence sending times in an automation.

Here’s a really simple way to automatically split your database so you can use that split in any list or automation.

Create a random number field (preferably a number field).
Create automations that assigns the number 1 to anyone that has a last name starting with A-K and 2 to anyone with a last name starting with L-Z. This the approximate 50/50 distribution of first letters of last names in the US.

Here’s a screenshot of what the L-Z automation rule would look like in Pardot (MCAE*)

Now you can use this value– if the random number is 1 or 2 to split an automation or program path.

Note that if you don’t have last names for some people in your database then you will have some prospects where this value is blank. You will have to decide how you want to deal with the blanks– either by excluding them from the list, or treating them as a third group.

Here’s some ideas on how to use this:

Split an automation to test an A or B version of an email, or test the order in which you send emails.
Delay sending of a large set of emails to half the group so all all emails are not sent at the same time.
Randomly splitting the assignement of new leads between 2 people.

This is an actual the random number split from a real dataset using this method:

This Pardot article written by: Bill Fetter

Unfettered Marketing

A collection of random thoughts on how people, places and things in our fascinating world connect to sales and marketing, and what we can learn from it.

Original Pardot Article: https://www.unfetteredmarketing.com/post/a-quick-and-easy-way-to-a-b-split-your-marketing-automation-database

Find more great Pardot articles at https://www.unfetteredmarketing.com/blog

Pardot Experts Blog

We have categorized all the different Pardot articles by topics.

Unfettered Marketing

A collection of random thoughts on how people, places and things in our fascinating world connect to sales and marketing, and what we can learn from it.

A Quick and Easy Way to A/B Split Your Marketing Automation Database

Unfettered Marketing

Pardot Experts Blog

Pardot Topic Categories

More Pardot Articles

Data Cloud & Account Engagement – What you need to know

Marketing Cloud Growth vs Account Engagement (Pardot)

Summer ’24 Broke Lead Assignment Notifications in Account Engagement

Using Engagement Studio Programs for Lead Assignment

How to generate content with Einstein Assistant in Pardot

Increase productivity with Sales Engagement Basic

Account Engagement’s Email Builder – New Email Experience

How to work with Person Accounts in Pardot

Unfettered Marketing

Pardot School