Shopify 리서치 허브 · 문서/위키형 둘러보기 분류 관리 자동 조사

Blue Sense Digital

YouTube 수집: 2026-11-05 게시: 2024-03-04
https://youtu.be/wWbVeVPUcho

내용

[subtitle-meta] lang=en auto=True hey guys tan here from Blue Sense Digital and in this video we're just going to be going over how to accurately segment or break down your order data on Shopify um to segment that into cohorts of average order value that you can see exactly you know the number of orders that are falling into different cohorts and then from that you can accurately place any sort of free shipping thresholds or let's say discount thresholds um in the most effective range um so that it has the biggest impact on your average order value and sales as a whole on Shopify so yeah strap in and let's dive in so just to demonstrate this concept holistically with a bad drawing so generally speaking what this graph looks like is it would look something like this where you'd have an initial Peak and then a slight peek towards the bottom end in terms of aov so on a graph if we had to draw that this would be number of orders and then this would be order value so let's say most of the orders that come through this particular store let's say are or have an average order value of $30 and then you have a bit of a you know a segment at the top over here let's say they sell a variation of of products the other segment up here in terms of order value let's say this was um $100 excuse my drawing skills now when you're looking at the average order metric on sorry the average order value metric on Shopify this takes into account all orders on your store um now it it doesn't take into account this trend um and a lot of Brands set free shipping thresholds um based off this average order value but this is actually a an ineffective way of doing this because you don't take into account these or you know Peak areas that I've mentioned here so let's say in this scenario for this business their average order value on Shopify might be sitting at around $60 which is slap bang in the middle of these two cohorts so let's say for example someone that's that's spending $30 on an order isn't going to be Keen to spend double to reach that free shipping threshold and that free shipping threshold does doesn't add any benefit or any value to people purchasing $100 product because obviously that's way over that free shipping threshold so this is kind of a a a Miss completely in terms of actual value add to the business ideally based on this um Trend you'd want to be setting your free shipping threshold let's say over there at $40 because it's a it's a lot more achievable for those people to add you know one small product to bump their order up $10 or so to get free shipping over $40 and then you could add some sort of second discount at let's say $120 and then it'll encourage these or this cohort that's sitting at an average of $100 to spend that extra $20 or so so this is the reason why we want to break down this data so that we can accurately see where these Peaks are and structure our discount structure accordingly so to go about this process I'll just run through this quick first thing you'll need to do is go over to Shopify I've just got a couple screenshots here go to the orders Tab and then at the top here just click export and Export all the orders from your Shopify store that'll then give you a CSV file which you can then drag and drop into Google Drive once that is uploaded so once that CSV file is uploaded just right click on that and open that as a Google sheet once that has been converted into a Google sheet then the only column we looking for is total average order value or you could do it on subtotal average order value depending on obviously how your discount is structured on or or sorry how you plan to structure your discount on the back end but just for the sake of this video Let's just assume that we're using total average order value so this is the only column we need so just cut or copy that and we can just move that to a new sheet okay once that's done we'll just need to do a little bit of data hygiene so you can just select that column go up to the top over here data and then sort sheet Za to a and then scroll scroll all the way down to yeah okay so scroll all the way down to the bottom of this St sometimes it might take you quite a while so once you've reached the bottom just make a mental note of the range that we'll be using in the code that we'll use so in this case this is 10865 reading from the top cell which would be A2 so A2 to a 1065 sorry 10865 so once we've done that we'll need to use a snippet of code just to break this data down for us so we've written a piece of code for you we'll sorry we'll link this in the video description but that should look something like this so just copy that code and head back on over to the Google sheet and and then up at the top over here under extensions go to app script then from here just delete everything that is that is currently in this section and then paste your your script in there now depending on what increments you're wanting to class your your orders into you can just adjust that over here so just follow the same you know nomenclature here and obviously Just Adjust that as you see fit so let's say we were only looking to go up or we wanted to add another increment or four 400 to 420 so just go column uh 420 and so on and so forth you can obviously just break that down as you like um then the second thing we're going to need to add is the range that we'll be operating in which is this section up over here as I've mentioned in this specific document that we're using here we going from A2 to a uh A1 865 so both those pieces of info the range as well as the increments have been put in um from there you can just hit save give it a name or the give the script a name if you'd like and then hit run the script should then ask you for authorization so just go review permissions and it'll ask you to sign in with your Google account and then click allow and as you can see here the script is started and the script is finished finished now if we go back to our Google sheet over here we'll see that it's broken down this data that we've thrown into the Google sheet here it's broken it down into two nice columns which is the increments that we put in so you know 0 to $20 20 to 40 40 to 60 Etc and the number of cells so the number of orders that fall into each increment now what we can do is just put this graph sorry put this data into a graph so just High that insert chart and there you go that's your your breakdown of the number of orders that fall into different average order value classes now as you can see here this follows exactly what I mentioned in the the bad drawing at the start where you have that initial Spike and then you got a bit of a spike at a at a higher average order value now these guys currently have a free shipping offer of over $100 so that would sit somewhere around over here now as you can see most of the orders are on the lower end and you know someone spending $4 to $50 I don't think or you know from a common sense perspective they wouldn't be too Keen to push that order all the way over $100 to get that free shipping uh threshold obviously there will be a few but the vast majority of people would rather just pay the shipping and you know buy or have a smaller order so now from here we can go to or go back to the drawing board and say okay we're going to perhaps put our free shipping threshold over $75 or over $80 so that you know this this uh segment of users the $4 to $60 orders are uh pushed to spend an additional you know 10 15 maybe even $20 to get that free shipping as opposed to another $50 to get that free shipping So It ultimately should have a much bigger impact on your average order value by you know firstly analyzing your average or your orders average order values and then placing your discounts or offers accordingly so that was it hopefully that was valuable I think that's a quite a cool system that that should work well for most businesses again if you have any comments please let us know in the comment section below if you like the video uh please give it a like it helps us out and we'll see you in the next one buffing out
원문 자막 펼치기
WEBVTT
Kind: captions
Language: en

00:00:00.080 --> 00:00:01.350 align:start position:0%
 
hey<00:00:00.199><c> guys</c><00:00:00.399><c> tan</c><00:00:00.719><c> here</c><00:00:00.799><c> from</c><00:00:00.919><c> Blue</c><00:00:01.120><c> Sense</c>

00:00:01.350 --> 00:00:01.360 align:start position:0%
hey guys tan here from Blue Sense
 

00:00:01.360 --> 00:00:02.669 align:start position:0%
hey guys tan here from Blue Sense
Digital<00:00:01.800><c> and</c><00:00:02.000><c> in</c><00:00:02.120><c> this</c><00:00:02.240><c> video</c><00:00:02.480><c> we're</c><00:00:02.600><c> just</c>

00:00:02.669 --> 00:00:02.679 align:start position:0%
Digital and in this video we're just
 

00:00:02.679 --> 00:00:04.950 align:start position:0%
Digital and in this video we're just
going<00:00:02.800><c> to</c><00:00:02.879><c> be</c><00:00:03.000><c> going</c><00:00:03.280><c> over</c><00:00:03.760><c> how</c><00:00:03.919><c> to</c><00:00:04.319><c> accurately</c>

00:00:04.950 --> 00:00:04.960 align:start position:0%
going to be going over how to accurately
 

00:00:04.960 --> 00:00:08.589 align:start position:0%
going to be going over how to accurately
segment<00:00:05.759><c> or</c><00:00:06.040><c> break</c><00:00:06.440><c> down</c><00:00:06.960><c> your</c><00:00:07.240><c> order</c><00:00:07.720><c> data</c><00:00:08.200><c> on</c>

00:00:08.589 --> 00:00:08.599 align:start position:0%
segment or break down your order data on
 

00:00:08.599 --> 00:00:13.629 align:start position:0%
segment or break down your order data on
Shopify<00:00:09.599><c> um</c><00:00:09.800><c> to</c><00:00:10.400><c> segment</c><00:00:11.120><c> that</c><00:00:11.920><c> into</c><00:00:12.880><c> cohorts</c>

00:00:13.629 --> 00:00:13.639 align:start position:0%
Shopify um to segment that into cohorts
 

00:00:13.639 --> 00:00:15.470 align:start position:0%
Shopify um to segment that into cohorts
of<00:00:13.880><c> average</c><00:00:14.200><c> order</c><00:00:14.519><c> value</c><00:00:14.920><c> that</c><00:00:15.040><c> you</c><00:00:15.120><c> can</c><00:00:15.200><c> see</c>

00:00:15.470 --> 00:00:15.480 align:start position:0%
of average order value that you can see
 

00:00:15.480 --> 00:00:17.790 align:start position:0%
of average order value that you can see
exactly<00:00:16.240><c> you</c><00:00:16.359><c> know</c><00:00:16.760><c> the</c><00:00:16.960><c> number</c><00:00:17.240><c> of</c><00:00:17.400><c> orders</c>

00:00:17.790 --> 00:00:17.800 align:start position:0%
exactly you know the number of orders
 

00:00:17.800 --> 00:00:19.670 align:start position:0%
exactly you know the number of orders
that<00:00:17.920><c> are</c><00:00:18.039><c> falling</c><00:00:18.439><c> into</c><00:00:18.760><c> different</c>

00:00:19.670 --> 00:00:19.680 align:start position:0%
that are falling into different
 

00:00:19.680 --> 00:00:22.790 align:start position:0%
that are falling into different
cohorts<00:00:20.680><c> and</c><00:00:20.840><c> then</c><00:00:21.720><c> from</c><00:00:22.080><c> that</c><00:00:22.359><c> you</c><00:00:22.480><c> can</c>

00:00:22.790 --> 00:00:22.800 align:start position:0%
cohorts and then from that you can
 

00:00:22.800 --> 00:00:24.750 align:start position:0%
cohorts and then from that you can
accurately<00:00:23.439><c> place</c><00:00:23.880><c> any</c><00:00:24.160><c> sort</c><00:00:24.320><c> of</c><00:00:24.480><c> free</c>

00:00:24.750 --> 00:00:24.760 align:start position:0%
accurately place any sort of free
 

00:00:24.760 --> 00:00:26.830 align:start position:0%
accurately place any sort of free
shipping<00:00:25.279><c> thresholds</c><00:00:26.199><c> or</c><00:00:26.400><c> let's</c><00:00:26.599><c> say</c>

00:00:26.830 --> 00:00:26.840 align:start position:0%
shipping thresholds or let's say
 

00:00:26.840 --> 00:00:29.429 align:start position:0%
shipping thresholds or let's say
discount<00:00:27.519><c> thresholds</c><00:00:28.519><c> um</c><00:00:28.679><c> in</c><00:00:28.840><c> the</c><00:00:29.039><c> most</c>

00:00:29.429 --> 00:00:29.439 align:start position:0%
discount thresholds um in the most
 

00:00:29.439 --> 00:00:30.550 align:start position:0%
discount thresholds um in the most
effective

00:00:30.550 --> 00:00:30.560 align:start position:0%
effective
 

00:00:30.560 --> 00:00:32.870 align:start position:0%
effective
range<00:00:31.560><c> um</c><00:00:31.720><c> so</c><00:00:31.880><c> that</c><00:00:31.960><c> it</c><00:00:32.160><c> has</c><00:00:32.320><c> the</c><00:00:32.480><c> biggest</c>

00:00:32.870 --> 00:00:32.880 align:start position:0%
range um so that it has the biggest
 

00:00:32.880 --> 00:00:35.110 align:start position:0%
range um so that it has the biggest
impact<00:00:33.440><c> on</c><00:00:34.000><c> your</c><00:00:34.200><c> average</c><00:00:34.480><c> order</c><00:00:34.719><c> value</c><00:00:35.000><c> and</c>

00:00:35.110 --> 00:00:35.120 align:start position:0%
impact on your average order value and
 

00:00:35.120 --> 00:00:37.950 align:start position:0%
impact on your average order value and
sales<00:00:35.440><c> as</c><00:00:35.559><c> a</c><00:00:35.680><c> whole</c><00:00:35.920><c> on</c><00:00:36.079><c> Shopify</c><00:00:36.760><c> so</c><00:00:37.559><c> yeah</c>

00:00:37.950 --> 00:00:37.960 align:start position:0%
sales as a whole on Shopify so yeah
 

