Mastering the Maze of Data: Unlock Clarity and Structure in Marketo Engage

[Music] [Carissa Russell] We are here to talk about Mastering the Maze of Data: Unlocking Clarity and Structure in Marketo Engage.

My name is Carissa Russell. I'm currently with McGraw Hill. I'm a four-time Marketo Champion. I have been certified since 2015, and I'm also an Adobe Subject Matter Expert. I am experienced in frontend web development and data management. I'm here with the esteemed Chris Kelley. [Chris Kelley] Thank you very much.

As Carissa said, my name is Chris Kelley. I am a Principal Marketing Automation Architect for Qualified Digital. I've been in the Marketo Champion program for two years now and I'm a Certified Marketo Solutions Architect. Please feel free to reach out to us at any time. But the agenda for today, why we're all here, why we're all super excited to be awake at 8am in the morning!

We're talking about Marketo and how to understand the data landscape using Marketo as the hub-and-spoke, central spoke. Talking about some common pitfalls that might happen when you have a data instance that you're running, inheriting or possible duplicates that are coming through and the importance of having clean data as you operate your Marketo instance. Then it's adventure time. You'll have to stay and watch for that, what that means. But it's good time. And I'll be handing that back to the rest of the group out for some questions when we talk about the key tenets after going through our presentation. All right. Thanks, Chris.

So let's first talk about data as a landscape. So when you walk into a new operations role, you really have to get the lay of the land. You have to understand your systems. What kind of data is in front of you? You have to understand your syncs, what kind of data is coming and going? You have to understand your processes. Are there data coming in, going out that are kicking off workflows? Is there data updates happening that are triggering automations within your instance? I know when I log in, it can really feel like a maze. It's dark. There's bits and bytes everywhere. I mean, I'm being silly, but where do you begin? The choices seem infinite and every path leads you down a different turn and you never know what's behind it. Some of them can lead you to dead ends a lot faster than others. And this is a lot like the processes that we have and how we structure our systems. So what are some common options for structuring data? Well, let's talk about databases and data streams from a central hub perspective using Marketo as that central spoke. So we see here we have Marketo Engage, a very rich database full of people and engagements, what we're all familiar with, but what's behind it right there? Well, that's a tiny little relational database called a Marketo custom object. Now this gives Marketo CRM-like capabilities where you can add additional data sets and relate them to the person record in a bunch of different ways. Marketo offers one-to-one, one to many, many, many options to link these records together. So you can have a very rich data set just here. But let's take a step back and look from a little more bird's eye point of view. And we have a CRM. Now a CRM also has that ability, like Marketo, to have relational databases inside, and these are also called objects. These objects can sync over with the people. These objects can also sync directly into Marketo custom objects.

Not just that though, we have services. There are tons and tons of really useful services out there, can really supercharge your marketing campaigns. Marketo is a widely adopted product, so a lot of these services have out-of-the-box integrations ready to go with Marketo. Not only that, from a rest API standpoint, Marketo is even more powerful. You can create custom service integrations to integrate it with nearly any business system you could think of. And there's just one more thing I want to reference. If you're in a larger, more global or enterprise business, you may also be integrated with a data lake. If you are, that is a beast of its own. So now, what was that? He was cute. All right, what are the-- So now that we have the landscape, what are the pros and what are the pitfalls of these setups? Well, first, let's take a look at CRM Sync. So this ensures that marketing and sales teams are working with consistent and up-to-date data. This automates your leading contact updates. So this reduces any manual entry or any delays on your workflows. It has a single source of truth because Marketo, that person in Marketo, is that exact person in the CRM because those two systems are synced together.

Now, some of the cons of this setup is that it can create duplicate records if it's not properly configured. The sync delays can cause Marketo data issues and the field sync and override are managed from the CRM side. So this could feel a little limiting when you're looking at it from a Marketo perspective.

Now let's take a look at APIs. So some of the pros here are that it allows customized data flows. So you can integrate Marketo with nearly any system that's API accessible. It provides real-time data updates. So this offers you a lot more options to personalize your campaigns and create more automations around them.

