NYC Segment Analyzer for Help Center
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

View only
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Welcome! Some instructions to help you set this up:
2
3
Make a copy of this doc for yourself. (If you’re logged into a Google Account, go to the File menu -> Make a Copy)
4
Open Klaviyo, and navigate to your Account Settings -> API Keys screen.
5
Generate a new API key, give it a name, and then copy it. It will be in the format of “pk_” and then a string of letters and number afterwards.
6
Paste that new API key into the field on the sheet to the right of “API Key”
7
Return to Klaviyo and navigate to your Metrics page from the left-hand navigation.
8
Find your “Placed Order” Metric in the list and click on it.
9
In your URL bar, find the 6-character ID. This is a unique identifier for your own account’s Placed Order account. It will be in the format of “MuTjBk” but unique to your account.
10
Copy and paste this value to the right of “Placed Order ID” field in the Segment Analyzer
11
After you've done this, the Customer Data sheet is ready to use.
12
13
Create a segment in Klaviyo of recent new customers, and one additional criteria. It’s okay to include suppressed customers in this list, because we won’t be emailing them - we’re using them to learn about what they purchase. Some good places to start with can preferences that you’ve collected in the past - size, colors, gender, style, needs, and so on. You may try a few different criteria before you find one that makes a meaningful difference, so it’s okay to pick something to start with and explore from there.
14
After the segment finishes running, go to the “Manage Segment” menu and export the segment. You’ll get a CSV file in a few seconds.
15
Copy the “ID” column out of the CSV, and paste it into the ID column in the Segment Analyzer.
16
After a few seconds, depending on the size of your segment, the rest of the sheet will fill in. On the right hand side, you’ll see calculated results for the most popular product amongst first-time customers, and their average spend in your store.
17
Re-run these results for different slices of your customer base.
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...