00:00:37.960 --> 00:00:41.029 align:start position:0%
sales as a whole on Shopify so yeah
strap<00:00:38.160><c> in</c><00:00:38.399><c> and</c><00:00:38.559><c> let's</c><00:00:38.760><c> dive</c><00:00:39.360><c> in</c><00:00:40.360><c> so</c><00:00:40.680><c> just</c><00:00:40.800><c> to</c>

00:00:41.029 --> 00:00:41.039 align:start position:0%
strap in and let's dive in so just to
 

00:00:41.039 --> 00:00:43.630 align:start position:0%
strap in and let's dive in so just to
demonstrate<00:00:41.680><c> this</c><00:00:42.320><c> concept</c><00:00:42.879><c> holistically</c>

00:00:43.630 --> 00:00:43.640 align:start position:0%
demonstrate this concept holistically
 

00:00:43.640 --> 00:00:46.590 align:start position:0%
demonstrate this concept holistically
with<00:00:43.840><c> a</c><00:00:44.320><c> bad</c><00:00:44.600><c> drawing</c><00:00:45.440><c> so</c><00:00:45.760><c> generally</c><00:00:46.199><c> speaking</c>

00:00:46.590 --> 00:00:46.600 align:start position:0%
with a bad drawing so generally speaking
 

00:00:46.600 --> 00:00:48.709 align:start position:0%
with a bad drawing so generally speaking
what<00:00:46.800><c> this</c><00:00:47.000><c> graph</c><00:00:47.320><c> looks</c><00:00:47.600><c> like</c><00:00:48.280><c> is</c><00:00:48.399><c> it</c><00:00:48.520><c> would</c>

00:00:48.709 --> 00:00:48.719 align:start position:0%
what this graph looks like is it would
 

00:00:48.719 --> 00:00:50.229 align:start position:0%
what this graph looks like is it would
look<00:00:48.920><c> something</c><00:00:49.239><c> like</c><00:00:49.520><c> this</c><00:00:49.920><c> where</c><00:00:50.039><c> you'd</c>

00:00:50.229 --> 00:00:50.239 align:start position:0%
look something like this where you'd
 

00:00:50.239 --> 00:00:52.229 align:start position:0%
look something like this where you'd
have<00:00:50.559><c> an</c><00:00:50.719><c> initial</c><00:00:51.160><c> Peak</c><00:00:51.480><c> and</c><00:00:51.559><c> then</c><00:00:51.680><c> a</c><00:00:51.840><c> slight</c>

00:00:52.229 --> 00:00:52.239 align:start position:0%
have an initial Peak and then a slight
 

00:00:52.239 --> 00:00:54.510 align:start position:0%
have an initial Peak and then a slight
peek<00:00:52.520><c> towards</c><00:00:53.320><c> the</c><00:00:53.480><c> bottom</c><00:00:53.760><c> end</c><00:00:54.000><c> in</c><00:00:54.120><c> terms</c><00:00:54.359><c> of</c>

00:00:54.510 --> 00:00:54.520 align:start position:0%
peek towards the bottom end in terms of
 

00:00:54.520 --> 00:01:00.029 align:start position:0%
peek towards the bottom end in terms of
aov<00:00:55.359><c> so</c><00:00:56.359><c> on</c><00:00:56.760><c> a</c><00:00:57.160><c> graph</c><00:00:58.120><c> if</c><00:00:58.239><c> we</c><00:00:58.399><c> had</c><00:00:58.519><c> to</c><00:00:58.680><c> draw</c><00:00:59.039><c> that</c>

00:01:00.029 --> 00:01:00.039 align:start position:0%
aov so on a graph if we had to draw that
 

00:01:00.039 --> 00:01:04.789 align:start position:0%
aov so on a graph if we had to draw that
this<00:01:00.199><c> would</c><00:01:00.840><c> be</c><00:01:01.840><c> number</c><00:01:02.480><c> of</c><00:01:03.159><c> orders</c><00:01:04.159><c> and</c><00:01:04.320><c> then</c>

00:01:04.789 --> 00:01:04.799 align:start position:0%
this would be number of orders and then
 

00:01:04.799 --> 00:01:07.950 align:start position:0%
this would be number of orders and then
this<00:01:04.960><c> would</c><00:01:05.159><c> be</c><00:01:05.400><c> order</c><00:01:05.920><c> value</c><00:01:06.920><c> so</c><00:01:07.240><c> let's</c><00:01:07.479><c> say</c>

00:01:07.950 --> 00:01:07.960 align:start position:0%
this would be order value so let's say
 

00:01:07.960 --> 00:01:09.670 align:start position:0%
this would be order value so let's say
most<00:01:08.280><c> of</c><00:01:08.439><c> the</c><00:01:08.560><c> orders</c><00:01:09.000><c> that</c><00:01:09.159><c> come</c><00:01:09.400><c> through</c>

00:01:09.670 --> 00:01:09.680 align:start position:0%
most of the orders that come through
 

00:01:09.680 --> 00:01:12.910 align:start position:0%
most of the orders that come through
this<00:01:09.880><c> particular</c><00:01:10.560><c> store</c><00:01:11.560><c> let's</c><00:01:11.799><c> say</c><00:01:12.159><c> are</c><00:01:12.680><c> or</c>

00:01:12.910 --> 00:01:12.920 align:start position:0%
this particular store let's say are or
 

00:01:12.920 --> 00:01:15.670 align:start position:0%
this particular store let's say are or
have<00:01:13.080><c> an</c><00:01:13.240><c> average</c><00:01:13.520><c> order</c><00:01:13.799><c> value</c><00:01:14.080><c> of</c><00:01:14.520><c> $30</c><00:01:15.520><c> and</c>

00:01:15.670 --> 00:01:15.680 align:start position:0%
have an average order value of $30 and
 

00:01:15.680 --> 00:01:17.830 align:start position:0%
have an average order value of $30 and
then<00:01:16.080><c> you</c><00:01:16.280><c> have</c><00:01:16.439><c> a</c><00:01:16.560><c> bit</c><00:01:16.680><c> of</c><00:01:16.799><c> a</c><00:01:17.080><c> you</c><00:01:17.200><c> know</c><00:01:17.680><c> a</c>

00:01:17.830 --> 00:01:17.840 align:start position:0%
then you have a bit of a you know a
 

00:01:17.840 --> 00:01:19.230 align:start position:0%
then you have a bit of a you know a
segment<00:01:18.200><c> at</c><00:01:18.320><c> the</c><00:01:18.439><c> top</c><00:01:18.600><c> over</c><00:01:18.799><c> here</c><00:01:18.920><c> let's</c><00:01:19.080><c> say</c>

00:01:19.230 --> 00:01:19.240 align:start position:0%
segment at the top over here let's say
 

00:01:19.240 --> 00:01:22.230 align:start position:0%
segment at the top over here let's say
they<00:01:19.360><c> sell</c><00:01:19.840><c> a</c><00:01:20.000><c> variation</c><00:01:20.560><c> of</c><00:01:20.840><c> of</c><00:01:21.079><c> products</c><00:01:22.079><c> the</c>

00:01:22.230 --> 00:01:22.240 align:start position:0%
they sell a variation of of products the
 

00:01:22.240 --> 00:01:26.270 align:start position:0%
they sell a variation of of products the
other<00:01:22.520><c> segment</c><00:01:22.920><c> up</c><00:01:23.200><c> here</c><00:01:23.880><c> in</c><00:01:24.079><c> terms</c><00:01:24.759><c> of</c><00:01:25.759><c> order</c>

00:01:26.270 --> 00:01:26.280 align:start position:0%
other segment up here in terms of order
 

00:01:26.280 --> 00:01:31.630 align:start position:0%
other segment up here in terms of order
value<00:01:26.920><c> let's</c><00:01:27.159><c> say</c><00:01:27.479><c> this</c><00:01:27.960><c> was</c><00:01:28.960><c> um</c><00:01:29.200><c> $100</c>

00:01:31.630 --> 00:01:31.640 align:start position:0%
value let's say this was um $100
 

00:01:31.640 --> 00:01:34.990 align:start position:0%
value let's say this was um $100
excuse<00:01:32.079><c> my</c><00:01:32.439><c> drawing</c><00:01:33.040><c> skills</c><00:01:34.040><c> now</c><00:01:34.560><c> when</c><00:01:34.720><c> you're</c>

00:01:34.990 --> 00:01:35.000 align:start position:0%
excuse my drawing skills now when you're
 

00:01:35.000 --> 00:01:39.429 align:start position:0%
excuse my drawing skills now when you're
looking<00:01:35.640><c> at</c><00:01:36.280><c> the</c><00:01:36.680><c> average</c><00:01:37.000><c> order</c><00:01:37.399><c> metric</c><00:01:38.439><c> on</c>

00:01:39.429 --> 00:01:39.439 align:start position:0%
looking at the average order metric on
 

00:01:39.439 --> 00:01:41.789 align:start position:0%
looking at the average order metric on
sorry<00:01:39.720><c> the</c><00:01:39.840><c> average</c><00:01:40.079><c> order</c><00:01:40.399><c> value</c><00:01:40.799><c> metric</c><00:01:41.200><c> on</c>

00:01:41.789 --> 00:01:41.799 align:start position:0%
sorry the average order value metric on
 

00:01:41.799 --> 00:01:44.789 align:start position:0%
sorry the average order value metric on
Shopify<00:01:42.799><c> this</c><00:01:43.159><c> takes</c><00:01:43.680><c> into</c><00:01:44.040><c> account</c><00:01:44.479><c> all</c>

00:01:44.789 --> 00:01:44.799 align:start position:0%
Shopify this takes into account all
 

00:01:44.799 --> 00:01:48.709 align:start position:0%
Shopify this takes into account all
orders<00:01:45.439><c> on</c><00:01:45.600><c> your</c><00:01:46.079><c> store</c><00:01:47.079><c> um</c><00:01:47.920><c> now</c><00:01:48.360><c> it</c><00:01:48.600><c> it</c>

00:01:48.709 --> 00:01:48.719 align:start position:0%
orders on your store um now it it
 

00:01:48.719 --> 00:01:50.389 align:start position:0%
orders on your store um now it it
doesn't<00:01:49.079><c> take</c><00:01:49.280><c> into</c>

00:01:50.389 --> 00:01:50.399 align:start position:0%
doesn't take into
 

00:01:50.399 --> 00:01:53.310 align:start position:0%
doesn't take into
account<00:01:51.399><c> this</c><00:01:51.680><c> trend</c><00:01:52.520><c> um</c><00:01:52.680><c> and</c><00:01:52.799><c> a</c><00:01:52.960><c> lot</c><00:01:53.119><c> of</c>

00:01:53.310 --> 00:01:53.320 align:start position:0%
account this trend um and a lot of
 

00:01:53.320 --> 00:01:56.910 align:start position:0%
account this trend um and a lot of
Brands<00:01:53.880><c> set</c><00:01:54.079><c> free</c><00:01:54.360><c> shipping</c><00:01:55.079><c> thresholds</c><00:01:56.079><c> um</c>

00:01:56.910 --> 00:01:56.920 align:start position:0%
Brands set free shipping thresholds um
 

00:01:56.920 --> 00:01:58.990 align:start position:0%
Brands set free shipping thresholds um
based<00:01:57.320><c> off</c><00:01:57.719><c> this</c><00:01:57.960><c> average</c><00:01:58.240><c> order</c><00:01:58.560><c> value</c><00:01:58.840><c> but</c>

00:01:58.990 --> 00:01:59.000 align:start position:0%
based off this average order value but
 

00:01:59.000 --> 00:02:01.109 align:start position:0%
based off this average order value but
this<00:01:59.119><c> is</c><00:01:59.280><c> actually</c><00:01:59.520><c> a</c><00:02:00.000><c> an</c><00:02:00.200><c> ineffective</c><00:02:00.840><c> way</c><00:02:01.000><c> of</c>

00:02:01.109 --> 00:02:01.119 align:start position:0%
this is actually a an ineffective way of
 

00:02:01.119 --> 00:02:03.350 align:start position:0%
this is actually a an ineffective way of
doing<00:02:01.439><c> this</c><00:02:01.759><c> because</c><00:02:02.159><c> you</c><00:02:02.320><c> don't</c><00:02:02.680><c> take</c><00:02:02.880><c> into</c>

00:02:03.350 --> 00:02:03.360 align:start position:0%
doing this because you don't take into
 

00:02:03.360 --> 00:02:05.029 align:start position:0%
doing this because you don't take into
account

