How to Upload Your Shopify Customer List to Google Ads

Speaker: 00:00:11

Today, I'm going to be showing you how

to export your Shopify customer list, how

2

: 00:00:15

to properly format it, and then how to

upload it in Google ads as a customer list

3

: 00:00:20

that you can leverage in your campaigns.

4

: 00:00:22

So really powerful way to have that

list automatically uploaded, maybe

5

: 00:00:26

weekly, maybe daily, depending on the

number of customers you have coming in.

6

: 00:00:35

Hey, everyone.

7

: 00:00:36

My name is Frank.

8

: 00:00:36

I'm an account manager

here at solutions eight.

9

: 00:00:39

And today I'm going to be showing you how

to export your Shopify customer list, how

10

: 00:00:44

to properly format it, and then how to

upload it in Google ads as a customer list

11

: 00:00:48

that you can leverage in your campaigns.

12

: 00:00:51

So for some context, customer lists

have been important for a while now.

13

: 00:00:55

But they're getting even more important

this year in: 2024

14

: 00:00:59

of third party cookies, you're going

to want to feed Google as much first

15

: 00:01:03

party data as you possibly can to

train the smart bidding algorithm.

16

: 00:01:08

And the best way to do that after

enhanced conversions is directly

17

: 00:01:12

uploading a customer list.

18

: 00:01:15

We're here in the backend

of our Shopify store.

19

: 00:01:18

And the first thing you want to

do is head to the left hand side

20

: 00:01:21

here and find the customers tab.

21

: 00:01:24

Go ahead and click that.

22

: 00:01:25

you'll be able to access all of

your customers from your store.

23

: 00:01:29

And we're going to segment out a specific

group of people to upload to Google ads.

24

: 00:01:35

So in most cases, you're probably

going to want to only upload people

25

: 00:01:38

who have actually made a purchase.

26

: 00:01:40

and not just their email address,

People who are purchasing customers.

27

: 00:01:44

And you might even want to segment

that by country or by product.

28

: 00:01:49

In our case, we're going to select a

group of customers who are from a certain

29

: 00:01:53

country and have purchased at least once.

30

: 00:01:55

So click in the segment box.

31

: 00:01:57

And in my case, I'm going to type

in country contains and select my

32

: 00:02:02

desired location, click apply, and

then go ahead and start typing.

33

: 00:02:07

And This filter and, or will pop up.

34

: 00:02:10

I'm going to choose and then type

in first order date, scroll all the

35

: 00:02:14

way down and click exists and apply.

36

: 00:02:18

What this does is guarantee that anyone

in this list here is from that country.

37

: 00:02:22

And.

38

: 00:02:23

Has an existing first order date,

meaning they have purchased at

39

: 00:02:26

least one time you can see here.

40

: 00:02:29

That's 89 percent of

customers in the store.

41

: 00:02:31

so the list has dropped

a substantial amount.

42

: 00:02:34

I just figure I don't want to upload

those people who aren't in that group just

43

: 00:02:38

because I want Google to have a narrow

focus on exactly, my target customers.

44

: 00:02:43

If you're going to be doing this more

than once, click save segment, and then

45

: 00:02:48

on the left hand side in segments, you'll

be able to come back to this segment

46

: 00:02:51

easily and export it again in the future.

47

: 00:02:55

In this case, I'm just

going to click export.

48

: 00:02:57

Make sure you have this selected.

49

: 00:02:59

all customers matching filter

selected your tags checked and

50

: 00:03:02

then your desired file format.

51

: 00:03:05

I'm going to choose CSV for

Excel and then click export.

52

: 00:03:09

It's going to send you a

zip file to your email.

53

: 00:03:12

Go ahead and download that, open

up the zip and then make sure

54

: 00:03:15

you have the CSV ready to go.

55

: 00:03:17

Next thing you want to do is head

over to a Google Sheet that you have

56

: 00:03:21

open and click File, Import, Upload,

Browse, and select your CSV file that

57

: 00:03:29

