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.
Pardot Topic Categories
- Account Based Marketing (ABM) (8)
- Business Units (13)
- ChatGPT / AI (3)
- Completion Actions (5)
- Connectors (10)
- Custom Redirects (4)
- Demand Generation (8)
- Dynamic Content (5)
- Einstein Features (11)
- Email Delivery (18)
- Email Open Rates (3)
- Pardot A/B Testing (2)
- Email Mailability (16)
- Do Not Email (1)
- Double Opt-in (2)
- Opt Out / Unsubscribe (14)
- Email Preferences Page (6)
- Engagement Studio (14)
- Industries (1)
- Non Profit (1)
- Landing Pages (10)
- Lead Generation (1)
- Lead Management (12)
- Lead Routing (2)
- Lead Scoring (15)
- Leads (3)
- Marketing Analytics – B2BMA (9)
- Marketing Automation (1)
- Marketing Cloud (2)
- Marketing Cloud Account Engagement (4)
- New Pardot Features (6)
- Opportunities (2)
- Optimization (3)
- Pardot Admin (62)
- Duplicates (1)
- Marketing Ops (1)
- Pardot Alerts (1)
- Pardot API (2)
- Pardot Automations (3)
- Pardot Careers (12)
- Pardot Certifications (4)
- Pardot Consulting (1)
- Pardot Cookies (3)
- Pardot Custom Objects (3)
- Pardot Email Builder (7)
- Pardot Email Templates (9)
- HML (6)
- Pardot Events (16)
- Pardot External Actions (1)
- Pardot External Activities (4)
- Pardot Forms (27)
- Form Handlers (7)
- Pardot Integrations (21)
- Data Cloud (1)
- Slack (1)
- Pardot Lead Grading (5)
- Pardot Lead Source (2)
- Pardot Lightning (1)
- Pardot Migration (1)
- Pardot Nurture / Drip Campaigns (1)
- Pardot Personalization (3)
- Pardot Profiles (1)
- Pardot Releases (19)
- Pardot Sandboxes (2)
- Pardot Segmentation (4)
- Pardot Strategy (7)
- Pardot Sync (2)
- Pardot Sync Errors (1)
- Pardot Tracker Domains (5)
- Pardot Training (3)
- Pardot Vs Other MAPs (4)
- Pardot Website Tracking (2)
- Reporting (22)
- Salesforce and Pardot (29)
- Marketing Data Sharing (2)
- Pardot Users (3)
- Salesforce Automation (4)
- Salesforce Flows (1)
- Salesforce Campaigns (20)
- Salesforce CRM (3)
- Record Types (1)
- Salesforce Engage (3)
- Salesforce Queues (2)
- Security and Privacy (1)
- Tags (3)
- The Authors (483)
- Cheshire Impact (9)
- Greenkey Digital (47)
- Invado Solutions (37)
- Jenna Molby (9)
- Marcloud Consulting (6)
- Nebula Consulting (53)
- Pardot Geeks (38)
- Salesforce Ben | The Drip (235)
- SalesLabX (2)
- Slalom (2)
- Unfettered Marketing (45)
- Uncategorized (1)
- Website Tracking (2)
- Website Search (1)
More Pardot Articles
See all posts
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