00:02:05.029 --> 00:02:05.039 align:start position:0%
account
 

00:02:05.039 --> 00:02:07.789 align:start position:0%
account
these<00:02:06.039><c> or</c><00:02:06.200><c> you</c><00:02:06.280><c> know</c><00:02:06.520><c> Peak</c><00:02:06.920><c> areas</c><00:02:07.479><c> that</c><00:02:07.640><c> I've</c>

00:02:07.789 --> 00:02:07.799 align:start position:0%
these or you know Peak areas that I've
 

00:02:07.799 --> 00:02:09.550 align:start position:0%
these or you know Peak areas that I've
mentioned<00:02:08.160><c> here</c><00:02:08.360><c> so</c><00:02:08.759><c> let's</c><00:02:08.959><c> say</c><00:02:09.119><c> in</c><00:02:09.319><c> this</c>

00:02:09.550 --> 00:02:09.560 align:start position:0%
mentioned here so let's say in this
 

00:02:09.560 --> 00:02:11.990 align:start position:0%
mentioned here so let's say in this
scenario<00:02:10.160><c> for</c><00:02:10.440><c> this</c><00:02:10.679><c> business</c><00:02:11.440><c> their</c><00:02:11.680><c> average</c>

00:02:11.990 --> 00:02:12.000 align:start position:0%
scenario for this business their average
 

00:02:12.000 --> 00:02:13.949 align:start position:0%
scenario for this business their average
order<00:02:12.319><c> value</c><00:02:12.560><c> on</c><00:02:12.720><c> Shopify</c><00:02:13.360><c> might</c><00:02:13.520><c> be</c><00:02:13.640><c> sitting</c>

00:02:13.949 --> 00:02:13.959 align:start position:0%
order value on Shopify might be sitting
 

00:02:13.959 --> 00:02:16.270 align:start position:0%
order value on Shopify might be sitting
at<00:02:14.120><c> around</c><00:02:14.360><c> $60</c><00:02:15.360><c> which</c><00:02:15.480><c> is</c><00:02:15.640><c> slap</c><00:02:15.920><c> bang</c><00:02:16.120><c> in</c><00:02:16.200><c> the</c>

00:02:16.270 --> 00:02:16.280 align:start position:0%
at around $60 which is slap bang in the
 

00:02:16.280 --> 00:02:19.070 align:start position:0%
at around $60 which is slap bang in the
middle<00:02:16.519><c> of</c><00:02:16.680><c> these</c><00:02:16.840><c> two</c><00:02:17.200><c> cohorts</c><00:02:18.200><c> so</c><00:02:18.599><c> let's</c><00:02:18.879><c> say</c>

00:02:19.070 --> 00:02:19.080 align:start position:0%
middle of these two cohorts so let's say
 

00:02:19.080 --> 00:02:20.710 align:start position:0%
middle of these two cohorts so let's say
for<00:02:19.280><c> example</c><00:02:19.599><c> someone</c><00:02:19.959><c> that's</c><00:02:20.319><c> that's</c>

00:02:20.710 --> 00:02:20.720 align:start position:0%
for example someone that's that's
 

00:02:20.720 --> 00:02:23.309 align:start position:0%
for example someone that's that's
spending<00:02:21.080><c> $30</c><00:02:21.760><c> on</c><00:02:21.879><c> an</c><00:02:22.000><c> order</c><00:02:22.640><c> isn't</c><00:02:22.879><c> going</c><00:02:23.000><c> to</c>

00:02:23.309 --> 00:02:23.319 align:start position:0%
spending $30 on an order isn't going to
 

00:02:23.319 --> 00:02:26.270 align:start position:0%
spending $30 on an order isn't going to
be<00:02:23.840><c> Keen</c><00:02:24.160><c> to</c><00:02:24.400><c> spend</c><00:02:24.840><c> double</c><00:02:25.319><c> to</c><00:02:25.519><c> reach</c><00:02:25.879><c> that</c>

00:02:26.270 --> 00:02:26.280 align:start position:0%
be Keen to spend double to reach that
 

00:02:26.280 --> 00:02:28.430 align:start position:0%
be Keen to spend double to reach that
free<00:02:26.519><c> shipping</c><00:02:26.879><c> threshold</c><00:02:27.879><c> and</c><00:02:28.040><c> that</c><00:02:28.200><c> free</c>

00:02:28.430 --> 00:02:28.440 align:start position:0%
free shipping threshold and that free
 

00:02:28.440 --> 00:02:31.270 align:start position:0%
free shipping threshold and that free
shipping<00:02:28.800><c> threshold</c><00:02:29.519><c> does</c><00:02:29.840><c> doesn't</c><00:02:30.720><c> add</c><00:02:31.040><c> any</c>

00:02:31.270 --> 00:02:31.280 align:start position:0%
shipping threshold does doesn't add any
 

00:02:31.280 --> 00:02:33.589 align:start position:0%
shipping threshold does doesn't add any
benefit<00:02:31.640><c> or</c><00:02:31.800><c> any</c><00:02:32.040><c> value</c><00:02:32.360><c> to</c><00:02:32.640><c> people</c>

00:02:33.589 --> 00:02:33.599 align:start position:0%
benefit or any value to people
 

00:02:33.599 --> 00:02:35.309 align:start position:0%
benefit or any value to people
purchasing<00:02:34.160><c> $100</c><00:02:34.800><c> product</c><00:02:35.120><c> because</c>

00:02:35.309 --> 00:02:35.319 align:start position:0%
purchasing $100 product because
 

00:02:35.319 --> 00:02:36.949 align:start position:0%
purchasing $100 product because
obviously<00:02:35.599><c> that's</c><00:02:35.840><c> way</c><00:02:36.080><c> over</c><00:02:36.560><c> that</c><00:02:36.680><c> free</c>

00:02:36.949 --> 00:02:36.959 align:start position:0%
obviously that's way over that free
 

00:02:36.959 --> 00:02:39.390 align:start position:0%
obviously that's way over that free
shipping<00:02:37.280><c> threshold</c><00:02:37.800><c> so</c><00:02:38.519><c> this</c><00:02:38.640><c> is</c><00:02:38.840><c> kind</c><00:02:38.959><c> of</c><00:02:39.120><c> a</c>

00:02:39.390 --> 00:02:39.400 align:start position:0%
shipping threshold so this is kind of a
 

00:02:39.400 --> 00:02:41.750 align:start position:0%
shipping threshold so this is kind of a
a<00:02:39.680><c> a</c><00:02:39.840><c> Miss</c><00:02:40.239><c> completely</c><00:02:40.760><c> in</c><00:02:40.879><c> terms</c><00:02:41.159><c> of</c><00:02:41.400><c> actual</c>

00:02:41.750 --> 00:02:41.760 align:start position:0%
a a Miss completely in terms of actual
 

00:02:41.760 --> 00:02:45.110 align:start position:0%
a a Miss completely in terms of actual
value<00:02:42.080><c> add</c><00:02:42.360><c> to</c><00:02:42.480><c> the</c><00:02:42.879><c> business</c><00:02:43.879><c> ideally</c><00:02:44.720><c> based</c>

00:02:45.110 --> 00:02:45.120 align:start position:0%
value add to the business ideally based
 

00:02:45.120 --> 00:02:48.149 align:start position:0%
value add to the business ideally based
on<00:02:45.560><c> this</c><00:02:46.560><c> um</c><00:02:46.879><c> Trend</c><00:02:47.360><c> you'd</c><00:02:47.599><c> want</c><00:02:47.760><c> to</c><00:02:47.920><c> be</c>

00:02:48.149 --> 00:02:48.159 align:start position:0%
on this um Trend you'd want to be
 

00:02:48.159 --> 00:02:50.509 align:start position:0%
on this um Trend you'd want to be
setting<00:02:48.680><c> your</c><00:02:48.879><c> free</c><00:02:49.159><c> shipping</c><00:02:49.599><c> threshold</c>

00:02:50.509 --> 00:02:50.519 align:start position:0%
setting your free shipping threshold
 

00:02:50.519 --> 00:02:54.270 align:start position:0%
setting your free shipping threshold
let's<00:02:50.720><c> say</c><00:02:50.959><c> over</c><00:02:51.280><c> there</c><00:02:51.640><c> at</c><00:02:52.159><c> $40</c><00:02:53.159><c> because</c><00:02:54.120><c> it's</c>

00:02:54.270 --> 00:02:54.280 align:start position:0%
let's say over there at $40 because it's
 

00:02:54.280 --> 00:02:56.229 align:start position:0%
let's say over there at $40 because it's
a<00:02:54.480><c> it's</c><00:02:54.599><c> a</c><00:02:54.720><c> lot</c><00:02:54.879><c> more</c><00:02:55.080><c> achievable</c><00:02:55.680><c> for</c><00:02:55.959><c> those</c>

00:02:56.229 --> 00:02:56.239 align:start position:0%
a it's a lot more achievable for those
 

00:02:56.239 --> 00:02:58.830 align:start position:0%
a it's a lot more achievable for those
people<00:02:56.560><c> to</c><00:02:57.440><c> add</c><00:02:57.720><c> you</c><00:02:57.840><c> know</c><00:02:58.040><c> one</c><00:02:58.239><c> small</c><00:02:58.599><c> product</c>

00:02:58.830 --> 00:02:58.840 align:start position:0%
people to add you know one small product
 

00:02:58.840 --> 00:03:01.190 align:start position:0%
people to add you know one small product
to<00:02:58.959><c> bump</c><00:02:59.200><c> their</c><00:02:59.280><c> order</c><00:02:59.519><c> up</c><00:02:59.920><c> $10</c><00:03:00.560><c> or</c><00:03:00.680><c> so</c><00:03:00.879><c> to</c><00:03:01.040><c> get</c>

00:03:01.190 --> 00:03:01.200 align:start position:0%
to bump their order up $10 or so to get
 

00:03:01.200 --> 00:03:03.350 align:start position:0%
to bump their order up $10 or so to get
free<00:03:01.400><c> shipping</c><00:03:01.720><c> over</c><00:03:02.040><c> $40</c><00:03:03.040><c> and</c><00:03:03.159><c> then</c><00:03:03.280><c> you</c>

00:03:03.350 --> 00:03:03.360 align:start position:0%
free shipping over $40 and then you
 

00:03:03.360 --> 00:03:05.390 align:start position:0%
free shipping over $40 and then you
could<00:03:03.560><c> add</c><00:03:03.799><c> some</c><00:03:03.959><c> sort</c><00:03:04.159><c> of</c><00:03:04.360><c> second</c><00:03:04.760><c> discount</c>

00:03:05.390 --> 00:03:05.400 align:start position:0%
could add some sort of second discount
 

00:03:05.400 --> 00:03:07.589 align:start position:0%
could add some sort of second discount
at<00:03:05.640><c> let's</c><00:03:05.879><c> say</c>

00:03:07.589 --> 00:03:07.599 align:start position:0%
at let's say
 

00:03:07.599 --> 00:03:11.149 align:start position:0%
at let's say
$120<00:03:08.599><c> and</c><00:03:08.720><c> then</c><00:03:08.879><c> it'll</c><00:03:09.480><c> encourage</c><00:03:10.480><c> these</c><00:03:10.920><c> or</c>

00:03:11.149 --> 00:03:11.159 align:start position:0%
$120 and then it'll encourage these or
 

00:03:11.159 --> 00:03:12.949 align:start position:0%
$120 and then it'll encourage these or
this<00:03:11.400><c> cohort</c><00:03:11.840><c> that's</c><00:03:11.959><c> sitting</c><00:03:12.440><c> at</c><00:03:12.560><c> an</c><00:03:12.720><c> average</c>

00:03:12.949 --> 00:03:12.959 align:start position:0%
this cohort that's sitting at an average
 

00:03:12.959 --> 00:03:16.630 align:start position:0%
this cohort that's sitting at an average
of<00:03:13.040><c> $100</c><00:03:13.720><c> to</c><00:03:13.879><c> spend</c><00:03:14.239><c> that</c><00:03:14.440><c> extra</c><00:03:14.640><c> $20</c><00:03:15.239><c> or</c><00:03:15.400><c> so</c><00:03:15.640><c> so</c>

00:03:16.630 --> 00:03:16.640 align:start position:0%
of $100 to spend that extra $20 or so so
 

