MARDREAMIN’ SUMMIT 2025
MAY 7-8, 2025 IN ATLANTA - GA

Days
Hours
Minutes
Seconds
🎉 The Event Is Live! 🎉

NOW PLAYING

View the session live or catch the replay here. You’ll find the recording and all related resources on this page once available.

Looking for the Chat?

Our live discussions are happening over in Slack. That’s where you can connect with speakers, join session threads, and chat with other attendees in real time.

Automate All the Things in Account Engagement

Hate spending time cleaning event lists, normalizing data, and, in general, manually doing things over and over again? Me too!

In this session, learn how to automate data cleaning, build dynamic email suppression lists, and make your Account Engagement org run smoother, without writing any code.

We’re talking all Account Engagement, all day, with no special Salesforce permissions necessary.

ExtensisHR

Lara

Black

Keep The Momentum Going

Episode 1 – Dear Marketing, Signed—Sales: ABM Edition

Video Transcript

Speaker 0: Alrighty. Welcome, everyone. Welcome. Just gonna give a minute or two for people to filter in. Welcome, Laura. Thank you. I will introduce you. Laura Laura Black’s been a, uh, Pardot user since 2011. So before Salesforce knew anything about Pardot, um, she is a four time Salesforce MVP, and, um, her Twitter handle is Pardot Pro, um, on on, uh, Twitter. And, of course, she hails from Austin, Texas. Welcome, Laura.

Speaker 1: Yeah. Thanks. It’s been a, um, a fun few years. Yeah. So I started using Pardot back when I was a marketing assistant. My VP of marketing came to me and was like, hey. I went to this conference, and we’re gonna buy this thing called Pardot, and you’re gonna learn how to use it. Um, so I was like, oh, I better go get a notepad and, uh, start taking notes.

Speaker 0: We call that an accidental admin.

Speaker 1: Yeah. Yeah. There there wasn’t, uh, we we weren’t even Kardashians at the time. That didn’t even exist as a name. So

Speaker 0: Alright. Well, once again, welcome, everyone. We have some people still filtering in here. Um, got a great, uh, great group here. You you are, um, you are in the automate all things in account engagement. So, um, if that’s what you were looking for, then you’re in the right place. Um, I do encourage you, um, after this to check out. We have, um, a really packed three days of really, um, awesome sessions. So would encourage you to check out the agenda, make sure, um, you see what we have avail available. But I’m gonna turn it over to Laura now. If you have any questions, um, please put them, um, in the q and a up at the top there on the right hand side. Um, we also have our session chat open, and I’ll be putting a few notes in there throughout the session. But, uh, go ahead, Laura. Take it away.

