Created on 17 June, 2021 | Updated on 5 July, 2021
How to Upload Shopify Customer List To Google Ads

How to Upload Shopify Customer List To Google Ads

Uploading your Shopify customer data to Google Ads is a powerful tool in allowing you to remarket existing buyers. If you know your customers will purchase from you again, setting up a Display Remarketing campaign or Smart Display campaign will generate that extra sales opportunity.

Why waste your initial customer acquisition efforts when you can get another sale.

Step 1 – Export Customer List

Export your customer list by going to your Shopify Admin page.

  • Click on Customers
  • Click on Export in the top right corner
  • From the pop up choose all customers
  • Click on Export Customers
  • An email will be sent to you with the file

Step 2 – Modifying The File

Open the file you have received in your email address and delete the following columns.

  • Company
  • Address 1
  • Address 2
  • City
  • Province
  • Province Code
  • Country
  • Accepts Marketing
  • Total Spent
  • Total Orders
  • Tags
  • Note
  • Tax Exempt

Essentially we want to keep the following

  • Email
  • Phone
  • First Name
  • Last Name
  • Country Code
  • Zip

In the header (the first row) rename the column name County Code to Country

Save your file as CSV.

Step 2 – Uploading The File In Google Ads

Log in to your Google Ads account and navigate to:

  1. Tools And Settings
  2. Audience Manager
  1. Click on the blue plus button and choose Customer List from the options.
  1. Provide an Audience Name (anything that helps you recognize the file)
  2. Leave the option Upload Emails, Phones, and/or Mailing Address
  3. Leave the settings Upload plain text data (unhashed)
  4. Choose your file you just modified
  5. Scroll to the bottom of the page and click on Upload and Create List
Google Ads Upload and Create Customer List
  1. Within 24 hours your list will be available in the Audience Manager section

Need Help?

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.