00:03:16.640 --> 00:03:18.710 align:start position:0%
of $100 to spend that extra $20 or so so
this<00:03:16.760><c> is</c><00:03:16.959><c> the</c><00:03:17.159><c> reason</c><00:03:17.720><c> why</c><00:03:17.959><c> we</c><00:03:18.080><c> want</c><00:03:18.239><c> to</c><00:03:18.400><c> break</c>

00:03:18.710 --> 00:03:18.720 align:start position:0%
this is the reason why we want to break
 

00:03:18.720 --> 00:03:20.550 align:start position:0%
this is the reason why we want to break
down<00:03:18.959><c> this</c><00:03:19.120><c> data</c><00:03:19.640><c> so</c><00:03:19.760><c> that</c><00:03:19.879><c> we</c><00:03:19.959><c> can</c><00:03:20.120><c> accurately</c>

00:03:20.550 --> 00:03:20.560 align:start position:0%
down this data so that we can accurately
 

00:03:20.560 --> 00:03:23.869 align:start position:0%
down this data so that we can accurately
see<00:03:20.959><c> where</c><00:03:21.319><c> these</c><00:03:21.799><c> Peaks</c><00:03:22.200><c> are</c><00:03:23.120><c> and</c><00:03:23.319><c> structure</c>

00:03:23.869 --> 00:03:23.879 align:start position:0%
see where these Peaks are and structure
 

00:03:23.879 --> 00:03:27.309 align:start position:0%
see where these Peaks are and structure
our<00:03:24.200><c> discount</c><00:03:24.760><c> structure</c><00:03:25.799><c> accordingly</c><00:03:26.799><c> so</c><00:03:27.040><c> to</c>

00:03:27.309 --> 00:03:27.319 align:start position:0%
our discount structure accordingly so to
 

00:03:27.319 --> 00:03:29.070 align:start position:0%
our discount structure accordingly so to
go<00:03:27.519><c> about</c><00:03:27.840><c> this</c><00:03:28.120><c> process</c><00:03:28.560><c> I'll</c><00:03:28.720><c> just</c><00:03:28.879><c> run</c>

00:03:29.070 --> 00:03:29.080 align:start position:0%
go about this process I'll just run
 

00:03:29.080 --> 00:03:30.429 align:start position:0%
go about this process I'll just run
through<00:03:29.280><c> this</c><00:03:29.439><c> quick</c>

00:03:30.429 --> 00:03:30.439 align:start position:0%
through this quick
 

00:03:30.439 --> 00:03:31.710 align:start position:0%
through this quick
first<00:03:30.640><c> thing</c><00:03:30.760><c> you'll</c><00:03:30.920><c> need</c><00:03:31.040><c> to</c><00:03:31.159><c> do</c><00:03:31.280><c> is</c><00:03:31.400><c> go</c><00:03:31.560><c> over</c>

00:03:31.710 --> 00:03:31.720 align:start position:0%
first thing you'll need to do is go over
 

00:03:31.720 --> 00:03:33.270 align:start position:0%
first thing you'll need to do is go over
to<00:03:31.959><c> Shopify</c><00:03:32.560><c> I've</c><00:03:32.680><c> just</c><00:03:32.799><c> got</c><00:03:32.879><c> a</c><00:03:33.000><c> couple</c>

00:03:33.270 --> 00:03:33.280 align:start position:0%
to Shopify I've just got a couple
 

00:03:33.280 --> 00:03:35.670 align:start position:0%
to Shopify I've just got a couple
screenshots<00:03:33.879><c> here</c><00:03:34.080><c> go</c><00:03:34.239><c> to</c><00:03:34.480><c> the</c><00:03:34.680><c> orders</c><00:03:35.239><c> Tab</c>

00:03:35.670 --> 00:03:35.680 align:start position:0%
screenshots here go to the orders Tab
 

00:03:35.680 --> 00:03:37.429 align:start position:0%
screenshots here go to the orders Tab
and<00:03:35.840><c> then</c><00:03:36.080><c> at</c><00:03:36.200><c> the</c><00:03:36.360><c> top</c><00:03:36.599><c> here</c><00:03:36.920><c> just</c><00:03:37.120><c> click</c>

00:03:37.429 --> 00:03:37.439 align:start position:0%
and then at the top here just click
 

00:03:37.439 --> 00:03:41.270 align:start position:0%
and then at the top here just click
export<00:03:38.400><c> and</c><00:03:38.599><c> Export</c><00:03:39.120><c> all</c><00:03:39.319><c> the</c><00:03:39.840><c> orders</c><00:03:40.840><c> from</c>

00:03:41.270 --> 00:03:41.280 align:start position:0%
export and Export all the orders from
 

00:03:41.280 --> 00:03:43.910 align:start position:0%
export and Export all the orders from
your<00:03:41.519><c> Shopify</c><00:03:42.080><c> store</c><00:03:42.799><c> that'll</c><00:03:43.120><c> then</c><00:03:43.360><c> give</c><00:03:43.519><c> you</c>

00:03:43.910 --> 00:03:43.920 align:start position:0%
your Shopify store that'll then give you
 

00:03:43.920 --> 00:03:47.350 align:start position:0%
your Shopify store that'll then give you
a<00:03:44.280><c> CSV</c><00:03:44.920><c> file</c><00:03:45.920><c> which</c><00:03:46.280><c> you</c><00:03:46.400><c> can</c><00:03:46.680><c> then</c><00:03:46.879><c> drag</c><00:03:47.159><c> and</c>

00:03:47.350 --> 00:03:47.360 align:start position:0%
a CSV file which you can then drag and
 

00:03:47.360 --> 00:03:50.390 align:start position:0%
a CSV file which you can then drag and
drop<00:03:47.720><c> into</c><00:03:48.159><c> Google</c><00:03:48.480><c> Drive</c><00:03:49.360><c> once</c><00:03:49.640><c> that</c><00:03:49.760><c> is</c>

00:03:50.390 --> 00:03:50.400 align:start position:0%
drop into Google Drive once that is
 

00:03:50.400 --> 00:03:52.990 align:start position:0%
drop into Google Drive once that is
uploaded<00:03:51.400><c> so</c><00:03:51.760><c> once</c><00:03:52.000><c> that</c><00:03:52.159><c> CSV</c><00:03:52.640><c> file</c><00:03:52.840><c> is</c>

00:03:52.990 --> 00:03:53.000 align:start position:0%
uploaded so once that CSV file is
 

00:03:53.000 --> 00:03:54.630 align:start position:0%
uploaded so once that CSV file is
uploaded<00:03:53.480><c> just</c><00:03:53.799><c> right</c><00:03:54.040><c> click</c><00:03:54.200><c> on</c><00:03:54.360><c> that</c><00:03:54.480><c> and</c>

00:03:54.630 --> 00:03:54.640 align:start position:0%
uploaded just right click on that and
 

00:03:54.640 --> 00:03:57.229 align:start position:0%
uploaded just right click on that and
open<00:03:54.959><c> that</c><00:03:55.239><c> as</c><00:03:55.400><c> a</c><00:03:55.560><c> Google</c><00:03:55.879><c> sheet</c><00:03:56.879><c> once</c><00:03:57.120><c> that</c>

00:03:57.229 --> 00:03:57.239 align:start position:0%
open that as a Google sheet once that
 

00:03:57.239 --> 00:03:59.270 align:start position:0%
open that as a Google sheet once that
has<00:03:57.400><c> been</c><00:03:57.640><c> converted</c><00:03:58.200><c> into</c><00:03:58.439><c> a</c><00:03:58.599><c> Google</c><00:03:58.840><c> sheet</c>

00:03:59.270 --> 00:03:59.280 align:start position:0%
has been converted into a Google sheet
 

00:03:59.280 --> 00:04:01.670 align:start position:0%
has been converted into a Google sheet
then<00:03:59.760><c> the</c><00:03:59.879><c> only</c><00:04:00.239><c> column</c><00:04:00.599><c> we</c><00:04:00.799><c> looking</c><00:04:01.120><c> for</c><00:04:01.439><c> is</c>

00:04:01.670 --> 00:04:01.680 align:start position:0%
then the only column we looking for is
 

00:04:01.680 --> 00:04:03.990 align:start position:0%
then the only column we looking for is
total<00:04:02.040><c> average</c><00:04:02.280><c> order</c><00:04:02.599><c> value</c><00:04:03.480><c> or</c><00:04:03.720><c> you</c><00:04:03.840><c> could</c>

00:04:03.990 --> 00:04:04.000 align:start position:0%
total average order value or you could
 

00:04:04.000 --> 00:04:06.830 align:start position:0%
total average order value or you could
do<00:04:04.159><c> it</c><00:04:04.360><c> on</c><00:04:04.799><c> subtotal</c><00:04:05.400><c> average</c><00:04:05.680><c> order</c><00:04:05.959><c> value</c>

00:04:06.830 --> 00:04:06.840 align:start position:0%
do it on subtotal average order value
 

00:04:06.840 --> 00:04:09.149 align:start position:0%
do it on subtotal average order value
depending<00:04:07.360><c> on</c><00:04:07.799><c> obviously</c><00:04:08.239><c> how</c><00:04:08.480><c> your</c><00:04:08.720><c> discount</c>

00:04:09.149 --> 00:04:09.159 align:start position:0%
depending on obviously how your discount
 

00:04:09.159 --> 00:04:12.030 align:start position:0%
depending on obviously how your discount
is<00:04:09.319><c> structured</c><00:04:10.000><c> on</c><00:04:10.799><c> or</c><00:04:11.159><c> or</c><00:04:11.360><c> sorry</c><00:04:11.720><c> how</c><00:04:11.879><c> you</c>

00:04:12.030 --> 00:04:12.040 align:start position:0%
is structured on or or sorry how you
 

00:04:12.040 --> 00:04:13.589 align:start position:0%
is structured on or or sorry how you
plan<00:04:12.319><c> to</c><00:04:12.480><c> structure</c><00:04:12.879><c> your</c><00:04:13.040><c> discount</c><00:04:13.400><c> on</c><00:04:13.480><c> the</c>

00:04:13.589 --> 00:04:13.599 align:start position:0%
plan to structure your discount on the
 

00:04:13.599 --> 00:04:15.869 align:start position:0%
plan to structure your discount on the
back<00:04:13.760><c> end</c><00:04:14.040><c> but</c><00:04:14.519><c> just</c><00:04:14.720><c> for</c><00:04:15.239><c> the</c><00:04:15.360><c> sake</c><00:04:15.560><c> of</c><00:04:15.720><c> this</c>

00:04:15.869 --> 00:04:15.879 align:start position:0%
back end but just for the sake of this
 

00:04:15.879 --> 00:04:18.710 align:start position:0%
back end but just for the sake of this
video<00:04:16.199><c> Let's</c><00:04:16.519><c> just</c><00:04:17.000><c> assume</c><00:04:17.400><c> that</c><00:04:17.519><c> we're</c><00:04:17.720><c> using</c>

00:04:18.710 --> 00:04:18.720 align:start position:0%
video Let's just assume that we're using
 

00:04:18.720 --> 00:04:20.349 align:start position:0%
video Let's just assume that we're using
total<00:04:19.040><c> average</c><00:04:19.320><c> order</c><00:04:19.600><c> value</c><00:04:19.880><c> so</c><00:04:20.040><c> this</c><00:04:20.160><c> is</c><00:04:20.280><c> the</c>

00:04:20.349 --> 00:04:20.359 align:start position:0%
total average order value so this is the
 

00:04:20.359 --> 00:04:24.469 align:start position:0%
total average order value so this is the
only<00:04:20.600><c> column</c><00:04:21.160><c> we</c><00:04:21.360><c> need</c><00:04:22.360><c> so</c><00:04:22.800><c> just</c><00:04:23.120><c> cut</c><00:04:23.759><c> or</c><00:04:24.080><c> copy</c>

00:04:24.469 --> 00:04:24.479 align:start position:0%
only column we need so just cut or copy
 

00:04:24.479 --> 00:04:26.710 align:start position:0%
only column we need so just cut or copy
that<00:04:24.880><c> and</c><00:04:25.000><c> we</c><00:04:25.120><c> can</c><00:04:25.280><c> just</c><00:04:25.400><c> move</c><00:04:25.680><c> that</c><00:04:25.800><c> to</c><00:04:25.960><c> a</c><00:04:26.080><c> new</c>

00:04:26.710 --> 00:04:26.720 align:start position:0%
that and we can just move that to a new
 