It provides you flexibility so you can enforce unique business rules. This is really handy if you are managing large data sets and you need to manage duplicates or audience segmentation. Now some of the cons here, it requires development resources to build and maintain your API calls. Depending on what expertise is available to you, this could be complicated. API rate limits can slow data processing if you have high volume. And if API calls aren't structured correctly, you could have a lot of data mismatches or orphaned records if you are not using proper validation rules. So you want to be careful with API because you can do a lot of damage if you do not have the expertise very quickly.

So before I finish, let's talk quickly about custom objects. Some of the pros here are that it enables complex data relationships beyond your standard lead and contact fields. It enhances personalization by storing additional attributes that are specific to your business. And it provides a way to enrich Marketo data directly in Marketo without depending on any other systems. You can also take your data set and upload it directly to the custom object within the Marketo UI. If you're interested in the ins and outs of this, you can check out my session from last year, which is also S210, where I dive in really deep about the idiosyncrasies with custom objects. Some of the cons here are that matching records correctly can be very difficult if you're linking fields are not very clear. You have to be very careful when you plan to use these because you have to choose that right data model if you're going to scale it. And then managing duplicates and orphaned records can be very complex. They can only be managed through the API. So this is something that you very much want to consider if you're going down the custom object route.

So now that we understand data as a landscape, I'm going to pass it over to Chris so we can talk about why it's important to keep it clean. Awesome, thanks. So as Carissa said, there are so many different ways to interact with your data, but at the same time, there are so many ways to bring that data into Marketo, and that is when we have the capability or the opportunity to create duplicates. There's a couple of different ways. One is the most common, your clients or your end users are going to be coming in through form submissions. And for the most part, it's pretty bulletproof. It's handled via API. However, you do have the capability of being susceptible to spam attacks where, you know, if they are wanting to, they have the ability to create multiple inputs within one second. So there's the possibility API has not updated your system yet, and boom, you have duplicates. So nothing that we can really go against in that way, but there is the capability of having spam attacks within the form submission. And then you also run into the issue, if you have multiple fields set within your Marketo instance, as the dedupe record. By default, Marketo will always be set up as email to be your dedupe field. But there are capabilities where you can ask for multiple fields to be in combination for the dedupe logic. So if you are running your Marketo instance, always make sure that you are sure how your Marketo instance is set up because this is going to be a reoccurring theme as I go through the remainder of these inputs.

The next one is the data imports, manual data imports. So as many people might be aware, this is probably one of the most common ways that you're going to bring in bulk data into your Marketo system. So the vulnerability from before, if you are not just using your email instance, you could email field as your dedupe field. You can accidentally create a huge amount of duplicates because Marketo will check against those fields and say, "Oh, yes, Chris Kelley Qualified Digital exists," but he may or may not have a first name field intact as well. So just be aware, the ability of taking the values as written. So if you fat-finger information inside of your input, Marketo doesn't know that. It's going to take it as, "Okay, boss, you put it in there, you know what you're talking about, let's go." So you need to do that validation before you bring it in. And then, also, this allows you to do your own field mapping. This is not done automatically. You do not have that form same as where you say first name equals first name underscore, what have you. So you need to be in charge of your own field mapping. So just be aware of that you are your biggest strength and your own worst enemy.

So going on to the next one, the CRM, this is probably one of the most powerful.

The main reason that you're going to run into duplicates here is because the CRM is considered the source of truth, especially with a native integration. So if you are having multiple Chris Kelleys in your CRM, Marketo says, "Okay, all of 'em are coming over." So you need to make sure that you understand how that data is being brought in, have that communication between the sales team, the CRM team, and Marketo, and just understand what data you're getting in before you run that sync.

It can be a very manual process. What do I mean by that? CRM Sync, it should be automatic. It can be a very manual process and how that data is brought into CRM. The sales team or whoever is in charge of CRM is going to be bringing that data in. They may or may not be doing some proper protocol before they bring that data in. So again, we're dealing with that human element on how that data is being brought in and synced between you and your system.

And it's outside of Marketo's control. So even if you decide to go through this whole escapade of wiping out all of that data inside of Marketo, because the CRM is the source of truth, that data is going to be brought back in.

You need to be able to update the source of truth in order for those edits to stick. So just be aware that even if you decide to take care of the duplicates inside of Marketo, that does not necessarily mean that the duplicates are gone for good.

