It might just be me, but I feel like I'm always getting like fun lists to clean or, you know, make magic out of. And today I'm going to show you guys one of the fun lists that I had. Okay, so some context for y'all. Okay, I got a list. All I have is company names. Some of them are not even company names. Some of them are like links. And now I need to find people's from those company names. My issue is first I got to clean up that little that list a little bit because as you could see here, oh my god, in this column, some of them are links, some of them are company names. It's a mess. All right. And we got to fix that. And one way I love to do that is just using clay formulas before I do any type of enrichment. Yes, darling, clay formulas are super, super powerful. And I'll go ahead and show you what that looks like. All right. Now, let's jump straight into our clay table right here. So, as you could see, all I have is company names, and they're not all formatted the same. Some of them are giving me an actual company name, like you could see here. Others are giving me our URL. So, it's not standardized. We need to fix that a little bit before we can actually search for people from these companies cuz that's what we want to do. All right. So the first thing I did was I ran okay. So the first thing I did I was I ran something through a clay formula. I love me a little clay formula. It helps me to clean things up without any cost and enrichment. Right. So the formula that I ran here was to only find those um PE companies in this list that gave me our URL. So I use this formula and you could see here I inputed like if they contain a don't mean for example the ending with all of these etc and it would give me back only those volumes. So this is a formula generated and that's exactly what it gave me. So now I have those specific URLs together. Right on to the next step. Next, I use Clear Bit to find domains. Now, fun fact, right now in Clay, when you use Clear Bit to find these domains, they cost you no credits. And that's why I used it. So, that's what I did. I did first only run if the extracted URL here is empty. meaning I only wanted to look for these ones that we don't have a URL for. And that's what it did. There you go. Now, we still have some that are still empty. And that's where we're going to actually now spend a little bit of click credit. Okay, cool. Next step is I run a Google search. I needed to find the companies here. So, let me show you what that looks like. The countries that I'm aiming for is United States because I do know these companies are in the US and I only want it to run if this domain here is empty and the extracted URL here is empty. So you needed to have two of them. It the instruction is to find domain from the company name. Cool. There we go. Now I have all of these wonderful domains. What do I need to do now? I need them all to be together in one column for me to move forward. And that's where you will use merge columns. And for anyone that does not know what a merge column looks like, this is what it looks like. You'll tell it to start first with this one here. If it has a value, then it will start with this domain column here. And then lastly, the last domain column we just enriched for. And here you have it. Now we have all these companies now have a domain associated with them. We can now use those companies to find people in our find people table. That's what we did. We inputed um from those companies the titles that we wanted to go after and we found Jerry domains and we pushed them to HubSpot. That's it guys. Super simple. Damn. Was that simple, right? And you might be thinking, okay, that's super easy and super basic way to use clay. And you're right. That's just one of the super easy basic ways that I use clay amongst the thousands of ways that I use clay. But you know what? It still saved me time. We don't want to manually do that. So what do we do? We work smarter. All right, guys. Bye.