you want to upload, and click Open.

58

: 00:03:31

It takes a few seconds to upload

depending on how large your list is,

59

: 00:03:36

and then when it's ready, there's

a setting that we want to choose.

60

: 00:03:40

So once you're in this window here,

instead of create new spreadsheet,

61

: 00:03:44

I'm just going to append to the

current sheet and leave everything

62

: 00:03:47

else as is and import our data.

63

: 00:03:50

So this does take a while because

it's uploading so many data points.

64

: 00:03:53

So in the meantime, let me show

you our options for formatting.

65

: 00:03:57

Google allows us to upload either a list

of just emails for a streamlined upload.

66

: 00:04:02

Or email, phone, first, last zip

and country for the possibility

67

: 00:04:07

to match with more customers.

68

: 00:04:09

So that's what we're going to do.

69

: 00:04:11

We want the best chance to match

our customer list to as many

70

: 00:04:15

Google accounts as possible.

71

: 00:04:16

So we're going to include

all of those data points.

72

: 00:04:19

sometimes it takes a while, Come on back

to your Google sheet whenever it's ready.

73

: 00:04:23

And then we're going to make

sure we remove any other columns

74

: 00:04:26

that aren't those data points

that we just talked about here.

75

: 00:04:30

So I'm going to remove customer

ID, however, you want to make sure

76

: 00:04:33

that you leave your zip codes and

your country and your phone remove

77

: 00:04:40

accepts SMS, total spend orders, no.

78

: 00:04:44

And any other thing here that

you don't want to upload to

79

: 00:04:48

Google, delete those columns.

80

: 00:04:50

First, last, default address.

81

: 00:04:53

That's our zip code here.

82

: 00:04:54

That's our country.

83

: 00:04:55

and then we have a bunch

of phone numbers here.

84

: 00:04:58

Not sure why we have Two different

fields, but I'm just going to remove

85

: 00:05:01

this one because it has less data in it.

86

: 00:05:03

The next thing you want to do is make

sure you match up the column title

87

: 00:05:06

with exactly what Google is saying.

88

: 00:05:09

So we do have to change two things here.

89

: 00:05:11

It is zip and country.

90

: 00:05:13

You can see here it has

default address zip.

91

: 00:05:16

Make sure you just type in zip.

92

: 00:05:18

And then this one, make

sure you type in country.

93

: 00:05:20

And then this one, we actually have

a third, make sure you type in phone.

94

: 00:05:25

And I like to organize

it in the exact order.

95

: 00:05:28

That Google recommends which is

email phone first last zip country.

96

: 00:05:32

So let's drag our columns

email phone first name last

97

: 00:05:37

name zip and Country perfect.

98

: 00:05:40

So we have everything ready to go here.

99

: 00:05:42

Just do one last double check should

be good to go ahead and click file

100

: 00:05:46

download and Comma separated value.

101

: 00:05:49

Select that should download

really quickly here.

102

: 00:05:52

So now that our list is downloaded, what

you want to do is head over to Google ads.

103

: 00:05:57

And if you haven't uploaded a

customer list before, you need

104

: 00:06:00

to go to tools and settings.

105

: 00:06:02

audience manager, and then click

the plus button and create a

106

: 00:06:07

customer list for everyone who has

already uploaded a customer list.

107

: 00:06:11

Sometime.

108

: 00:06:12

what you can do is apply this filter

type customer list to easily find the

109

: 00:06:17

list you're looking for to upload.

110

: 00:06:19

In this case, we're going to replace our

customer list that I uploaded in January.

111

: 00:06:23

So go ahead and click on your

customer list and in the top

112

: 00:06:27

right, click these three dots.

113

: 00:06:28

Click edit list.

114

: 00:06:30

And now that it's March, I'm going

to update that to March,: 2024

115

: 00:06:36

and click edit your list based

on customer contact information.

116

: 00:06:41

And I'm going to replace the existing

list members with a new customer list.

117

: 00:06:45

Check this box to make sure that it'll