And then as Carissa has said before, the API sync capabilities are insanely powerful. You can do so much with your data with the Marketo instance as a whole with the API capabilities that are available. However, you are in charge of creating that call. So again, your own worst enemy, if you know what you're doing, you can create some very powerful automation. But if you are writing these calls incorrectly, they will take that as a gospel. Marketo says, "You know what you're doing, we're going to do whatever you tell me to do." So just be prepared for that. And again, that comes down to understanding if your system is set up for just email as your dedupe or if you have any custom field as your dedupe. It really comes down to when you're going this custom, when you're going this hands-on, understand your data, understand how your Marketo instance is set up.

So that being said, these duplicates, why is that such a big deal? Well, they can screw your analytics, they can screw you with your communication. Do you understand which person you're actually emailing? How is that data being assigned back? You really need to understand how the duplicates are messing with your system, messing with your communication limits, and just in general harm the customer experience.

All right, the adventurous path, like I promised. Carissa's going to take us off here.

Alrighty, you guys ready? Thank you. All right. So we're going to do something a little different here and you may see some stickers on your chairs to set the scene. But Marketo's a complex system and there are a lot of different scenarios we deal with every single day working in marketing operations. So we're taking a little different route here and we're going to set it up with some scenarios. So each problem is going to be a thing that we deal with every day in marketing operations. And if you will bear with me here and give me a moment to set the scene. I know some of you out here are into this. Imagine you're an adventurer in a vast dungeon hunting through a maze of data.

Around each corner is a unique challenge related to data management. Can you untangle all of the data streams and best the spaghetti beast? Your choices will determine the success of your quest to maintain a clean and efficient database. Now, you will only be armed with your intellect, but we are here to help you through this terrible maze. And we have two teams today. We have the Workflow Warlocks right here.

I told 'em the Slytherin would make people have feelings. I don't know about you guys. I-- All I told the sword in hand is I don't want a dynamic system.

And we have the Data Knights of the Clean Table. So are you guys ready to traverse the maze? Because it is what now? 8:15am. - Let's go. - Let's do it. We got it. All right. So the first beast is here, the legacy data nightmare. A bad data migration. Now I don't know about you guys, but this one has me shaking in my boots because we just lived through this. So the problem, a global company recently migrated customer records from an old marketing automation platform into Marketo Engage. However, the previous system didn't enforce strict data hygiene rules. So the import resulted in thousands and thousands of duplicate records. The marketing team now faces challenges in segmenting their audience accurately because that outdated duplicate record will misfire promotions, inflate email volume, and cause their workflows to go awry. So presented with a beast of this nature, how can we attack it? Well, we can turn left or turn right. Now one thing you'll notice as we go through the solutions to our problems is that no answer is truly right or wrong. Marketo is a really powerful system that comes with a lot of problems that you can solve, but you can be so creative because there are that many ways to solve it. A lot of these issues depend on things you have in front of you. They depend on the skill level of your team, the bandwidth of your team, maybe your budget, maybe the technology stack in front of you. So what we want to help you do is figure out how to think about these problems so you can navigate your way through the next time you hit a spaghetti beast. So with that being said, how do we fight this bad data migration? Well, we can turn left and bulk export, clean in Excel, and reimport, or we can turn right and run a one-time deduplication API script. So I'm calling on all y'all, raise your right hand if you want to turn right or your left hand if you want to turn left.

All right. Sucker. No, I'm kidding. I was expecting to see a lot of rights. - I know how this one hurts. - Yep. Okay, so let's talk about the people who turned left first. So your team can export the possible duplicates list. You can clean that data in Excel using the formulas in that platform to match those duplicate records based on however you program the formula and then reimport that clean data set. Now this method is usually very accessible. A lot of people have this technology and are able to do it, but depending on the scale of your issue, this could be a heavy, heavy lift. So it will solve your problem, but it may not be feasible. So if we have a global company with this issue, a sizable issue, a better option would be to run a one-time deduplication API script. So what does that look like? The team can leverage Marketo's REST API to scan for duplicate records based on email, phone number, or any custom fields that your business deems and then automatically merge them. Now this requires developer support and it requires that level of expertise to execute 'cause like Chris said, you could do a lot of damage very quickly. You want to make sure when it's being created that you are choosing what fields when, creating that hierarchy properly, and then testing it first. So when you run it, you make sure that everything is merging correctly, but it is extremely scalable. So this was the way that we solved it and it worked very well. So we have bested this beast. And now, Chris, you're up. All right.