00:04:26.720 --> 00:04:28.950 align:start position:0%
that and we can just move that to a new
sheet<00:04:27.720><c> okay</c><00:04:27.960><c> once</c><00:04:28.280><c> that's</c><00:04:28.520><c> done</c><00:04:28.720><c> we'll</c><00:04:28.880><c> just</c>

00:04:28.950 --> 00:04:28.960 align:start position:0%
sheet okay once that's done we'll just
 

00:04:28.960 --> 00:04:30.749 align:start position:0%
sheet okay once that's done we'll just
need<00:04:29.080><c> to</c><00:04:29.160><c> do</c><00:04:29.280><c> a</c><00:04:29.320><c> little</c><00:04:29.440><c> bit</c><00:04:29.720><c> of</c><00:04:29.840><c> data</c><00:04:30.120><c> hygiene</c>

00:04:30.749 --> 00:04:30.759 align:start position:0%
need to do a little bit of data hygiene
 

00:04:30.759 --> 00:04:33.469 align:start position:0%
need to do a little bit of data hygiene
so<00:04:31.280><c> you</c><00:04:31.360><c> can</c><00:04:31.560><c> just</c><00:04:31.720><c> select</c><00:04:32.039><c> that</c><00:04:32.280><c> column</c><00:04:33.199><c> go</c><00:04:33.360><c> up</c>

00:04:33.469 --> 00:04:33.479 align:start position:0%
so you can just select that column go up
 

00:04:33.479 --> 00:04:36.670 align:start position:0%
so you can just select that column go up
to<00:04:33.600><c> the</c><00:04:33.759><c> top</c><00:04:33.960><c> over</c><00:04:34.160><c> here</c><00:04:34.440><c> data</c><00:04:35.440><c> and</c><00:04:35.639><c> then</c><00:04:36.240><c> sort</c>

00:04:36.670 --> 00:04:36.680 align:start position:0%
to the top over here data and then sort
 

00:04:36.680 --> 00:04:40.310 align:start position:0%
to the top over here data and then sort
sheet<00:04:37.160><c> Za</c><00:04:37.440><c> to</c><00:04:37.680><c> a</c><00:04:38.680><c> and</c><00:04:38.840><c> then</c><00:04:39.039><c> scroll</c><00:04:39.759><c> scroll</c><00:04:40.199><c> all</c>

00:04:40.310 --> 00:04:40.320 align:start position:0%
sheet Za to a and then scroll scroll all
 

00:04:40.320 --> 00:04:42.749 align:start position:0%
sheet Za to a and then scroll scroll all
the<00:04:40.440><c> way</c><00:04:40.720><c> down</c>

00:04:42.749 --> 00:04:42.759 align:start position:0%
the way down
 

00:04:42.759 --> 00:04:45.430 align:start position:0%
the way down
to<00:04:43.759><c> yeah</c><00:04:44.080><c> okay</c><00:04:44.199><c> so</c><00:04:44.440><c> scroll</c><00:04:44.840><c> all</c><00:04:44.960><c> the</c><00:04:45.080><c> way</c><00:04:45.240><c> down</c>

00:04:45.430 --> 00:04:45.440 align:start position:0%
to yeah okay so scroll all the way down
 

00:04:45.440 --> 00:04:48.590 align:start position:0%
to yeah okay so scroll all the way down
to<00:04:45.840><c> the</c><00:04:46.000><c> bottom</c><00:04:46.520><c> of</c><00:04:46.759><c> this</c>

00:04:48.590 --> 00:04:48.600 align:start position:0%
to the bottom of this
 

00:04:48.600 --> 00:04:50.830 align:start position:0%
to the bottom of this
St<00:04:49.600><c> sometimes</c><00:04:49.800><c> it</c><00:04:49.919><c> might</c><00:04:50.080><c> take</c><00:04:50.240><c> you</c><00:04:50.400><c> quite</c><00:04:50.560><c> a</c>

00:04:50.830 --> 00:04:50.840 align:start position:0%
St sometimes it might take you quite a
 

00:04:50.840 --> 00:04:53.150 align:start position:0%
St sometimes it might take you quite a
while<00:04:51.840><c> so</c><00:04:52.160><c> once</c><00:04:52.320><c> you've</c><00:04:52.479><c> reached</c><00:04:52.720><c> the</c><00:04:52.840><c> bottom</c>

00:04:53.150 --> 00:04:53.160 align:start position:0%
while so once you've reached the bottom
 

00:04:53.160 --> 00:04:57.070 align:start position:0%
while so once you've reached the bottom
just<00:04:53.360><c> make</c><00:04:53.600><c> a</c><00:04:53.800><c> mental</c><00:04:54.199><c> note</c><00:04:54.800><c> of</c><00:04:55.800><c> the</c><00:04:56.360><c> range</c>

00:04:57.070 --> 00:04:57.080 align:start position:0%
just make a mental note of the range
 

00:04:57.080 --> 00:04:59.790 align:start position:0%
just make a mental note of the range
that<00:04:57.240><c> we'll</c><00:04:57.440><c> be</c><00:04:57.639><c> using</c><00:04:58.320><c> in</c><00:04:59.000><c> the</c><00:04:59.199><c> code</c><00:04:59.680><c> that</c>

00:04:59.790 --> 00:04:59.800 align:start position:0%
that we'll be using in the code that
 

00:04:59.800 --> 00:05:03.029 align:start position:0%
that we'll be using in the code that
we'll<00:05:00.120><c> use</c><00:05:01.120><c> so</c><00:05:01.360><c> in</c><00:05:01.560><c> this</c><00:05:01.720><c> case</c><00:05:02.039><c> this</c><00:05:02.160><c> is</c>

00:05:03.029 --> 00:05:03.039 align:start position:0%
we'll use so in this case this is
 

00:05:03.039 --> 00:05:05.950 align:start position:0%
we'll use so in this case this is
10865<00:05:04.039><c> reading</c><00:05:04.600><c> from</c><00:05:04.880><c> the</c><00:05:05.080><c> top</c><00:05:05.320><c> cell</c><00:05:05.840><c> which</c>

00:05:05.950 --> 00:05:05.960 align:start position:0%
10865 reading from the top cell which
 

00:05:05.960 --> 00:05:09.390 align:start position:0%
10865 reading from the top cell which
would<00:05:06.120><c> be</c><00:05:06.320><c> A2</c><00:05:06.880><c> so</c><00:05:07.080><c> A2</c><00:05:07.720><c> to</c><00:05:08.199><c> a</c>

00:05:09.390 --> 00:05:09.400 align:start position:0%
would be A2 so A2 to a
 

00:05:09.400 --> 00:05:11.310 align:start position:0%
would be A2 so A2 to a
1065<00:05:10.400><c> sorry</c>

00:05:11.310 --> 00:05:11.320 align:start position:0%
1065 sorry
 

00:05:11.320 --> 00:05:13.550 align:start position:0%
1065 sorry
10865<00:05:12.320><c> so</c><00:05:12.560><c> once</c><00:05:12.720><c> we've</c><00:05:12.919><c> done</c><00:05:13.080><c> that</c><00:05:13.240><c> we'll</c><00:05:13.400><c> need</c>

00:05:13.550 --> 00:05:13.560 align:start position:0%
10865 so once we've done that we'll need
 

00:05:13.560 --> 00:05:16.070 align:start position:0%
10865 so once we've done that we'll need
to<00:05:13.800><c> use</c><00:05:14.240><c> a</c><00:05:14.440><c> snippet</c><00:05:14.919><c> of</c><00:05:15.080><c> code</c><00:05:15.360><c> just</c><00:05:15.600><c> to</c><00:05:15.800><c> break</c>

00:05:16.070 --> 00:05:16.080 align:start position:0%
to use a snippet of code just to break
 

00:05:16.080 --> 00:05:18.590 align:start position:0%
to use a snippet of code just to break
this<00:05:16.280><c> data</c><00:05:16.639><c> down</c><00:05:16.919><c> for</c><00:05:17.160><c> us</c><00:05:17.840><c> so</c><00:05:18.000><c> we've</c><00:05:18.199><c> written</c><00:05:18.479><c> a</c>

00:05:18.590 --> 00:05:18.600 align:start position:0%
this data down for us so we've written a
 

00:05:18.600 --> 00:05:20.749 align:start position:0%
this data down for us so we've written a
piece<00:05:18.759><c> of</c><00:05:18.919><c> code</c><00:05:19.160><c> for</c><00:05:19.400><c> you</c><00:05:19.639><c> we'll</c><00:05:20.199><c> sorry</c><00:05:20.520><c> we'll</c>

00:05:20.749 --> 00:05:20.759 align:start position:0%
piece of code for you we'll sorry we'll
 

00:05:20.759 --> 00:05:23.749 align:start position:0%
piece of code for you we'll sorry we'll
link<00:05:21.080><c> this</c><00:05:21.400><c> in</c><00:05:21.800><c> the</c><00:05:22.000><c> video</c><00:05:22.520><c> description</c><00:05:23.520><c> but</c>

00:05:23.749 --> 00:05:23.759 align:start position:0%
link this in the video description but
 

00:05:23.759 --> 00:05:25.670 align:start position:0%
link this in the video description but
that<00:05:23.880><c> should</c><00:05:24.160><c> look</c><00:05:24.440><c> something</c><00:05:24.840><c> like</c><00:05:25.080><c> this</c><00:05:25.400><c> so</c>

00:05:25.670 --> 00:05:25.680 align:start position:0%
that should look something like this so
 

00:05:25.680 --> 00:05:28.309 align:start position:0%
that should look something like this so
just<00:05:25.919><c> copy</c><00:05:26.240><c> that</c><00:05:26.680><c> code</c><00:05:27.680><c> and</c><00:05:27.880><c> head</c><00:05:28.039><c> back</c><00:05:28.199><c> on</c>

00:05:28.309 --> 00:05:28.319 align:start position:0%
just copy that code and head back on
 

00:05:28.319 --> 00:05:30.110 align:start position:0%
just copy that code and head back on
over<00:05:28.479><c> to</c><00:05:28.600><c> the</c><00:05:28.720><c> Google</c><00:05:28.960><c> sheet</c><00:05:29.319><c> and</c><00:05:29.560><c> and</c><00:05:29.639><c> then</c><00:05:29.880><c> up</c>

00:05:30.110 --> 00:05:30.120 align:start position:0%
over to the Google sheet and and then up
 

00:05:30.120 --> 00:05:32.469 align:start position:0%
over to the Google sheet and and then up
at<00:05:30.240><c> the</c><00:05:30.440><c> top</c><00:05:30.680><c> over</c><00:05:30.880><c> here</c><00:05:31.080><c> under</c><00:05:31.440><c> extensions</c><00:05:32.319><c> go</c>

00:05:32.469 --> 00:05:32.479 align:start position:0%
at the top over here under extensions go
 

00:05:32.479 --> 00:05:36.070 align:start position:0%
at the top over here under extensions go
to<00:05:32.840><c> app</c><00:05:33.360><c> script</c><00:05:34.360><c> then</c><00:05:34.639><c> from</c><00:05:34.960><c> here</c><00:05:35.319><c> just</c><00:05:35.560><c> delete</c>

00:05:36.070 --> 00:05:36.080 align:start position:0%
to app script then from here just delete
 

00:05:36.080 --> 00:05:38.590 align:start position:0%
to app script then from here just delete
everything<00:05:36.560><c> that</c><00:05:36.720><c> is</c><00:05:37.240><c> that</c><00:05:37.360><c> is</c><00:05:37.960><c> currently</c><00:05:38.440><c> in</c>

00:05:38.590 --> 00:05:38.600 align:start position:0%
everything that is that is currently in
 

00:05:38.600 --> 00:05:40.550 align:start position:0%
everything that is that is currently in
this<00:05:38.840><c> section</c><00:05:39.400><c> and</c><00:05:39.520><c> then</c><00:05:39.759><c> paste</c><00:05:40.039><c> your</c><00:05:40.360><c> your</c>

00:05:40.550 --> 00:05:40.560 align:start position:0%
this section and then paste your your
 

00:05:40.560 --> 00:05:43.430 align:start position:0%
this section and then paste your your
script<00:05:40.880><c> in</c><00:05:41.120><c> there</c><00:05:41.960><c> now</c><00:05:42.440><c> depending</c><00:05:42.919><c> on</c><00:05:43.199><c> what</c>

00:05:43.430 --> 00:05:43.440 align:start position:0%
script in there now depending on what
 

