Blue Sense Digital
내용
[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>