What do we have next? Duplicate overload. So I know that many people out here have done it on purpose and shaking their head afterwards on "Was that truly necessary? Why did I do this to myself?" But let's talk about the problem.

Rapidly growing SaaS company recently integrated with Salesforce CRM into Marketo. However, the sync-- After the sync, marketing team noticed that there's a huge buildup or new duplicates that have come through. So some customers had four different profiles and this led to huge conflicts in email communication, inaccurate scoring, and confused reps who are engaging with the wrong lead or been given the wrong information because they were looking at the wrong duplicate. So this company now faces an urgent need to consolidate this data before an upcoming product launch.

What are we going to do? We can turn left, the manual merge method within Marketo, or we can turn right. Show of hands, who's turning left and who's turning right? Lot of lefts. Rights? Okay, great. I'm keeping track. So nobody's, you know, changing their answer.

So if we turn left, the manual approach.

Marketo has a Possible Duplicates filter built in, and you can choose this to manually merge these records and ensures incredible control over the data. You can go field by field ensuring that each one of these records is merging exactly as I need it. This is incredibly important for certain systems, certain industries where you must have that level of control. You can't have the merge happen in some mysterious black box where it happens for you. I need to be insanely accurate about how my data is being represented, how it's being merged. And the manual merge system within Marketo will allow you to do that. However, it is manual. If you have thousands of leads, are you really wanting to sit down and do that every single time? And it's not just the first time it might happen, right? They could come back. So, yes, you have an insane amount of manual control. However, it's not scalable, it's not a long term solution. However, it gives you that control. Or you can turn right. You can have an automated duplication, deduplication with an iPaaS tool. So you can implement an iPaaS tool like a Workato or a Vertify, which will handle that information inflight so it never even makes it into Marketo. And it will be able to allow you to keeps your-- That data stays clean. Like I said before in the manual option, it could still come back and dirty your data again within Marketo. However, if you have some sort of tool standing in between, you can be sure that that data is going to stay clean. However, it is a tool, it is another integration. It's going to take that time, it's going to take that scalability, it's going to take that...

You know, training. How am I going to do this? Who's going to handle it? How am I going to report on it? So it just-- If you have the time, if you have the budget, if you have the skillset...

Are you going to go more manual or are you going to go more scalable? It depends on what the requirements are for your company.

All right, back to Carissa. All right, I think we're kicking him down here. He looks like he's getting smaller to me.

All right, so this one is the paid ad retargeting mishap. So some of you may be familiar with things like this. An e-commerce company runs retargeting campaigns on Google Ads and Facebook. But the marketing team noticed that customers who are abandoning their cart were getting multiple reminder emails. The source was sometimes it was an old duplicate record and then sometimes it came from a more recent purchase record. They noticed frustration among the customers with peaks in unsubscribe rates and spam complaints. So seeing how this is happening, what are some ways that we can attack this? Well, would you like to turn left and use Marketo's Merge People function? Or would you like to turn right and implement an auto deduplication Smart Campaign? I know which one I'm doing.

Let's see it, hands up.

- 8am, I know. - Thank you. I love it. We're keeping everybody awake. All right, so the people who turned left, they can regular-- You can create a process within your team that will regularly review and merge those duplicate records manually before launching any retargeting campaigns. Now, depending on the size of your database, depending on the frequency of your campaigns, depending on how much team bandwidth you have available to run these pre-checks, this solution could solve it for you and get that at the beginning, but it will be very manual, especially if you have large data sets. So you can see my little guy down there. He took a bit of a hit because that would hurt. So if you want to turn right and implement an auto deduplication Smart Campaign, you would be setting up automated triggers that detect when a user has two or more records with recent cart activity and then merge them using that most recent engagement as the master record. Now this solution is fantastic because it's automatic, but you need that level of expertise to set this up because if you are basing a workflow like this on the most recent engagement and using that as the master record, does it have all the other data points that you call important to your business retained when it does the merge? You'll want to make sure when you set up anything automated like this within Marketo that you are planning for those eventualities and make sure that they are in those workflows because then when you set something up like this and it's handling them all as they go all the time, you can trust it and set it and forget it.