00:05:43.440 --> 00:05:46.710 align:start position:0%
script in there now depending on what
increments<00:05:44.000><c> you're</c><00:05:44.160><c> wanting</c><00:05:44.560><c> to</c><00:05:45.080><c> class</c><00:05:45.800><c> your</c>

00:05:46.710 --> 00:05:46.720 align:start position:0%
increments you're wanting to class your
 

00:05:46.720 --> 00:05:49.150 align:start position:0%
increments you're wanting to class your
your<00:05:47.319><c> orders</c><00:05:47.840><c> into</c><00:05:48.280><c> you</c><00:05:48.360><c> can</c><00:05:48.520><c> just</c><00:05:48.720><c> adjust</c>

00:05:49.150 --> 00:05:49.160 align:start position:0%
your orders into you can just adjust
 

00:05:49.160 --> 00:05:51.350 align:start position:0%
your orders into you can just adjust
that<00:05:49.360><c> over</c><00:05:49.600><c> here</c><00:05:49.759><c> so</c><00:05:49.960><c> just</c><00:05:50.080><c> follow</c><00:05:50.440><c> the</c><00:05:50.639><c> same</c>

00:05:51.350 --> 00:05:51.360 align:start position:0%
that over here so just follow the same
 

00:05:51.360 --> 00:05:54.189 align:start position:0%
that over here so just follow the same
you<00:05:51.479><c> know</c><00:05:51.639><c> nomenclature</c><00:05:52.639><c> here</c><00:05:53.639><c> and</c><00:05:53.800><c> obviously</c>

00:05:54.189 --> 00:05:54.199 align:start position:0%
you know nomenclature here and obviously
 

00:05:54.199 --> 00:05:56.110 align:start position:0%
you know nomenclature here and obviously
Just<00:05:54.400><c> Adjust</c><00:05:54.800><c> that</c><00:05:55.039><c> as</c><00:05:55.120><c> you</c><00:05:55.240><c> see</c><00:05:55.479><c> fit</c><00:05:55.800><c> so</c><00:05:55.960><c> let's</c>

00:05:56.110 --> 00:05:56.120 align:start position:0%
Just Adjust that as you see fit so let's
 

00:05:56.120 --> 00:05:57.870 align:start position:0%
Just Adjust that as you see fit so let's
say<00:05:56.240><c> we</c><00:05:56.360><c> were</c><00:05:56.520><c> only</c><00:05:56.759><c> looking</c><00:05:57.000><c> to</c><00:05:57.199><c> go</c><00:05:57.400><c> up</c><00:05:57.680><c> or</c><00:05:57.800><c> we</c>

00:05:57.870 --> 00:05:57.880 align:start position:0%
say we were only looking to go up or we
 

00:05:57.880 --> 00:05:59.469 align:start position:0%
say we were only looking to go up or we
wanted<00:05:58.080><c> to</c><00:05:58.240><c> add</c><00:05:58.440><c> another</c><00:05:58.720><c> increment</c><00:05:59.080><c> or</c><00:05:59.199><c> four</c>

00:05:59.469 --> 00:05:59.479 align:start position:0%
wanted to add another increment or four
 

00:05:59.479 --> 00:06:03.270 align:start position:0%
wanted to add another increment or four
400<00:05:59.880><c> to</c><00:06:00.120><c> 420</c><00:06:00.680><c> so</c><00:06:00.840><c> just</c><00:06:01.000><c> go</c><00:06:01.280><c> column</c><00:06:02.280><c> uh</c>

00:06:03.270 --> 00:06:03.280 align:start position:0%
400 to 420 so just go column uh
 

00:06:03.280 --> 00:06:05.469 align:start position:0%
400 to 420 so just go column uh
420<00:06:04.280><c> and</c><00:06:04.440><c> so</c><00:06:04.600><c> on</c><00:06:04.720><c> and</c><00:06:04.880><c> so</c><00:06:05.039><c> forth</c><00:06:05.240><c> you</c><00:06:05.319><c> can</c>

00:06:05.469 --> 00:06:05.479 align:start position:0%
420 and so on and so forth you can
 

00:06:05.479 --> 00:06:06.909 align:start position:0%
420 and so on and so forth you can
obviously<00:06:05.800><c> just</c><00:06:05.919><c> break</c><00:06:06.160><c> that</c><00:06:06.319><c> down</c><00:06:06.599><c> as</c><00:06:06.680><c> you</c>

00:06:06.909 --> 00:06:06.919 align:start position:0%
obviously just break that down as you
 

00:06:06.919 --> 00:06:08.870 align:start position:0%
obviously just break that down as you
like<00:06:07.880><c> um</c><00:06:08.120><c> then</c><00:06:08.240><c> the</c><00:06:08.400><c> second</c><00:06:08.639><c> thing</c><00:06:08.759><c> we're</c>

00:06:08.870 --> 00:06:08.880 align:start position:0%
like um then the second thing we're
 

00:06:08.880 --> 00:06:11.589 align:start position:0%
like um then the second thing we're
going<00:06:08.960><c> to</c><00:06:09.039><c> need</c><00:06:09.160><c> to</c><00:06:09.360><c> add</c><00:06:09.880><c> is</c><00:06:10.440><c> the</c><00:06:10.880><c> range</c><00:06:11.479><c> that</c>

00:06:11.589 --> 00:06:11.599 align:start position:0%
going to need to add is the range that
 

00:06:11.599 --> 00:06:13.469 align:start position:0%
going to need to add is the range that
we'll<00:06:11.759><c> be</c><00:06:11.960><c> operating</c><00:06:12.400><c> in</c><00:06:12.880><c> which</c><00:06:13.000><c> is</c><00:06:13.280><c> this</c>

00:06:13.469 --> 00:06:13.479 align:start position:0%
we'll be operating in which is this
 

00:06:13.479 --> 00:06:15.870 align:start position:0%
we'll be operating in which is this
section<00:06:13.800><c> up</c><00:06:14.000><c> over</c><00:06:14.240><c> here</c><00:06:14.960><c> as</c><00:06:15.120><c> I've</c><00:06:15.280><c> mentioned</c>

00:06:15.870 --> 00:06:15.880 align:start position:0%
section up over here as I've mentioned
 

00:06:15.880 --> 00:06:18.990 align:start position:0%
section up over here as I've mentioned
in<00:06:16.560><c> this</c><00:06:17.360><c> specific</c><00:06:18.360><c> document</c><00:06:18.759><c> that</c><00:06:18.840><c> we're</c>

00:06:18.990 --> 00:06:19.000 align:start position:0%
in this specific document that we're
 

00:06:19.000 --> 00:06:23.230 align:start position:0%
in this specific document that we're
using<00:06:19.319><c> here</c><00:06:19.520><c> we</c><00:06:19.720><c> going</c><00:06:20.080><c> from</c><00:06:20.400><c> A2</c><00:06:21.120><c> to</c><00:06:21.440><c> a</c><00:06:22.440><c> uh</c>

00:06:23.230 --> 00:06:23.240 align:start position:0%
using here we going from A2 to a uh
 

00:06:23.240 --> 00:06:28.270 align:start position:0%
using here we going from A2 to a uh
A1<00:06:24.440><c> 865</c><00:06:25.440><c> so</c><00:06:26.240><c> both</c><00:06:26.599><c> those</c><00:06:26.880><c> pieces</c><00:06:27.160><c> of</c><00:06:27.400><c> info</c><00:06:28.080><c> the</c>

00:06:28.270 --> 00:06:28.280 align:start position:0%
A1 865 so both those pieces of info the
 

00:06:28.280 --> 00:06:29.950 align:start position:0%
A1 865 so both those pieces of info the
range<00:06:28.720><c> as</c><00:06:28.840><c> well</c><00:06:29.000><c> as</c><00:06:29.120><c> the</c><00:06:29.440><c> increments</c><00:06:29.840><c> have</c>

00:06:29.950 --> 00:06:29.960 align:start position:0%
range as well as the increments have
 

00:06:29.960 --> 00:06:33.270 align:start position:0%
range as well as the increments have
been<00:06:30.160><c> put</c><00:06:30.319><c> in</c><00:06:31.319><c> um</c><00:06:32.120><c> from</c><00:06:32.479><c> there</c><00:06:32.720><c> you</c><00:06:32.840><c> can</c><00:06:33.039><c> just</c>

00:06:33.270 --> 00:06:33.280 align:start position:0%
been put in um from there you can just
 

00:06:33.280 --> 00:06:35.070 align:start position:0%
been put in um from there you can just
hit

00:06:35.070 --> 00:06:35.080 align:start position:0%
hit
 

00:06:35.080 --> 00:06:37.589 align:start position:0%
hit
save<00:06:36.080><c> give</c><00:06:36.199><c> it</c><00:06:36.319><c> a</c><00:06:36.520><c> name</c><00:06:36.880><c> or</c><00:06:37.080><c> the</c><00:06:37.319><c> give</c><00:06:37.520><c> the</c>

00:06:37.589 --> 00:06:37.599 align:start position:0%
save give it a name or the give the
 

00:06:37.599 --> 00:06:40.990 align:start position:0%
save give it a name or the give the
script<00:06:37.800><c> a</c><00:06:37.960><c> name</c><00:06:38.160><c> if</c><00:06:38.240><c> you'd</c><00:06:38.479><c> like</c><00:06:38.800><c> and</c><00:06:38.919><c> then</c><00:06:39.160><c> hit</c>

00:06:40.990 --> 00:06:41.000 align:start position:0%
script a name if you'd like and then hit
 

00:06:41.000 --> 00:06:43.749 align:start position:0%
script a name if you'd like and then hit
run<00:06:42.000><c> the</c><00:06:42.240><c> script</c><00:06:42.560><c> should</c><00:06:42.800><c> then</c><00:06:43.080><c> ask</c><00:06:43.319><c> you</c><00:06:43.479><c> for</c>

00:06:43.749 --> 00:06:43.759 align:start position:0%
run the script should then ask you for
 

00:06:43.759 --> 00:06:45.950 align:start position:0%
run the script should then ask you for
authorization<00:06:44.680><c> so</c><00:06:44.919><c> just</c><00:06:45.039><c> go</c><00:06:45.280><c> review</c>

00:06:45.950 --> 00:06:45.960 align:start position:0%
authorization so just go review
 

00:06:45.960 --> 00:06:48.150 align:start position:0%
authorization so just go review
permissions<00:06:46.960><c> and</c><00:06:47.120><c> it'll</c><00:06:47.360><c> ask</c><00:06:47.520><c> you</c><00:06:47.639><c> to</c><00:06:47.759><c> sign</c><00:06:47.960><c> in</c>

00:06:48.150 --> 00:06:48.160 align:start position:0%
permissions and it'll ask you to sign in
 

00:06:48.160 --> 00:06:55.589 align:start position:0%
permissions and it'll ask you to sign in
with<00:06:48.280><c> your</c><00:06:48.440><c> Google</c><00:06:48.919><c> account</c><00:06:49.919><c> and</c><00:06:50.120><c> then</c><00:06:50.360><c> click</c>

00:06:55.589 --> 00:06:55.599 align:start position:0%
 
 

00:06:55.599 --> 00:06:57.790 align:start position:0%
 
allow<00:06:56.599><c> and</c><00:06:56.800><c> as</c><00:06:56.879><c> you</c><00:06:56.960><c> can</c><00:06:57.080><c> see</c><00:06:57.280><c> here</c><00:06:57.440><c> the</c><00:06:57.520><c> script</c>

00:06:57.790 --> 00:06:57.800 align:start position:0%
allow and as you can see here the script
 

00:06:57.800 --> 00:06:59.390 align:start position:0%
allow and as you can see here the script
is<00:06:57.960><c> started</c><00:06:58.560><c> and</c><00:06:58.720><c> the</c><00:06:58.840><c> script</c><00:06:59.080><c> is</c><00:06:59.199><c> finished</c>

00:06:59.390 --> 00:06:59.400 align:start position:0%
is started and the script is finished
 

00:06:59.400 --> 00:07:01.390 align:start position:0%
is started and the script is finished
finished<00:07:00.039><c> now</c><00:07:00.199><c> if</c><00:07:00.280><c> we</c><00:07:00.440><c> go</c><00:07:00.680><c> back</c><00:07:00.840><c> to</c><00:07:00.960><c> our</c><00:07:01.160><c> Google</c>

