Dynamic Lists to Clean Up Your Database

Lara Black inspired and contributed to this blog.

Are you trying to keep your mailable limit down?  

Marketers often find themselves creeping close to their mailable limit and either have to clean out the MCAE (Pardot) database or pay up.  

Go to Pardot Settings > Account Settings > Usage and limits to see where you stand. Look at your current mailable prospects against your system limit.

This Salesforce resource is helpful, but I’m taking it further. Once you are ready, here are some dynamic list ideas to get you started in the cleaning process.

Never been emailed

Look for prospects who have been in the system for more than a year, and you’ve never emailed them. It’s a two-step (two list) process.

  1. First, create a dynamic list (named Database cleaning) with the criteria “Prospect has been emailed at least one time in the last 10,000 days.”
  2. Then create a second dynamic list for “Prospect is NOT a member of Database cleaning” AND “Prospect time is greater than 365 days.” (You can change the day count to suit your situation.)

account engagement dynamic list created days ago

Lack of engagement

Create a dynamic list to check for inactivity. For example, use the “Prospect has been emailed,” “Prospect created” and “Prospect last activity days ago .”The last activity criteria checks for form submissions and email clicks. See details here. (Do not use email open because it is no longer a reliable email metric.)

I usually copy this list and create multiple versions for different day variations. For example, try 730 days, 365 days, or 180 days.

What do the results tell you?

account engagement dynamic list prospect has been emailed

Competitors

Get rid of competitors.

account engagement dynamic list email contains

Unqualified job titles

Eliminate unwanted job titles.

account engagement dynamic list job title

Salesforce unqualified

Often, companies have a custom field to denote retired/deceased/left the company status for Lead or Contact records. Use those criteria to filter out these unwanted prospects.

account engagement dynamic list inactive true

Low scores

Rule out prospects based on low scoring and grading criteria (could use either Match All or Match Any).

account engagement dynamic list prospect score

Next Steps

Now what?

You have your lists, and you’ve identified which prospects need to say “bye-bye.” You have choices for elimination. Here are the actions to consider:

Delete in Salesforce

I would explore this option first. If you have a segment of prospects that you will never email and they are in Salesforce, talk to your Salesforce admin to potentially delete them altogether. When you delete a Lead or Contact record in Salesforce, MCAE (Pardot) will put the corresponding prospect in the recycle bin. Bam! Two for one effort, and it results in an overall cleaner database!

Recycle bin

When you delete a prospect, MCAE (Pardot) will put it in the recycle bin. Prospects in the recycle bin don’t count toward usage limits and will NOT delete the corresponding Lead or Contact records in Salesforce.

To delete a prospect from a list, select the check box in the top left to pick all the prospects. You will need to use table actions to delete prospects.

Read more about the recycle bin. You can restore prospects from the recycle bin. 

account engagement table actions

Do Not Email

Marketers can use the Do Not Email field for email suppression. Prospects marked as Do Not EMail also don’t count toward usage limits. But remember, prospects marked Do Not Email can still get operational emails.  

Create a repeating automation rule for any prospects you want as Do Not Email. For example, the automation rule below will mark the prospects Do Not Email immediately without any additional effort.

account engagement dynamic list Do Not Email

What to do with bounced prospects?

A bounced prospect is an invalid email or a prospect has soft bounced five times.

These don’t hurt your database count, but over time they can become an overwhelming segment of your MCAE database.  

First, talk with your Salesforce administrator. If the prospect’s email bounced, they are likely people who have left their job and could be deleted in Salesforce. Otherwise, I’d send them to the recycle bin as well.  

 


 

This Pardot article written by:  Jen Kazin

Greenkey Digital

Unlock the Power of Pardot. Don’t spend tens of thousands of dollars on marketing systems to simply… send emails.

Original Pardot Article: https://greenkeydigital.com/database-clean/?utm_source=rss&utm_medium=rss&utm_campaign=database-clean

Find more great Pardot articles at https://greenkeydigital.com/

Pardot Experts Blog

We have categorized all the different Pardot articles by topics.

Pardot Topic Categories

More Pardot Articles

See all posts

 


 

This Pardot article written by:  Jen Kazin

Greenkey Digital

Unlock the Power of Pardot. Don’t spend tens of thousands of dollars on marketing systems to simply… send emails.

Original Pardot Article: https://greenkeydigital.com/database-clean/?utm_source=rss&utm_medium=rss&utm_campaign=database-clean

Find more great Pardot articles at https://greenkeydigital.com/