All right, I think we got him there.

Oh, it's looking smaller to me. I think we're getting through that nasty data. All right, so everybody has run into this one at any point in time where too many cooks in the kitchen.

What does that mean? Well, it means that in our instance, a B2B software company, is struggling with duplicate records across multiple different layers in the database. Gross. Their marketing and sales team work with the leads and contacts in Marketo Engage and Salesforce, but there is no structured process. Who wins? Why are they here? It all depends on who's asking, right? No. So the leads to existing contacts. So we have multiple different ways that the lead are updating. When a new lead is generated via a form fill or a list import, they don't always get matched correctly or an existing contact already exists and a duplicate might be created. That causes confusion in outreach. Who am I supposed to be talking to? Is it supposed to be the lead? Is it the contact? What status are they in? So the second being a lead to lead. So some leads can be created multiple times due to a sync error or some of the other issues that we had talked about before inside of a regional marketing campaign leading to multiple or disconnected records at the same time, causing orphaned data, and then again, confusion with who am I actually supposed to market to. And then within contacts to contacts, key accounts have multiple contacts and they're listed separately, changed roles somehow, updated new information. Which one is the most up to date? When you have multiple records, sometimes it's impossible to tell based off of what logic you have set up inside of your system. So without a true hierarchy, without a true understanding between all of the systems involved, how are we able to track the accurate history? Who am I supposed to be talking to? So turning left, we can use a third party tool. I know that's super ambiguous, but anybody, any takers? Okay, turn right. Leverage a CRM as the source of truth.

Ah! Okay, okay, okay, okay. All right. So we turn left. What does that mean? So using a third party tool such as other SaaS or systems or an iPaaS tool, something like that, can help you create that hierarchy. It is going to be outside of Marketo, it's going to be outside of your CRM. Some level of appetite needs to be able to take on that integration so you can do it inflight. So what does that mean? It means that on the way from your CRM or whatever data input is happening, that data is being collected and then having that mapping predetermined. It is happening automatically. It can happen at scale, but it does have a huge data overview that you need to understand as a company why it's happening this way, educate the people why it's happening this way. And you need to have a lot of documentation to ensure that you understand how this tool is happening. It's a bit more hands off. It's a little bit black box if you do not have access to it. So it depends how much access you need to your data, understanding processes and things like that. Or you can handle the data at rest, meaning it's already inside of Marketo. We already talked about how that can be a benefit and a disadvantage because when it's inside of Marketo, there are other sources of truth that can overwrite that data. However, it can ensure that you clean up your information at any one point in time, and it allows you to create a master record so that you know for a fact who am I supposed to be talking to at least in the Marketo instance, if somebody reaches out and says, "Who is the source of truth?" You can say, "This record." So you can see here I have a couple of options for inflights or Workato or Mulesoft is very good at this. Or at Rest, I have Undoop. It is a tool that I have created after 10 years of working in the automation space that is designed to allow you to have hands-on approach, understand your data at every point in the future and your very detailed level of control on how you want to merge those records. If anybody's interested, please let me know. I'd be happy to talk about it.

If we turn right, we leverage the CRM as a source of truth. So if you are able to, you are able to create a level of communication and understanding with the people who run the CRM, your sales team. In an ideal world, that is best practice anyway where you have that open communication between marketing and sales and understand why that information is coming over, why the information that you're putting in affects marketing, and again, how marketing can send that rightly back to sales. So really getting on that same level of understanding, education throughout the team, breaking down those silos. But it is really, really important that you're able to understand how data's coming in and who is in control of that and how it affects you down the way. So leveraging CRM as a source of truth relies on education, understanding as a team, as a whole company, and understanding that the CRM will overwrite Marketo. Marketo considers the CRM as source of truth. Alrighty. All right, next up, the multi-channel attribution conflict. So an enterprise company tracks customer interactions across multiple channels, emails, paid ads, webinars, sales calls. You can imagine they're all done in the same system. I'm kidding. They're all very different. Every system tracks every single interaction differently. They are all synced behind the scenes. But the marketing team noticed that incorrect attribution was appearing in their reporting. So it made it very difficult to understand truly which channels were driving the actual revenue. So let's take this meatball out.