Speaker 1: Alright. So welcome everyone to automate all the things in account engagement, a k a Pardot. Um, you are gonna hear me call it Pardot just because I’ve been a Pardot user since 2011, and it’s just stuck in my brain. Um, but this session is really designed to talk about, you know, what are the things that you as a marketing person can do that doesn’t involve code? How can you resolve some of your problems with Pardot, um, without writing a line of code? And there’s a lot you can do just inside of Pardot to, um, to fix up some problems, to set yourself up for success. So we are going to kick off with thanks to our awesome sponsors. Um, I’ve used a lot of these in my time. Uh, Stencil is I’m actually a current client of Stencil, and PFL is a great company. I don’t know all of them, but thank you to all of our awesome sponsors. Uh, so we are gonna talk about a few big points. Data cleaning with Engagement Studio. Uh, fun fact, as Mike Cruiser likes to say, you don’t have to send email with engagement studio. It doesn’t have to send email. Although that is what we think about it in terms of nurturing, you can you can leverage it for many more things. I’m gonna talk about creating a master suppression list, um, and I’m also gonna talk about competitor handling and a couple of other helpful dynamic lists. I’m gonna talk a little fast because this is a lot to cover in our time, um, but please go ahead and put your questions in the chat. If I see them, I’ll answer them, but, otherwise, we’ll do questions at the end. So data cleaning with engagement studio. Uh, so this really stems from what I call Laura hates to do things over and over and over again. Um, so really common scenario, someone sends you an Excel file. You’re they’re like, hey. Get this into Pardot. We’re gonna wanna, you know, nurture them, or we’re gonna go to an event. Here’s the list of people we need to invite to meet us at the event. So what do you have to do every time you get one of these Excel files? Is you have to look it over, correct the data, most commonly, states and countries. Maybe you have some other tedious fields you always need to be filled in. But you have to do this data correction before you can import it to Pardot. Otherwise, you know, your your system is all out of sync. And if you wanted to send an email to everybody in Florida, you have to create a really tedious list or or do data cleaning later. So let’s talk about what you can do to set yourself self up so you don’t have to do these tedious things over and over. So to dive into this, to create an engagement studio that’s going to save you all this time, just set yourself up, do a quick look, see what are the correct values you need for Salesforce. So we’re gonna talk about correcting states and countries. Um, so you need what are the values that Salesforce wants for state and countries. You’re gonna create a dynamic list for each of those. You’re gonna create an engagement studio, and then you’re gonna take some time and build out that engagement studio with a lot of rule checks and then actions of of changing values. So let’s take a quick look. Um, I do have some handy downloads for you. Um, on my website, I have these as text files. So if you want The US states, you can get a list of The US states. If you want a list of the countries, you can get the country values as a, um, as a quick download. Um, and this will circulate later, so we can definitely, um, you know, you don’t have to try and type every single one of these. Um, but, basically, for your dynamic list for states, you’re gonna make a dynamic list that says the prospect default field for state is not empty, and the default field for country is United States, and then a series of the prospect default field state is not, and then you’re gonna have all of the correct state values in in it. And that’s where that previous screen, that that list comes in handy. So this is what it looks like. In Pardot, you have the option to, um, you know, it says isn’t, not is not, but same same concept in the in the box. You you have, um, the ability to type in the exact state values. So Alabama semicolon in Pardot language is an or. So it’s it’s state isn’t Alabama, isn’t Alaska, isn’t Arizona. And you’re gonna do a match all on these. So you’re not accidentally hitting, like, Germany and their state is, um, you know, AR or something like that. You wanna hit the exact right segment of people. Um, so filter filter the ones that are incorrect. So you know that they’re in The United States. You know they have a state value. State value is not empty. But it’s not hitting one of the correct state values, Alabama, Alaska, Arizona, etcetera, etcetera. District of Columbia should probably be in there. So this is gonna be your dynamic list, which is gonna be the recipient list recipient list even though we’re not sending any emails. But you’re going to use that dynamic list as the recipient list of your engagement studio program. And you’re just gonna build out a series of repeating steps. A yellow, uh, step, which is listening or, um, checking a field value. Uh, that yellow step creates a yes, no branch. And on the yes path, if they meet the criteria, um, you know, I’m gonna show you that in a second, then you’re gonna correct the data on the blue path. And then you’re gonna add a red end step, meaning that person who met met that value now exits the program. And you’re gonna do this, um, very left hand branching program, and it’s gonna have what I call the ultimate no path. Somebody met the dynamic list but did not meet the other other values and get corrected. So they went down the ultimate no path, and, um, something’s wrong with them. So they didn’t meet the exact criteria. They didn’t get corrected. So that step has a notify user, which is usually me, to say, hey, Laura. Something’s wrong with your engagement studio program. So zoomed out, this is what this looks like. So I said it’s recipient program at the start, and then, uh, it goes down to a yellow step. Is the field value, you know, out does it begin with a L, Alabama? You know, is it is it the two letter code, etcetera, etcetera. And so it’ll just correct the state values and just exit on those red steps. And then, um, notice how it, like, builds down into the left, like I said. So here’s where, you know, the zoomed in view. We start with the recipient who meets the dynamic list. Um, their state value is equal to a l. So this is the two letter, um, um, Alabama. Right? So we know that we wanna correct it on the yellow the yellow makes a branch, yes or no. Uh, and on the yes, the state value is exactly a l. We know we wanna change it to Alabama because that’s the two letter state code for Alabama. We didn’t say prospects field begins with AL because that could match Alaska. We say it is AL. Right? Exact two letter match. Those two letter matches, we’re gonna correct to Alabama. And that’s the yes you know, the the blue gets added to the yes step, and then you just end them on that path because they don’t need to go down the other logic check. Some people build this as, like, a bunch of looping around, looping around, but you don’t need to build out. They don’t need to go down all those 50 plus steps. Just let them end, um, and that saves you a lot of time. Um, so you just kinda continue down. On the no path, you build out the next step. Um, you build out, you know, is the state a k, that’s Alaska. You know, on the yes path, change to Alaska, so on and so on. And just keep building. It is a little tedious, but what I’ll say is that engagement studio does have a, um, copy steps program. So I encourage you to take advantage of that. You’re gonna copy a blank yellow step. You’re gonna copy the blue step and and so on and so on. So save yourself some time and, like, copy those steps, and then you’ll just have to open them each and put in the correct values and so on and so on. So this is the very far left path of the program, what I call the ultimate no. So if they made it through all those logic checks and still didn’t meet a yellow yellow one and go down a yes path, they’re gonna hit my ultimate no path. No. They didn’t meet any of these logic checks. And it’s going to send me a part of email, you know, a notification that, hey. This person, um, did something in this engagement studio. And I’ve named my engagement studio something very obvious. It’s like correct US states or something like that. So if I get a notification that says, Laura, somebody, you know, is notifying you, I know that I should open up that prospect and figure out what went wrong. Maybe I forgot to include, you know, Wyoming. Maybe I forgot to fill in Michigan, um, or I duplicated something and left those steps out somewhere. Great. I can just run them through this program. I’ll get notified. And, eventually, I get no more notifications unless something is really, really wrong with their data. Like, their country said United States and state wasn’t empty, but they actually are supposed to be in Germany or United Kingdom or something like that. In which case, I’ll go in, I’ll open up those people, and I’ll change their country, um, to to be actually correct. So this kinda builds in those checks for you that you did it correctly, um, and that when somebody does actually notify you, it’s actually something that’s actually wrong. So this again is the full view zoomed out. So remember, like, it’s building down and to the left to get get to your ultimate no path. That’s super handy. And, um, so that was states. Countries is very similar, although there’s a lot more countries. So it’s really the dynamic list for countries is the prospect default field for country is not empty, and you’re gonna put in the correct values of countries. So, again, we’ll circulate slides so that you can grab those lists from my website. Um, but I grab the list of countries from like, if you have state and country pick list set up for Salesforce, I grab the countries that Salesforce is gonna want you to match. So you can quickly grab those. So, again, you’re going to have a lot of these, um, you know, at the very top, default field, country is not empty, but then you’re gonna have a lot of these country isn’t American Samoa, South Korea, etcetera, etcetera, etcetera. Um, so you’re gonna have a lot of those, and I believe my list, like, builds it out for you so you have those groups and can just, like, copy and paste it. And then, again, you’re just gonna build this same dynamic list, but what I would tell you is you probably don’t need to build a step for every country. Your company probably does business with just a few countries. Um, and so if you create your dynamic list and let it before you build the engagement program, create your dynamic list and, um, let it send you the email that says here’s your dynamic list, and then you export that, you’re gonna get a view of here are the most common incorrect countries. So you can kind of pick and choose which countries you need to build to begin with. Um, so Australia, you know, country default field country is, and it’s the two letter Au, uh, that’s Australia. So the blue step is gonna say change to Australia and so on and so on. And, again, this program ends with a notify user. So if I to build this program out, I created only 10 countries because that was what my initial dynamic list said. Hey. You have misspellings on these 10 countries. Um, you know, maybe as time goes on, I actually now I have a incorrect country that wasn’t built into my program. Now I can go and I can edit my program, and I can add those steps because it seems like I’m going to need them. Um, so eventually, you’ll be pretty solid on this list, but, yeah, you don’t need to build out a country data cleaning program. For every country, just focus on the ones that you see most common are problems and build this in. Prior boss of mine called this a washing machine. And, basically, every prospect who hits parrot, which is pretty much every prospect in your database with an email address, is gonna hit these. And often, they would hit, um, you know, sync errors in your in your, um, sync queue. And what’s nice about this is they’re gonna have a sync error, but they’re actually gonna get automatically cleaned. And then because Pardot is changing the field value, it puts them back in the sync queue to, like, sync again. So it kinda solves a lot of your state and country mismatch, uh, sync errors from Salesforce without you having to do it manually. So it’s tedious to set up, but it saves you so much time because now when you have those event lists, hey. I went to this event, and here’s the CSV. You don’t have to spend time cleaning the state and country fields every single time you get a list. You can just move on, upload, import the list of email addresses with the fields into Pardot, and Pardot will take care of cleaning it as you import it into into Pardot account engagement. Um, so it saves you so much time. And like I said, this is born out of Laura hates doing these things over and over and over again, and it’s not a single line of code. Jessica’s asking, in your program, do you check the box to allow a prospect to enter the program more than once? I don’t because a field value change like this should persist. They shouldn’t be changing countries back to the wrong spelling. You can if you suspect there’s a problem, um, but, honestly, they should never need to repeat this program. Um, but you can. But you only have, like, 10 programs that are allowed to repeat, so I tend to leave that off because I think a a data change shouldn’t change once it’s fixed. Um, okay. So we’re gonna talk about other time saving things. So master suppression list. How many times do you send an email? Is there a max about how many criteria I can put in one dynamic list? I don’t think so. I did hit a maximum on automation rules, but I’ve never hit a maximum on dynamic lists. And I think the country one, uh, I think I hit, like, 13 rules in it because of how I grouped all of the countries, and that was no problem. I’ve also done, like, just a super, super long dynamic list and never hit a maximum. But, uh, so you you if you hit a maximum, I’d be very surprised because I’ve never hit a max since I’ve been using Pardot since 2011. Um, but if you do, you would deserve an award for hitting a maximum. Um, okay. So master’s expression list. We’re gonna talk about saving yourself some time as you’re building emails. So my nurture programs. Um, if I have an evergreen nurture program, I’m always going to want to suppress similar things. So I’m gonna wanna suppress my company’s employees from dropping into the nurture program and skewing my numbers. I’m going to want to suppress any competitors. I’m going to want to suppress any people who are already unmailable so that they don’t skew my numbers of like, hey, this many people entered the program, but they weren’t actually sent any emails. The, uh, so how does the Excel you mentioned get grabbed to go into the engagement studio? So you will download the text file, and it has everything you need to build the dynamic list yourself. So you can’t, like, upload the Excel file and create a dynamic list. You just need to, like, copy and paste the rows into the the dynamic list that I sent. So sorry. I’m gonna stop answering questions about engaging programs because I’m getting sidetracked. Um, but so building a master suppression list saves you a lot of time because you’re gonna create one, maybe two master suppression lists that you’re gonna use on all of your email sent. So instead of having to manually remember to add, like, 15 different suppression lists to a newsletter email or to a nurture program, you’re just going to grab the one suppression list that’s called, like, master suppression list or master exclusion list for nurture programs. You’re just you’re gonna know what to grab every single time. So instead of having to remember to suppress every single separate list, roll it all up into one master suppression list. And I’m not kidding when I say my master suppression list often has, like, 20 subsets of other lists. So maybe I’ll make a suppression I’ll make a dynamic list in Pardot that says, this is all of my company’s employees, and that, uh, that list is made up of, you know, prospect default field email ends with @accentshr.com. That’s my list, a dynamic list of all of my employees. If they show up in Salesforce or they fill out one of one of my website forms, um, they’re going to automatically match that dynamic list. Now make another suppression list, make another dynamic list that rolls up all of these people into one. So you can literally say, um, the the, um, oh, yeah. Great. Make a naming convention for your your list that strips them altogether. So I frequently start them with z z z because that sends them to the very bottom of my list alphabetically. Um, but I’ll say, like, z z z dash suppression competitors or something like that so that I know exactly what they’re for. Um, so this is what the master suppression list looks for. I’m gonna say prospect list is a member of current clients, or they are a member of junk email addresses, or they are a member of my employees, or they are a member of my competitors. So I make all these different dynamic lists automatically searching Pardot and matching them if they have the email domain of my competitors or, um, they are one of my deleted records from Salesforce or they’re one of my current clients. And all of these are dynamic lists So because I want them to automatically update, and then they’ll join that dynamic list. Then they’ll also join my master suppression list a little bit later. Uh, so this is great. These are gonna be a match any, so you’re in or. They don’t have to be a member of my clients and my competitors and my employees because that’s never gonna happen. You want them to be a member of any one of these lists or this other list or this other list. So this saves you a lot of time. And I might have a master suppression list for my newsletters and then a different suppression list for my nurture programs because, um, maybe I actually want my current clients to go into a nurture program about, hey. You’re up for renewal or something like that. So just be aware of what’s in each list and make them correctly. Um, I’m gonna show you how to, uh, do competitor handling. So we all know people kinda panic, and our stakeholders kinda panic about, like, what if one of our competitors, you know, is on our newsletter list? And and, like, honestly, it’s not that big a deal. You know, like, go join your competitors’ newsletter list and see what they’re promoting. But your competitors kind of cost you money because in Pardot account engagement, you have these contact blocks. Right? And, um, every additional 10,000 contacts, mailable prospects, costs you money. So you want to make your competitors unmailable because they’re sitting there in your database as a mailable prospect counting against your contact blocks. And you could constantly send them to the recycle bin, but if they come to your website and fill out another form or something like that, that’ll pull them out of the recycle bin automatically. So kind of I like to ignore them, and I just mark them as unmailable so they’re not eating up my prospects, um, my prospect seats. So this is different. I’m not gonna make a dynamic list, although I can and I do in my last series. You just I just showed you how to make the, um, you know, make a dynamic list. But because I want to do something to the, um, to the competitors, I’m gonna create an automation rule. So very easy criteria, the prospect default field for the email address ends with at company dot com, so your competitor@atcompetitor.com. And the automation rule is going to change the default field called do not email to true. So, literally, I’m marking them as opted out. Um, it’s actually, like, technically considering them a bounce so they can’t, like, opt back in, but it’s super, super convenient. So the other thing is that you might have competitors filling out things with a Gmail address, and you’re like, well, I don’t wanna suppress everyone with a Gmail address. Okay. So what you can do is if you see those as a one off, you know that Joe John Doe is a, um, is a competitor because you recognize the name and they use their real name, you can just go apply a Pardot tag, call it, you know, competitor as the tag. And then instead of just prospect default field email ends with company, um, you can say or prospect tag is competitor. And now those ones that you manually tag as competitors will also hit the automation rule and also get opted out. So that’s really good. Um, and then if you have, um, you know, other things that you never wanna email people who are like the student intern or, you know, the summer intern or, you know, somebody’s executive assistant or something like that. Create additional things to make them match this rule and mark them as opted out because you don’t need them sitting there and eating up your database limits and costing you money. Um, just mark them as do not email is true, and that takes them out of your mailable database counts. So I’m gonna do other helpful dynamic lists. So whenever I start a new job or I spent a couple years as a consultant, I would go into the Pardot account, and I would make dynamic lists showing who are my unavailable prospects. So I would make dynamic lists for, you know, the people who are opted out, the people who are bounced, and the people who I have marked as do not email, which is like, they didn’t opt out, they didn’t bounce, but I don’t actually want to send them. It’s sort of the equivalent of a bounce, but it’s like an extra thing. Um, like, my competitors, I mark them as do not email. So this is a really simple series of dynamic lists. This is, um, the the first thing you’re gonna pick in the dynamic list is prospect email status is, and then that final option gives you these choices. You can choose opted out. You can choose bounce. You can choose do not email. So just make a separate list for each of these, and then you can kinda get a count for, like, you know, how many of these people are opted out versus bounce. How many have I marked do not email? Because you might have a 100,000 people in your database, and it’s 75% mailable, but how many of them are bounced? How many are opted out? These are the the dynamic list that’ll give you those answers. So they’re really, really easy to build. Like I said, you just pick this first option for prospect email status. Just say is, I don’t think you have any choices in there, and just pick one of these, you know, opted out, do not email. The the, um, oop, I jumped ahead. But, anyway, you can see how you can build these available prospect lists. I did make a dynamic list for my competitors. So I made an automation rule to change a field value. Um, that’s all well and good, but maybe I want to, um, create a dynamic list for other purposes. Like, maybe I want to send them to my recycle bin. Maybe I want to monitor how many of my competitors are coming in. Dynamic list can help you with that. So just like building the automation rule, you’re gonna do criteria for prospect default field email ends with, you know, your@company.com or these other, um, you know, the company name is, you know, Amazon. Company name is, you know, whatever your competitors are. Um, and then, again, do your, you know, prospect tag as competitor. So if you, like, see one or two as a competitor, you can just apply the tag, and then they’ll hit this dynamic list. List. So this is a really convenient way if you’re, you know, wanting to, like, send them to the recycle bin. Here’s all your competitors at once. Go visit this list, send them all to recycle bin, get rid of them.