upload properly and do make sure that you

118

: 00:06:50

collected all of your customer information

in compliance with Google's policies.

119

: 00:06:54

But that one is on you guys,

drop file here, or browse, click

120

: 00:06:59

browse and upload that list.

121

: 00:07:01

We just downloaded from Google sheets.

122

: 00:07:04

Make sure it's the one from there,

not the original Shopify download.

123

: 00:07:07

Cause this is the properly formatted one.

124

: 00:07:10

Go ahead and click open.

125

: 00:07:11

And then, if you have any settings

you need to change, for example, you

126

: 00:07:16

can select a membership duration.

127

: 00:07:19

I like to select no expiration

and you can include a description.

128

: 00:07:23

So you remember in the future, if

this was a list of people who only

129

: 00:07:27

purchased from a specific country

or maybe a specific product, so you

130

: 00:07:31

don't forget next time you come back.

131

: 00:07:33

so with everything done there, the next

step is to click save and continue,

132

: 00:07:38

and Google is going to upload that.

133

: 00:07:41

I'll just pause the video

here while it uploads.

134

: 00:07:43

Okay, we're back with our list done

uploading, and you can see here it'll give

135

: 00:07:47

us a summary, and it's saying there's a

few rows that were formatted incorrectly.

136

: 00:07:52

Most likely the phone number or something

wasn't right, but that's almost all.

137

: 00:07:57

100 percent of people.

138

: 00:07:58

just keep in mind when you upload a

er list, you do need at least: 1000

139

: 00:08:02

matched customers to be able to use it.

140

: 00:08:04

And then when you're here,

just go ahead and click done.

141

: 00:08:07

And this list will start populating.

142

: 00:08:10

If you click on match rate, you

can see the previous match rate.

143

: 00:08:15

You click segment members.

144

: 00:08:16

You can see here, the

one we just uploaded day.

145

: 00:08:20

It has just started processing that

can take like 24 to 48 hours or more

146

: 00:08:27

for the list to be fully processed.

147

: 00:08:29

When it does, you'll be able to

see the number of people in the

148

: 00:08:32

list and the estimated match rate.

149

: 00:08:34

of the customers that

match to Google accounts.

150

: 00:08:37

And so from here, once your list is done

populating, you can use it as audience

151

: 00:08:42

signals in performance, max exclusions

in all kinds of campaigns like YouTube,

152

: 00:08:46

for example, and then the Google ads

algorithm can start using those signals.

153

: 00:08:51

Data points as signals for its

bidding and optimization, and you'll

154

: 00:08:56

be in good standing moving forward

without those third party cookies.

155

: 00:09:01

As we come into the end of the year,

the best practice for this is to

156

: 00:09:04

upload your lists as often as possible.

157

: 00:09:07

And obviously with this method, it takes

a little bit of time and manual work.

158

: 00:09:11

So if you want a way to optimize that, I

recommend if you have Klaviyo, integrated

159

: 00:09:18

with your business or other third party

platforms, maybe like Sendlane, to

160

: 00:09:24

upload your customer list on Klaviyo.

161

: 00:09:26

Automatically from them.

162

: 00:09:28

real quick, when you're in

clavio, what you want to do

163

: 00:09:31

on the bottom left is click.

164

: 00:09:33

Integrations, and you'll

arrive on this page here.

165

: 00:09:37

You just need to click add integration

and search for Google and Google ads.

166

: 00:09:42

you do have to link it

through an admin account.

167

: 00:09:45

You can't link it through access,

one that you have an MCC account.

168

: 00:09:49

So just keep that in mind.

169

: 00:09:51

And then once you do, you're able to

select exactly which audience you want

170

: 00:09:54

uploaded And where, so really powerful

way to have that list automatically

171

: 00:09:59

uploaded, maybe weekly, maybe daily,

depending on the number of customers

172

: 00:10:02

you have coming So that has been how to

upload your customer lists to Google ads.

173

: 00:10:08

Thanks everyone.