We can turn left and standardize data ingestion rules or we can turn right and de-duplicate across systems using an iPaaS tool. So make your choice.

Lots of lefts this time. I was expecting to see a bunch of that side. Yeah. All right, so let's talk about turning left. So the company can define a global unique identifier, an ID field, and then configure all inbound marketing sources to check for existing records before creating new ones. Now this is standard best practice. Before you integrate any systems together, you want to make sure they are matching on IDs, so every system transferring through knows what record they are touching. This is not always the case. So if you are in your new role and you're getting your lay of the land, make sure you check this. Make sure all of your systems are set up to standardize that data ingestion or you can find dupes coming in from all which ways. So let's take a look at turning right. So an iPaaS tool can act as a data orchestration layer, ensuring that records from different platforms are emerged before syncing into Marketo, and that creates the single source of truth. So to do this solution, you would likely have to have a more adopted technology stack because this is adding a layer outside of Marketo that is doing the processing across all of your systems that are integrated. They're looking at all of those records globally. They're using one global ID to match 'em all across systems. And when they flow through back and forth, they know exactly which one that is. So adding that data orchestration layer is amazing. It's awesome, but it depends on what you have in front of you if it's possible to do. So, all right, I think we got 'em and I think this might be the last one. You want to take 'em out? We're going to do it. All right.

It's the last choice. I know it's a lot of pressure, but we can handle it.

The last problem, everybody has it. It's the human error duplicate crisis. Can't run away from it 'cause it's right next to you...

And it's going to be with you everywhere you go. So how do we handle it? Company relies on manual data entry process for adding leads into the CRM. Because there's no structured workflow, there's no data validation, they're unknowingly creating duplicate records and you don't know if it's already in the system or under different email variations or what have you. There are so many different-- Fill your blank. You know what I'm talking about here. So since the Marketo treats the CRM as source of truth, and these duplicates sync into Marketo without being flagged as duplicates. Over time, you have inflated lead records which leads to inconsistent customer journey tracking, inconsistent scoring, skewed marketing attribution. The list goes on.

Do we turn left, the manual process overhaul? Heavy left. Or do we turn right and we move away from the manual process? Lot of rights on that one.

Don't blame you. But sometimes that is not an option. Sometimes all you have is the manual. Sometimes you are an army of one and it kind of sucks and it's lonely, but we can get it through it together.

So how do we get through it together? By communicating with the rest of the team, by communicating with the other siloed workflows, by bringing one team from our many teams into one team.

So you need to be incredibly, incredibly detailed. You create a lot of documentation, you communicate excessively with the teams so that they understand why we are doing it. Yes, Steve...

You have to check for duplicates before you put chriskelley@qualifieddigital.com into the CRM. Yes, it is important. This is why, Steve.

So again, manual process overhaul, it's a lot of work, but it needs to happen. It needs to happen now. And you have the added benefit of having the best practice communication opening with the marketing team, the sales team, all the stakeholders involved so that everybody knows the processes, everybody knows where that data is supposed to be located.

Everybody sings Kumbaya, and we have a clean system.

Or we turn right, we move away from manual. We implement change management, educating the sales team, similar, but we also allow the automation that you purchased to automate, let it do its job.

Check duplicates in the CRM before entering the lead. Make sure that you have that source of truth acting as a good source of truth so that when people talk about the CRM, they trust it. They understand that this data is good and we understand as a team the effort and capability that went into it. And together as a whole ecosystem it works as intended. It prides longevity, scalability, accountability.

So each one goes for time, each one has education involved, but it allows for how much time, how much cost, how much education.

All right.

We made it.

We made through the adventure. Did anybody take an arrow to the knee, get squished by a boulder, eaten by the flying spaghetti data monster? How did we do? Did we make it? Did we find the answers we're looking for? Yes, say it again.

