How can I upload existing client data?

The QUESTION

I’m just trying to figure out how can I upload existing client data  – based on e-mail address, for example?

The ANSWER

You have to create a CSV file including customer data and upload it into Google Ads to incorporate this targeting into your campaigns.

To successfully use your customer data file, it’s important to ensure that you format your customer data file correctly.

Customer Match will let you target ads to your existing customers using the data they share with you (email). 

You need to create a CSV file that includes all customer data and then upload it into Google Ads to target them using your campaigns. 

Your file must have the exact data that google requires and in the correct form. 

Instructions

The following instructions will guide you through the process of uploading a customer customer data file to create a new Customer list.

1. Click the tools icon  in the top right corner of your screen.
2. Under the section labeled “Shared library” click Audience manager.
3. Click Audience lists from the Page Menu on the left.
4. Click the plus button  to create a new audience list.
5. Choose “Customer list.”
6. Choose whether to upload a plain text data file or a hashed data file.
   • If you choose to upload customer data in plain text, the private customer data in your file (Email, Phone, First Name, and Last Name) will be hashed on your computer using the SHA256 algorithm before sending it securely to Google’s servers. Country and Zip data won’t be hashed.
   • If you choose to hash your data, make sure it meets the requirements described in the formatting guidelines for customer list data files.
7. Choose your new file.
8. If you agree, check the box “This data was collected and is being shared with Google in compliance with Google’s policies.”
9. Set a membership duration. The default membership duration is unlimited, but you can set a custom time limit.
10. Click Upload and create list.
11. You can view the progress of uploading your data file under “Audiences lists”. This process may take up to 48 hours to complete.
12. Once your data has uploaded, you’ll see a file upload success page. You’ll see information about the number of rows that successfully uploaded and your match rate percentage.

by Simon Koss – Google Partner Premier, SEM & Analytics Business Trainer