(This is the transcript from our new video so it may not read as well as a normal blog post would)
Google CRM database upload
Hi everybody, it’s Steve from Koozai. A lot of our clients ask us if they’re able to use their CRM database and target those users with adverts. And the answer is yes, you can. So I’m going to take a couple of minutes now just to show you how to upload that data into Google ads. And the data can be uploaded to Google, Facebook, LinkedIn, whatever platform you are using. But for this video, I’m just going to show you how to do it for Google ads. So the first thing that you need to do is log into your Google ads account, and you want to go to the tools and settings section over to the shared library and then down to audience manager. And we click on audience manager, that then opens this page here. We need to click on the blue cross and we want to upload the customer list. So we click on that button and that brings us to this page here. As you can see, there’s a lot of templates that we can use and a lot of formatting guidelines, but basically for an email address upload, it’s very, very simple. I’m just going to show you an example here in this Excel sheet. All it needs to be is one column. The column needs to be called email because that’s what’s recognized when it’s uploaded to Google ads and you just list your email addresses in that column. As you can see, I’ve got three made up emails here. You have a lot more email addresses, you just list them in that column and then you save that file as a CSV. And that’s really important that it’s saved as a CSV because that’s the format that’s recognized when we upload to Google ads. So once we’ve sorted out the list, I’m going to minimize that we can then come in and upload it. Before we do that, we’re just going to give our audience a name, so we’re going to call it something like CRM database. Perhaps this is a list of people who’ve signed up to your newsletter. So we call it newsletter sign ups August, 2020, because that shows us when we uploaded it. And we can then reupload and get new users into that list in a few months time. As you can see, we cannot load email addresses, phone numbers, and names and addresses. However, the most simple and effective way of targeting your CRM database is by using email addresses. As you can see here, we can either upload as a plain text data or hash data. We always recommend uploading the plain text data. The reason being is that that data will be hashed when it’s uploaded. And what that means is it basically turns your database into code so people can’t access that data. So if we’re managing your account, we can’t go in and find the users that are in your email database. Once you upload it, it’s completely hashed and it will be able to be used, but you can’t see the email addresses in the file. So then we go to, we’ll use this option here, and we simply choose the file that we want to upload. So this is our file that we created. We’re going to upload that. And we’re just going to tick this box to say that it complies with Google’s Customer Match policies. If you want to have a read of those policies, you can click on this link and you can find out what they are, but it’s pretty straightforward. We just upload it, we tick the box and then we come down to here to upload and create the list. As you can see there, it’s hashing and uploading, and we get a success message to say that the three rows we uploaded were all in the correct format, which is really, really good. Of course, you’ll have many more rows than three. A couple of considerations that is important to mention at moment is that the matching process can take up to 24 hours. So what Google will do is it will find the users that are in your email address list, and it will match them to users across Google. And when they’re searching, it will match those and we can increase our . It’s important that your list is 1000 users or more so lists must have at least 1000 matched users. So if you’re uploading a list with 1000 users, it’s likely that some of them won’t get matched. So ideally you would have a much larger list than 1000 users. The larger our list, the more accurate it is really, and the better results you’re going to have. So I would certainly recommend having an email address upload of more than 1000 users. So hopefully you found that useful and you’re now confident uploading your CRM database into Google ads and yeah, you can use it to target those users that you already have details of. So thanks for watching.
Our Head of Paid, Steve, has over a decade of experience in PPC. He’s worked with a plethora of big brands including the likes of easyJet, L’Oreal, Nissan and Stannah. With extensive experience across B2B lead gen and B2C ecommerce using Google, Bing, Facebook, YouTube, LinkedIn and Amazon, he’s our go-to guy for all things PPC. Steve’s personal passions include playing the drums in an 80s covers band and DIY.
Sign up now and get our free monthly email. It’s filled with our favourite pieces of the news from the industry, SEO, PPC, Social Media and more. And, don’t forget - it’s free, so why haven’t you signed up already?