All right. As you can see down below here, I do have a QR code for a video series that I did on dedupe management hosted by Adobe. It goes through many different iterations of if you can only do manual all the way, increasingly going through Marketo and then even out of Marketo into more of a system iPaaS. So if you want any more detailed information, please check out this video series. But I think that we have all understood just how powerful Marketo is, right? Each one of us here has our own Marketo story. We have our own experiences and we have our own, I wish we could do that.

It's not about the tool, it's about the knowledge. It's about coming together and understanding as a team, how can we utilize our current existing software, current existing architecture to our benefit, right? It's not about we can't do it. It's about let's do the best we can with what we have.

All right. So by some miracle, we did not happen to hit on your specific use case. That is okay.

If you look through all of our different options, there are some key tenets that are ringing true throughout all of them. And if you use these key tenets, they will allow you to take home and apply it to your current situation and walk out with a best practice capability to handle what you're going through. So regular audits. This is incredibly important to understand if your data is cleaned. If it's not, let's start that process. If I did clean it, is it staying cleaned? If not, what happened? Where is it broken? Where can I track it down to the situation and stop it from happening again? Automation. Marketo's an incredibly powerful tool. You have many other powerful tools feeding into Marketo. Let that automation work for you. Let that power work for you and allow you as a marketer or any other person interacting with marketing ops. Do what you need to do. Don't babysit the system. Don't be doing all this manual work when you don't have to. Leverage that strategy, leverage that communication, leverage that technology.

User training. Everybody hates it, but it is insanely important. Every single time that we have spoken about a turn left or turn right, education has been involved. It is necessary not only for how do I use this tool effectively but how do I work as a team holistically through the lead journey effectively? How do I provide the best experience for my end user as possible? How do I provide that consistent communication? User training. Get people involved make sure they're all on the same page.

Have those clear protocols. So document everything, always. I know it's the worst, but you must do it.

If you add those clear protocols, you will cut down on the number of meetings at 8am and work on other things that need to happen. Don't allow yourself to run into the situations and have to climb your way back out of it. Fight the monster before it exists.

Continuous monitoring. Like I said before, you created this amazing system. Make sure that it's still amazing. Make sure that you have ways to view that data. Make sure that it is still performing. Don't make it a black box. Understand how things are working and continue to monitor your glorious system. So by adhering to all of these principles, by going through and understanding each of these tenets and applying them to yourself, your company, however you need to, you're able to navigate your own maze of data. Conquer your own spaghetti data monster.

Thank you very much. Please fill out-- [Music]

In-Person On-Demand Session

Mastering the Maze of Data: Unlock Clarity and Structure in Marketo Engage - S210

Sign in
ON DEMAND

Closed captions in English can be accessed in the video player.

Share this page

Speakers

  • Carissa Russell

    Carissa Russell

    Sr. Marketing Operations Analyst, McGraw Hill

  • Chris Kelley

    Chris Kelley

    Principal Marketing Automation Architect, Qualified Digital

Featured Products

Session Resources

Sign in to download session resources

About the Session

When data becomes an overwhelming maze, it's easy to get lost. Featuring insights from McGraw Hill, learn how to structure your data for efficiency and get best practices for linking records and preserving integrity. Using real-life examples, we'll cover database audits and integrating automation into your workflows. Discover how to manage duplicates and databases with APIs, smart campaigns, and integrations to keep your marketing data clean, organized, and aligned with business goals.  

Key takeaways:

  • Best practices for auditing your database, identifying, and merging duplicate records without losing customer data
  • Creating dynamic segments and automating report subscriptions to enhance targeting and reporting capabilities
  • Organizing your database for scalability and alignment with your unique business processes, setting a foundation for consistent, reliable data management

Technical Level: Beginner to Intermediate

Track: B2B Marketing

Presentation Style: Case/Use Study

Audience: Digital Marketer, Operations Professional, Marketing Practitioner, Marketing Operations , Data Practitioner, Marketing Technologist

This content is copyrighted by Adobe Inc. Any recording and posting of this content is strictly prohibited.


By accessing resources linked on this page ("Session Resources"), you agree that 1. Resources are Sample Files per our Terms of Use and 2. you will use Session Resources solely as directed by the applicable speaker.

New release

Agentic AI at Adobe

Give your teams the productivity partner and always-on insights they need to deliver true personalization at scale with Adobe Experience Platform Agent Orchestrator.