00:07:01.390 --> 00:07:01.400 align:start position:0%
finished now if we go back to our Google
 

00:07:01.400 --> 00:07:02.710 align:start position:0%
finished now if we go back to our Google
sheet<00:07:01.680><c> over</c><00:07:01.879><c> here</c><00:07:02.000><c> we'll</c><00:07:02.199><c> see</c><00:07:02.400><c> that</c><00:07:02.520><c> it's</c>

00:07:02.710 --> 00:07:02.720 align:start position:0%
sheet over here we'll see that it's
 

00:07:02.720 --> 00:07:06.309 align:start position:0%
sheet over here we'll see that it's
broken<00:07:03.199><c> down</c><00:07:04.120><c> this</c><00:07:04.879><c> data</c><00:07:05.319><c> that</c><00:07:05.440><c> we've</c><00:07:06.000><c> thrown</c>

00:07:06.309 --> 00:07:06.319 align:start position:0%
broken down this data that we've thrown
 

00:07:06.319 --> 00:07:08.189 align:start position:0%
broken down this data that we've thrown
into<00:07:06.520><c> the</c><00:07:06.639><c> Google</c><00:07:06.879><c> sheet</c><00:07:07.199><c> here</c><00:07:07.720><c> it's</c><00:07:07.879><c> broken</c>

00:07:08.189 --> 00:07:08.199 align:start position:0%
into the Google sheet here it's broken
 

00:07:08.199 --> 00:07:11.550 align:start position:0%
into the Google sheet here it's broken
it<00:07:08.319><c> down</c><00:07:08.440><c> into</c><00:07:08.639><c> two</c><00:07:08.879><c> nice</c><00:07:09.160><c> columns</c><00:07:09.800><c> which</c><00:07:10.560><c> is</c>

00:07:11.550 --> 00:07:11.560 align:start position:0%
it down into two nice columns which is
 

00:07:11.560 --> 00:07:13.909 align:start position:0%
it down into two nice columns which is
the<00:07:11.800><c> increments</c><00:07:12.360><c> that</c><00:07:12.479><c> we</c><00:07:12.639><c> put</c><00:07:12.800><c> in</c><00:07:13.080><c> so</c><00:07:13.800><c> you</c>

00:07:13.909 --> 00:07:13.919 align:start position:0%
the increments that we put in so you
 

00:07:13.919 --> 00:07:17.790 align:start position:0%
the increments that we put in so you
know<00:07:14.080><c> 0</c><00:07:14.440><c> to</c><00:07:14.479><c> $20</c><00:07:15.160><c> 20</c><00:07:15.479><c> to</c><00:07:15.599><c> 40</c><00:07:16.000><c> 40</c><00:07:16.319><c> to</c><00:07:16.479><c> 60</c><00:07:16.840><c> Etc</c><00:07:17.639><c> and</c>

00:07:17.790 --> 00:07:17.800 align:start position:0%
know 0 to $20 20 to 40 40 to 60 Etc and
 

00:07:17.800 --> 00:07:19.909 align:start position:0%
know 0 to $20 20 to 40 40 to 60 Etc and
the<00:07:18.000><c> number</c><00:07:18.319><c> of</c><00:07:18.520><c> cells</c><00:07:19.039><c> so</c><00:07:19.240><c> the</c><00:07:19.440><c> number</c><00:07:19.680><c> of</c>

00:07:19.909 --> 00:07:19.919 align:start position:0%
the number of cells so the number of
 

00:07:19.919 --> 00:07:23.469 align:start position:0%
the number of cells so the number of
orders<00:07:20.919><c> that</c><00:07:21.319><c> fall</c><00:07:21.800><c> into</c><00:07:22.360><c> each</c>

00:07:23.469 --> 00:07:23.479 align:start position:0%
orders that fall into each
 

00:07:23.479 --> 00:07:26.309 align:start position:0%
orders that fall into each
increment<00:07:24.479><c> now</c><00:07:24.720><c> what</c><00:07:24.840><c> we</c><00:07:25.039><c> can</c><00:07:25.319><c> do</c><00:07:25.560><c> is</c><00:07:25.840><c> just</c><00:07:26.080><c> put</c>

00:07:26.309 --> 00:07:26.319 align:start position:0%
increment now what we can do is just put
 

00:07:26.319 --> 00:07:28.510 align:start position:0%
increment now what we can do is just put
this<00:07:26.599><c> graph</c><00:07:26.960><c> sorry</c><00:07:27.319><c> put</c><00:07:27.520><c> this</c><00:07:27.720><c> data</c><00:07:28.120><c> into</c><00:07:28.319><c> a</c>

00:07:28.510 --> 00:07:28.520 align:start position:0%
this graph sorry put this data into a
 

00:07:28.520 --> 00:07:32.510 align:start position:0%
this graph sorry put this data into a
graph<00:07:28.759><c> so</c><00:07:28.919><c> just</c><00:07:29.080><c> High</c><00:07:29.720><c> that</c><00:07:30.680><c> insert</c>

00:07:32.510 --> 00:07:32.520 align:start position:0%
graph so just High that insert
 

00:07:32.520 --> 00:07:36.629 align:start position:0%
graph so just High that insert
chart<00:07:33.520><c> and</c><00:07:34.360><c> there</c><00:07:34.440><c> you</c><00:07:34.639><c> go</c><00:07:34.919><c> that's</c><00:07:35.199><c> your</c><00:07:35.720><c> your</c>

00:07:36.629 --> 00:07:36.639 align:start position:0%
chart and there you go that's your your
 

00:07:36.639 --> 00:07:39.830 align:start position:0%
chart and there you go that's your your
breakdown<00:07:37.639><c> of</c><00:07:38.599><c> the</c><00:07:38.800><c> number</c><00:07:39.080><c> of</c><00:07:39.240><c> orders</c><00:07:39.680><c> that</c>

00:07:39.830 --> 00:07:39.840 align:start position:0%
breakdown of the number of orders that
 

00:07:39.840 --> 00:07:42.270 align:start position:0%
breakdown of the number of orders that
fall<00:07:40.199><c> into</c><00:07:40.560><c> different</c><00:07:40.919><c> average</c><00:07:41.280><c> order</c><00:07:41.639><c> value</c>

00:07:42.270 --> 00:07:42.280 align:start position:0%
fall into different average order value
 

00:07:42.280 --> 00:07:44.869 align:start position:0%
fall into different average order value
classes<00:07:43.240><c> now</c><00:07:43.400><c> as</c><00:07:43.479><c> you</c><00:07:43.560><c> can</c><00:07:43.720><c> see</c><00:07:44.000><c> here</c><00:07:44.680><c> this</c>

00:07:44.869 --> 00:07:44.879 align:start position:0%
classes now as you can see here this
 

00:07:44.879 --> 00:07:48.390 align:start position:0%
classes now as you can see here this
follows<00:07:45.479><c> exactly</c><00:07:45.879><c> what</c><00:07:46.039><c> I</c><00:07:46.199><c> mentioned</c><00:07:47.159><c> in</c><00:07:48.159><c> the</c>

00:07:48.390 --> 00:07:48.400 align:start position:0%
follows exactly what I mentioned in the
 

00:07:48.400 --> 00:07:50.029 align:start position:0%
follows exactly what I mentioned in the
the<00:07:48.560><c> bad</c><00:07:48.800><c> drawing</c><00:07:49.159><c> at</c><00:07:49.319><c> the</c><00:07:49.440><c> start</c><00:07:49.759><c> where</c><00:07:49.879><c> you</c>

00:07:50.029 --> 00:07:50.039 align:start position:0%
the bad drawing at the start where you
 

00:07:50.039 --> 00:07:51.550 align:start position:0%
the bad drawing at the start where you
have<00:07:50.199><c> that</c><00:07:50.400><c> initial</c><00:07:50.800><c> Spike</c><00:07:51.159><c> and</c><00:07:51.240><c> then</c><00:07:51.319><c> you</c><00:07:51.440><c> got</c>

00:07:51.550 --> 00:07:51.560 align:start position:0%
have that initial Spike and then you got
 

00:07:51.560 --> 00:07:53.469 align:start position:0%
have that initial Spike and then you got
a<00:07:51.639><c> bit</c><00:07:51.759><c> of</c><00:07:51.840><c> a</c><00:07:52.000><c> spike</c><00:07:52.319><c> at</c><00:07:52.440><c> a</c><00:07:52.919><c> at</c><00:07:53.039><c> a</c><00:07:53.159><c> higher</c>

00:07:53.469 --> 00:07:53.479 align:start position:0%
a bit of a spike at a at a higher
 

00:07:53.479 --> 00:07:56.710 align:start position:0%
a bit of a spike at a at a higher
average<00:07:53.759><c> order</c><00:07:54.159><c> value</c><00:07:55.159><c> now</c><00:07:55.759><c> these</c><00:07:56.120><c> guys</c>

00:07:56.710 --> 00:07:56.720 align:start position:0%
average order value now these guys
 

00:07:56.720 --> 00:07:59.629 align:start position:0%
average order value now these guys
currently<00:07:57.360><c> have</c><00:07:57.800><c> a</c><00:07:57.960><c> free</c><00:07:58.319><c> shipping</c><00:07:58.759><c> offer</c><00:07:59.360><c> of</c>

00:07:59.629 --> 00:07:59.639 align:start position:0%
currently have a free shipping offer of
 

00:07:59.639 --> 00:08:02.390 align:start position:0%
currently have a free shipping offer of
over<00:08:00.240><c> $100</c><00:08:01.240><c> so</c><00:08:01.479><c> that</c><00:08:01.599><c> would</c><00:08:01.800><c> sit</c><00:08:02.080><c> somewhere</c>

00:08:02.390 --> 00:08:02.400 align:start position:0%
over $100 so that would sit somewhere
 

00:08:02.400 --> 00:08:04.430 align:start position:0%
over $100 so that would sit somewhere
around<00:08:02.639><c> over</c><00:08:02.919><c> here</c><00:08:03.560><c> now</c><00:08:03.720><c> as</c><00:08:03.800><c> you</c><00:08:03.879><c> can</c><00:08:04.000><c> see</c><00:08:04.240><c> most</c>

00:08:04.430 --> 00:08:04.440 align:start position:0%
around over here now as you can see most
 

00:08:04.440 --> 00:08:07.990 align:start position:0%
around over here now as you can see most
of<00:08:04.560><c> the</c><00:08:04.639><c> orders</c><00:08:05.120><c> are</c><00:08:05.360><c> on</c><00:08:05.479><c> the</c><00:08:05.639><c> lower</c><00:08:06.039><c> end</c><00:08:07.039><c> and</c>

00:08:07.990 --> 00:08:08.000 align:start position:0%
of the orders are on the lower end and
 

00:08:08.000 --> 00:08:11.070 align:start position:0%
of the orders are on the lower end and
you<00:08:08.120><c> know</c><00:08:08.479><c> someone</c><00:08:08.879><c> spending</c><00:08:09.240><c> $4</c><00:08:09.639><c> to</c><00:08:09.960><c> $50</c><00:08:10.960><c> I</c>

00:08:11.070 --> 00:08:11.080 align:start position:0%
you know someone spending $4 to $50 I
 

00:08:11.080 --> 00:08:13.629 align:start position:0%
you know someone spending $4 to $50 I
don't<00:08:11.440><c> think</c><00:08:11.800><c> or</c><00:08:12.080><c> you</c><00:08:12.199><c> know</c><00:08:12.960><c> from</c><00:08:13.120><c> a</c><00:08:13.360><c> common</c>

00:08:13.629 --> 00:08:13.639 align:start position:0%
don't think or you know from a common
 

00:08:13.639 --> 00:08:15.589 align:start position:0%
don't think or you know from a common
sense<00:08:14.000><c> perspective</c><00:08:14.639><c> they</c><00:08:14.759><c> wouldn't</c><00:08:15.039><c> be</c><00:08:15.319><c> too</c>

00:08:15.589 --> 00:08:15.599 align:start position:0%
sense perspective they wouldn't be too
 

00:08:15.599 --> 00:08:18.790 align:start position:0%
sense perspective they wouldn't be too
Keen<00:08:16.039><c> to</c><00:08:17.000><c> push</c><00:08:17.319><c> that</c><00:08:17.520><c> order</c><00:08:17.960><c> all</c><00:08:18.120><c> the</c><00:08:18.240><c> way</c><00:08:18.479><c> over</c>