Speaker 0: Hey, Laura? Yes. I just wanted to give you a heads up that we’re at about, um, four minutes.

Speaker 1: Sure. I’m good. Um, so this is, again, how you make your, uh, dynamic lists for employees of your own company. Um, so, again, maybe you have a tag where, uh, you know, you have a, uh, a, um, a test list where you and your coworkers use your Gmail addresses. Maybe you tag those with employees, and so you you create a dynamic list, which is the employees of your own company. So email ends with, you know, my company dot com, um, or their tag is employees, kind of on and on. So so here, I did see in the in the chat somebody was saying, how do I make a list of people who have been deleted from Salesforce? So we all know we hate it that that sales team members do it, but they do delete people out of Salesforce. It’s super annoying. It creates sync errors in Salesforce. Um, this is how you do it. The prospect the choice in the dynamic list is prospect CRM status is, and you have contact lead or has been deleted from Salesforce. So just make a dynamic list for this. This is how you grab the ones who’ve been deleted from Salesforce. Um, and then another good one is your junk email addresses. So we know that people fill in, you know, disposableaddress.com, junk junk mail. So this is a dynamic list that grabs all the junk mail addresses for you. Um, again, this is a really great one to build into your automation role to mark them unmailable because they’re just gonna sit there and eat up your database. If you have a really robust, like, gated content strategy, this one is going to grab all of the junk mail addresses and let you mark them unmailable right away. And, again, there’s a list of junk mail domains that you can grab from my website. So that is all the fun dynamic lists and everything that you can build without writing a single line of code, but that can save you a lot of time. Um, were there any questions that I didn’t jump to, um, as it went through?

Speaker 0: Yeah. Hi, Laura. A lot of lot of activity, um, in the q and a and in the chat, um, just going through that now. Um, some of them are more, um, quest questions like, you know, getting, um, Excel files into, um, Engagement Studio. We can talk about Yeah. We can address that offline. So I’m just reading this one. I work for a nonprofit that provides services to other nonprofits. We use Proverat for marketing purposes, but we also use Salesforce list emails for programmatic emails. Yeah. Um, I’m just gonna skim through this. What happens is that we get Pardot emails and it bounces because it picked up by their email provider as spam. Any way to prevent this, um, and automate it what automating it when it happens? I’m not sure I understand.

Speaker 1: Yeah. I think I need to do a walk through with somebody to understand what’s going on. There are some people so nonprofits have a very, like there is a session on nonprofits with Pardot and account engagement. I encourage you to ask your question there because peep there are some people who specialize in the nonprofit, you know, service pack and Pardot and intricacies involved. And I’m not sure the involvement in the, you know, list emails from Salesforce question.

Speaker 0: Yeah. Um, alright. Several a couple questions about the max criteria in an automation, and I was gonna, um, look that up to confirm the answer. I thought it was, um, for some reason, I thought it was 24. Um, I have that number in my head. Um, but I

Speaker 1: have for if you’re sending an email with dynamic list, I believe there’s a maximum of, like I’m sorry. Dynamic content. I believe there’s a maximum of, like, 12 pieces of dynamic content. But the actual, like, criteria lines in an automation rule or dynamic list, I hit them once in an automation rule and never again, um, and I ended up just building it as a dynamic list instead. Um, dynamic list has a much longer, like, larger set of criteria that you can add to dynamic list.

Speaker 0: Awesome. Well, we are about to get cut off, so thank you everyone for joining.

Speaker 1: Thank you, Laura. Everyone.