00:08:18.790 --> 00:08:18.800 align:start position:0%
Keen to push that order all the way over
 

00:08:18.800 --> 00:08:21.749 align:start position:0%
Keen to push that order all the way over
$100<00:08:19.800><c> to</c><00:08:20.080><c> get</c><00:08:20.319><c> that</c><00:08:20.479><c> free</c><00:08:20.759><c> shipping</c><00:08:21.599><c> uh</c>

00:08:21.749 --> 00:08:21.759 align:start position:0%
$100 to get that free shipping uh
 

00:08:21.759 --> 00:08:23.550 align:start position:0%
$100 to get that free shipping uh
threshold<00:08:22.280><c> obviously</c><00:08:22.599><c> there</c><00:08:22.720><c> will</c><00:08:22.879><c> be</c><00:08:23.039><c> a</c><00:08:23.120><c> few</c>

00:08:23.550 --> 00:08:23.560 align:start position:0%
threshold obviously there will be a few
 

00:08:23.560 --> 00:08:25.350 align:start position:0%
threshold obviously there will be a few
but<00:08:24.000><c> the</c><00:08:24.159><c> vast</c><00:08:24.440><c> majority</c><00:08:24.800><c> of</c><00:08:24.960><c> people</c><00:08:25.159><c> would</c>

00:08:25.350 --> 00:08:25.360 align:start position:0%
but the vast majority of people would
 

00:08:25.360 --> 00:08:27.430 align:start position:0%
but the vast majority of people would
rather<00:08:25.599><c> just</c><00:08:25.720><c> pay</c><00:08:25.919><c> the</c><00:08:26.039><c> shipping</c><00:08:26.560><c> and</c><00:08:27.319><c> you</c>

00:08:27.430 --> 00:08:27.440 align:start position:0%
rather just pay the shipping and you
 

00:08:27.440 --> 00:08:32.070 align:start position:0%
rather just pay the shipping and you
know<00:08:27.800><c> buy</c><00:08:28.479><c> or</c><00:08:29.560><c> have</c><00:08:29.800><c> a</c><00:08:30.000><c> smaller</c><00:08:30.440><c> order</c><00:08:31.400><c> so</c><00:08:31.800><c> now</c>

00:08:32.070 --> 00:08:32.080 align:start position:0%
know buy or have a smaller order so now
 

00:08:32.080 --> 00:08:34.870 align:start position:0%
know buy or have a smaller order so now
from<00:08:32.360><c> here</c><00:08:32.560><c> we</c><00:08:32.680><c> can</c><00:08:32.919><c> go</c><00:08:33.159><c> to</c><00:08:34.039><c> or</c><00:08:34.240><c> go</c><00:08:34.479><c> back</c><00:08:34.640><c> to</c><00:08:34.760><c> the</c>

00:08:34.870 --> 00:08:34.880 align:start position:0%
from here we can go to or go back to the
 

00:08:34.880 --> 00:08:36.310 align:start position:0%
from here we can go to or go back to the
drawing<00:08:35.159><c> board</c><00:08:35.399><c> and</c><00:08:35.519><c> say</c><00:08:35.919><c> okay</c><00:08:36.080><c> we're</c><00:08:36.240><c> going</c>

00:08:36.310 --> 00:08:36.320 align:start position:0%
drawing board and say okay we're going
 

00:08:36.320 --> 00:08:39.029 align:start position:0%
drawing board and say okay we're going
to<00:08:36.919><c> perhaps</c><00:08:37.479><c> put</c><00:08:37.760><c> our</c><00:08:38.240><c> free</c><00:08:38.599><c> shipping</c>

00:08:39.029 --> 00:08:39.039 align:start position:0%
to perhaps put our free shipping
 

00:08:39.039 --> 00:08:44.269 align:start position:0%
to perhaps put our free shipping
threshold<00:08:39.839><c> over</c><00:08:40.279><c> $75</c><00:08:41.279><c> or</c><00:08:41.440><c> over</c><00:08:42.080><c> $80</c><00:08:43.080><c> so</c><00:08:43.360><c> that</c>

00:08:44.269 --> 00:08:44.279 align:start position:0%
threshold over $75 or over $80 so that
 

00:08:44.279 --> 00:08:48.670 align:start position:0%
threshold over $75 or over $80 so that
you<00:08:44.440><c> know</c><00:08:44.760><c> this</c><00:08:45.399><c> this</c><00:08:46.279><c> uh</c><00:08:46.680><c> segment</c><00:08:47.200><c> of</c><00:08:47.680><c> users</c>

00:08:48.670 --> 00:08:48.680 align:start position:0%
you know this this uh segment of users
 

00:08:48.680 --> 00:08:52.110 align:start position:0%
you know this this uh segment of users
the<00:08:48.760><c> $4</c><00:08:49.160><c> to</c><00:08:49.279><c> $60</c><00:08:50.000><c> orders</c><00:08:50.480><c> are</c><00:08:51.320><c> uh</c><00:08:51.519><c> pushed</c><00:08:51.959><c> to</c>

00:08:52.110 --> 00:08:52.120 align:start position:0%
the $4 to $60 orders are uh pushed to
 

00:08:52.120 --> 00:08:54.430 align:start position:0%
the $4 to $60 orders are uh pushed to
spend<00:08:52.480><c> an</c><00:08:52.640><c> additional</c><00:08:53.279><c> you</c><00:08:53.399><c> know</c><00:08:53.560><c> 10</c><00:08:53.880><c> 15</c><00:08:54.200><c> maybe</c>

00:08:54.430 --> 00:08:54.440 align:start position:0%
spend an additional you know 10 15 maybe
 

00:08:54.440 --> 00:08:56.670 align:start position:0%
spend an additional you know 10 15 maybe
even<00:08:54.519><c> $20</c><00:08:55.440><c> to</c><00:08:55.640><c> get</c><00:08:55.760><c> that</c><00:08:55.920><c> free</c><00:08:56.120><c> shipping</c><00:08:56.519><c> as</c>

00:08:56.670 --> 00:08:56.680 align:start position:0%
even $20 to get that free shipping as
 

00:08:56.680 --> 00:08:58.910 align:start position:0%
even $20 to get that free shipping as
opposed<00:08:57.000><c> to</c><00:08:57.160><c> another</c><00:08:57.360><c> $50</c><00:08:58.320><c> to</c><00:08:58.480><c> get</c><00:08:58.640><c> that</c><00:08:58.760><c> free</c>

00:08:58.910 --> 00:08:58.920 align:start position:0%
opposed to another $50 to get that free
 

00:08:58.920 --> 00:09:00.069 align:start position:0%
opposed to another $50 to get that free
shipping

00:09:00.069 --> 00:09:00.079 align:start position:0%
shipping
 

00:09:00.079 --> 00:09:01.949 align:start position:0%
shipping
So<00:09:00.560><c> It</c><00:09:00.720><c> ultimately</c><00:09:01.200><c> should</c><00:09:01.480><c> have</c><00:09:01.600><c> a</c><00:09:01.760><c> much</c>

00:09:01.949 --> 00:09:01.959 align:start position:0%
So It ultimately should have a much
 

00:09:01.959 --> 00:09:04.470 align:start position:0%
So It ultimately should have a much
bigger<00:09:02.320><c> impact</c><00:09:02.880><c> on</c><00:09:03.480><c> your</c><00:09:03.880><c> average</c><00:09:04.160><c> order</c>

00:09:04.470 --> 00:09:04.480 align:start position:0%
bigger impact on your average order
 

00:09:04.480 --> 00:09:07.030 align:start position:0%
bigger impact on your average order
value<00:09:04.920><c> by</c><00:09:05.399><c> you</c><00:09:05.519><c> know</c><00:09:05.720><c> firstly</c><00:09:06.200><c> analyzing</c><00:09:06.760><c> your</c>

00:09:07.030 --> 00:09:07.040 align:start position:0%
value by you know firstly analyzing your
 

00:09:07.040 --> 00:09:09.230 align:start position:0%
value by you know firstly analyzing your
average<00:09:07.399><c> or</c><00:09:07.640><c> your</c><00:09:07.839><c> orders</c><00:09:08.560><c> average</c><00:09:08.880><c> order</c>

00:09:09.230 --> 00:09:09.240 align:start position:0%
average or your orders average order
 

00:09:09.240 --> 00:09:11.790 align:start position:0%
average or your orders average order
values<00:09:10.240><c> and</c><00:09:10.399><c> then</c><00:09:10.600><c> placing</c><00:09:11.040><c> your</c><00:09:11.320><c> discounts</c>

00:09:11.790 --> 00:09:11.800 align:start position:0%
values and then placing your discounts
 

00:09:11.800 --> 00:09:14.630 align:start position:0%
values and then placing your discounts
or<00:09:12.040><c> offers</c><00:09:12.880><c> accordingly</c><00:09:13.880><c> so</c><00:09:14.120><c> that</c><00:09:14.240><c> was</c><00:09:14.399><c> it</c>

00:09:14.630 --> 00:09:14.640 align:start position:0%
or offers accordingly so that was it
 

00:09:14.640 --> 00:09:16.389 align:start position:0%
or offers accordingly so that was it
hopefully<00:09:14.920><c> that</c><00:09:15.040><c> was</c><00:09:15.240><c> valuable</c><00:09:16.160><c> I</c><00:09:16.240><c> think</c>

00:09:16.389 --> 00:09:16.399 align:start position:0%
hopefully that was valuable I think
 

00:09:16.399 --> 00:09:18.550 align:start position:0%
hopefully that was valuable I think
that's<00:09:16.560><c> a</c><00:09:16.680><c> quite</c><00:09:16.839><c> a</c><00:09:17.000><c> cool</c><00:09:17.680><c> system</c><00:09:18.200><c> that</c><00:09:18.440><c> that</c>

00:09:18.550 --> 00:09:18.560 align:start position:0%
that's a quite a cool system that that
 

00:09:18.560 --> 00:09:21.069 align:start position:0%
that's a quite a cool system that that
should<00:09:18.880><c> work</c><00:09:19.160><c> well</c><00:09:19.399><c> for</c><00:09:19.720><c> most</c><00:09:20.079><c> businesses</c>

00:09:21.069 --> 00:09:21.079 align:start position:0%
should work well for most businesses
 

00:09:21.079 --> 00:09:22.710 align:start position:0%
should work well for most businesses
again<00:09:21.279><c> if</c><00:09:21.399><c> you</c><00:09:21.519><c> have</c><00:09:21.640><c> any</c><00:09:21.839><c> comments</c><00:09:22.399><c> please</c>

00:09:22.710 --> 00:09:22.720 align:start position:0%
again if you have any comments please
 

00:09:22.720 --> 00:09:24.670 align:start position:0%
again if you have any comments please
let<00:09:23.320><c> us</c><00:09:23.519><c> know</c><00:09:23.720><c> in</c><00:09:23.839><c> the</c><00:09:23.920><c> comment</c><00:09:24.200><c> section</c><00:09:24.440><c> below</c>

00:09:24.670 --> 00:09:24.680 align:start position:0%
let us know in the comment section below
 

00:09:24.680 --> 00:09:26.430 align:start position:0%
let us know in the comment section below
if<00:09:24.760><c> you</c><00:09:24.880><c> like</c><00:09:25.079><c> the</c><00:09:25.200><c> video</c><00:09:25.920><c> uh</c><00:09:26.040><c> please</c><00:09:26.240><c> give</c><00:09:26.360><c> it</c>

00:09:26.430 --> 00:09:26.440 align:start position:0%
if you like the video uh please give it
 

00:09:26.440 --> 00:09:28.230 align:start position:0%
if you like the video uh please give it
a<00:09:26.560><c> like</c><00:09:26.680><c> it</c><00:09:26.800><c> helps</c><00:09:27.040><c> us</c><00:09:27.200><c> out</c><00:09:27.640><c> and</c><00:09:27.920><c> we'll</c><00:09:28.040><c> see</c><00:09:28.160><c> you</c>

00:09:28.230 --> 00:09:28.240 align:start position:0%
a like it helps us out and we'll see you
 

00:09:28.240 --> 00:09:32.160 align:start position:0%
a like it helps us out and we'll see you
in<00:09:28.320><c> the</c><00:09:28.399><c> next</c><00:09:28.560><c> one</c><00:09:29.240><c> buffing</c><00:09:29.640><c> out</c>

이 자료가 속한 분류

할인·프로모션 전략
AOV·전환율

← 돌아가기