Blue Sense Digital
내용
[subtitle-meta] lang=en auto=True
in this video I'll be running through
how to analyze and leverage a cohort
analysis particularly for e-commerce
Brands if you go into Shopify you come
to analytics and you then open up your
customer cohort analysis you'll be
presented with a data table that should
look something like this dependent on
how you set up your time frame in the
top left corner now later in the video
we'll be diving into how this changes
and how this will change the table and
the data presented to you as well as
changing the metrics the intervals and
the cohort inclusions and how you can
leverage these to get as many as
possible out of the data that's
presented to you now there's three ways
that you can look at this graph or this
data table to pull away insights and
then next steps that you can directly
action within your brand to become more
profitable to increase LTV to increase
aov and to overall increase the
efficiency and profitability of your
brand number one is looking across the
horizontal plane number two is analyzing
vertically and number three is looking
across diagonally each of these gives
you different insights so it's important
that you understand how to do each one
and what different insights they'll give
you firstly doing a horizontal analysis
so if we look at the customer cohort
data table and we look from left to
right and the easiest way to do this is
for me to get rid of a bunch of data and
we'll just look at that first column
which is November
2022 what you'll see here and what the
data is telling us is that for all of
the customers that made their first
purchase with us in November 2022
they spent
$23,000 in total on their first order in
November then within the first 30 days
which is November still they came back
and spent an additional
12,620 then in the next 30 days they
went and spent 177,000 then in the next
30-day period they came back and spent
13,000 in the next 30-day period they
came back and spent about 7,000 so to
simplify this even further when we're
looking at month one what this means is
December
2022 so in the month of December
2022 the November cohort the November
customers first time buying was in
November they came back and bought and
spent another
$177,000 we move along this would then
be January 2023 they came back and they
spent
13,670 then in February they came back
and they spent $
6,930 and then this goes on and on so
what you're seeing is the users that
bought for the first time in November
what was their spending habits after
that did they come back and if they did
come back how much did they spend in
total now to get very specific and you
can interchange this sentence depending
on whichever Ro you're looking at if we
were to look at this number right here
this tells us that the customers that
purchased in November
2022 came back and spent
13,670 in January
2023 this should say now from that
looking at this horizontally what can we
start to take away what are the insights
and how can we then go ahead and
actually apply these into the business
well the first major Insight looking at
these numbers across the horizontal
plane is there's a huge drop off in
return Revenue at the month three Mark
onwards in month one we get 177,000 then
we get 13,000 so it's a bit of a dip and
then there's a significant drop off
about 50% and that maintains for a
little bit and then it drops another 50%
and then another 50% so the question is
why does returning customer Revenue
Harve after the 90day mark because if we
can prevent it from harving even for
just one extra month then that's going
to unlock an additional $6 to $7,000 of
Revenue every month from every new
customer cohort that we
generate the answer to this is quite
simple this client runs a diet-based
product and the diet only lasts 90 days
so the question then is how can we
extend the LTV past the diet's length
what can we do how can we be clever with
our positioning with potential new
product launches so that we can continue
to get Revenue out of these customers
even after they've finished the diet can
we have some kind of Maintenance
protocol that they can hop on that then
increases the LTV is there a different
diet that they should then be running
into after this one there's obviously
hundreds of different answers here and
there's hundreds of different analyses
that need to be done to determine what
the best course of action is but that is
the primary reason is to why LTV is
dropping so if we can fix this we can
immediately add 20 30,000 per month to
existing customers that we're already
bringing in the door so this would just
be unlocking Revenue that's just sitting
here by improving this
ltp let's look vertically so if we look
at this customer cohort analysis up and
down and once again let's shrink the
data here and just look at this leftand
column the first thing that you'll
notice is that net sales decline as you
look backwards in time now if you graph
this as well which you can see on the
right it looks like sales are falling
off a cliff it's important to note here
that this is not the sale numbers these
guys have been consistent for the last
year their revenue has stayed stable the
reason why revenue is dropping as you
come forward is because if we look down
the bottom here this October cohort
hasn't had time to come back and repeat
purchase yet so all we're seeing is
their first order Revenue we're not
seeing any of the returning order
revenue and total revenue of a business
equals and let me pull this up as this
is later in the slides here total
revenue in the business equals new
customer Revenue plus existing customer
revenue and because we're currently only
looking at first customer Revenue we're
not seeing all of the rest they actually
did about
$150,000 in the month of October and
that remaining 110 that's missing from
this is all customers that are coming
back and returning and we'll talk about
that later and how that ties into the
diagonal analysis but that's firstly
worth
noting diving into how you should
actually be looking at this vertically
is fairly simple as you move down you
will see the date range move down and
you're looking at a different cohort so
up here we're looking at the November
cohort in the first 30 days they spent
12,000 the December cohort in the first
30 days they came back and spent 2,000
4,000
Etc so if we're to zoom in on for
example
January what this tells us is the
customers that purchased in January 2023
spent
$447 in the remainder of January 2023 so
in the following 30 days from their
first purchase they spent an additional
4,47 as an entire cohort all of those
customers together some of them came
back and you total all that revenue and
it comes to
4,470 now where this startes to get
interesting and I've moved over from
month zero column to month one column is
you can start to identify Trends and
pull them out start to ask questions and
then get answers because it shows us
fluctuations in returning customer
Revenue over
time for example example the month one
returning customer Revenue peaked in
February
2023 why is that the case why did we
have such a good return customer rate in
February well firstly because we're
looking at Revenue numbers and not
percentage numbers it's going to skew
based on month-to-month sale
fluctuations so generally speaking it
isn't the best practice to be looking at
dollar values here and instead we should
be looking at returning customer
percentages but regardless this still
was a really good month why was that
well when we look back in time and we do
an analysis what we'll find is that back
in February we actually
sent 5 adms rather than
four so that's likely why returning
customer Revenue was so good and this
should actually technically say March
because these users were in Feb and then
they came back in March and bought so we
spent we sent more edms in March which
resulted in that High Revenue
pick and then before going into the
diagonal analysis you can also do this
in the inverse so you can look at where
returning customer numbers are really
poor for example down here in August and
we can start to troubleshoot why that
might be the case and how we can get
back to these high return customer rates
that we had
previously looking on the diagonal plane
this is usually the hardest plane to
wrap your head around um but it actually
is quite simple once you understand
it let's zoom in on a very particular
Square here so that you can get an
understanding of what each of these
squares mean and how they all tie into
each other if we look at this box right
here what this is telling us is the July
2023 customer cohort and we can see this
by going across and looking here spent $
6,34 in the month of October why the
month of October well because this is
July
August September October so we're
looking forward in time and this comes
to October now the interesting thing
here is that as we start to go up and
down this diagonal this will always
result in it being October so we can
look here and this tells us that in June
2023 this customer cohort spent
4,190 once again in October because if
we look at June and we go month one this
is July August
September
October and this follows all the way
through so this one up here tells us
what the November cohort spent in
October this one down here April tells
us what the April cohort spent in
October and so this starts to develop an
interesting relationship between the
diagonal Revenue numbers and total
revenue what you can do to find total
revenue is you can sum that entire
diagonal area that I've LED here I've
called it a column here but technically
it's not a column and you can add the
first order Revenue down here and you
should get total
revenue because total revenue equals new
customer Revenue plus existing customer
Revenue so you take this you'd add it to
this and then you should get total ref
now the interesting thing here is that
you won't get total rev if you were to
go and add those numbers together and
have a look at the back end of Shopify
and the reason you wouldn't is because
this
area goes infinitely to the top right
corner we're just seeing the last 12
months of data but
realistically there's a cohort back in
January 2022 who's still buying there's
a cohort back in February 2022 who's
still buying so unless we had access to
the Infinity of diagonal data and we
could go all the way back to the
start of the brand then we would get the
actual Revenue number but if you were to
add all these numbers together added to
this you actually would get slightly
under which shows you that the remainder
let's say we add all this up we add it
to this we get 100K but in reality they
did 120k in October well that 20K
difference simply means that $20,000 of
Revenue came from existing customers
that first time purchased before the
last
year
so you can analyze this customer cohort
analysis horizontally vertically or
diagonally and they'll all tell you
different things if you're looking
vertically it's going to give you the
ability to look at how returning
customer revenue and percentage numbers
fluctuated over time you can then
identify months that were really high
performing try to figure out why they
were high performing and then apply that
into your business if you're looking
horizontally you can look at where
there's a significant drop off in return
customer rates figure out why are people
dropping up after 90 days and then what
can we do to address this can we
increase our EDM significantly after a
user has been in our database for 90
days is there an issue with the actual
core offering for example are we doing a
diet that ends after 90 days and that's
why users aren't coming back and then
when we look diagonally this gives us a
breakdown of how our Revenue this month
has been attributed to past customer
cohorts and we can also find similar
Trends here as we would horizontally for
example we can find that this month
majority of Revenue came from users that
purchased in August and September now
this makes sense because we know that on
average most of our purchases do come in
the last 90 days but if we find any
anomalies here we can then pull that out
analyze it and use it to find next
steps now in addition to analyzing
horizontally vertically and diagonally
we can also use this customer cohort
data to calculate
LTV and we can do that just using the
first two columns here we can take net
sales we can divide it by first order
sales and that should give us an LTV
ratio to get the actual LTV what you
want to do is change the metric down
here to customers and then do basic
division of these two columns LTV equals
net sales divided by cohort size so for
example if we wanted to find the LTV of
the November cohort so the users that
purchased in November how much on
average did they spend with the brand
over the
lifetime we take 283,000 and divide it
by
1,031 that would give us
$274 which means that the November
cohort LTV is
274 now we can also do some cohort
inclusions or customer segmentation on
the right hand side here and pull away
some really interesting insights that
once again gives us actionable next
steps to implement in the brand
for example we can sort by users
that uh purchased a subscription rather
than a onetime
buy we can once again run the same
analysis let's have a look at the
November cohort net sales amount of
people that actually bought what we'll
find is LTV is actually
$436 as you can see right there so it's
up
59% so people that apply for a
subscription rather than just buying the
product on average spend 59% more over
their lifetime what does this tell us
well we should probably force people
onto subscriptions let's not even let
people purchase one time let's force
people onto subscriptions is we can see
that it's very very effective for
increasing lifetime value and November
it's a small data set we're looking at
38 customers there so it might be skewed
so let's look at the entire last 12
months of data let's take the whole
$200,000 of subscription Revenue that we
generated and let's divide by the entire
cohort size and that's going to give us
43 so it's still much higher it's about
52% higher so it still validates that
subscription members spend a lot more
than regular uh
customers now in the top right corner
here we can also run this analysis by
Breaking Down based on customer
retention rates number of customers net
sales gross sales or average order
value you can also change the date range
in the top leftand corner here to fill
out the entire data table if you're
going to be looking at LTV numbers it's
really important to fill out the entire
data table and the reason being is that
if you're just looking at uh data of the
last 12 months you're going to have this
half complete data table whereby if you
were to do an LTV analysis and let's go
back a few slides here if you were to do
an LTV analysis of October and you took
net sales and you divided by first order
sales you'd find that there's no
LTV and that's because none of these
customers have come back and bought
again and so you can't really do an LTV
analysis on the last 2 3 4 months of
data because these people haven't had
the time yet to come back and repurchase
and spend money and so when you sum this
entire table yes the top few rows are
going to be accurate but the bottom are
all going to be inaccurate and so it's
going to automatically skew towards a
worse LTV it's not going to be a direct
representation of what your actual LTV
is a few things to look out for when
you're running through this analysis
you're changing the metrics around
you're looking at the data table is
number one aov should always be
increasing over time so if you sort by
the average order value metric here you
want to be making sure that average
order value is increasing as people come
back and repeat purchase as when people
come back to your store they should be
more confident in your brand they're
bought from you before they know that
you're reliable they like your products
and so they should be spending more
money if they aren't it means that
there's a fundamental issue with your
offering you might not even have an
offer avaluable for people to spend more
money and that needs to exist so you
need to put some kind of bundling
together maybe release a new product um
have careful upsells that allow clever
upsells sorry that allow for increased
average order value but there needs to
be the ability for the customer to be
able to spend more when they return if
you don't see this increasing over time
that's a large red flag and that's an
opportunity for growth number two you
can do product break Downs so if you
come down to not the customer one it's
actually being hidden here if you come
down to cohort inclusion you can sort
this by individual product types or
collection types and so you can do this
full analysis but you can do it based on
an individual collection so does this
collection have better returning
customer rates than this one and a very
specific example of how this would apply
to your brand is let's say that you sell
two primary products both are $100 both
sit at a five row when you advertise
them on Google and Facebook so you're
pushing them both equally as hard but
what you might find when you do this
analysis is that the LTV on product B is
$250 but the LTV on product a is
120 and so when you look at that you go
okay we should actually be spending way
more on customer acquisition for product
B than we should for product a because
we unlock a repeat purchase of $150 here
which we we don't do here and so just by
making that analysis then making that
change in spend distribution across uh
customer acquisition based on skew
you'll see a significant uptick in the
profitability of the business and the
revenue of the business as well is
you'll have better repeat purchase rates
which will increase returning customer
Revenue which is going to skew monthly
Revenue up and significantly skew up
profitability because it's really really
doesn't cost much to get a user back to
site to buy
again and the third thing to look out to
is that you want to be viewing last
year's data once again if you're looking
at LTV metrics so that you can
completely fill out this data table and
have an accurate representation of what
these cohorts did over the following 12
months
원문 자막 펼치기
WEBVTT Kind: captions Language: en 00:00:00.120 --> 00:00:01.189 align:start position:0% in<00:00:00.240><c> this</c><00:00:00.359><c> video</c><00:00:00.560><c> I'll</c><00:00:00.680><c> be</c><00:00:00.799><c> running</c><00:00:01.000><c> through</c> 00:00:01.189 --> 00:00:01.199 align:start position:0% in this video I'll be running through 00:00:01.199 --> 00:00:03.110 align:start position:0% in this video I'll be running through how<00:00:01.280><c> to</c><00:00:01.480><c> analyze</c><00:00:01.880><c> and</c><00:00:02.040><c> leverage</c><00:00:02.440><c> a</c><00:00:02.600><c> cohort</c> 00:00:03.110 --> 00:00:03.120 align:start position:0% how to analyze and leverage a cohort 00:00:03.120 --> 00:00:05.269 align:start position:0% how to analyze and leverage a cohort analysis<00:00:03.760><c> particularly</c><00:00:04.240><c> for</c><00:00:04.600><c> e-commerce</c> 00:00:05.269 --> 00:00:05.279 align:start position:0% analysis particularly for e-commerce 00:00:05.279 --> 00:00:07.990 align:start position:0% analysis particularly for e-commerce Brands<00:00:06.279><c> if</c><00:00:06.359><c> you</c><00:00:06.520><c> go</c><00:00:06.720><c> into</c><00:00:06.960><c> Shopify</c><00:00:07.720><c> you</c><00:00:07.799><c> come</c> 00:00:07.990 --> 00:00:08.000 align:start position:0% Brands if you go into Shopify you come 00:00:08.000 --> 00:00:09.870 align:start position:0% Brands if you go into Shopify you come to<00:00:08.200><c> analytics</c><00:00:08.800><c> and</c><00:00:08.880><c> you</c><00:00:09.040><c> then</c><00:00:09.200><c> open</c><00:00:09.440><c> up</c><00:00:09.599><c> your</c> 00:00:09.870 --> 00:00:09.880 align:start position:0% to analytics and you then open up your 00:00:09.880 --> 00:00:11.950 align:start position:0% to analytics and you then open up your customer<00:00:10.320><c> cohort</c><00:00:10.840><c> analysis</c><00:00:11.599><c> you'll</c><00:00:11.799><c> be</c> 00:00:11.950 --> 00:00:11.960 align:start position:0% customer cohort analysis you'll be 00:00:11.960 --> 00:00:13.390 align:start position:0% customer cohort analysis you'll be presented<00:00:12.280><c> with</c><00:00:12.400><c> a</c><00:00:12.559><c> data</c><00:00:12.799><c> table</c><00:00:13.080><c> that</c><00:00:13.200><c> should</c> 00:00:13.390 --> 00:00:13.400 align:start position:0% presented with a data table that should 00:00:13.400 --> 00:00:15.070 align:start position:0% presented with a data table that should look<00:00:13.639><c> something</c><00:00:14.000><c> like</c><00:00:14.200><c> this</c><00:00:14.480><c> dependent</c><00:00:14.839><c> on</c> 00:00:15.070 --> 00:00:15.080 align:start position:0% look something like this dependent on 00:00:15.080 --> 00:00:16.750 align:start position:0% look something like this dependent on how<00:00:15.200><c> you</c><00:00:15.360><c> set</c><00:00:15.559><c> up</c><00:00:15.719><c> your</c><00:00:16.000><c> time</c><00:00:16.240><c> frame</c><00:00:16.480><c> in</c><00:00:16.600><c> the</c> 00:00:16.750 --> 00:00:16.760 align:start position:0% how you set up your time frame in the 00:00:16.760 --> 00:00:18.790 align:start position:0% how you set up your time frame in the top<00:00:16.960><c> left</c><00:00:17.160><c> corner</c><00:00:17.760><c> now</c><00:00:17.920><c> later</c><00:00:18.160><c> in</c><00:00:18.279><c> the</c><00:00:18.400><c> video</c> 00:00:18.790 --> 00:00:18.800 align:start position:0% top left corner now later in the video 00:00:18.800 --> 00:00:20.910 align:start position:0% top left corner now later in the video we'll<00:00:19.000><c> be</c><00:00:19.199><c> diving</c><00:00:19.520><c> into</c><00:00:19.840><c> how</c><00:00:20.080><c> this</c><00:00:20.400><c> changes</c> 00:00:20.910 --> 00:00:20.920 align:start position:0% we'll be diving into how this changes 00:00:20.920 --> 00:00:22.310 align:start position:0% we'll be diving into how this changes and<00:00:21.080><c> how</c><00:00:21.199><c> this</c><00:00:21.279><c> will</c><00:00:21.439><c> change</c><00:00:21.720><c> the</c><00:00:21.920><c> table</c><00:00:22.160><c> and</c> 00:00:22.310 --> 00:00:22.320 align:start position:0% and how this will change the table and 00:00:22.320 --> 00:00:24.670 align:start position:0% and how this will change the table and the<00:00:22.480><c> data</c><00:00:22.720><c> presented</c><00:00:23.039><c> to</c><00:00:23.199><c> you</c><00:00:23.760><c> as</c><00:00:24.039><c> well</c><00:00:24.279><c> as</c> 00:00:24.670 --> 00:00:24.680 align:start position:0% the data presented to you as well as 00:00:24.680 --> 00:00:26.429 align:start position:0% the data presented to you as well as changing<00:00:25.080><c> the</c><00:00:25.240><c> metrics</c><00:00:25.680><c> the</c><00:00:25.800><c> intervals</c><00:00:26.320><c> and</c> 00:00:26.429 --> 00:00:26.439 align:start position:0% changing the metrics the intervals and 00:00:26.439 --> 00:00:28.269 align:start position:0% changing the metrics the intervals and the<00:00:26.599><c> cohort</c><00:00:27.119><c> inclusions</c><00:00:27.720><c> and</c><00:00:27.880><c> how</c><00:00:28.000><c> you</c><00:00:28.119><c> can</c> 00:00:28.269 --> 00:00:28.279 align:start position:0% the cohort inclusions and how you can 00:00:28.279 --> 00:00:30.429 align:start position:0% the cohort inclusions and how you can leverage<00:00:28.760><c> these</c><00:00:29.199><c> to</c><00:00:29.320><c> get</c><00:00:29.439><c> as</c><00:00:29.560><c> many</c><00:00:30.240><c> as</c> 00:00:30.429 --> 00:00:30.439 align:start position:0% leverage these to get as many as 00:00:30.439 --> 00:00:32.229 align:start position:0% leverage these to get as many as possible<00:00:31.240><c> out</c><00:00:31.439><c> of</c><00:00:31.599><c> the</c><00:00:31.800><c> data</c><00:00:32.040><c> that's</c> 00:00:32.229 --> 00:00:32.239 align:start position:0% possible out of the data that's 00:00:32.239 --> 00:00:34.869 align:start position:0% possible out of the data that's presented<00:00:32.640><c> to</c><00:00:32.800><c> you</c><00:00:33.640><c> now</c><00:00:33.800><c> there's</c><00:00:34.320><c> three</c><00:00:34.640><c> ways</c> 00:00:34.869 --> 00:00:34.879 align:start position:0% presented to you now there's three ways 00:00:34.879 --> 00:00:36.470 align:start position:0% presented to you now there's three ways that<00:00:35.000><c> you</c><00:00:35.120><c> can</c><00:00:35.280><c> look</c><00:00:35.399><c> at</c><00:00:35.600><c> this</c><00:00:35.840><c> graph</c><00:00:36.079><c> or</c><00:00:36.280><c> this</c> 00:00:36.470 --> 00:00:36.480 align:start position:0% that you can look at this graph or this 00:00:36.480 --> 00:00:39.069 align:start position:0% that you can look at this graph or this data<00:00:36.800><c> table</c><00:00:37.440><c> to</c><00:00:37.640><c> pull</c><00:00:37.879><c> away</c><00:00:38.280><c> insights</c><00:00:38.960><c> and</c> 00:00:39.069 --> 00:00:39.079 align:start position:0% data table to pull away insights and 00:00:39.079 --> 00:00:40.709 align:start position:0% data table to pull away insights and then<00:00:39.280><c> next</c><00:00:39.520><c> steps</c><00:00:39.800><c> that</c><00:00:39.920><c> you</c><00:00:40.000><c> can</c><00:00:40.239><c> directly</c> 00:00:40.709 --> 00:00:40.719 align:start position:0% then next steps that you can directly 00:00:40.719 --> 00:00:42.670 align:start position:0% then next steps that you can directly action<00:00:41.200><c> within</c><00:00:41.440><c> your</c><00:00:41.600><c> brand</c><00:00:42.039><c> to</c><00:00:42.200><c> become</c><00:00:42.440><c> more</c> 00:00:42.670 --> 00:00:42.680 align:start position:0% action within your brand to become more 00:00:42.680 --> 00:00:44.670 align:start position:0% action within your brand to become more profitable<00:00:43.160><c> to</c><00:00:43.320><c> increase</c><00:00:43.640><c> LTV</c><00:00:44.200><c> to</c><00:00:44.320><c> increase</c> 00:00:44.670 --> 00:00:44.680 align:start position:0% profitable to increase LTV to increase 00:00:44.680 --> 00:00:46.549 align:start position:0% profitable to increase LTV to increase aov<00:00:45.399><c> and</c><00:00:45.520><c> to</c><00:00:45.640><c> overall</c><00:00:46.039><c> increase</c><00:00:46.399><c> the</c> 00:00:46.549 --> 00:00:46.559 align:start position:0% aov and to overall increase the 00:00:46.559 --> 00:00:48.910 align:start position:0% aov and to overall increase the efficiency<00:00:47.000><c> and</c><00:00:47.160><c> profitability</c><00:00:47.960><c> of</c><00:00:48.320><c> your</c> 00:00:48.910 --> 00:00:48.920 align:start position:0% efficiency and profitability of your 00:00:48.920 --> 00:00:51.670 align:start position:0% efficiency and profitability of your brand<00:00:49.920><c> number</c><00:00:50.199><c> one</c><00:00:50.600><c> is</c><00:00:50.879><c> looking</c><00:00:51.239><c> across</c><00:00:51.520><c> the</c> 00:00:51.670 --> 00:00:51.680 align:start position:0% brand number one is looking across the 00:00:51.680 --> 00:00:54.470 align:start position:0% brand number one is looking across the horizontal<00:00:52.239><c> plane</c><00:00:53.000><c> number</c><00:00:53.280><c> two</c><00:00:53.600><c> is</c><00:00:53.840><c> analyzing</c> 00:00:54.470 --> 00:00:54.480 align:start position:0% horizontal plane number two is analyzing 00:00:54.480 --> 00:00:56.590 align:start position:0% horizontal plane number two is analyzing vertically<00:00:55.320><c> and</c><00:00:55.480><c> number</c><00:00:55.760><c> three</c><00:00:56.039><c> is</c><00:00:56.199><c> looking</c> 00:00:56.590 --> 00:00:56.600 align:start position:0% vertically and number three is looking 00:00:56.600 --> 00:00:58.869 align:start position:0% vertically and number three is looking across<00:00:57.160><c> diagonally</c><00:00:58.160><c> each</c><00:00:58.320><c> of</c><00:00:58.519><c> these</c><00:00:58.680><c> gives</c> 00:00:58.869 --> 00:00:58.879 align:start position:0% across diagonally each of these gives 00:00:58.879 --> 00:01:00.830 align:start position:0% across diagonally each of these gives you<00:00:59.039><c> different</c><00:00:59.359><c> insights</c><00:00:59.960><c> so</c><00:01:00.399><c> it's</c><00:01:00.559><c> important</c> 00:01:00.830 --> 00:01:00.840 align:start position:0% you different insights so it's important 00:01:00.840 --> 00:01:02.189 align:start position:0% you different insights so it's important that<00:01:00.960><c> you</c><00:01:01.280><c> understand</c><00:01:01.440><c> how</c><00:01:01.559><c> to</c><00:01:01.680><c> do</c><00:01:01.879><c> each</c><00:01:02.039><c> one</c> 00:01:02.189 --> 00:01:02.199 align:start position:0% that you understand how to do each one 00:01:02.199 --> 00:01:03.869 align:start position:0% that you understand how to do each one and<00:01:02.359><c> what</c><00:01:02.480><c> different</c><00:01:02.719><c> insights</c><00:01:03.120><c> they'll</c><00:01:03.359><c> give</c> 00:01:03.869 --> 00:01:03.879 align:start position:0% and what different insights they'll give 00:01:03.879 --> 00:01:07.510 align:start position:0% and what different insights they'll give you<00:01:04.879><c> firstly</c><00:01:05.360><c> doing</c><00:01:05.640><c> a</c><00:01:05.920><c> horizontal</c><00:01:06.520><c> analysis</c> 00:01:07.510 --> 00:01:07.520 align:start position:0% you firstly doing a horizontal analysis 00:01:07.520 --> 00:01:09.670 align:start position:0% you firstly doing a horizontal analysis so<00:01:07.720><c> if</c><00:01:07.880><c> we</c><00:01:08.000><c> look</c><00:01:08.119><c> at</c><00:01:08.240><c> the</c><00:01:08.400><c> customer</c><00:01:08.880><c> cohort</c> 00:01:09.670 --> 00:01:09.680 align:start position:0% so if we look at the customer cohort 00:01:09.680 --> 00:01:12.030 align:start position:0% so if we look at the customer cohort data<00:01:10.000><c> table</c><00:01:10.439><c> and</c><00:01:10.560><c> we</c><00:01:10.720><c> look</c><00:01:11.000><c> from</c><00:01:11.360><c> left</c><00:01:11.720><c> to</c> 00:01:12.030 --> 00:01:12.040 align:start position:0% data table and we look from left to 00:01:12.040 --> 00:01:13.469 align:start position:0% data table and we look from left to right<00:01:12.400><c> and</c><00:01:12.479><c> the</c><00:01:12.600><c> easiest</c><00:01:12.920><c> way</c><00:01:13.000><c> to</c><00:01:13.119><c> do</c><00:01:13.280><c> this</c><00:01:13.400><c> is</c> 00:01:13.469 --> 00:01:13.479 align:start position:0% right and the easiest way to do this is 00:01:13.479 --> 00:01:15.149 align:start position:0% right and the easiest way to do this is for<00:01:13.600><c> me</c><00:01:13.720><c> to</c><00:01:13.880><c> get</c><00:01:14.040><c> rid</c><00:01:14.200><c> of</c><00:01:14.320><c> a</c><00:01:14.400><c> bunch</c><00:01:14.600><c> of</c><00:01:14.759><c> data</c><00:01:15.080><c> and</c> 00:01:15.149 --> 00:01:15.159 align:start position:0% for me to get rid of a bunch of data and 00:01:15.159 --> 00:01:16.870 align:start position:0% for me to get rid of a bunch of data and we'll<00:01:15.360><c> just</c><00:01:15.520><c> look</c><00:01:15.680><c> at</c><00:01:15.880><c> that</c><00:01:16.119><c> first</c><00:01:16.439><c> column</c> 00:01:16.870 --> 00:01:16.880 align:start position:0% we'll just look at that first column 00:01:16.880 --> 00:01:19.030 align:start position:0% we'll just look at that first column which<00:01:17.000><c> is</c><00:01:17.280><c> November</c> 00:01:19.030 --> 00:01:19.040 align:start position:0% which is November 00:01:19.040 --> 00:01:21.469 align:start position:0% which is November 2022<00:01:20.040><c> what</c><00:01:20.159><c> you'll</c><00:01:20.400><c> see</c><00:01:20.759><c> here</c><00:01:21.040><c> and</c><00:01:21.200><c> what</c><00:01:21.320><c> the</c> 00:01:21.469 --> 00:01:21.479 align:start position:0% 2022 what you'll see here and what the 00:01:21.479 --> 00:01:24.190 align:start position:0% 2022 what you'll see here and what the data<00:01:21.759><c> is</c><00:01:21.920><c> telling</c><00:01:22.280><c> us</c><00:01:23.000><c> is</c><00:01:23.200><c> that</c><00:01:23.439><c> for</c><00:01:23.880><c> all</c><00:01:24.040><c> of</c> 00:01:24.190 --> 00:01:24.200 align:start position:0% data is telling us is that for all of 00:01:24.200 --> 00:01:26.830 align:start position:0% data is telling us is that for all of the<00:01:24.799><c> customers</c><00:01:25.799><c> that</c><00:01:25.960><c> made</c><00:01:26.240><c> their</c><00:01:26.520><c> first</c> 00:01:26.830 --> 00:01:26.840 align:start position:0% the customers that made their first 00:01:26.840 --> 00:01:30.350 align:start position:0% the customers that made their first purchase<00:01:27.280><c> with</c><00:01:27.439><c> us</c><00:01:27.960><c> in</c><00:01:28.200><c> November</c><00:01:28.840><c> 2022</c> 00:01:30.350 --> 00:01:30.360 align:start position:0% purchase with us in November 2022 00:01:30.360 --> 00:01:31.789 align:start position:0% purchase with us in November 2022 they<00:01:30.520><c> spent</c> 00:01:31.789 --> 00:01:31.799 align:start position:0% they spent 00:01:31.799 --> 00:01:35.069 align:start position:0% they spent $23,000<00:01:32.799><c> in</c><00:01:33.000><c> total</c><00:01:33.280><c> on</c><00:01:33.439><c> their</c><00:01:33.640><c> first</c><00:01:33.880><c> order</c><00:01:34.520><c> in</c> 00:01:35.069 --> 00:01:35.079 align:start position:0% $23,000 in total on their first order in 00:01:35.079 --> 00:01:37.990 align:start position:0% $23,000 in total on their first order in November<00:01:36.079><c> then</c><00:01:36.320><c> within</c><00:01:36.560><c> the</c><00:01:36.720><c> first</c><00:01:37.000><c> 30</c><00:01:37.399><c> days</c> 00:01:37.990 --> 00:01:38.000 align:start position:0% November then within the first 30 days 00:01:38.000 --> 00:01:40.389 align:start position:0% November then within the first 30 days which<00:01:38.119><c> is</c><00:01:38.399><c> November</c><00:01:38.960><c> still</c><00:01:39.840><c> they</c><00:01:40.000><c> came</c><00:01:40.240><c> back</c> 00:01:40.389 --> 00:01:40.399 align:start position:0% which is November still they came back 00:01:40.399 --> 00:01:42.950 align:start position:0% which is November still they came back and<00:01:40.520><c> spent</c><00:01:40.880><c> an</c><00:01:41.079><c> additional</c> 00:01:42.950 --> 00:01:42.960 align:start position:0% and spent an additional 00:01:42.960 --> 00:01:47.709 align:start position:0% and spent an additional 12,620<00:01:44.439><c> then</c><00:01:45.439><c> in</c><00:01:45.600><c> the</c><00:01:45.920><c> next</c><00:01:46.520><c> 30</c><00:01:46.960><c> days</c><00:01:47.600><c> they</c> 00:01:47.709 --> 00:01:47.719 align:start position:0% 12,620 then in the next 30 days they 00:01:47.719 --> 00:01:49.950 align:start position:0% 12,620 then in the next 30 days they went<00:01:47.920><c> and</c><00:01:48.040><c> spent</c><00:01:48.320><c> 177,000</c><00:01:49.240><c> then</c><00:01:49.360><c> in</c><00:01:49.520><c> the</c><00:01:49.719><c> next</c> 00:01:49.950 --> 00:01:49.960 align:start position:0% went and spent 177,000 then in the next 00:01:49.960 --> 00:01:51.630 align:start position:0% went and spent 177,000 then in the next 30-day<00:01:50.439><c> period</c><00:01:50.759><c> they</c><00:01:50.920><c> came</c><00:01:51.079><c> back</c><00:01:51.200><c> and</c><00:01:51.320><c> spent</c> 00:01:51.630 --> 00:01:51.640 align:start position:0% 30-day period they came back and spent 00:01:51.640 --> 00:01:53.510 align:start position:0% 30-day period they came back and spent 13,000<00:01:52.399><c> in</c><00:01:52.520><c> the</c><00:01:52.640><c> next</c><00:01:52.799><c> 30-day</c><00:01:53.159><c> period</c><00:01:53.399><c> they</c> 00:01:53.510 --> 00:01:53.520 align:start position:0% 13,000 in the next 30-day period they 00:01:53.520 --> 00:01:56.069 align:start position:0% 13,000 in the next 30-day period they came<00:01:53.640><c> back</c><00:01:53.759><c> and</c><00:01:53.920><c> spent</c><00:01:54.200><c> about</c><00:01:54.799><c> 7,000</c><00:01:55.799><c> so</c><00:01:55.920><c> to</c> 00:01:56.069 --> 00:01:56.079 align:start position:0% came back and spent about 7,000 so to 00:01:56.079 --> 00:01:57.510 align:start position:0% came back and spent about 7,000 so to simplify<00:01:56.520><c> this</c><00:01:56.719><c> even</c><00:01:56.960><c> further</c><00:01:57.280><c> when</c><00:01:57.399><c> we're</c> 00:01:57.510 --> 00:01:57.520 align:start position:0% simplify this even further when we're 00:01:57.520 --> 00:01:59.429 align:start position:0% simplify this even further when we're looking<00:01:57.719><c> at</c><00:01:57.920><c> month</c><00:01:58.240><c> one</c><00:01:58.759><c> what</c><00:01:58.880><c> this</c><00:01:59.000><c> means</c><00:01:59.240><c> is</c> 00:01:59.429 --> 00:01:59.439 align:start position:0% looking at month one what this means is 00:01:59.439 --> 00:02:00.389 align:start position:0% looking at month one what this means is December 00:02:00.389 --> 00:02:00.399 align:start position:0% December 00:02:00.399 --> 00:02:03.510 align:start position:0% December 2022<00:02:01.399><c> so</c><00:02:01.560><c> in</c><00:02:01.680><c> the</c><00:02:01.840><c> month</c><00:02:02.119><c> of</c><00:02:02.320><c> December</c> 00:02:03.510 --> 00:02:03.520 align:start position:0% 2022 so in the month of December 00:02:03.520 --> 00:02:07.069 align:start position:0% 2022 so in the month of December 2022<00:02:04.520><c> the</c><00:02:04.759><c> November</c><00:02:05.479><c> cohort</c><00:02:06.479><c> the</c><00:02:06.640><c> November</c> 00:02:07.069 --> 00:02:07.079 align:start position:0% 2022 the November cohort the November 00:02:07.079 --> 00:02:08.790 align:start position:0% 2022 the November cohort the November customers<00:02:07.799><c> first</c><00:02:08.039><c> time</c><00:02:08.200><c> buying</c><00:02:08.479><c> was</c><00:02:08.640><c> in</c> 00:02:08.790 --> 00:02:08.800 align:start position:0% customers first time buying was in 00:02:08.800 --> 00:02:11.390 align:start position:0% customers first time buying was in November<00:02:09.599><c> they</c><00:02:09.800><c> came</c><00:02:10.039><c> back</c><00:02:10.200><c> and</c><00:02:10.479><c> bought</c><00:02:11.239><c> and</c> 00:02:11.390 --> 00:02:11.400 align:start position:0% November they came back and bought and 00:02:11.400 --> 00:02:13.070 align:start position:0% November they came back and bought and spent<00:02:11.720><c> another</c> 00:02:13.070 --> 00:02:13.080 align:start position:0% spent another 00:02:13.080 --> 00:02:15.350 align:start position:0% spent another $177,000<00:02:14.080><c> we</c><00:02:14.239><c> move</c><00:02:14.480><c> along</c><00:02:14.920><c> this</c><00:02:15.040><c> would</c><00:02:15.200><c> then</c> 00:02:15.350 --> 00:02:15.360 align:start position:0% $177,000 we move along this would then 00:02:15.360 --> 00:02:18.390 align:start position:0% $177,000 we move along this would then be<00:02:15.560><c> January</c><00:02:16.560><c> 2023</c><00:02:17.560><c> they</c><00:02:17.720><c> came</c><00:02:18.000><c> back</c><00:02:18.160><c> and</c><00:02:18.280><c> they</c> 00:02:18.390 --> 00:02:18.400 align:start position:0% be January 2023 they came back and they 00:02:18.400 --> 00:02:20.430 align:start position:0% be January 2023 they came back and they spent 00:02:20.430 --> 00:02:20.440 align:start position:0% spent 00:02:20.440 --> 00:02:23.190 align:start position:0% spent 13,670<00:02:21.440><c> then</c><00:02:21.680><c> in</c><00:02:21.920><c> February</c><00:02:22.599><c> they</c><00:02:22.800><c> came</c><00:02:23.040><c> back</c> 00:02:23.190 --> 00:02:23.200 align:start position:0% 13,670 then in February they came back 00:02:23.200 --> 00:02:25.470 align:start position:0% 13,670 then in February they came back and<00:02:23.319><c> they</c><00:02:23.440><c> spent</c><00:02:23.760><c> $</c> 00:02:25.470 --> 00:02:25.480 align:start position:0% and they spent $ 00:02:25.480 --> 00:02:28.190 align:start position:0% and they spent $ 6,930<00:02:26.480><c> and</c><00:02:26.599><c> then</c><00:02:26.760><c> this</c><00:02:26.920><c> goes</c><00:02:27.160><c> on</c><00:02:27.319><c> and</c><00:02:27.480><c> on</c><00:02:28.000><c> so</c> 00:02:28.190 --> 00:02:28.200 align:start position:0% 6,930 and then this goes on and on so 00:02:28.200 --> 00:02:30.589 align:start position:0% 6,930 and then this goes on and on so what<00:02:28.280><c> you're</c><00:02:28.440><c> seeing</c><00:02:28.879><c> is</c><00:02:29.560><c> the</c><00:02:30.000><c> users</c><00:02:30.440><c> that</c> 00:02:30.589 --> 00:02:30.599 align:start position:0% what you're seeing is the users that 00:02:30.599 --> 00:02:32.589 align:start position:0% what you're seeing is the users that bought<00:02:30.840><c> for</c><00:02:30.959><c> the</c><00:02:31.080><c> first</c><00:02:31.280><c> time</c><00:02:31.400><c> in</c><00:02:31.599><c> November</c> 00:02:32.589 --> 00:02:32.599 align:start position:0% bought for the first time in November 00:02:32.599 --> 00:02:34.229 align:start position:0% bought for the first time in November what<00:02:32.760><c> was</c><00:02:32.920><c> their</c><00:02:33.120><c> spending</c><00:02:33.560><c> habits</c><00:02:33.959><c> after</c> 00:02:34.229 --> 00:02:34.239 align:start position:0% what was their spending habits after 00:02:34.239 --> 00:02:36.350 align:start position:0% what was their spending habits after that<00:02:35.000><c> did</c><00:02:35.200><c> they</c><00:02:35.360><c> come</c><00:02:35.599><c> back</c><00:02:35.800><c> and</c><00:02:35.920><c> if</c><00:02:36.040><c> they</c><00:02:36.200><c> did</c> 00:02:36.350 --> 00:02:36.360 align:start position:0% that did they come back and if they did 00:02:36.360 --> 00:02:39.390 align:start position:0% that did they come back and if they did come<00:02:36.599><c> back</c><00:02:36.879><c> how</c><00:02:37.040><c> much</c><00:02:37.239><c> did</c><00:02:37.440><c> they</c><00:02:37.560><c> spend</c><00:02:38.040><c> in</c> 00:02:39.390 --> 00:02:39.400 align:start position:0% come back how much did they spend in 00:02:39.400 --> 00:02:42.910 align:start position:0% come back how much did they spend in total<00:02:40.440><c> now</c><00:02:41.440><c> to</c><00:02:41.640><c> get</c><00:02:41.879><c> very</c><00:02:42.200><c> specific</c><00:02:42.720><c> and</c><00:02:42.840><c> you</c> 00:02:42.910 --> 00:02:42.920 align:start position:0% total now to get very specific and you 00:02:42.920 --> 00:02:44.910 align:start position:0% total now to get very specific and you can<00:02:43.200><c> interchange</c><00:02:43.879><c> this</c><00:02:44.080><c> sentence</c><00:02:44.560><c> depending</c> 00:02:44.910 --> 00:02:44.920 align:start position:0% can interchange this sentence depending 00:02:44.920 --> 00:02:48.309 align:start position:0% can interchange this sentence depending on<00:02:45.519><c> whichever</c><00:02:46.319><c> Ro</c><00:02:46.680><c> you're</c><00:02:46.920><c> looking</c><00:02:47.200><c> at</c><00:02:48.040><c> if</c><00:02:48.200><c> we</c> 00:02:48.309 --> 00:02:48.319 align:start position:0% on whichever Ro you're looking at if we 00:02:48.319 --> 00:02:50.869 align:start position:0% on whichever Ro you're looking at if we were<00:02:48.480><c> to</c><00:02:48.680><c> look</c><00:02:48.840><c> at</c><00:02:49.159><c> this</c><00:02:49.400><c> number</c><00:02:49.879><c> right</c><00:02:50.159><c> here</c> 00:02:50.869 --> 00:02:50.879 align:start position:0% were to look at this number right here 00:02:50.879 --> 00:02:52.910 align:start position:0% were to look at this number right here this<00:02:51.040><c> tells</c><00:02:51.360><c> us</c><00:02:51.879><c> that</c><00:02:52.040><c> the</c><00:02:52.280><c> customers</c><00:02:52.720><c> that</c> 00:02:52.910 --> 00:02:52.920 align:start position:0% this tells us that the customers that 00:02:52.920 --> 00:02:54.710 align:start position:0% this tells us that the customers that purchased<00:02:53.400><c> in</c><00:02:53.560><c> November</c> 00:02:54.710 --> 00:02:54.720 align:start position:0% purchased in November 00:02:54.720 --> 00:02:57.830 align:start position:0% purchased in November 2022<00:02:55.720><c> came</c><00:02:55.959><c> back</c><00:02:56.120><c> and</c><00:02:56.280><c> spent</c> 00:02:57.830 --> 00:02:57.840 align:start position:0% 2022 came back and spent 00:02:57.840 --> 00:03:00.470 align:start position:0% 2022 came back and spent 13,670<00:02:58.840><c> in</c><00:02:59.120><c> January</c> 00:03:00.470 --> 00:03:00.480 align:start position:0% 13,670 in January 00:03:00.480 --> 00:03:04.589 align:start position:0% 13,670 in January 2023<00:03:01.480><c> this</c><00:03:01.599><c> should</c><00:03:02.360><c> say</c><00:03:03.360><c> now</c><00:03:03.959><c> from</c><00:03:04.280><c> that</c> 00:03:04.589 --> 00:03:04.599 align:start position:0% 2023 this should say now from that 00:03:04.599 --> 00:03:07.270 align:start position:0% 2023 this should say now from that looking<00:03:04.840><c> at</c><00:03:05.040><c> this</c><00:03:05.519><c> horizontally</c><00:03:06.519><c> what</c><00:03:06.840><c> can</c><00:03:07.040><c> we</c> 00:03:07.270 --> 00:03:07.280 align:start position:0% looking at this horizontally what can we 00:03:07.280 --> 00:03:09.350 align:start position:0% looking at this horizontally what can we start<00:03:07.720><c> to</c><00:03:07.920><c> take</c><00:03:08.120><c> away</c><00:03:08.440><c> what</c><00:03:08.519><c> are</c><00:03:08.680><c> the</c><00:03:08.840><c> insights</c> 00:03:09.350 --> 00:03:09.360 align:start position:0% start to take away what are the insights 00:03:09.360 --> 00:03:10.670 align:start position:0% start to take away what are the insights and<00:03:09.560><c> how</c><00:03:09.680><c> can</c><00:03:09.799><c> we</c><00:03:09.959><c> then</c><00:03:10.120><c> go</c><00:03:10.239><c> ahead</c><00:03:10.519><c> and</c> 00:03:10.670 --> 00:03:10.680 align:start position:0% and how can we then go ahead and 00:03:10.680 --> 00:03:12.789 align:start position:0% and how can we then go ahead and actually<00:03:10.959><c> apply</c><00:03:11.280><c> these</c><00:03:11.440><c> into</c><00:03:11.680><c> the</c><00:03:11.799><c> business</c> 00:03:12.789 --> 00:03:12.799 align:start position:0% actually apply these into the business 00:03:12.799 --> 00:03:14.789 align:start position:0% actually apply these into the business well<00:03:13.000><c> the</c><00:03:13.200><c> first</c><00:03:13.519><c> major</c><00:03:13.920><c> Insight</c><00:03:14.360><c> looking</c><00:03:14.599><c> at</c> 00:03:14.789 --> 00:03:14.799 align:start position:0% well the first major Insight looking at 00:03:14.799 --> 00:03:16.630 align:start position:0% well the first major Insight looking at these<00:03:15.000><c> numbers</c><00:03:15.560><c> across</c><00:03:15.920><c> the</c><00:03:16.080><c> horizontal</c> 00:03:16.630 --> 00:03:16.640 align:start position:0% these numbers across the horizontal 00:03:16.640 --> 00:03:19.589 align:start position:0% these numbers across the horizontal plane<00:03:17.200><c> is</c><00:03:18.120><c> there's</c><00:03:18.319><c> a</c><00:03:18.560><c> huge</c><00:03:18.879><c> drop</c><00:03:19.159><c> off</c><00:03:19.280><c> in</c> 00:03:19.589 --> 00:03:19.599 align:start position:0% plane is there's a huge drop off in 00:03:19.599 --> 00:03:21.589 align:start position:0% plane is there's a huge drop off in return<00:03:19.879><c> Revenue</c><00:03:20.519><c> at</c><00:03:20.640><c> the</c><00:03:20.760><c> month</c><00:03:21.040><c> three</c><00:03:21.319><c> Mark</c> 00:03:21.589 --> 00:03:21.599 align:start position:0% return Revenue at the month three Mark 00:03:21.599 --> 00:03:24.750 align:start position:0% return Revenue at the month three Mark onwards<00:03:22.519><c> in</c><00:03:22.680><c> month</c><00:03:22.959><c> one</c><00:03:23.360><c> we</c><00:03:23.480><c> get</c><00:03:23.720><c> 177,000</c><00:03:24.640><c> then</c> 00:03:24.750 --> 00:03:24.760 align:start position:0% onwards in month one we get 177,000 then 00:03:24.760 --> 00:03:27.030 align:start position:0% onwards in month one we get 177,000 then we<00:03:24.840><c> get</c><00:03:25.000><c> 13,000</c><00:03:25.720><c> so</c><00:03:25.840><c> it's</c><00:03:25.959><c> a</c><00:03:26.040><c> bit</c><00:03:26.159><c> of</c><00:03:26.239><c> a</c><00:03:26.400><c> dip</c><00:03:26.920><c> and</c> 00:03:27.030 --> 00:03:27.040 align:start position:0% we get 13,000 so it's a bit of a dip and 00:03:27.040 --> 00:03:28.550 align:start position:0% we get 13,000 so it's a bit of a dip and then<00:03:27.159><c> there's</c><00:03:27.280><c> a</c><00:03:27.480><c> significant</c><00:03:28.080><c> drop</c><00:03:28.319><c> off</c> 00:03:28.550 --> 00:03:28.560 align:start position:0% then there's a significant drop off 00:03:28.560 --> 00:03:30.670 align:start position:0% then there's a significant drop off about<00:03:28.760><c> 50%</c><00:03:29.480><c> and</c><00:03:29.879><c> that</c><00:03:29.959><c> maintains</c><00:03:30.439><c> for</c><00:03:30.560><c> a</c> 00:03:30.670 --> 00:03:30.680 align:start position:0% about 50% and that maintains for a 00:03:30.680 --> 00:03:32.470 align:start position:0% about 50% and that maintains for a little<00:03:30.840><c> bit</c><00:03:31.000><c> and</c><00:03:31.080><c> then</c><00:03:31.200><c> it</c><00:03:31.280><c> drops</c><00:03:31.599><c> another</c><00:03:31.879><c> 50%</c> 00:03:32.470 --> 00:03:32.480 align:start position:0% little bit and then it drops another 50% 00:03:32.480 --> 00:03:35.429 align:start position:0% little bit and then it drops another 50% and<00:03:32.599><c> then</c><00:03:32.760><c> another</c><00:03:33.480><c> 50%</c><00:03:34.480><c> so</c><00:03:34.640><c> the</c><00:03:34.799><c> question</c><00:03:35.120><c> is</c> 00:03:35.429 --> 00:03:35.439 align:start position:0% and then another 50% so the question is 00:03:35.439 --> 00:03:37.830 align:start position:0% and then another 50% so the question is why<00:03:35.640><c> does</c><00:03:35.879><c> returning</c><00:03:36.760><c> customer</c><00:03:37.239><c> Revenue</c> 00:03:37.830 --> 00:03:37.840 align:start position:0% why does returning customer Revenue 00:03:37.840 --> 00:03:40.869 align:start position:0% why does returning customer Revenue Harve<00:03:38.720><c> after</c><00:03:39.000><c> the</c><00:03:39.120><c> 90day</c><00:03:39.720><c> mark</c><00:03:40.400><c> because</c><00:03:40.599><c> if</c><00:03:40.720><c> we</c> 00:03:40.869 --> 00:03:40.879 align:start position:0% Harve after the 90day mark because if we 00:03:40.879 --> 00:03:42.789 align:start position:0% Harve after the 90day mark because if we can<00:03:41.080><c> prevent</c><00:03:41.360><c> it</c><00:03:41.519><c> from</c><00:03:41.720><c> harving</c><00:03:42.400><c> even</c><00:03:42.599><c> for</c> 00:03:42.789 --> 00:03:42.799 align:start position:0% can prevent it from harving even for 00:03:42.799 --> 00:03:45.030 align:start position:0% can prevent it from harving even for just<00:03:43.040><c> one</c><00:03:43.280><c> extra</c><00:03:43.640><c> month</c><00:03:44.519><c> then</c><00:03:44.680><c> that's</c><00:03:44.879><c> going</c> 00:03:45.030 --> 00:03:45.040 align:start position:0% just one extra month then that's going 00:03:45.040 --> 00:03:47.710 align:start position:0% just one extra month then that's going to<00:03:45.159><c> unlock</c><00:03:45.480><c> an</c><00:03:45.640><c> additional</c><00:03:46.040><c> $6</c><00:03:46.400><c> to</c><00:03:46.560><c> $7,000</c><00:03:47.560><c> of</c> 00:03:47.710 --> 00:03:47.720 align:start position:0% to unlock an additional $6 to $7,000 of 00:03:47.720 --> 00:03:50.110 align:start position:0% to unlock an additional $6 to $7,000 of Revenue<00:03:48.519><c> every</c><00:03:48.760><c> month</c><00:03:49.080><c> from</c><00:03:49.319><c> every</c><00:03:49.560><c> new</c> 00:03:50.110 --> 00:03:50.120 align:start position:0% Revenue every month from every new 00:03:50.120 --> 00:03:52.030 align:start position:0% Revenue every month from every new customer<00:03:50.560><c> cohort</c><00:03:51.040><c> that</c><00:03:51.159><c> we</c> 00:03:52.030 --> 00:03:52.040 align:start position:0% customer cohort that we 00:03:52.040 --> 00:03:54.149 align:start position:0% customer cohort that we generate<00:03:53.040><c> the</c><00:03:53.200><c> answer</c><00:03:53.400><c> to</c><00:03:53.560><c> this</c><00:03:53.720><c> is</c><00:03:53.920><c> quite</c> 00:03:54.149 --> 00:03:54.159 align:start position:0% generate the answer to this is quite 00:03:54.159 --> 00:03:56.190 align:start position:0% generate the answer to this is quite simple<00:03:54.640><c> this</c><00:03:54.879><c> client</c><00:03:55.280><c> runs</c><00:03:55.560><c> a</c><00:03:55.840><c> diet-based</c> 00:03:56.190 --> 00:03:56.200 align:start position:0% simple this client runs a diet-based 00:03:56.200 --> 00:03:59.830 align:start position:0% simple this client runs a diet-based product<00:03:57.159><c> and</c><00:03:57.280><c> the</c><00:03:57.519><c> diet</c><00:03:57.799><c> only</c><00:03:58.079><c> lasts</c><00:03:58.400><c> 90</c><00:03:58.799><c> days</c> 00:03:59.830 --> 00:03:59.840 align:start position:0% product and the diet only lasts 90 days 00:03:59.840 --> 00:04:01.550 align:start position:0% product and the diet only lasts 90 days so<00:04:00.040><c> the</c><00:04:00.159><c> question</c><00:04:00.480><c> then</c><00:04:00.640><c> is</c><00:04:01.040><c> how</c><00:04:01.200><c> can</c><00:04:01.360><c> we</c> 00:04:01.550 --> 00:04:01.560 align:start position:0% so the question then is how can we 00:04:01.560 --> 00:04:03.910 align:start position:0% so the question then is how can we extend<00:04:01.920><c> the</c><00:04:02.079><c> LTV</c><00:04:02.799><c> past</c><00:04:03.000><c> the</c><00:04:03.159><c> diet's</c><00:04:03.519><c> length</c> 00:04:03.910 --> 00:04:03.920 align:start position:0% extend the LTV past the diet's length 00:04:03.920 --> 00:04:05.869 align:start position:0% extend the LTV past the diet's length what<00:04:04.040><c> can</c><00:04:04.200><c> we</c><00:04:04.360><c> do</c><00:04:04.599><c> how</c><00:04:04.720><c> can</c><00:04:04.840><c> we</c><00:04:04.959><c> be</c><00:04:05.159><c> clever</c><00:04:05.760><c> with</c> 00:04:05.869 --> 00:04:05.879 align:start position:0% what can we do how can we be clever with 00:04:05.879 --> 00:04:07.470 align:start position:0% what can we do how can we be clever with our<00:04:06.159><c> positioning</c><00:04:06.680><c> with</c><00:04:06.879><c> potential</c><00:04:07.239><c> new</c> 00:04:07.470 --> 00:04:07.480 align:start position:0% our positioning with potential new 00:04:07.480 --> 00:04:09.630 align:start position:0% our positioning with potential new product<00:04:07.799><c> launches</c><00:04:08.640><c> so</c><00:04:08.840><c> that</c><00:04:08.959><c> we</c><00:04:09.079><c> can</c><00:04:09.280><c> continue</c> 00:04:09.630 --> 00:04:09.640 align:start position:0% product launches so that we can continue 00:04:09.640 --> 00:04:11.710 align:start position:0% product launches so that we can continue to<00:04:09.799><c> get</c><00:04:10.000><c> Revenue</c><00:04:10.480><c> out</c><00:04:10.599><c> of</c><00:04:10.840><c> these</c><00:04:11.079><c> customers</c> 00:04:11.710 --> 00:04:11.720 align:start position:0% to get Revenue out of these customers 00:04:11.720 --> 00:04:14.149 align:start position:0% to get Revenue out of these customers even<00:04:12.040><c> after</c><00:04:12.360><c> they've</c><00:04:12.599><c> finished</c><00:04:12.920><c> the</c><00:04:13.120><c> diet</c><00:04:14.000><c> can</c> 00:04:14.149 --> 00:04:14.159 align:start position:0% even after they've finished the diet can 00:04:14.159 --> 00:04:15.789 align:start position:0% even after they've finished the diet can we<00:04:14.319><c> have</c><00:04:14.519><c> some</c><00:04:14.760><c> kind</c><00:04:14.920><c> of</c><00:04:15.159><c> Maintenance</c> 00:04:15.789 --> 00:04:15.799 align:start position:0% we have some kind of Maintenance 00:04:15.799 --> 00:04:18.069 align:start position:0% we have some kind of Maintenance protocol<00:04:16.639><c> that</c><00:04:16.799><c> they</c><00:04:16.919><c> can</c><00:04:17.120><c> hop</c><00:04:17.359><c> on</c><00:04:17.759><c> that</c><00:04:17.919><c> then</c> 00:04:18.069 --> 00:04:18.079 align:start position:0% protocol that they can hop on that then 00:04:18.079 --> 00:04:21.469 align:start position:0% protocol that they can hop on that then increases<00:04:18.519><c> the</c><00:04:18.680><c> LTV</c><00:04:19.680><c> is</c><00:04:19.919><c> there</c><00:04:20.560><c> a</c><00:04:20.840><c> different</c> 00:04:21.469 --> 00:04:21.479 align:start position:0% increases the LTV is there a different 00:04:21.479 --> 00:04:22.830 align:start position:0% increases the LTV is there a different diet<00:04:21.799><c> that</c><00:04:21.919><c> they</c><00:04:22.040><c> should</c><00:04:22.240><c> then</c><00:04:22.360><c> be</c><00:04:22.520><c> running</c> 00:04:22.830 --> 00:04:22.840 align:start position:0% diet that they should then be running 00:04:22.840 --> 00:04:25.189 align:start position:0% diet that they should then be running into<00:04:23.280><c> after</c><00:04:23.639><c> this</c><00:04:23.800><c> one</c><00:04:24.400><c> there's</c><00:04:24.720><c> obviously</c> 00:04:25.189 --> 00:04:25.199 align:start position:0% into after this one there's obviously 00:04:25.199 --> 00:04:26.510 align:start position:0% into after this one there's obviously hundreds<00:04:25.520><c> of</c><00:04:25.680><c> different</c><00:04:25.919><c> answers</c><00:04:26.280><c> here</c><00:04:26.400><c> and</c> 00:04:26.510 --> 00:04:26.520 align:start position:0% hundreds of different answers here and 00:04:26.520 --> 00:04:28.310 align:start position:0% hundreds of different answers here and there's<00:04:26.720><c> hundreds</c><00:04:27.000><c> of</c><00:04:27.199><c> different</c><00:04:27.840><c> analyses</c> 00:04:28.310 --> 00:04:28.320 align:start position:0% there's hundreds of different analyses 00:04:28.320 --> 00:04:29.909 align:start position:0% there's hundreds of different analyses that<00:04:28.440><c> need</c><00:04:28.560><c> to</c><00:04:28.639><c> be</c><00:04:28.800><c> done</c><00:04:29.000><c> to</c><00:04:29.120><c> determine</c><00:04:29.720><c> what</c> 00:04:29.909 --> 00:04:29.919 align:start position:0% that need to be done to determine what 00:04:29.919 --> 00:04:32.590 align:start position:0% that need to be done to determine what the<00:04:30.160><c> best</c><00:04:30.639><c> course</c><00:04:30.880><c> of</c><00:04:31.120><c> action</c><00:04:31.440><c> is</c><00:04:32.199><c> but</c><00:04:32.400><c> that</c><00:04:32.479><c> is</c> 00:04:32.590 --> 00:04:32.600 align:start position:0% the best course of action is but that is 00:04:32.600 --> 00:04:34.390 align:start position:0% the best course of action is but that is the<00:04:32.800><c> primary</c><00:04:33.160><c> reason</c><00:04:33.440><c> is</c><00:04:33.560><c> to</c><00:04:33.720><c> why</c><00:04:33.880><c> LTV</c><00:04:34.280><c> is</c> 00:04:34.390 --> 00:04:34.400 align:start position:0% the primary reason is to why LTV is 00:04:34.400 --> 00:04:36.150 align:start position:0% the primary reason is to why LTV is dropping<00:04:34.800><c> so</c><00:04:34.919><c> if</c><00:04:35.000><c> we</c><00:04:35.120><c> can</c><00:04:35.280><c> fix</c><00:04:35.600><c> this</c><00:04:35.880><c> we</c><00:04:35.960><c> can</c> 00:04:36.150 --> 00:04:36.160 align:start position:0% dropping so if we can fix this we can 00:04:36.160 --> 00:04:39.870 align:start position:0% dropping so if we can fix this we can immediately<00:04:36.759><c> add</c><00:04:37.360><c> 20</c><00:04:37.880><c> 30,000</c><00:04:38.680><c> per</c><00:04:38.880><c> month</c><00:04:39.400><c> to</c> 00:04:39.870 --> 00:04:39.880 align:start position:0% immediately add 20 30,000 per month to 00:04:39.880 --> 00:04:41.270 align:start position:0% immediately add 20 30,000 per month to existing<00:04:40.280><c> customers</c><00:04:40.680><c> that</c><00:04:40.800><c> we're</c><00:04:41.000><c> already</c> 00:04:41.270 --> 00:04:41.280 align:start position:0% existing customers that we're already 00:04:41.280 --> 00:04:43.189 align:start position:0% existing customers that we're already bringing<00:04:41.600><c> in</c><00:04:41.720><c> the</c><00:04:41.840><c> door</c><00:04:42.560><c> so</c><00:04:42.759><c> this</c><00:04:42.880><c> would</c><00:04:43.039><c> just</c> 00:04:43.189 --> 00:04:43.199 align:start position:0% bringing in the door so this would just 00:04:43.199 --> 00:04:45.430 align:start position:0% bringing in the door so this would just be<00:04:43.440><c> unlocking</c><00:04:44.320><c> Revenue</c><00:04:44.720><c> that's</c><00:04:44.960><c> just</c><00:04:45.120><c> sitting</c> 00:04:45.430 --> 00:04:45.440 align:start position:0% be unlocking Revenue that's just sitting 00:04:45.440 --> 00:04:49.189 align:start position:0% be unlocking Revenue that's just sitting here<00:04:46.199><c> by</c><00:04:46.400><c> improving</c><00:04:47.000><c> this</c> 00:04:49.189 --> 00:04:49.199 align:start position:0% 00:04:49.199 --> 00:04:52.629 align:start position:0% ltp<00:04:50.199><c> let's</c><00:04:50.440><c> look</c><00:04:51.120><c> vertically</c><00:04:52.120><c> so</c><00:04:52.280><c> if</c><00:04:52.360><c> we</c><00:04:52.520><c> look</c> 00:04:52.629 --> 00:04:52.639 align:start position:0% ltp let's look vertically so if we look 00:04:52.639 --> 00:04:55.950 align:start position:0% ltp let's look vertically so if we look at<00:04:52.759><c> this</c><00:04:52.960><c> customer</c><00:04:53.320><c> cohort</c><00:04:54.080><c> analysis</c><00:04:55.080><c> up</c><00:04:55.320><c> and</c> 00:04:55.950 --> 00:04:55.960 align:start position:0% at this customer cohort analysis up and 00:04:55.960 --> 00:04:58.550 align:start position:0% at this customer cohort analysis up and down<00:04:56.960><c> and</c><00:04:57.120><c> once</c><00:04:57.320><c> again</c><00:04:57.680><c> let's</c><00:04:57.960><c> shrink</c><00:04:58.400><c> the</c> 00:04:58.550 --> 00:04:58.560 align:start position:0% down and once again let's shrink the 00:04:58.560 --> 00:05:00.830 align:start position:0% down and once again let's shrink the data<00:04:58.880><c> here</c><00:04:59.080><c> and</c><00:04:59.320><c> just</c><00:04:59.720><c> look</c><00:04:59.840><c> at</c><00:05:00.000><c> this</c><00:05:00.160><c> leftand</c> 00:05:00.830 --> 00:05:00.840 align:start position:0% data here and just look at this leftand 00:05:00.840 --> 00:05:02.670 align:start position:0% data here and just look at this leftand column<00:05:01.840><c> the</c><00:05:02.000><c> first</c><00:05:02.240><c> thing</c><00:05:02.360><c> that</c><00:05:02.479><c> you'll</c> 00:05:02.670 --> 00:05:02.680 align:start position:0% column the first thing that you'll 00:05:02.680 --> 00:05:06.070 align:start position:0% column the first thing that you'll notice<00:05:03.120><c> is</c><00:05:03.320><c> that</c><00:05:03.520><c> net</c><00:05:03.840><c> sales</c><00:05:04.840><c> decline</c><00:05:05.840><c> as</c><00:05:05.960><c> you</c> 00:05:06.070 --> 00:05:06.080 align:start position:0% notice is that net sales decline as you 00:05:06.080 --> 00:05:08.909 align:start position:0% notice is that net sales decline as you look<00:05:06.280><c> backwards</c><00:05:06.680><c> in</c><00:05:06.919><c> time</c><00:05:07.720><c> now</c><00:05:08.280><c> if</c><00:05:08.360><c> you</c><00:05:08.560><c> graph</c> 00:05:08.909 --> 00:05:08.919 align:start position:0% look backwards in time now if you graph 00:05:08.919 --> 00:05:10.150 align:start position:0% look backwards in time now if you graph this<00:05:09.039><c> as</c><00:05:09.199><c> well</c><00:05:09.400><c> which</c><00:05:09.520><c> you</c><00:05:09.600><c> can</c><00:05:09.720><c> see</c><00:05:09.880><c> on</c><00:05:10.000><c> the</c> 00:05:10.150 --> 00:05:10.160 align:start position:0% this as well which you can see on the 00:05:10.160 --> 00:05:11.590 align:start position:0% this as well which you can see on the right<00:05:10.400><c> it</c><00:05:10.520><c> looks</c><00:05:10.680><c> like</c><00:05:10.840><c> sales</c><00:05:11.160><c> are</c><00:05:11.320><c> falling</c> 00:05:11.590 --> 00:05:11.600 align:start position:0% right it looks like sales are falling 00:05:11.600 --> 00:05:14.070 align:start position:0% right it looks like sales are falling off<00:05:11.759><c> a</c><00:05:11.919><c> cliff</c><00:05:12.759><c> it's</c><00:05:13.000><c> important</c><00:05:13.360><c> to</c><00:05:13.560><c> note</c><00:05:13.919><c> here</c> 00:05:14.070 --> 00:05:14.080 align:start position:0% off a cliff it's important to note here 00:05:14.080 --> 00:05:16.310 align:start position:0% off a cliff it's important to note here that<00:05:14.280><c> this</c><00:05:14.400><c> is</c><00:05:14.759><c> not</c><00:05:15.240><c> the</c><00:05:15.400><c> sale</c><00:05:15.720><c> numbers</c><00:05:16.120><c> these</c> 00:05:16.310 --> 00:05:16.320 align:start position:0% that this is not the sale numbers these 00:05:16.320 --> 00:05:17.790 align:start position:0% that this is not the sale numbers these guys<00:05:16.479><c> have</c><00:05:16.600><c> been</c><00:05:16.800><c> consistent</c><00:05:17.320><c> for</c><00:05:17.479><c> the</c><00:05:17.600><c> last</c> 00:05:17.790 --> 00:05:17.800 align:start position:0% guys have been consistent for the last 00:05:17.800 --> 00:05:20.150 align:start position:0% guys have been consistent for the last year<00:05:17.960><c> their</c><00:05:18.120><c> revenue</c><00:05:18.520><c> has</c><00:05:18.680><c> stayed</c><00:05:19.039><c> stable</c><00:05:19.960><c> the</c> 00:05:20.150 --> 00:05:20.160 align:start position:0% year their revenue has stayed stable the 00:05:20.160 --> 00:05:22.870 align:start position:0% year their revenue has stayed stable the reason<00:05:20.639><c> why</c><00:05:20.919><c> revenue</c><00:05:21.479><c> is</c><00:05:21.759><c> dropping</c><00:05:22.600><c> as</c><00:05:22.680><c> you</c> 00:05:22.870 --> 00:05:22.880 align:start position:0% reason why revenue is dropping as you 00:05:22.880 --> 00:05:25.629 align:start position:0% reason why revenue is dropping as you come<00:05:23.160><c> forward</c><00:05:24.160><c> is</c><00:05:24.440><c> because</c><00:05:24.960><c> if</c><00:05:25.080><c> we</c><00:05:25.240><c> look</c><00:05:25.440><c> down</c> 00:05:25.629 --> 00:05:25.639 align:start position:0% come forward is because if we look down 00:05:25.639 --> 00:05:29.590 align:start position:0% come forward is because if we look down the<00:05:25.800><c> bottom</c><00:05:26.280><c> here</c><00:05:27.280><c> this</c><00:05:28.080><c> October</c><00:05:28.680><c> cohort</c> 00:05:29.590 --> 00:05:29.600 align:start position:0% the bottom here this October cohort 00:05:29.600 --> 00:05:31.510 align:start position:0% the bottom here this October cohort hasn't<00:05:29.919><c> had</c><00:05:30.160><c> time</c><00:05:30.360><c> to</c><00:05:30.600><c> come</c><00:05:30.800><c> back</c><00:05:30.960><c> and</c><00:05:31.160><c> repeat</c> 00:05:31.510 --> 00:05:31.520 align:start position:0% hasn't had time to come back and repeat 00:05:31.520 --> 00:05:34.430 align:start position:0% hasn't had time to come back and repeat purchase<00:05:32.000><c> yet</c><00:05:32.800><c> so</c><00:05:33.000><c> all</c><00:05:33.199><c> we're</c><00:05:33.400><c> seeing</c><00:05:33.960><c> is</c> 00:05:34.430 --> 00:05:34.440 align:start position:0% purchase yet so all we're seeing is 00:05:34.440 --> 00:05:36.950 align:start position:0% purchase yet so all we're seeing is their<00:05:34.639><c> first</c><00:05:34.880><c> order</c><00:05:35.639><c> Revenue</c><00:05:36.639><c> we're</c><00:05:36.800><c> not</c> 00:05:36.950 --> 00:05:36.960 align:start position:0% their first order Revenue we're not 00:05:36.960 --> 00:05:39.029 align:start position:0% their first order Revenue we're not seeing<00:05:37.280><c> any</c><00:05:37.479><c> of</c><00:05:37.720><c> the</c><00:05:37.840><c> returning</c><00:05:38.280><c> order</c> 00:05:39.029 --> 00:05:39.039 align:start position:0% seeing any of the returning order 00:05:39.039 --> 00:05:43.270 align:start position:0% seeing any of the returning order revenue<00:05:40.039><c> and</c><00:05:40.600><c> total</c><00:05:41.039><c> revenue</c><00:05:41.520><c> of</c><00:05:41.680><c> a</c><00:05:42.280><c> business</c> 00:05:43.270 --> 00:05:43.280 align:start position:0% revenue and total revenue of a business 00:05:43.280 --> 00:05:45.790 align:start position:0% revenue and total revenue of a business equals<00:05:44.199><c> and</c><00:05:44.360><c> let</c><00:05:44.479><c> me</c><00:05:45.000><c> pull</c><00:05:45.240><c> this</c><00:05:45.360><c> up</c><00:05:45.600><c> as</c><00:05:45.720><c> this</c> 00:05:45.790 --> 00:05:45.800 align:start position:0% equals and let me pull this up as this 00:05:45.800 --> 00:05:47.629 align:start position:0% equals and let me pull this up as this is<00:05:45.919><c> later</c><00:05:46.199><c> in</c><00:05:46.319><c> the</c><00:05:46.479><c> slides</c><00:05:46.880><c> here</c><00:05:47.360><c> total</c> 00:05:47.629 --> 00:05:47.639 align:start position:0% is later in the slides here total 00:05:47.639 --> 00:05:49.309 align:start position:0% is later in the slides here total revenue<00:05:47.919><c> in</c><00:05:48.039><c> the</c><00:05:48.120><c> business</c><00:05:48.520><c> equals</c><00:05:49.039><c> new</c> 00:05:49.309 --> 00:05:49.319 align:start position:0% revenue in the business equals new 00:05:49.319 --> 00:05:52.189 align:start position:0% revenue in the business equals new customer<00:05:49.759><c> Revenue</c><00:05:50.639><c> plus</c><00:05:51.000><c> existing</c><00:05:51.479><c> customer</c> 00:05:52.189 --> 00:05:52.199 align:start position:0% customer Revenue plus existing customer 00:05:52.199 --> 00:05:55.189 align:start position:0% customer Revenue plus existing customer revenue<00:05:53.199><c> and</c><00:05:53.639><c> because</c><00:05:54.039><c> we're</c><00:05:54.280><c> currently</c><00:05:54.840><c> only</c> 00:05:55.189 --> 00:05:55.199 align:start position:0% revenue and because we're currently only 00:05:55.199 --> 00:05:58.590 align:start position:0% revenue and because we're currently only looking<00:05:55.960><c> at</c><00:05:56.960><c> first</c><00:05:57.319><c> customer</c><00:05:57.720><c> Revenue</c><00:05:58.440><c> we're</c> 00:05:58.590 --> 00:05:58.600 align:start position:0% looking at first customer Revenue we're 00:05:58.600 --> 00:06:00.309 align:start position:0% looking at first customer Revenue we're not<00:05:58.759><c> seeing</c><00:05:59.039><c> all</c><00:05:59.160><c> of</c><00:05:59.280><c> the</c><00:05:59.560><c> rest</c><00:05:59.919><c> they</c><00:06:00.080><c> actually</c> 00:06:00.309 --> 00:06:00.319 align:start position:0% not seeing all of the rest they actually 00:06:00.319 --> 00:06:01.390 align:start position:0% not seeing all of the rest they actually did<00:06:00.520><c> about</c> 00:06:01.390 --> 00:06:01.400 align:start position:0% did about 00:06:01.400 --> 00:06:04.070 align:start position:0% did about $150,000<00:06:02.400><c> in</c><00:06:02.520><c> the</c><00:06:02.600><c> month</c><00:06:02.800><c> of</c><00:06:03.000><c> October</c><00:06:03.919><c> and</c> 00:06:04.070 --> 00:06:04.080 align:start position:0% $150,000 in the month of October and 00:06:04.080 --> 00:06:06.150 align:start position:0% $150,000 in the month of October and that<00:06:04.360><c> remaining</c><00:06:04.720><c> 110</c><00:06:05.440><c> that's</c><00:06:05.600><c> missing</c><00:06:05.919><c> from</c> 00:06:06.150 --> 00:06:06.160 align:start position:0% that remaining 110 that's missing from 00:06:06.160 --> 00:06:07.990 align:start position:0% that remaining 110 that's missing from this<00:06:06.639><c> is</c><00:06:06.759><c> all</c><00:06:07.000><c> customers</c><00:06:07.479><c> that</c><00:06:07.599><c> are</c><00:06:07.720><c> coming</c> 00:06:07.990 --> 00:06:08.000 align:start position:0% this is all customers that are coming 00:06:08.000 --> 00:06:10.070 align:start position:0% this is all customers that are coming back<00:06:08.120><c> and</c><00:06:08.400><c> returning</c><00:06:09.400><c> and</c><00:06:09.520><c> we'll</c><00:06:09.720><c> talk</c><00:06:09.880><c> about</c> 00:06:10.070 --> 00:06:10.080 align:start position:0% back and returning and we'll talk about 00:06:10.080 --> 00:06:11.589 align:start position:0% back and returning and we'll talk about that<00:06:10.240><c> later</c><00:06:10.560><c> and</c><00:06:10.680><c> how</c><00:06:10.840><c> that</c><00:06:11.000><c> ties</c><00:06:11.240><c> into</c><00:06:11.440><c> the</c> 00:06:11.589 --> 00:06:11.599 align:start position:0% that later and how that ties into the 00:06:11.599 --> 00:06:14.309 align:start position:0% that later and how that ties into the diagonal<00:06:12.240><c> analysis</c><00:06:13.240><c> but</c><00:06:13.440><c> that's</c><00:06:13.880><c> firstly</c> 00:06:14.309 --> 00:06:14.319 align:start position:0% diagonal analysis but that's firstly 00:06:14.319 --> 00:06:15.510 align:start position:0% diagonal analysis but that's firstly worth 00:06:15.510 --> 00:06:15.520 align:start position:0% worth 00:06:15.520 --> 00:06:17.510 align:start position:0% worth noting<00:06:16.520><c> diving</c><00:06:16.800><c> into</c><00:06:17.080><c> how</c><00:06:17.199><c> you</c><00:06:17.280><c> should</c> 00:06:17.510 --> 00:06:17.520 align:start position:0% noting diving into how you should 00:06:17.520 --> 00:06:20.150 align:start position:0% noting diving into how you should actually<00:06:17.759><c> be</c><00:06:17.960><c> looking</c><00:06:18.280><c> at</c><00:06:18.520><c> this</c><00:06:19.160><c> vertically</c> 00:06:20.150 --> 00:06:20.160 align:start position:0% actually be looking at this vertically 00:06:20.160 --> 00:06:24.309 align:start position:0% actually be looking at this vertically is<00:06:20.639><c> fairly</c><00:06:21.319><c> simple</c><00:06:22.319><c> as</c><00:06:22.440><c> you</c><00:06:22.639><c> move</c><00:06:23.199><c> down</c><00:06:24.199><c> you</c> 00:06:24.309 --> 00:06:24.319 align:start position:0% is fairly simple as you move down you 00:06:24.319 --> 00:06:26.909 align:start position:0% is fairly simple as you move down you will<00:06:24.599><c> see</c><00:06:25.599><c> the</c><00:06:25.800><c> date</c><00:06:26.039><c> range</c><00:06:26.280><c> move</c><00:06:26.560><c> down</c><00:06:26.759><c> and</c> 00:06:26.909 --> 00:06:26.919 align:start position:0% will see the date range move down and 00:06:26.919 --> 00:06:29.070 align:start position:0% will see the date range move down and you're<00:06:27.080><c> looking</c><00:06:27.319><c> at</c><00:06:27.400><c> a</c><00:06:27.520><c> different</c><00:06:27.840><c> cohort</c><00:06:28.840><c> so</c> 00:06:29.070 --> 00:06:29.080 align:start position:0% you're looking at a different cohort so 00:06:29.080 --> 00:06:30.870 align:start position:0% you're looking at a different cohort so up<00:06:29.240><c> here</c><00:06:29.800><c> we're</c><00:06:29.960><c> looking</c><00:06:30.199><c> at</c><00:06:30.319><c> the</c><00:06:30.440><c> November</c> 00:06:30.870 --> 00:06:30.880 align:start position:0% up here we're looking at the November 00:06:30.880 --> 00:06:33.309 align:start position:0% up here we're looking at the November cohort<00:06:31.720><c> in</c><00:06:31.800><c> the</c><00:06:31.960><c> first</c><00:06:32.199><c> 30</c><00:06:32.560><c> days</c><00:06:32.880><c> they</c><00:06:33.000><c> spent</c> 00:06:33.309 --> 00:06:33.319 align:start position:0% cohort in the first 30 days they spent 00:06:33.319 --> 00:06:35.350 align:start position:0% cohort in the first 30 days they spent 12,000<00:06:34.080><c> the</c><00:06:34.199><c> December</c><00:06:34.560><c> cohort</c><00:06:34.960><c> in</c><00:06:35.080><c> the</c><00:06:35.160><c> first</c> 00:06:35.350 --> 00:06:35.360 align:start position:0% 12,000 the December cohort in the first 00:06:35.360 --> 00:06:37.430 align:start position:0% 12,000 the December cohort in the first 30<00:06:35.680><c> days</c><00:06:35.919><c> they</c><00:06:36.080><c> came</c><00:06:36.240><c> back</c><00:06:36.400><c> and</c><00:06:36.479><c> spent</c><00:06:36.759><c> 2,000</c> 00:06:37.430 --> 00:06:37.440 align:start position:0% 30 days they came back and spent 2,000 00:06:37.440 --> 00:06:38.749 align:start position:0% 30 days they came back and spent 2,000 4,000 00:06:38.749 --> 00:06:38.759 align:start position:0% 4,000 00:06:38.759 --> 00:06:41.189 align:start position:0% 4,000 Etc<00:06:39.759><c> so</c><00:06:39.919><c> if</c><00:06:40.000><c> we're</c><00:06:40.160><c> to</c><00:06:40.280><c> zoom</c><00:06:40.520><c> in</c><00:06:40.720><c> on</c><00:06:41.000><c> for</c> 00:06:41.189 --> 00:06:41.199 align:start position:0% Etc so if we're to zoom in on for 00:06:41.199 --> 00:06:42.710 align:start position:0% Etc so if we're to zoom in on for example 00:06:42.710 --> 00:06:42.720 align:start position:0% example 00:06:42.720 --> 00:06:45.350 align:start position:0% example January<00:06:43.720><c> what</c><00:06:43.919><c> this</c><00:06:44.080><c> tells</c><00:06:44.400><c> us</c><00:06:44.759><c> is</c><00:06:45.120><c> the</c> 00:06:45.350 --> 00:06:45.360 align:start position:0% January what this tells us is the 00:06:45.360 --> 00:06:48.870 align:start position:0% January what this tells us is the customers<00:06:45.840><c> that</c><00:06:46.080><c> purchased</c><00:06:46.560><c> in</c><00:06:46.840><c> January</c><00:06:47.880><c> 2023</c> 00:06:48.870 --> 00:06:48.880 align:start position:0% customers that purchased in January 2023 00:06:48.880 --> 00:06:50.270 align:start position:0% customers that purchased in January 2023 spent 00:06:50.270 --> 00:06:50.280 align:start position:0% spent 00:06:50.280 --> 00:06:53.950 align:start position:0% spent $447<00:06:51.280><c> in</c><00:06:51.400><c> the</c><00:06:51.720><c> remainder</c><00:06:52.080><c> of</c><00:06:52.319><c> January</c><00:06:52.800><c> 2023</c><00:06:53.800><c> so</c> 00:06:53.950 --> 00:06:53.960 align:start position:0% $447 in the remainder of January 2023 so 00:06:53.960 --> 00:06:55.670 align:start position:0% $447 in the remainder of January 2023 so in<00:06:54.080><c> the</c><00:06:54.199><c> following</c><00:06:54.639><c> 30</c><00:06:55.000><c> days</c><00:06:55.280><c> from</c><00:06:55.479><c> their</c> 00:06:55.670 --> 00:06:55.680 align:start position:0% in the following 30 days from their 00:06:55.680 --> 00:06:58.390 align:start position:0% in the following 30 days from their first<00:06:56.000><c> purchase</c><00:06:57.000><c> they</c><00:06:57.160><c> spent</c><00:06:57.400><c> an</c><00:06:57.560><c> additional</c> 00:06:58.390 --> 00:06:58.400 align:start position:0% first purchase they spent an additional 00:06:58.400 --> 00:07:02.110 align:start position:0% first purchase they spent an additional 4,47<00:06:59.800><c> as</c><00:06:59.919><c> an</c><00:07:00.120><c> entire</c><00:07:00.599><c> cohort</c><00:07:01.560><c> all</c><00:07:01.680><c> of</c><00:07:01.879><c> those</c> 00:07:02.110 --> 00:07:02.120 align:start position:0% 4,47 as an entire cohort all of those 00:07:02.120 --> 00:07:04.230 align:start position:0% 4,47 as an entire cohort all of those customers<00:07:02.759><c> together</c><00:07:03.400><c> some</c><00:07:03.599><c> of</c><00:07:03.720><c> them</c><00:07:03.919><c> came</c> 00:07:04.230 --> 00:07:04.240 align:start position:0% customers together some of them came 00:07:04.240 --> 00:07:06.469 align:start position:0% customers together some of them came back<00:07:04.639><c> and</c><00:07:04.759><c> you</c><00:07:04.919><c> total</c><00:07:05.240><c> all</c><00:07:05.479><c> that</c><00:07:05.960><c> revenue</c><00:07:06.400><c> and</c> 00:07:06.469 --> 00:07:06.479 align:start position:0% back and you total all that revenue and 00:07:06.479 --> 00:07:09.790 align:start position:0% back and you total all that revenue and it<00:07:06.560><c> comes</c><00:07:06.720><c> to</c> 00:07:09.790 --> 00:07:09.800 align:start position:0% 00:07:09.800 --> 00:07:12.189 align:start position:0% 4,470<00:07:10.800><c> now</c><00:07:11.360><c> where</c><00:07:11.560><c> this</c><00:07:11.680><c> startes</c><00:07:11.919><c> to</c><00:07:12.080><c> get</c> 00:07:12.189 --> 00:07:12.199 align:start position:0% 4,470 now where this startes to get 00:07:12.199 --> 00:07:13.790 align:start position:0% 4,470 now where this startes to get interesting<00:07:12.599><c> and</c><00:07:12.720><c> I've</c><00:07:12.879><c> moved</c><00:07:13.199><c> over</c><00:07:13.479><c> from</c> 00:07:13.790 --> 00:07:13.800 align:start position:0% interesting and I've moved over from 00:07:13.800 --> 00:07:16.430 align:start position:0% interesting and I've moved over from month<00:07:14.120><c> zero</c><00:07:14.520><c> column</c><00:07:14.800><c> to</c><00:07:14.960><c> month</c><00:07:15.160><c> one</c><00:07:15.520><c> column</c><00:07:16.280><c> is</c> 00:07:16.430 --> 00:07:16.440 align:start position:0% month zero column to month one column is 00:07:16.440 --> 00:07:19.230 align:start position:0% month zero column to month one column is you<00:07:16.560><c> can</c><00:07:16.800><c> start</c><00:07:17.039><c> to</c><00:07:17.360><c> identify</c><00:07:18.160><c> Trends</c><00:07:19.039><c> and</c> 00:07:19.230 --> 00:07:19.240 align:start position:0% you can start to identify Trends and 00:07:19.240 --> 00:07:21.469 align:start position:0% you can start to identify Trends and pull<00:07:19.520><c> them</c><00:07:19.680><c> out</c><00:07:19.879><c> start</c><00:07:20.080><c> to</c><00:07:20.720><c> ask</c><00:07:21.000><c> questions</c><00:07:21.360><c> and</c> 00:07:21.469 --> 00:07:21.479 align:start position:0% pull them out start to ask questions and 00:07:21.479 --> 00:07:24.270 align:start position:0% pull them out start to ask questions and then<00:07:21.680><c> get</c><00:07:22.160><c> answers</c><00:07:23.160><c> because</c><00:07:23.479><c> it</c><00:07:23.599><c> shows</c><00:07:23.919><c> us</c> 00:07:24.270 --> 00:07:24.280 align:start position:0% then get answers because it shows us 00:07:24.280 --> 00:07:26.350 align:start position:0% then get answers because it shows us fluctuations<00:07:25.280><c> in</c><00:07:25.440><c> returning</c><00:07:25.960><c> customer</c> 00:07:26.350 --> 00:07:26.360 align:start position:0% fluctuations in returning customer 00:07:26.360 --> 00:07:27.909 align:start position:0% fluctuations in returning customer Revenue<00:07:26.879><c> over</c> 00:07:27.909 --> 00:07:27.919 align:start position:0% Revenue over 00:07:27.919 --> 00:07:30.950 align:start position:0% Revenue over time<00:07:28.919><c> for</c><00:07:29.080><c> example</c><00:07:29.360><c> example</c><00:07:30.280><c> the</c><00:07:30.440><c> month</c><00:07:30.720><c> one</c> 00:07:30.950 --> 00:07:30.960 align:start position:0% time for example example the month one 00:07:30.960 --> 00:07:33.029 align:start position:0% time for example example the month one returning<00:07:31.440><c> customer</c><00:07:31.879><c> Revenue</c><00:07:32.400><c> peaked</c><00:07:32.800><c> in</c> 00:07:33.029 --> 00:07:33.039 align:start position:0% returning customer Revenue peaked in 00:07:33.039 --> 00:07:34.309 align:start position:0% returning customer Revenue peaked in February 00:07:34.309 --> 00:07:34.319 align:start position:0% February 00:07:34.319 --> 00:07:37.390 align:start position:0% February 2023<00:07:35.319><c> why</c><00:07:35.479><c> is</c><00:07:35.639><c> that</c><00:07:35.840><c> the</c><00:07:36.000><c> case</c><00:07:36.879><c> why</c><00:07:37.039><c> did</c><00:07:37.199><c> we</c> 00:07:37.390 --> 00:07:37.400 align:start position:0% 2023 why is that the case why did we 00:07:37.400 --> 00:07:40.309 align:start position:0% 2023 why is that the case why did we have<00:07:37.680><c> such</c><00:07:37.919><c> a</c><00:07:38.160><c> good</c><00:07:38.759><c> return</c><00:07:39.080><c> customer</c><00:07:39.520><c> rate</c><00:07:40.080><c> in</c> 00:07:40.309 --> 00:07:40.319 align:start position:0% have such a good return customer rate in 00:07:40.319 --> 00:07:42.589 align:start position:0% have such a good return customer rate in February<00:07:41.120><c> well</c><00:07:41.800><c> firstly</c><00:07:42.199><c> because</c><00:07:42.440><c> we're</c> 00:07:42.589 --> 00:07:42.599 align:start position:0% February well firstly because we're 00:07:42.599 --> 00:07:44.230 align:start position:0% February well firstly because we're looking<00:07:42.800><c> at</c><00:07:42.960><c> Revenue</c><00:07:43.360><c> numbers</c><00:07:43.879><c> and</c><00:07:44.039><c> not</c> 00:07:44.230 --> 00:07:44.240 align:start position:0% looking at Revenue numbers and not 00:07:44.240 --> 00:07:46.589 align:start position:0% looking at Revenue numbers and not percentage<00:07:44.759><c> numbers</c><00:07:45.199><c> it's</c><00:07:45.400><c> going</c><00:07:45.560><c> to</c><00:07:45.879><c> skew</c> 00:07:46.589 --> 00:07:46.599 align:start position:0% percentage numbers it's going to skew 00:07:46.599 --> 00:07:49.029 align:start position:0% percentage numbers it's going to skew based<00:07:46.879><c> on</c><00:07:47.520><c> month-to-month</c><00:07:48.120><c> sale</c> 00:07:49.029 --> 00:07:49.039 align:start position:0% based on month-to-month sale 00:07:49.039 --> 00:07:51.110 align:start position:0% based on month-to-month sale fluctuations<00:07:50.039><c> so</c><00:07:50.240><c> generally</c><00:07:50.680><c> speaking</c><00:07:51.000><c> it</c> 00:07:51.110 --> 00:07:51.120 align:start position:0% fluctuations so generally speaking it 00:07:51.120 --> 00:07:53.350 align:start position:0% fluctuations so generally speaking it isn't<00:07:51.479><c> the</c><00:07:51.680><c> best</c><00:07:52.039><c> practice</c><00:07:52.400><c> to</c><00:07:52.520><c> be</c><00:07:52.680><c> looking</c><00:07:52.960><c> at</c> 00:07:53.350 --> 00:07:53.360 align:start position:0% isn't the best practice to be looking at 00:07:53.360 --> 00:07:55.350 align:start position:0% isn't the best practice to be looking at dollar<00:07:53.680><c> values</c><00:07:54.120><c> here</c><00:07:54.560><c> and</c><00:07:54.720><c> instead</c><00:07:55.039><c> we</c><00:07:55.159><c> should</c> 00:07:55.350 --> 00:07:55.360 align:start position:0% dollar values here and instead we should 00:07:55.360 --> 00:07:57.550 align:start position:0% dollar values here and instead we should be<00:07:55.520><c> looking</c><00:07:55.720><c> at</c><00:07:55.879><c> returning</c><00:07:56.759><c> customer</c> 00:07:57.550 --> 00:07:57.560 align:start position:0% be looking at returning customer 00:07:57.560 --> 00:08:00.070 align:start position:0% be looking at returning customer percentages<00:07:58.560><c> but</c><00:07:58.840><c> regardless</c><00:07:59.720><c> this</c><00:07:59.840><c> still</c> 00:08:00.070 --> 00:08:00.080 align:start position:0% percentages but regardless this still 00:08:00.080 --> 00:08:03.830 align:start position:0% percentages but regardless this still was<00:08:00.199><c> a</c><00:08:00.319><c> really</c><00:08:00.479><c> good</c><00:08:01.000><c> month</c><00:08:02.000><c> why</c><00:08:02.199><c> was</c><00:08:02.840><c> that</c> 00:08:03.830 --> 00:08:03.840 align:start position:0% was a really good month why was that 00:08:03.840 --> 00:08:05.990 align:start position:0% was a really good month why was that well<00:08:04.360><c> when</c><00:08:04.479><c> we</c><00:08:04.639><c> look</c><00:08:04.879><c> back</c><00:08:05.039><c> in</c><00:08:05.240><c> time</c><00:08:05.599><c> and</c><00:08:05.720><c> we</c><00:08:05.840><c> do</c> 00:08:05.990 --> 00:08:06.000 align:start position:0% well when we look back in time and we do 00:08:06.000 --> 00:08:08.029 align:start position:0% well when we look back in time and we do an<00:08:06.199><c> analysis</c><00:08:06.680><c> what</c><00:08:06.800><c> we'll</c><00:08:07.000><c> find</c><00:08:07.280><c> is</c><00:08:07.479><c> that</c><00:08:07.879><c> back</c> 00:08:08.029 --> 00:08:08.039 align:start position:0% an analysis what we'll find is that back 00:08:08.039 --> 00:08:09.710 align:start position:0% an analysis what we'll find is that back in<00:08:08.199><c> February</c><00:08:08.639><c> we</c><00:08:08.840><c> actually</c> 00:08:09.710 --> 00:08:09.720 align:start position:0% in February we actually 00:08:09.720 --> 00:08:13.029 align:start position:0% in February we actually sent<00:08:10.720><c> 5</c><00:08:11.000><c> adms</c><00:08:11.919><c> rather</c><00:08:12.159><c> than</c> 00:08:13.029 --> 00:08:13.039 align:start position:0% sent 5 adms rather than 00:08:13.039 --> 00:08:16.869 align:start position:0% sent 5 adms rather than four<00:08:14.039><c> so</c><00:08:14.280><c> that's</c><00:08:14.560><c> likely</c><00:08:15.080><c> why</c><00:08:16.039><c> returning</c> 00:08:16.869 --> 00:08:16.879 align:start position:0% four so that's likely why returning 00:08:16.879 --> 00:08:19.270 align:start position:0% four so that's likely why returning customer<00:08:17.280><c> Revenue</c><00:08:17.720><c> was</c><00:08:18.120><c> so</c><00:08:18.400><c> good</c><00:08:19.000><c> and</c><00:08:19.159><c> this</c> 00:08:19.270 --> 00:08:19.280 align:start position:0% customer Revenue was so good and this 00:08:19.280 --> 00:08:21.629 align:start position:0% customer Revenue was so good and this should<00:08:19.599><c> actually</c><00:08:20.000><c> technically</c><00:08:20.400><c> say</c><00:08:20.800><c> March</c> 00:08:21.629 --> 00:08:21.639 align:start position:0% should actually technically say March 00:08:21.639 --> 00:08:23.550 align:start position:0% should actually technically say March because<00:08:21.919><c> these</c><00:08:22.080><c> users</c><00:08:22.440><c> were</c><00:08:22.680><c> in</c><00:08:22.919><c> Feb</c><00:08:23.319><c> and</c><00:08:23.440><c> then</c> 00:08:23.550 --> 00:08:23.560 align:start position:0% because these users were in Feb and then 00:08:23.560 --> 00:08:25.830 align:start position:0% because these users were in Feb and then they<00:08:23.759><c> came</c><00:08:23.960><c> back</c><00:08:24.120><c> in</c><00:08:24.319><c> March</c><00:08:24.599><c> and</c><00:08:24.759><c> bought</c><00:08:25.560><c> so</c><00:08:25.720><c> we</c> 00:08:25.830 --> 00:08:25.840 align:start position:0% they came back in March and bought so we 00:08:25.840 --> 00:08:28.430 align:start position:0% they came back in March and bought so we spent<00:08:26.319><c> we</c><00:08:26.400><c> sent</c><00:08:26.680><c> more</c><00:08:26.879><c> edms</c><00:08:27.360><c> in</c><00:08:27.560><c> March</c><00:08:28.280><c> which</c> 00:08:28.430 --> 00:08:28.440 align:start position:0% spent we sent more edms in March which 00:08:28.440 --> 00:08:31.430 align:start position:0% spent we sent more edms in March which resulted<00:08:28.800><c> in</c><00:08:28.919><c> that</c><00:08:29.280><c> High</c><00:08:29.479><c> Revenue</c> 00:08:31.430 --> 00:08:31.440 align:start position:0% resulted in that High Revenue 00:08:31.440 --> 00:08:33.829 align:start position:0% resulted in that High Revenue pick<00:08:32.440><c> and</c><00:08:32.560><c> then</c><00:08:32.719><c> before</c><00:08:33.039><c> going</c><00:08:33.279><c> into</c><00:08:33.680><c> the</c> 00:08:33.829 --> 00:08:33.839 align:start position:0% pick and then before going into the 00:08:33.839 --> 00:08:36.110 align:start position:0% pick and then before going into the diagonal<00:08:34.399><c> analysis</c><00:08:34.959><c> you</c><00:08:35.080><c> can</c><00:08:35.479><c> also</c><00:08:35.800><c> do</c><00:08:36.000><c> this</c> 00:08:36.110 --> 00:08:36.120 align:start position:0% diagonal analysis you can also do this 00:08:36.120 --> 00:08:38.550 align:start position:0% diagonal analysis you can also do this in<00:08:36.240><c> the</c><00:08:36.479><c> inverse</c><00:08:37.479><c> so</c><00:08:37.599><c> you</c><00:08:37.719><c> can</c><00:08:37.839><c> look</c><00:08:37.959><c> at</c><00:08:38.120><c> where</c> 00:08:38.550 --> 00:08:38.560 align:start position:0% in the inverse so you can look at where 00:08:38.560 --> 00:08:40.550 align:start position:0% in the inverse so you can look at where returning<00:08:39.560><c> customer</c><00:08:39.919><c> numbers</c><00:08:40.159><c> are</c><00:08:40.320><c> really</c> 00:08:40.550 --> 00:08:40.560 align:start position:0% returning customer numbers are really 00:08:40.560 --> 00:08:42.750 align:start position:0% returning customer numbers are really poor<00:08:41.039><c> for</c><00:08:41.200><c> example</c><00:08:41.560><c> down</c><00:08:41.719><c> here</c><00:08:41.880><c> in</c><00:08:42.039><c> August</c><00:08:42.640><c> and</c> 00:08:42.750 --> 00:08:42.760 align:start position:0% poor for example down here in August and 00:08:42.760 --> 00:08:44.470 align:start position:0% poor for example down here in August and we<00:08:42.880><c> can</c><00:08:43.039><c> start</c><00:08:43.200><c> to</c><00:08:43.360><c> troubleshoot</c><00:08:44.120><c> why</c><00:08:44.320><c> that</c> 00:08:44.470 --> 00:08:44.480 align:start position:0% we can start to troubleshoot why that 00:08:44.480 --> 00:08:46.470 align:start position:0% we can start to troubleshoot why that might<00:08:44.640><c> be</c><00:08:44.800><c> the</c><00:08:44.920><c> case</c><00:08:45.560><c> and</c><00:08:45.760><c> how</c><00:08:45.920><c> we</c><00:08:46.040><c> can</c><00:08:46.240><c> get</c> 00:08:46.470 --> 00:08:46.480 align:start position:0% might be the case and how we can get 00:08:46.480 --> 00:08:48.910 align:start position:0% might be the case and how we can get back<00:08:46.720><c> to</c><00:08:47.640><c> these</c><00:08:47.839><c> high</c><00:08:48.160><c> return</c><00:08:48.360><c> customer</c><00:08:48.720><c> rates</c> 00:08:48.910 --> 00:08:48.920 align:start position:0% back to these high return customer rates 00:08:48.920 --> 00:08:50.310 align:start position:0% back to these high return customer rates that<00:08:49.040><c> we</c><00:08:49.160><c> had</c> 00:08:50.310 --> 00:08:50.320 align:start position:0% that we had 00:08:50.320 --> 00:08:53.070 align:start position:0% that we had previously<00:08:51.320><c> looking</c><00:08:51.640><c> on</c><00:08:51.800><c> the</c><00:08:52.000><c> diagonal</c><00:08:52.560><c> plane</c> 00:08:53.070 --> 00:08:53.080 align:start position:0% previously looking on the diagonal plane 00:08:53.080 --> 00:08:56.110 align:start position:0% previously looking on the diagonal plane this<00:08:53.320><c> is</c><00:08:54.160><c> usually</c><00:08:54.680><c> the</c><00:08:54.959><c> hardest</c><00:08:55.519><c> plane</c><00:08:55.839><c> to</c> 00:08:56.110 --> 00:08:56.120 align:start position:0% this is usually the hardest plane to 00:08:56.120 --> 00:08:58.509 align:start position:0% this is usually the hardest plane to wrap<00:08:56.360><c> your</c><00:08:56.519><c> head</c><00:08:56.760><c> around</c><00:08:57.519><c> um</c><00:08:57.680><c> but</c><00:08:57.839><c> it</c><00:08:58.040><c> actually</c> 00:08:58.509 --> 00:08:58.519 align:start position:0% wrap your head around um but it actually 00:08:58.519 --> 00:09:01.750 align:start position:0% wrap your head around um but it actually is<00:08:58.880><c> quite</c><00:08:59.360><c> simple</c><00:08:59.839><c> once</c><00:09:00.000><c> you</c><00:09:00.440><c> understand</c> 00:09:01.750 --> 00:09:01.760 align:start position:0% is quite simple once you understand 00:09:01.760 --> 00:09:04.870 align:start position:0% is quite simple once you understand it<00:09:02.760><c> let's</c><00:09:02.959><c> zoom</c><00:09:03.160><c> in</c><00:09:03.279><c> on</c><00:09:03.440><c> a</c><00:09:03.800><c> very</c><00:09:04.120><c> particular</c> 00:09:04.870 --> 00:09:04.880 align:start position:0% it let's zoom in on a very particular 00:09:04.880 --> 00:09:06.870 align:start position:0% it let's zoom in on a very particular Square<00:09:05.399><c> here</c><00:09:05.959><c> so</c><00:09:06.120><c> that</c><00:09:06.240><c> you</c><00:09:06.320><c> can</c><00:09:06.440><c> get</c><00:09:06.560><c> an</c> 00:09:06.870 --> 00:09:06.880 align:start position:0% Square here so that you can get an 00:09:06.880 --> 00:09:08.269 align:start position:0% Square here so that you can get an understanding<00:09:07.160><c> of</c><00:09:07.720><c> what</c><00:09:07.880><c> each</c><00:09:08.040><c> of</c><00:09:08.160><c> these</c> 00:09:08.269 --> 00:09:08.279 align:start position:0% understanding of what each of these 00:09:08.279 --> 00:09:09.670 align:start position:0% understanding of what each of these squares<00:09:08.600><c> mean</c><00:09:08.800><c> and</c><00:09:08.880><c> how</c><00:09:09.000><c> they</c><00:09:09.120><c> all</c><00:09:09.240><c> tie</c><00:09:09.440><c> into</c> 00:09:09.670 --> 00:09:09.680 align:start position:0% squares mean and how they all tie into 00:09:09.680 --> 00:09:12.630 align:start position:0% squares mean and how they all tie into each<00:09:09.839><c> other</c><00:09:10.760><c> if</c><00:09:10.880><c> we</c><00:09:11.040><c> look</c><00:09:11.200><c> at</c><00:09:11.560><c> this</c><00:09:11.959><c> box</c><00:09:12.360><c> right</c> 00:09:12.630 --> 00:09:12.640 align:start position:0% each other if we look at this box right 00:09:12.640 --> 00:09:16.069 align:start position:0% each other if we look at this box right here<00:09:13.160><c> what</c><00:09:13.320><c> this</c><00:09:13.440><c> is</c><00:09:13.600><c> telling</c><00:09:13.959><c> us</c><00:09:14.480><c> is</c><00:09:14.760><c> the</c><00:09:14.959><c> July</c> 00:09:16.069 --> 00:09:16.079 align:start position:0% here what this is telling us is the July 00:09:16.079 --> 00:09:18.750 align:start position:0% here what this is telling us is the July 2023<00:09:17.079><c> customer</c><00:09:17.560><c> cohort</c><00:09:18.079><c> and</c><00:09:18.200><c> we</c><00:09:18.279><c> can</c><00:09:18.399><c> see</c><00:09:18.600><c> this</c> 00:09:18.750 --> 00:09:18.760 align:start position:0% 2023 customer cohort and we can see this 00:09:18.760 --> 00:09:23.110 align:start position:0% 2023 customer cohort and we can see this by<00:09:18.920><c> going</c><00:09:19.200><c> across</c><00:09:19.720><c> and</c><00:09:19.880><c> looking</c><00:09:20.320><c> here</c><00:09:21.320><c> spent</c><00:09:21.600><c> $</c> 00:09:23.110 --> 00:09:23.120 align:start position:0% by going across and looking here spent $ 00:09:23.120 --> 00:09:26.230 align:start position:0% by going across and looking here spent $ 6,34<00:09:24.120><c> in</c><00:09:24.279><c> the</c><00:09:24.399><c> month</c><00:09:24.640><c> of</c><00:09:24.959><c> October</c><00:09:25.959><c> why</c><00:09:26.120><c> the</c> 00:09:26.230 --> 00:09:26.240 align:start position:0% 6,34 in the month of October why the 00:09:26.240 --> 00:09:28.710 align:start position:0% 6,34 in the month of October why the month<00:09:26.399><c> of</c><00:09:26.560><c> October</c><00:09:27.000><c> well</c><00:09:27.240><c> because</c><00:09:28.120><c> this</c><00:09:28.279><c> is</c> 00:09:28.710 --> 00:09:28.720 align:start position:0% month of October well because this is 00:09:28.720 --> 00:09:30.750 align:start position:0% month of October well because this is July 00:09:30.750 --> 00:09:30.760 align:start position:0% July 00:09:30.760 --> 00:09:34.430 align:start position:0% July August<00:09:32.000><c> September</c><00:09:33.120><c> October</c><00:09:34.120><c> so</c><00:09:34.279><c> we're</c> 00:09:34.430 --> 00:09:34.440 align:start position:0% August September October so we're 00:09:34.440 --> 00:09:36.590 align:start position:0% August September October so we're looking<00:09:34.760><c> forward</c><00:09:35.200><c> in</c><00:09:35.480><c> time</c><00:09:35.800><c> and</c><00:09:36.000><c> this</c><00:09:36.360><c> comes</c> 00:09:36.590 --> 00:09:36.600 align:start position:0% looking forward in time and this comes 00:09:36.600 --> 00:09:38.430 align:start position:0% looking forward in time and this comes to<00:09:36.800><c> October</c><00:09:37.480><c> now</c><00:09:37.640><c> the</c><00:09:37.800><c> interesting</c><00:09:38.200><c> thing</c> 00:09:38.430 --> 00:09:38.440 align:start position:0% to October now the interesting thing 00:09:38.440 --> 00:09:40.350 align:start position:0% to October now the interesting thing here<00:09:38.600><c> is</c><00:09:38.720><c> that</c><00:09:38.959><c> as</c><00:09:39.120><c> we</c><00:09:39.279><c> start</c><00:09:39.480><c> to</c><00:09:39.680><c> go</c><00:09:39.959><c> up</c><00:09:40.120><c> and</c> 00:09:40.350 --> 00:09:40.360 align:start position:0% here is that as we start to go up and 00:09:40.360 --> 00:09:42.990 align:start position:0% here is that as we start to go up and down<00:09:40.640><c> this</c><00:09:41.120><c> diagonal</c><00:09:42.120><c> this</c><00:09:42.240><c> will</c><00:09:42.600><c> always</c> 00:09:42.990 --> 00:09:43.000 align:start position:0% down this diagonal this will always 00:09:43.000 --> 00:09:45.710 align:start position:0% down this diagonal this will always result<00:09:43.600><c> in</c><00:09:43.760><c> it</c><00:09:43.959><c> being</c><00:09:44.320><c> October</c><00:09:45.320><c> so</c><00:09:45.480><c> we</c><00:09:45.560><c> can</c> 00:09:45.710 --> 00:09:45.720 align:start position:0% result in it being October so we can 00:09:45.720 --> 00:09:48.829 align:start position:0% result in it being October so we can look<00:09:46.000><c> here</c><00:09:46.720><c> and</c><00:09:46.839><c> this</c><00:09:46.959><c> tells</c><00:09:47.240><c> us</c><00:09:47.440><c> that</c><00:09:47.600><c> in</c><00:09:47.800><c> June</c> 00:09:48.829 --> 00:09:48.839 align:start position:0% look here and this tells us that in June 00:09:48.839 --> 00:09:51.829 align:start position:0% look here and this tells us that in June 2023<00:09:49.839><c> this</c><00:09:50.040><c> customer</c><00:09:50.440><c> cohort</c><00:09:50.880><c> spent</c> 00:09:51.829 --> 00:09:51.839 align:start position:0% 2023 this customer cohort spent 00:09:51.839 --> 00:09:55.590 align:start position:0% 2023 this customer cohort spent 4,190<00:09:52.839><c> once</c><00:09:53.240><c> again</c><00:09:53.880><c> in</c><00:09:54.279><c> October</c><00:09:55.279><c> because</c><00:09:55.480><c> if</c> 00:09:55.590 --> 00:09:55.600 align:start position:0% 4,190 once again in October because if 00:09:55.600 --> 00:09:57.590 align:start position:0% 4,190 once again in October because if we<00:09:55.720><c> look</c><00:09:55.839><c> at</c><00:09:56.000><c> June</c><00:09:56.480><c> and</c><00:09:56.600><c> we</c><00:09:56.720><c> go</c><00:09:56.880><c> month</c><00:09:57.120><c> one</c><00:09:57.480><c> this</c> 00:09:57.590 --> 00:09:57.600 align:start position:0% we look at June and we go month one this 00:09:57.600 --> 00:09:59.630 align:start position:0% we look at June and we go month one this is<00:09:57.839><c> July</c><00:09:58.760><c> August</c> 00:09:59.630 --> 00:09:59.640 align:start position:0% is July August 00:09:59.640 --> 00:10:01.949 align:start position:0% is July August September 00:10:01.949 --> 00:10:01.959 align:start position:0% September 00:10:01.959 --> 00:10:04.509 align:start position:0% September October<00:10:02.959><c> and</c><00:10:03.079><c> this</c><00:10:03.240><c> follows</c><00:10:03.800><c> all</c><00:10:04.079><c> the</c><00:10:04.279><c> way</c> 00:10:04.509 --> 00:10:04.519 align:start position:0% October and this follows all the way 00:10:04.519 --> 00:10:06.269 align:start position:0% October and this follows all the way through<00:10:04.839><c> so</c><00:10:05.040><c> this</c><00:10:05.160><c> one</c><00:10:05.360><c> up</c><00:10:05.519><c> here</c><00:10:05.720><c> tells</c><00:10:06.000><c> us</c> 00:10:06.269 --> 00:10:06.279 align:start position:0% through so this one up here tells us 00:10:06.279 --> 00:10:08.389 align:start position:0% through so this one up here tells us what<00:10:06.399><c> the</c><00:10:06.560><c> November</c><00:10:07.079><c> cohort</c><00:10:07.920><c> spent</c><00:10:08.200><c> in</c> 00:10:08.389 --> 00:10:08.399 align:start position:0% what the November cohort spent in 00:10:08.399 --> 00:10:10.990 align:start position:0% what the November cohort spent in October<00:10:09.399><c> this</c><00:10:09.519><c> one</c><00:10:09.760><c> down</c><00:10:09.959><c> here</c><00:10:10.200><c> April</c><00:10:10.760><c> tells</c> 00:10:10.990 --> 00:10:11.000 align:start position:0% October this one down here April tells 00:10:11.000 --> 00:10:13.190 align:start position:0% October this one down here April tells us<00:10:11.160><c> what</c><00:10:11.279><c> the</c><00:10:11.440><c> April</c><00:10:11.760><c> cohort</c><00:10:12.560><c> spent</c><00:10:12.839><c> in</c> 00:10:13.190 --> 00:10:13.200 align:start position:0% us what the April cohort spent in 00:10:13.200 --> 00:10:15.670 align:start position:0% us what the April cohort spent in October<00:10:14.200><c> and</c><00:10:14.279><c> so</c><00:10:14.440><c> this</c><00:10:14.600><c> starts</c><00:10:14.880><c> to</c><00:10:15.200><c> develop</c><00:10:15.560><c> an</c> 00:10:15.670 --> 00:10:15.680 align:start position:0% October and so this starts to develop an 00:10:15.680 --> 00:10:17.710 align:start position:0% October and so this starts to develop an interesting<00:10:16.120><c> relationship</c><00:10:16.959><c> between</c><00:10:17.480><c> the</c> 00:10:17.710 --> 00:10:17.720 align:start position:0% interesting relationship between the 00:10:17.720 --> 00:10:20.350 align:start position:0% interesting relationship between the diagonal<00:10:18.200><c> Revenue</c><00:10:18.560><c> numbers</c><00:10:19.040><c> and</c><00:10:19.399><c> total</c> 00:10:20.350 --> 00:10:20.360 align:start position:0% diagonal Revenue numbers and total 00:10:20.360 --> 00:10:22.829 align:start position:0% diagonal Revenue numbers and total revenue<00:10:21.360><c> what</c><00:10:21.519><c> you</c><00:10:21.640><c> can</c><00:10:21.880><c> do</c><00:10:22.079><c> to</c><00:10:22.279><c> find</c><00:10:22.560><c> total</c> 00:10:22.829 --> 00:10:22.839 align:start position:0% revenue what you can do to find total 00:10:22.839 --> 00:10:26.870 align:start position:0% revenue what you can do to find total revenue<00:10:23.560><c> is</c><00:10:23.720><c> you</c><00:10:23.839><c> can</c><00:10:24.160><c> sum</c><00:10:25.040><c> that</c><00:10:25.240><c> entire</c> 00:10:26.870 --> 00:10:26.880 align:start position:0% revenue is you can sum that entire 00:10:26.880 --> 00:10:30.030 align:start position:0% revenue is you can sum that entire diagonal<00:10:27.880><c> area</c><00:10:28.440><c> that</c><00:10:28.600><c> I've</c><00:10:29.200><c> LED</c><00:10:29.519><c> here</c><00:10:29.920><c> I've</c> 00:10:30.030 --> 00:10:30.040 align:start position:0% diagonal area that I've LED here I've 00:10:30.040 --> 00:10:31.470 align:start position:0% diagonal area that I've LED here I've called<00:10:30.240><c> it</c><00:10:30.320><c> a</c><00:10:30.480><c> column</c><00:10:30.839><c> here</c><00:10:30.959><c> but</c><00:10:31.079><c> technically</c> 00:10:31.470 --> 00:10:31.480 align:start position:0% called it a column here but technically 00:10:31.480 --> 00:10:34.069 align:start position:0% called it a column here but technically it's<00:10:31.640><c> not</c><00:10:31.760><c> a</c><00:10:32.160><c> column</c><00:10:33.160><c> and</c><00:10:33.279><c> you</c><00:10:33.399><c> can</c><00:10:33.680><c> add</c><00:10:33.880><c> the</c> 00:10:34.069 --> 00:10:34.079 align:start position:0% it's not a column and you can add the 00:10:34.079 --> 00:10:35.990 align:start position:0% it's not a column and you can add the first<00:10:34.320><c> order</c><00:10:34.680><c> Revenue</c><00:10:35.120><c> down</c><00:10:35.399><c> here</c><00:10:35.720><c> and</c><00:10:35.839><c> you</c> 00:10:35.990 --> 00:10:36.000 align:start position:0% first order Revenue down here and you 00:10:36.000 --> 00:10:37.310 align:start position:0% first order Revenue down here and you should<00:10:36.279><c> get</c><00:10:36.519><c> total</c> 00:10:37.310 --> 00:10:37.320 align:start position:0% should get total 00:10:37.320 --> 00:10:40.190 align:start position:0% should get total revenue<00:10:38.320><c> because</c><00:10:38.600><c> total</c><00:10:38.920><c> revenue</c><00:10:39.399><c> equals</c><00:10:39.920><c> new</c> 00:10:40.190 --> 00:10:40.200 align:start position:0% revenue because total revenue equals new 00:10:40.200 --> 00:10:42.949 align:start position:0% revenue because total revenue equals new customer<00:10:40.639><c> Revenue</c><00:10:41.480><c> plus</c><00:10:41.839><c> existing</c><00:10:42.279><c> customer</c> 00:10:42.949 --> 00:10:42.959 align:start position:0% customer Revenue plus existing customer 00:10:42.959 --> 00:10:46.550 align:start position:0% customer Revenue plus existing customer Revenue<00:10:43.959><c> so</c><00:10:44.120><c> you</c><00:10:44.360><c> take</c><00:10:44.680><c> this</c><00:10:45.680><c> you'd</c><00:10:45.959><c> add</c><00:10:46.120><c> it</c><00:10:46.240><c> to</c> 00:10:46.550 --> 00:10:46.560 align:start position:0% Revenue so you take this you'd add it to 00:10:46.560 --> 00:10:50.069 align:start position:0% Revenue so you take this you'd add it to this<00:10:47.440><c> and</c><00:10:47.560><c> then</c><00:10:47.680><c> you</c><00:10:47.760><c> should</c><00:10:48.040><c> get</c><00:10:48.279><c> total</c><00:10:48.639><c> ref</c> 00:10:50.069 --> 00:10:50.079 align:start position:0% this and then you should get total ref 00:10:50.079 --> 00:10:53.269 align:start position:0% this and then you should get total ref now<00:10:51.079><c> the</c><00:10:51.399><c> interesting</c><00:10:52.040><c> thing</c><00:10:52.360><c> here</c><00:10:52.920><c> is</c><00:10:53.160><c> that</c> 00:10:53.269 --> 00:10:53.279 align:start position:0% now the interesting thing here is that 00:10:53.279 --> 00:10:56.230 align:start position:0% now the interesting thing here is that you<00:10:53.440><c> won't</c><00:10:53.839><c> get</c><00:10:54.000><c> total</c><00:10:54.600><c> rev</c><00:10:55.600><c> if</c><00:10:55.720><c> you</c><00:10:55.800><c> were</c><00:10:56.000><c> to</c> 00:10:56.230 --> 00:10:56.240 align:start position:0% you won't get total rev if you were to 00:10:56.240 --> 00:10:57.629 align:start position:0% you won't get total rev if you were to go<00:10:56.399><c> and</c><00:10:56.639><c> add</c><00:10:56.800><c> those</c><00:10:56.959><c> numbers</c><00:10:57.360><c> together</c><00:10:57.519><c> and</c> 00:10:57.629 --> 00:10:57.639 align:start position:0% go and add those numbers together and 00:10:57.639 --> 00:10:59.470 align:start position:0% go and add those numbers together and have<00:10:57.760><c> a</c><00:10:57.839><c> look</c><00:10:57.959><c> at</c><00:10:58.079><c> the</c><00:10:58.160><c> back</c><00:10:58.279><c> end</c><00:10:58.440><c> of</c><00:10:58.560><c> Shopify</c> 00:10:59.470 --> 00:10:59.480 align:start position:0% have a look at the back end of Shopify 00:10:59.480 --> 00:11:03.710 align:start position:0% have a look at the back end of Shopify and<00:10:59.600><c> the</c><00:10:59.760><c> reason</c><00:11:00.040><c> you</c><00:11:00.200><c> wouldn't</c><00:11:00.959><c> is</c><00:11:01.279><c> because</c> 00:11:03.710 --> 00:11:03.720 align:start position:0% and the reason you wouldn't is because 00:11:03.720 --> 00:11:05.269 align:start position:0% and the reason you wouldn't is because this 00:11:05.269 --> 00:11:05.279 align:start position:0% this 00:11:05.279 --> 00:11:08.750 align:start position:0% this area<00:11:06.279><c> goes</c><00:11:07.040><c> infinitely</c><00:11:08.040><c> to</c><00:11:08.200><c> the</c><00:11:08.360><c> top</c><00:11:08.560><c> right</c> 00:11:08.750 --> 00:11:08.760 align:start position:0% area goes infinitely to the top right 00:11:08.760 --> 00:11:10.790 align:start position:0% area goes infinitely to the top right corner<00:11:09.480><c> we're</c><00:11:09.680><c> just</c><00:11:09.839><c> seeing</c><00:11:10.120><c> the</c><00:11:10.279><c> last</c><00:11:10.519><c> 12</c> 00:11:10.790 --> 00:11:10.800 align:start position:0% corner we're just seeing the last 12 00:11:10.800 --> 00:11:13.269 align:start position:0% corner we're just seeing the last 12 months<00:11:11.040><c> of</c><00:11:11.279><c> data</c><00:11:12.200><c> but</c> 00:11:13.269 --> 00:11:13.279 align:start position:0% months of data but 00:11:13.279 --> 00:11:16.110 align:start position:0% months of data but realistically<00:11:14.279><c> there's</c><00:11:14.680><c> a</c><00:11:15.000><c> cohort</c><00:11:15.480><c> back</c><00:11:15.639><c> in</c> 00:11:16.110 --> 00:11:16.120 align:start position:0% realistically there's a cohort back in 00:11:16.120 --> 00:11:18.629 align:start position:0% realistically there's a cohort back in January<00:11:16.600><c> 2022</c><00:11:17.560><c> who's</c><00:11:17.800><c> still</c><00:11:18.000><c> buying</c><00:11:18.519><c> there's</c> 00:11:18.629 --> 00:11:18.639 align:start position:0% January 2022 who's still buying there's 00:11:18.639 --> 00:11:21.110 align:start position:0% January 2022 who's still buying there's a<00:11:18.800><c> cohort</c><00:11:19.200><c> back</c><00:11:19.320><c> in</c><00:11:19.519><c> February</c><00:11:19.920><c> 2022</c><00:11:20.880><c> who's</c> 00:11:21.110 --> 00:11:21.120 align:start position:0% a cohort back in February 2022 who's 00:11:21.120 --> 00:11:24.430 align:start position:0% a cohort back in February 2022 who's still<00:11:21.320><c> buying</c><00:11:22.160><c> so</c><00:11:22.320><c> unless</c><00:11:22.600><c> we</c><00:11:22.760><c> had</c><00:11:23.040><c> access</c><00:11:23.480><c> to</c> 00:11:24.430 --> 00:11:24.440 align:start position:0% still buying so unless we had access to 00:11:24.440 --> 00:11:27.190 align:start position:0% still buying so unless we had access to the<00:11:25.240><c> Infinity</c><00:11:25.839><c> of</c><00:11:26.120><c> diagonal</c><00:11:26.720><c> data</c><00:11:27.000><c> and</c><00:11:27.120><c> we</c> 00:11:27.190 --> 00:11:27.200 align:start position:0% the Infinity of diagonal data and we 00:11:27.200 --> 00:11:29.470 align:start position:0% the Infinity of diagonal data and we could<00:11:27.360><c> go</c><00:11:27.600><c> all</c><00:11:27.760><c> the</c><00:11:27.880><c> way</c><00:11:28.160><c> back</c><00:11:28.360><c> to</c><00:11:28.680><c> the</c> 00:11:29.470 --> 00:11:29.480 align:start position:0% could go all the way back to the 00:11:29.480 --> 00:11:32.069 align:start position:0% could go all the way back to the start<00:11:29.839><c> of</c><00:11:30.000><c> the</c><00:11:30.200><c> brand</c><00:11:31.120><c> then</c><00:11:31.360><c> we</c><00:11:31.480><c> would</c><00:11:31.720><c> get</c><00:11:31.880><c> the</c> 00:11:32.069 --> 00:11:32.079 align:start position:0% start of the brand then we would get the 00:11:32.079 --> 00:11:34.030 align:start position:0% start of the brand then we would get the actual<00:11:32.360><c> Revenue</c><00:11:32.760><c> number</c><00:11:33.399><c> but</c><00:11:33.560><c> if</c><00:11:33.639><c> you</c><00:11:33.720><c> were</c><00:11:33.880><c> to</c> 00:11:34.030 --> 00:11:34.040 align:start position:0% actual Revenue number but if you were to 00:11:34.040 --> 00:11:35.870 align:start position:0% actual Revenue number but if you were to add<00:11:34.200><c> all</c><00:11:34.360><c> these</c><00:11:34.519><c> numbers</c><00:11:34.920><c> together</c><00:11:35.360><c> added</c><00:11:35.600><c> to</c> 00:11:35.870 --> 00:11:35.880 align:start position:0% add all these numbers together added to 00:11:35.880 --> 00:11:37.790 align:start position:0% add all these numbers together added to this<00:11:36.399><c> you</c><00:11:36.639><c> actually</c><00:11:37.040><c> would</c><00:11:37.240><c> get</c><00:11:37.399><c> slightly</c> 00:11:37.790 --> 00:11:37.800 align:start position:0% this you actually would get slightly 00:11:37.800 --> 00:11:40.670 align:start position:0% this you actually would get slightly under<00:11:38.760><c> which</c><00:11:38.920><c> shows</c><00:11:39.240><c> you</c><00:11:39.519><c> that</c><00:11:39.680><c> the</c><00:11:40.000><c> remainder</c> 00:11:40.670 --> 00:11:40.680 align:start position:0% under which shows you that the remainder 00:11:40.680 --> 00:11:43.310 align:start position:0% under which shows you that the remainder let's<00:11:40.880><c> say</c><00:11:41.040><c> we</c><00:11:41.200><c> add</c><00:11:41.360><c> all</c><00:11:41.560><c> this</c><00:11:41.959><c> up</c><00:11:42.959><c> we</c><00:11:43.079><c> add</c><00:11:43.240><c> it</c> 00:11:43.310 --> 00:11:43.320 align:start position:0% let's say we add all this up we add it 00:11:43.320 --> 00:11:46.190 align:start position:0% let's say we add all this up we add it to<00:11:43.560><c> this</c><00:11:43.920><c> we</c><00:11:44.079><c> get</c><00:11:44.360><c> 100K</c><00:11:45.320><c> but</c><00:11:45.480><c> in</c><00:11:45.639><c> reality</c><00:11:46.079><c> they</c> 00:11:46.190 --> 00:11:46.200 align:start position:0% to this we get 100K but in reality they 00:11:46.200 --> 00:11:49.870 align:start position:0% to this we get 100K but in reality they did<00:11:46.839><c> 120k</c><00:11:47.839><c> in</c><00:11:48.040><c> October</c><00:11:48.880><c> well</c><00:11:49.079><c> that</c><00:11:49.240><c> 20K</c> 00:11:49.870 --> 00:11:49.880 align:start position:0% did 120k in October well that 20K 00:11:49.880 --> 00:11:52.190 align:start position:0% did 120k in October well that 20K difference<00:11:50.560><c> simply</c><00:11:50.839><c> means</c><00:11:51.120><c> that</c><00:11:51.200><c> $20,000</c><00:11:52.079><c> of</c> 00:11:52.190 --> 00:11:52.200 align:start position:0% difference simply means that $20,000 of 00:11:52.200 --> 00:11:54.710 align:start position:0% difference simply means that $20,000 of Revenue<00:11:53.000><c> came</c><00:11:53.160><c> from</c><00:11:53.399><c> existing</c><00:11:53.839><c> customers</c> 00:11:54.710 --> 00:11:54.720 align:start position:0% Revenue came from existing customers 00:11:54.720 --> 00:11:57.030 align:start position:0% Revenue came from existing customers that<00:11:54.959><c> first</c><00:11:55.279><c> time</c><00:11:55.560><c> purchased</c><00:11:56.519><c> before</c><00:11:56.839><c> the</c> 00:11:57.030 --> 00:11:57.040 align:start position:0% that first time purchased before the 00:11:57.040 --> 00:11:57.949 align:start position:0% that first time purchased before the last 00:11:57.949 --> 00:11:57.959 align:start position:0% last 00:11:57.959 --> 00:12:00.710 align:start position:0% last year 00:12:00.710 --> 00:12:00.720 align:start position:0% year 00:12:00.720 --> 00:12:02.949 align:start position:0% year so<00:12:00.880><c> you</c><00:12:00.959><c> can</c><00:12:01.200><c> analyze</c><00:12:01.600><c> this</c><00:12:01.760><c> customer</c><00:12:02.160><c> cohort</c> 00:12:02.949 --> 00:12:02.959 align:start position:0% so you can analyze this customer cohort 00:12:02.959 --> 00:12:05.870 align:start position:0% so you can analyze this customer cohort analysis<00:12:04.079><c> horizontally</c><00:12:05.079><c> vertically</c><00:12:05.680><c> or</c> 00:12:05.870 --> 00:12:05.880 align:start position:0% analysis horizontally vertically or 00:12:05.880 --> 00:12:07.590 align:start position:0% analysis horizontally vertically or diagonally<00:12:06.480><c> and</c><00:12:06.560><c> they'll</c><00:12:06.760><c> all</c><00:12:07.079><c> tell</c><00:12:07.320><c> you</c> 00:12:07.590 --> 00:12:07.600 align:start position:0% diagonally and they'll all tell you 00:12:07.600 --> 00:12:09.949 align:start position:0% diagonally and they'll all tell you different<00:12:07.959><c> things</c><00:12:08.800><c> if</c><00:12:08.920><c> you're</c><00:12:09.120><c> looking</c> 00:12:09.949 --> 00:12:09.959 align:start position:0% different things if you're looking 00:12:09.959 --> 00:12:11.590 align:start position:0% different things if you're looking vertically<00:12:10.720><c> it's</c><00:12:10.920><c> going</c><00:12:11.040><c> to</c><00:12:11.200><c> give</c><00:12:11.320><c> you</c><00:12:11.440><c> the</c> 00:12:11.590 --> 00:12:11.600 align:start position:0% vertically it's going to give you the 00:12:11.600 --> 00:12:13.790 align:start position:0% vertically it's going to give you the ability<00:12:11.959><c> to</c><00:12:12.120><c> look</c><00:12:12.279><c> at</c><00:12:12.600><c> how</c><00:12:13.199><c> returning</c> 00:12:13.790 --> 00:12:13.800 align:start position:0% ability to look at how returning 00:12:13.800 --> 00:12:15.949 align:start position:0% ability to look at how returning customer<00:12:14.240><c> revenue</c><00:12:14.920><c> and</c><00:12:15.079><c> percentage</c><00:12:15.519><c> numbers</c> 00:12:15.949 --> 00:12:15.959 align:start position:0% customer revenue and percentage numbers 00:12:15.959 --> 00:12:17.990 align:start position:0% customer revenue and percentage numbers fluctuated<00:12:16.720><c> over</c><00:12:17.000><c> time</c><00:12:17.519><c> you</c><00:12:17.639><c> can</c><00:12:17.800><c> then</c> 00:12:17.990 --> 00:12:18.000 align:start position:0% fluctuated over time you can then 00:12:18.000 --> 00:12:20.110 align:start position:0% fluctuated over time you can then identify<00:12:18.560><c> months</c><00:12:19.040><c> that</c><00:12:19.120><c> were</c><00:12:19.399><c> really</c><00:12:19.839><c> high</c> 00:12:20.110 --> 00:12:20.120 align:start position:0% identify months that were really high 00:12:20.120 --> 00:12:21.990 align:start position:0% identify months that were really high performing<00:12:21.000><c> try</c><00:12:21.160><c> to</c><00:12:21.279><c> figure</c><00:12:21.480><c> out</c><00:12:21.720><c> why</c><00:12:21.880><c> they</c> 00:12:21.990 --> 00:12:22.000 align:start position:0% performing try to figure out why they 00:12:22.000 --> 00:12:23.389 align:start position:0% performing try to figure out why they were<00:12:22.160><c> high</c><00:12:22.360><c> performing</c><00:12:22.720><c> and</c><00:12:22.839><c> then</c><00:12:23.000><c> apply</c><00:12:23.279><c> that</c> 00:12:23.389 --> 00:12:23.399 align:start position:0% were high performing and then apply that 00:12:23.399 --> 00:12:25.430 align:start position:0% were high performing and then apply that into<00:12:23.560><c> your</c><00:12:23.720><c> business</c><00:12:24.720><c> if</c><00:12:24.839><c> you're</c><00:12:25.000><c> looking</c> 00:12:25.430 --> 00:12:25.440 align:start position:0% into your business if you're looking 00:12:25.440 --> 00:12:27.389 align:start position:0% into your business if you're looking horizontally<00:12:26.440><c> you</c><00:12:26.560><c> can</c><00:12:26.760><c> look</c><00:12:26.920><c> at</c><00:12:27.160><c> where</c> 00:12:27.389 --> 00:12:27.399 align:start position:0% horizontally you can look at where 00:12:27.399 --> 00:12:29.750 align:start position:0% horizontally you can look at where there's<00:12:27.560><c> a</c><00:12:27.760><c> significant</c><00:12:28.320><c> drop</c><00:12:28.600><c> off</c><00:12:29.120><c> in</c><00:12:29.440><c> return</c> 00:12:29.750 --> 00:12:29.760 align:start position:0% there's a significant drop off in return 00:12:29.760 --> 00:12:31.949 align:start position:0% there's a significant drop off in return customer<00:12:30.160><c> rates</c><00:12:30.720><c> figure</c><00:12:31.000><c> out</c><00:12:31.360><c> why</c><00:12:31.519><c> are</c><00:12:31.720><c> people</c> 00:12:31.949 --> 00:12:31.959 align:start position:0% customer rates figure out why are people 00:12:31.959 --> 00:12:34.389 align:start position:0% customer rates figure out why are people dropping<00:12:32.360><c> up</c><00:12:32.760><c> after</c><00:12:33.000><c> 90</c><00:12:33.399><c> days</c><00:12:33.959><c> and</c><00:12:34.079><c> then</c><00:12:34.279><c> what</c> 00:12:34.389 --> 00:12:34.399 align:start position:0% dropping up after 90 days and then what 00:12:34.399 --> 00:12:36.230 align:start position:0% dropping up after 90 days and then what can<00:12:34.519><c> we</c><00:12:34.639><c> do</c><00:12:34.839><c> to</c><00:12:35.040><c> address</c><00:12:35.440><c> this</c><00:12:35.920><c> can</c><00:12:36.079><c> we</c> 00:12:36.230 --> 00:12:36.240 align:start position:0% can we do to address this can we 00:12:36.240 --> 00:12:38.990 align:start position:0% can we do to address this can we increase<00:12:36.639><c> our</c><00:12:36.880><c> EDM</c><00:12:37.560><c> significantly</c><00:12:38.560><c> after</c><00:12:38.839><c> a</c> 00:12:38.990 --> 00:12:39.000 align:start position:0% increase our EDM significantly after a 00:12:39.000 --> 00:12:41.069 align:start position:0% increase our EDM significantly after a user<00:12:39.360><c> has</c><00:12:39.519><c> been</c><00:12:39.760><c> in</c><00:12:39.920><c> our</c><00:12:40.160><c> database</c><00:12:40.560><c> for</c><00:12:40.720><c> 90</c> 00:12:41.069 --> 00:12:41.079 align:start position:0% user has been in our database for 90 00:12:41.079 --> 00:12:42.910 align:start position:0% user has been in our database for 90 days<00:12:41.760><c> is</c><00:12:41.839><c> there</c><00:12:42.000><c> an</c><00:12:42.120><c> issue</c><00:12:42.360><c> with</c><00:12:42.480><c> the</c><00:12:42.600><c> actual</c> 00:12:42.910 --> 00:12:42.920 align:start position:0% days is there an issue with the actual 00:12:42.920 --> 00:12:44.629 align:start position:0% days is there an issue with the actual core<00:12:43.240><c> offering</c><00:12:43.680><c> for</c><00:12:43.839><c> example</c><00:12:44.120><c> are</c><00:12:44.199><c> we</c><00:12:44.320><c> doing</c><00:12:44.519><c> a</c> 00:12:44.629 --> 00:12:44.639 align:start position:0% core offering for example are we doing a 00:12:44.639 --> 00:12:46.310 align:start position:0% core offering for example are we doing a diet<00:12:44.920><c> that</c><00:12:45.040><c> ends</c><00:12:45.360><c> after</c><00:12:45.560><c> 90</c><00:12:45.880><c> days</c><00:12:46.079><c> and</c><00:12:46.199><c> that's</c> 00:12:46.310 --> 00:12:46.320 align:start position:0% diet that ends after 90 days and that's 00:12:46.320 --> 00:12:48.430 align:start position:0% diet that ends after 90 days and that's why<00:12:46.440><c> users</c><00:12:46.760><c> aren't</c><00:12:47.000><c> coming</c><00:12:47.320><c> back</c><00:12:48.199><c> and</c><00:12:48.320><c> then</c> 00:12:48.430 --> 00:12:48.440 align:start position:0% why users aren't coming back and then 00:12:48.440 --> 00:12:50.189 align:start position:0% why users aren't coming back and then when<00:12:48.560><c> we</c><00:12:48.720><c> look</c><00:12:48.959><c> diagonally</c><00:12:49.600><c> this</c><00:12:49.720><c> gives</c><00:12:49.920><c> us</c><00:12:50.040><c> a</c> 00:12:50.189 --> 00:12:50.199 align:start position:0% when we look diagonally this gives us a 00:12:50.199 --> 00:12:54.310 align:start position:0% when we look diagonally this gives us a breakdown<00:12:50.880><c> of</c><00:12:51.800><c> how</c><00:12:52.079><c> our</c><00:12:52.320><c> Revenue</c><00:12:52.880><c> this</c><00:12:53.320><c> month</c> 00:12:54.310 --> 00:12:54.320 align:start position:0% breakdown of how our Revenue this month 00:12:54.320 --> 00:12:56.430 align:start position:0% breakdown of how our Revenue this month has<00:12:54.480><c> been</c><00:12:54.720><c> attributed</c><00:12:55.240><c> to</c><00:12:55.560><c> past</c><00:12:55.920><c> customer</c> 00:12:56.430 --> 00:12:56.440 align:start position:0% has been attributed to past customer 00:12:56.440 --> 00:12:58.790 align:start position:0% has been attributed to past customer cohorts<00:12:57.440><c> and</c><00:12:57.560><c> we</c><00:12:57.639><c> can</c><00:12:57.839><c> also</c><00:12:58.079><c> find</c><00:12:58.320><c> similar</c> 00:12:58.790 --> 00:12:58.800 align:start position:0% cohorts and we can also find similar 00:12:58.800 --> 00:13:01.430 align:start position:0% cohorts and we can also find similar Trends<00:12:59.199><c> here</c><00:12:59.440><c> as</c><00:12:59.560><c> we</c><00:12:59.720><c> would</c><00:13:00.199><c> horizontally</c><00:13:01.199><c> for</c> 00:13:01.430 --> 00:13:01.440 align:start position:0% Trends here as we would horizontally for 00:13:01.440 --> 00:13:03.990 align:start position:0% Trends here as we would horizontally for example<00:13:01.959><c> we</c><00:13:02.079><c> can</c><00:13:02.279><c> find</c><00:13:02.480><c> that</c><00:13:02.680><c> this</c><00:13:03.000><c> month</c> 00:13:03.990 --> 00:13:04.000 align:start position:0% example we can find that this month 00:13:04.000 --> 00:13:07.269 align:start position:0% example we can find that this month majority<00:13:04.519><c> of</c><00:13:04.720><c> Revenue</c><00:13:05.279><c> came</c><00:13:05.800><c> from</c><00:13:06.800><c> users</c><00:13:07.120><c> that</c> 00:13:07.269 --> 00:13:07.279 align:start position:0% majority of Revenue came from users that 00:13:07.279 --> 00:13:08.790 align:start position:0% majority of Revenue came from users that purchased<00:13:07.639><c> in</c><00:13:07.760><c> August</c><00:13:08.040><c> and</c><00:13:08.199><c> September</c><00:13:08.639><c> now</c> 00:13:08.790 --> 00:13:08.800 align:start position:0% purchased in August and September now 00:13:08.800 --> 00:13:10.350 align:start position:0% purchased in August and September now this<00:13:08.920><c> makes</c><00:13:09.160><c> sense</c><00:13:09.519><c> because</c><00:13:09.760><c> we</c><00:13:09.880><c> know</c><00:13:10.040><c> that</c><00:13:10.199><c> on</c> 00:13:10.350 --> 00:13:10.360 align:start position:0% this makes sense because we know that on 00:13:10.360 --> 00:13:12.189 align:start position:0% this makes sense because we know that on average<00:13:10.800><c> most</c><00:13:10.959><c> of</c><00:13:11.079><c> our</c><00:13:11.240><c> purchases</c><00:13:11.680><c> do</c><00:13:11.880><c> come</c><00:13:12.040><c> in</c> 00:13:12.189 --> 00:13:12.199 align:start position:0% average most of our purchases do come in 00:13:12.199 --> 00:13:14.389 align:start position:0% average most of our purchases do come in the<00:13:12.320><c> last</c><00:13:12.480><c> 90</c><00:13:12.839><c> days</c><00:13:13.440><c> but</c><00:13:13.560><c> if</c><00:13:13.680><c> we</c><00:13:13.839><c> find</c><00:13:14.160><c> any</c> 00:13:14.389 --> 00:13:14.399 align:start position:0% the last 90 days but if we find any 00:13:14.399 --> 00:13:16.629 align:start position:0% the last 90 days but if we find any anomalies<00:13:15.120><c> here</c><00:13:15.560><c> we</c><00:13:15.680><c> can</c><00:13:15.839><c> then</c><00:13:16.000><c> pull</c><00:13:16.240><c> that</c><00:13:16.360><c> out</c> 00:13:16.629 --> 00:13:16.639 align:start position:0% anomalies here we can then pull that out 00:13:16.639 --> 00:13:19.910 align:start position:0% anomalies here we can then pull that out analyze<00:13:17.040><c> it</c><00:13:17.199><c> and</c><00:13:17.320><c> use</c><00:13:17.480><c> it</c><00:13:17.600><c> to</c><00:13:17.839><c> find</c><00:13:18.399><c> next</c> 00:13:19.910 --> 00:13:19.920 align:start position:0% analyze it and use it to find next 00:13:19.920 --> 00:13:22.629 align:start position:0% analyze it and use it to find next steps<00:13:20.920><c> now</c><00:13:21.120><c> in</c><00:13:21.279><c> addition</c><00:13:21.600><c> to</c><00:13:21.839><c> analyzing</c> 00:13:22.629 --> 00:13:22.639 align:start position:0% steps now in addition to analyzing 00:13:22.639 --> 00:13:25.350 align:start position:0% steps now in addition to analyzing horizontally<00:13:23.600><c> vertically</c><00:13:24.240><c> and</c><00:13:24.440><c> diagonally</c> 00:13:25.350 --> 00:13:25.360 align:start position:0% horizontally vertically and diagonally 00:13:25.360 --> 00:13:27.790 align:start position:0% horizontally vertically and diagonally we<00:13:25.480><c> can</c><00:13:25.760><c> also</c><00:13:26.040><c> use</c><00:13:26.240><c> this</c><00:13:26.440><c> customer</c><00:13:26.920><c> cohort</c> 00:13:27.790 --> 00:13:27.800 align:start position:0% we can also use this customer cohort 00:13:27.800 --> 00:13:29.949 align:start position:0% we can also use this customer cohort data<00:13:28.240><c> to</c><00:13:28.839><c> calculate</c> 00:13:29.949 --> 00:13:29.959 align:start position:0% data to calculate 00:13:29.959 --> 00:13:33.030 align:start position:0% data to calculate LTV<00:13:30.959><c> and</c><00:13:31.120><c> we</c><00:13:31.240><c> can</c><00:13:31.480><c> do</c><00:13:31.720><c> that</c><00:13:32.000><c> just</c><00:13:32.279><c> using</c><00:13:32.839><c> the</c> 00:13:33.030 --> 00:13:33.040 align:start position:0% LTV and we can do that just using the 00:13:33.040 --> 00:13:35.110 align:start position:0% LTV and we can do that just using the first<00:13:33.320><c> two</c><00:13:33.560><c> columns</c><00:13:34.040><c> here</c><00:13:34.360><c> we</c><00:13:34.480><c> can</c><00:13:34.639><c> take</c><00:13:34.880><c> net</c> 00:13:35.110 --> 00:13:35.120 align:start position:0% first two columns here we can take net 00:13:35.120 --> 00:13:37.389 align:start position:0% first two columns here we can take net sales<00:13:35.680><c> we</c><00:13:35.760><c> can</c><00:13:35.920><c> divide</c><00:13:36.160><c> it</c><00:13:36.360><c> by</c><00:13:36.600><c> first</c><00:13:37.000><c> order</c> 00:13:37.389 --> 00:13:37.399 align:start position:0% sales we can divide it by first order 00:13:37.399 --> 00:13:42.069 align:start position:0% sales we can divide it by first order sales<00:13:38.000><c> and</c><00:13:38.160><c> that</c><00:13:38.320><c> should</c><00:13:38.680><c> give</c><00:13:38.880><c> us</c><00:13:39.600><c> an</c><00:13:39.720><c> LTV</c> 00:13:42.069 --> 00:13:42.079 align:start position:0% sales and that should give us an LTV 00:13:42.079 --> 00:13:45.310 align:start position:0% sales and that should give us an LTV ratio<00:13:43.079><c> to</c><00:13:43.240><c> get</c><00:13:43.399><c> the</c><00:13:43.560><c> actual</c><00:13:44.120><c> LTV</c><00:13:45.120><c> what</c><00:13:45.240><c> you</c> 00:13:45.310 --> 00:13:45.320 align:start position:0% ratio to get the actual LTV what you 00:13:45.320 --> 00:13:47.030 align:start position:0% ratio to get the actual LTV what you want<00:13:45.440><c> to</c><00:13:45.600><c> do</c><00:13:45.800><c> is</c><00:13:45.959><c> change</c><00:13:46.279><c> the</c><00:13:46.440><c> metric</c><00:13:46.839><c> down</c> 00:13:47.030 --> 00:13:47.040 align:start position:0% want to do is change the metric down 00:13:47.040 --> 00:13:49.110 align:start position:0% want to do is change the metric down here<00:13:47.160><c> to</c><00:13:47.360><c> customers</c><00:13:48.279><c> and</c><00:13:48.399><c> then</c><00:13:48.519><c> do</c><00:13:48.760><c> basic</c> 00:13:49.110 --> 00:13:49.120 align:start position:0% here to customers and then do basic 00:13:49.120 --> 00:13:52.350 align:start position:0% here to customers and then do basic division<00:13:49.600><c> of</c><00:13:50.040><c> these</c><00:13:50.320><c> two</c><00:13:50.600><c> columns</c><00:13:51.440><c> LTV</c><00:13:52.040><c> equals</c> 00:13:52.350 --> 00:13:52.360 align:start position:0% division of these two columns LTV equals 00:13:52.360 --> 00:13:55.350 align:start position:0% division of these two columns LTV equals net<00:13:52.560><c> sales</c><00:13:52.959><c> divided</c><00:13:53.320><c> by</c><00:13:53.600><c> cohort</c><00:13:54.079><c> size</c><00:13:54.839><c> so</c><00:13:55.120><c> for</c> 00:13:55.350 --> 00:13:55.360 align:start position:0% net sales divided by cohort size so for 00:13:55.360 --> 00:13:57.550 align:start position:0% net sales divided by cohort size so for example<00:13:55.759><c> if</c><00:13:55.880><c> we</c><00:13:55.959><c> wanted</c><00:13:56.199><c> to</c><00:13:56.320><c> find</c><00:13:56.519><c> the</c><00:13:56.639><c> LTV</c><00:13:57.360><c> of</c> 00:13:57.550 --> 00:13:57.560 align:start position:0% example if we wanted to find the LTV of 00:13:57.560 --> 00:13:59.710 align:start position:0% example if we wanted to find the LTV of the<00:13:57.759><c> November</c><00:13:58.320><c> cohort</c><00:13:59.000><c> so</c><00:13:59.160><c> the</c><00:13:59.279><c> users</c><00:13:59.560><c> that</c> 00:13:59.710 --> 00:13:59.720 align:start position:0% the November cohort so the users that 00:13:59.720 --> 00:14:01.470 align:start position:0% the November cohort so the users that purchased<00:14:00.079><c> in</c><00:14:00.240><c> November</c><00:14:00.959><c> how</c><00:14:01.120><c> much</c><00:14:01.279><c> on</c> 00:14:01.470 --> 00:14:01.480 align:start position:0% purchased in November how much on 00:14:01.480 --> 00:14:03.389 align:start position:0% purchased in November how much on average<00:14:01.800><c> did</c><00:14:02.040><c> they</c><00:14:02.240><c> spend</c><00:14:02.680><c> with</c><00:14:02.800><c> the</c><00:14:02.959><c> brand</c> 00:14:03.389 --> 00:14:03.399 align:start position:0% average did they spend with the brand 00:14:03.399 --> 00:14:05.430 align:start position:0% average did they spend with the brand over<00:14:03.600><c> the</c> 00:14:05.430 --> 00:14:05.440 align:start position:0% over the 00:14:05.440 --> 00:14:09.269 align:start position:0% over the lifetime<00:14:06.440><c> we</c><00:14:06.720><c> take</c><00:14:07.240><c> 283,000</c><00:14:08.199><c> and</c><00:14:08.880><c> divide</c><00:14:09.120><c> it</c> 00:14:09.269 --> 00:14:09.279 align:start position:0% lifetime we take 283,000 and divide it 00:14:09.279 --> 00:14:10.749 align:start position:0% lifetime we take 283,000 and divide it by 00:14:10.749 --> 00:14:10.759 align:start position:0% by 00:14:10.759 --> 00:14:13.350 align:start position:0% by 1,031<00:14:11.759><c> that</c><00:14:11.839><c> would</c><00:14:12.000><c> give</c><00:14:12.160><c> us</c> 00:14:13.350 --> 00:14:13.360 align:start position:0% 1,031 that would give us 00:14:13.360 --> 00:14:15.470 align:start position:0% 1,031 that would give us $274<00:14:14.360><c> which</c><00:14:14.560><c> means</c><00:14:14.800><c> that</c><00:14:14.959><c> the</c><00:14:15.079><c> November</c> 00:14:15.470 --> 00:14:15.480 align:start position:0% $274 which means that the November 00:14:15.480 --> 00:14:17.629 align:start position:0% $274 which means that the November cohort<00:14:15.880><c> LTV</c><00:14:16.320><c> is</c> 00:14:17.629 --> 00:14:17.639 align:start position:0% cohort LTV is 00:14:17.639 --> 00:14:20.110 align:start position:0% cohort LTV is 274<00:14:18.639><c> now</c><00:14:18.800><c> we</c><00:14:18.880><c> can</c><00:14:19.040><c> also</c><00:14:19.240><c> do</c><00:14:19.399><c> some</c><00:14:19.639><c> cohort</c> 00:14:20.110 --> 00:14:20.120 align:start position:0% 274 now we can also do some cohort 00:14:20.120 --> 00:14:22.030 align:start position:0% 274 now we can also do some cohort inclusions<00:14:20.600><c> or</c><00:14:20.839><c> customer</c><00:14:21.279><c> segmentation</c><00:14:21.920><c> on</c> 00:14:22.030 --> 00:14:22.040 align:start position:0% inclusions or customer segmentation on 00:14:22.040 --> 00:14:23.870 align:start position:0% inclusions or customer segmentation on the<00:14:22.160><c> right</c><00:14:22.399><c> hand</c><00:14:22.560><c> side</c><00:14:22.920><c> here</c><00:14:23.199><c> and</c><00:14:23.440><c> pull</c><00:14:23.639><c> away</c> 00:14:23.870 --> 00:14:23.880 align:start position:0% the right hand side here and pull away 00:14:23.880 --> 00:14:25.430 align:start position:0% the right hand side here and pull away some<00:14:24.079><c> really</c><00:14:24.360><c> interesting</c><00:14:24.800><c> insights</c><00:14:25.279><c> that</c> 00:14:25.430 --> 00:14:25.440 align:start position:0% some really interesting insights that 00:14:25.440 --> 00:14:27.110 align:start position:0% some really interesting insights that once<00:14:25.639><c> again</c><00:14:25.920><c> gives</c><00:14:26.120><c> us</c><00:14:26.320><c> actionable</c><00:14:26.800><c> next</c> 00:14:27.110 --> 00:14:27.120 align:start position:0% once again gives us actionable next 00:14:27.120 --> 00:14:29.470 align:start position:0% once again gives us actionable next steps<00:14:27.680><c> to</c><00:14:27.839><c> implement</c><00:14:28.199><c> in</c><00:14:28.320><c> the</c><00:14:28.440><c> brand</c> 00:14:29.470 --> 00:14:29.480 align:start position:0% steps to implement in the brand 00:14:29.480 --> 00:14:31.790 align:start position:0% steps to implement in the brand for<00:14:29.680><c> example</c><00:14:30.040><c> we</c><00:14:30.120><c> can</c><00:14:30.279><c> sort</c><00:14:30.639><c> by</c><00:14:30.800><c> users</c> 00:14:31.790 --> 00:14:31.800 align:start position:0% for example we can sort by users 00:14:31.800 --> 00:14:35.069 align:start position:0% for example we can sort by users that<00:14:32.800><c> uh</c><00:14:33.480><c> purchased</c><00:14:33.880><c> a</c><00:14:34.040><c> subscription</c><00:14:34.839><c> rather</c> 00:14:35.069 --> 00:14:35.079 align:start position:0% that uh purchased a subscription rather 00:14:35.079 --> 00:14:36.710 align:start position:0% that uh purchased a subscription rather than<00:14:35.199><c> a</c><00:14:35.360><c> onetime</c> 00:14:36.710 --> 00:14:36.720 align:start position:0% than a onetime 00:14:36.720 --> 00:14:38.870 align:start position:0% than a onetime buy<00:14:37.720><c> we</c><00:14:37.839><c> can</c><00:14:38.000><c> once</c><00:14:38.199><c> again</c><00:14:38.399><c> run</c><00:14:38.560><c> the</c><00:14:38.639><c> same</c> 00:14:38.870 --> 00:14:38.880 align:start position:0% buy we can once again run the same 00:14:38.880 --> 00:14:40.269 align:start position:0% buy we can once again run the same analysis<00:14:39.519><c> let's</c><00:14:39.680><c> have</c><00:14:39.800><c> a</c><00:14:39.880><c> look</c><00:14:40.000><c> at</c><00:14:40.120><c> the</c> 00:14:40.269 --> 00:14:40.279 align:start position:0% analysis let's have a look at the 00:14:40.279 --> 00:14:42.749 align:start position:0% analysis let's have a look at the November<00:14:40.880><c> cohort</c><00:14:41.440><c> net</c><00:14:41.720><c> sales</c><00:14:42.440><c> amount</c><00:14:42.639><c> of</c> 00:14:42.749 --> 00:14:42.759 align:start position:0% November cohort net sales amount of 00:14:42.759 --> 00:14:44.430 align:start position:0% November cohort net sales amount of people<00:14:42.959><c> that</c><00:14:43.120><c> actually</c><00:14:43.360><c> bought</c><00:14:44.199><c> what</c><00:14:44.279><c> we'll</c> 00:14:44.430 --> 00:14:44.440 align:start position:0% people that actually bought what we'll 00:14:44.440 --> 00:14:47.790 align:start position:0% people that actually bought what we'll find<00:14:44.720><c> is</c><00:14:44.839><c> LTV</c><00:14:45.440><c> is</c><00:14:45.600><c> actually</c> 00:14:47.790 --> 00:14:47.800 align:start position:0% find is LTV is actually 00:14:47.800 --> 00:14:50.790 align:start position:0% find is LTV is actually $436<00:14:48.800><c> as</c><00:14:48.920><c> you</c><00:14:49.079><c> can</c><00:14:49.279><c> see</c><00:14:49.680><c> right</c><00:14:49.959><c> there</c><00:14:50.440><c> so</c><00:14:50.600><c> it's</c> 00:14:50.790 --> 00:14:50.800 align:start position:0% $436 as you can see right there so it's 00:14:50.800 --> 00:14:52.389 align:start position:0% $436 as you can see right there so it's up 00:14:52.389 --> 00:14:52.399 align:start position:0% up 00:14:52.399 --> 00:14:54.829 align:start position:0% up 59%<00:14:53.399><c> so</c><00:14:53.639><c> people</c><00:14:53.959><c> that</c><00:14:54.240><c> apply</c><00:14:54.519><c> for</c><00:14:54.680><c> a</c> 00:14:54.829 --> 00:14:54.839 align:start position:0% 59% so people that apply for a 00:14:54.839 --> 00:14:56.269 align:start position:0% 59% so people that apply for a subscription<00:14:55.399><c> rather</c><00:14:55.600><c> than</c><00:14:55.759><c> just</c><00:14:55.880><c> buying</c><00:14:56.120><c> the</c> 00:14:56.269 --> 00:14:56.279 align:start position:0% subscription rather than just buying the 00:14:56.279 --> 00:14:59.230 align:start position:0% subscription rather than just buying the product<00:14:56.800><c> on</c><00:14:57.000><c> average</c><00:14:57.279><c> spend</c><00:14:57.680><c> 59%</c><00:14:58.759><c> more</c><00:14:59.040><c> over</c> 00:14:59.230 --> 00:14:59.240 align:start position:0% product on average spend 59% more over 00:14:59.240 --> 00:15:01.269 align:start position:0% product on average spend 59% more over their<00:14:59.480><c> lifetime</c><00:15:00.480><c> what</c><00:15:00.600><c> does</c><00:15:00.720><c> this</c><00:15:00.880><c> tell</c><00:15:01.040><c> us</c> 00:15:01.269 --> 00:15:01.279 align:start position:0% their lifetime what does this tell us 00:15:01.279 --> 00:15:02.829 align:start position:0% their lifetime what does this tell us well<00:15:01.399><c> we</c><00:15:01.480><c> should</c><00:15:01.759><c> probably</c><00:15:02.160><c> force</c><00:15:02.600><c> people</c> 00:15:02.829 --> 00:15:02.839 align:start position:0% well we should probably force people 00:15:02.839 --> 00:15:04.629 align:start position:0% well we should probably force people onto<00:15:03.160><c> subscriptions</c><00:15:03.800><c> let's</c><00:15:03.959><c> not</c><00:15:04.120><c> even</c><00:15:04.399><c> let</c> 00:15:04.629 --> 00:15:04.639 align:start position:0% onto subscriptions let's not even let 00:15:04.639 --> 00:15:07.030 align:start position:0% onto subscriptions let's not even let people<00:15:05.199><c> purchase</c><00:15:05.600><c> one</c><00:15:05.839><c> time</c><00:15:06.399><c> let's</c><00:15:06.720><c> force</c> 00:15:07.030 --> 00:15:07.040 align:start position:0% people purchase one time let's force 00:15:07.040 --> 00:15:08.790 align:start position:0% people purchase one time let's force people<00:15:07.240><c> onto</c><00:15:07.480><c> subscriptions</c><00:15:08.040><c> is</c><00:15:08.399><c> we</c><00:15:08.519><c> can</c><00:15:08.600><c> see</c> 00:15:08.790 --> 00:15:08.800 align:start position:0% people onto subscriptions is we can see 00:15:08.800 --> 00:15:10.069 align:start position:0% people onto subscriptions is we can see that<00:15:08.920><c> it's</c><00:15:09.160><c> very</c><00:15:09.360><c> very</c><00:15:09.600><c> effective</c><00:15:09.920><c> for</c> 00:15:10.069 --> 00:15:10.079 align:start position:0% that it's very very effective for 00:15:10.079 --> 00:15:13.269 align:start position:0% that it's very very effective for increasing<00:15:10.560><c> lifetime</c><00:15:11.040><c> value</c><00:15:12.040><c> and</c><00:15:12.759><c> November</c> 00:15:13.269 --> 00:15:13.279 align:start position:0% increasing lifetime value and November 00:15:13.279 --> 00:15:14.829 align:start position:0% increasing lifetime value and November it's<00:15:13.399><c> a</c><00:15:13.519><c> small</c><00:15:13.880><c> data</c><00:15:14.120><c> set</c><00:15:14.279><c> we're</c><00:15:14.440><c> looking</c><00:15:14.680><c> at</c> 00:15:14.829 --> 00:15:14.839 align:start position:0% it's a small data set we're looking at 00:15:14.839 --> 00:15:16.829 align:start position:0% it's a small data set we're looking at 38<00:15:15.320><c> customers</c><00:15:15.800><c> there</c><00:15:15.920><c> so</c><00:15:16.040><c> it</c><00:15:16.160><c> might</c><00:15:16.320><c> be</c><00:15:16.440><c> skewed</c> 00:15:16.829 --> 00:15:16.839 align:start position:0% 38 customers there so it might be skewed 00:15:16.839 --> 00:15:18.550 align:start position:0% 38 customers there so it might be skewed so<00:15:17.000><c> let's</c><00:15:17.199><c> look</c><00:15:17.320><c> at</c><00:15:17.440><c> the</c><00:15:17.639><c> entire</c><00:15:18.120><c> last</c><00:15:18.320><c> 12</c> 00:15:18.550 --> 00:15:18.560 align:start position:0% so let's look at the entire last 12 00:15:18.560 --> 00:15:20.710 align:start position:0% so let's look at the entire last 12 months<00:15:18.800><c> of</c><00:15:18.959><c> data</c><00:15:19.320><c> let's</c><00:15:19.519><c> take</c><00:15:19.720><c> the</c><00:15:20.240><c> whole</c> 00:15:20.710 --> 00:15:20.720 align:start position:0% months of data let's take the whole 00:15:20.720 --> 00:15:23.389 align:start position:0% months of data let's take the whole $200,000<00:15:21.720><c> of</c><00:15:22.240><c> subscription</c><00:15:22.800><c> Revenue</c><00:15:23.160><c> that</c><00:15:23.279><c> we</c> 00:15:23.389 --> 00:15:23.399 align:start position:0% $200,000 of subscription Revenue that we 00:15:23.399 --> 00:15:25.430 align:start position:0% $200,000 of subscription Revenue that we generated<00:15:24.160><c> and</c><00:15:24.320><c> let's</c><00:15:24.519><c> divide</c><00:15:24.839><c> by</c><00:15:25.000><c> the</c><00:15:25.120><c> entire</c> 00:15:25.430 --> 00:15:25.440 align:start position:0% generated and let's divide by the entire 00:15:25.440 --> 00:15:27.790 align:start position:0% generated and let's divide by the entire cohort<00:15:25.959><c> size</c><00:15:26.720><c> and</c><00:15:26.839><c> that's</c><00:15:27.000><c> going</c><00:15:27.079><c> to</c><00:15:27.240><c> give</c><00:15:27.399><c> us</c> 00:15:27.790 --> 00:15:27.800 align:start position:0% cohort size and that's going to give us 00:15:27.800 --> 00:15:30.550 align:start position:0% cohort size and that's going to give us 43<00:15:29.079><c> so</c><00:15:29.199><c> it's</c><00:15:29.399><c> still</c><00:15:29.759><c> much</c><00:15:29.959><c> higher</c><00:15:30.240><c> it's</c><00:15:30.360><c> about</c> 00:15:30.550 --> 00:15:30.560 align:start position:0% 43 so it's still much higher it's about 00:15:30.560 --> 00:15:33.829 align:start position:0% 43 so it's still much higher it's about 52%<00:15:31.240><c> higher</c><00:15:31.480><c> so</c><00:15:31.600><c> it</c><00:15:31.720><c> still</c><00:15:32.199><c> validates</c><00:15:33.199><c> that</c> 00:15:33.829 --> 00:15:33.839 align:start position:0% 52% higher so it still validates that 00:15:33.839 --> 00:15:36.189 align:start position:0% 52% higher so it still validates that subscription<00:15:34.800><c> members</c><00:15:35.360><c> spend</c><00:15:35.680><c> a</c><00:15:35.800><c> lot</c><00:15:35.959><c> more</c> 00:15:36.189 --> 00:15:36.199 align:start position:0% subscription members spend a lot more 00:15:36.199 --> 00:15:39.189 align:start position:0% subscription members spend a lot more than<00:15:36.639><c> regular</c><00:15:37.639><c> uh</c> 00:15:39.189 --> 00:15:39.199 align:start position:0% than regular uh 00:15:39.199 --> 00:15:41.230 align:start position:0% than regular uh customers<00:15:40.199><c> now</c><00:15:40.319><c> in</c><00:15:40.440><c> the</c><00:15:40.560><c> top</c><00:15:40.759><c> right</c><00:15:40.920><c> corner</c> 00:15:41.230 --> 00:15:41.240 align:start position:0% customers now in the top right corner 00:15:41.240 --> 00:15:43.590 align:start position:0% customers now in the top right corner here<00:15:41.399><c> we</c><00:15:41.480><c> can</c><00:15:41.680><c> also</c><00:15:42.000><c> run</c><00:15:42.279><c> this</c><00:15:42.480><c> analysis</c><00:15:43.360><c> by</c> 00:15:43.590 --> 00:15:43.600 align:start position:0% here we can also run this analysis by 00:15:43.600 --> 00:15:45.069 align:start position:0% here we can also run this analysis by Breaking<00:15:44.000><c> Down</c><00:15:44.279><c> based</c><00:15:44.480><c> on</c><00:15:44.680><c> customer</c> 00:15:45.069 --> 00:15:45.079 align:start position:0% Breaking Down based on customer 00:15:45.079 --> 00:15:46.829 align:start position:0% Breaking Down based on customer retention<00:15:45.519><c> rates</c><00:15:45.880><c> number</c><00:15:46.079><c> of</c><00:15:46.240><c> customers</c><00:15:46.680><c> net</c> 00:15:46.829 --> 00:15:46.839 align:start position:0% retention rates number of customers net 00:15:46.839 --> 00:15:49.150 align:start position:0% retention rates number of customers net sales<00:15:47.120><c> gross</c><00:15:47.399><c> sales</c><00:15:47.839><c> or</c><00:15:48.040><c> average</c><00:15:48.279><c> order</c> 00:15:49.150 --> 00:15:49.160 align:start position:0% sales gross sales or average order 00:15:49.160 --> 00:15:51.629 align:start position:0% sales gross sales or average order value<00:15:50.160><c> you</c><00:15:50.279><c> can</c><00:15:50.519><c> also</c><00:15:50.800><c> change</c><00:15:51.079><c> the</c><00:15:51.199><c> date</c><00:15:51.399><c> range</c> 00:15:51.629 --> 00:15:51.639 align:start position:0% value you can also change the date range 00:15:51.639 --> 00:15:53.870 align:start position:0% value you can also change the date range in<00:15:51.759><c> the</c><00:15:51.920><c> top</c><00:15:52.120><c> leftand</c><00:15:52.639><c> corner</c><00:15:53.000><c> here</c><00:15:53.399><c> to</c><00:15:53.639><c> fill</c> 00:15:53.870 --> 00:15:53.880 align:start position:0% in the top leftand corner here to fill 00:15:53.880 --> 00:15:55.910 align:start position:0% in the top leftand corner here to fill out<00:15:54.079><c> the</c><00:15:54.240><c> entire</c><00:15:54.639><c> data</c><00:15:54.959><c> table</c><00:15:55.639><c> if</c><00:15:55.720><c> you're</c> 00:15:55.910 --> 00:15:55.920 align:start position:0% out the entire data table if you're 00:15:55.920 --> 00:15:58.110 align:start position:0% out the entire data table if you're going<00:15:56.079><c> to</c><00:15:56.240><c> be</c><00:15:56.360><c> looking</c><00:15:56.560><c> at</c><00:15:56.720><c> LTV</c><00:15:57.319><c> numbers</c><00:15:57.920><c> it's</c> 00:15:58.110 --> 00:15:58.120 align:start position:0% going to be looking at LTV numbers it's 00:15:58.120 --> 00:16:00.509 align:start position:0% going to be looking at LTV numbers it's really<00:15:58.600><c> important</c><00:15:59.000><c> to</c><00:15:59.240><c> fill</c><00:15:59.480><c> out</c><00:16:00.000><c> the</c><00:16:00.160><c> entire</c> 00:16:00.509 --> 00:16:00.519 align:start position:0% really important to fill out the entire 00:16:00.519 --> 00:16:02.590 align:start position:0% really important to fill out the entire data<00:16:00.839><c> table</c><00:16:01.480><c> and</c><00:16:01.600><c> the</c><00:16:01.759><c> reason</c><00:16:02.120><c> being</c><00:16:02.360><c> is</c><00:16:02.480><c> that</c> 00:16:02.590 --> 00:16:02.600 align:start position:0% data table and the reason being is that 00:16:02.600 --> 00:16:04.910 align:start position:0% data table and the reason being is that if<00:16:02.680><c> you're</c><00:16:02.959><c> just</c><00:16:03.160><c> looking</c><00:16:03.480><c> at</c><00:16:04.120><c> uh</c><00:16:04.360><c> data</c><00:16:04.639><c> of</c><00:16:04.800><c> the</c> 00:16:04.910 --> 00:16:04.920 align:start position:0% if you're just looking at uh data of the 00:16:04.920 --> 00:16:07.350 align:start position:0% if you're just looking at uh data of the last<00:16:05.120><c> 12</c><00:16:05.399><c> months</c><00:16:06.000><c> you're</c><00:16:06.240><c> going</c><00:16:06.440><c> to</c><00:16:06.759><c> have</c><00:16:07.120><c> this</c> 00:16:07.350 --> 00:16:07.360 align:start position:0% last 12 months you're going to have this 00:16:07.360 --> 00:16:09.990 align:start position:0% last 12 months you're going to have this half<00:16:07.720><c> complete</c><00:16:08.079><c> data</c><00:16:08.399><c> table</c><00:16:09.199><c> whereby</c><00:16:09.800><c> if</c><00:16:09.920><c> you</c> 00:16:09.990 --> 00:16:10.000 align:start position:0% half complete data table whereby if you 00:16:10.000 --> 00:16:12.590 align:start position:0% half complete data table whereby if you were<00:16:10.160><c> to</c><00:16:10.279><c> do</c><00:16:10.360><c> an</c><00:16:10.480><c> LTV</c><00:16:11.040><c> analysis</c><00:16:11.800><c> and</c><00:16:12.000><c> let's</c><00:16:12.399><c> go</c> 00:16:12.590 --> 00:16:12.600 align:start position:0% were to do an LTV analysis and let's go 00:16:12.600 --> 00:16:14.710 align:start position:0% were to do an LTV analysis and let's go back<00:16:12.759><c> a</c><00:16:12.880><c> few</c><00:16:13.079><c> slides</c><00:16:13.519><c> here</c><00:16:14.160><c> if</c><00:16:14.240><c> you</c><00:16:14.360><c> were</c><00:16:14.480><c> to</c><00:16:14.600><c> do</c> 00:16:14.710 --> 00:16:14.720 align:start position:0% back a few slides here if you were to do 00:16:14.720 --> 00:16:17.910 align:start position:0% back a few slides here if you were to do an<00:16:14.800><c> LTV</c><00:16:15.319><c> analysis</c><00:16:15.839><c> of</c><00:16:16.360><c> October</c><00:16:17.360><c> and</c><00:16:17.480><c> you</c><00:16:17.600><c> took</c> 00:16:17.910 --> 00:16:17.920 align:start position:0% an LTV analysis of October and you took 00:16:17.920 --> 00:16:19.629 align:start position:0% an LTV analysis of October and you took net<00:16:18.160><c> sales</c><00:16:18.480><c> and</c><00:16:18.600><c> you</c><00:16:18.720><c> divided</c><00:16:19.040><c> by</c><00:16:19.160><c> first</c><00:16:19.360><c> order</c> 00:16:19.629 --> 00:16:19.639 align:start position:0% net sales and you divided by first order 00:16:19.639 --> 00:16:22.910 align:start position:0% net sales and you divided by first order sales<00:16:20.120><c> you'd</c><00:16:20.360><c> find</c><00:16:20.519><c> that</c><00:16:20.680><c> there's</c><00:16:20.880><c> no</c> 00:16:22.910 --> 00:16:22.920 align:start position:0% sales you'd find that there's no 00:16:22.920 --> 00:16:24.949 align:start position:0% sales you'd find that there's no LTV<00:16:23.920><c> and</c><00:16:24.040><c> that's</c><00:16:24.240><c> because</c><00:16:24.480><c> none</c><00:16:24.600><c> of</c><00:16:24.759><c> these</c> 00:16:24.949 --> 00:16:24.959 align:start position:0% LTV and that's because none of these 00:16:24.959 --> 00:16:26.949 align:start position:0% LTV and that's because none of these customers<00:16:25.399><c> have</c><00:16:25.560><c> come</c><00:16:25.800><c> back</c><00:16:25.959><c> and</c><00:16:26.120><c> bought</c> 00:16:26.949 --> 00:16:26.959 align:start position:0% customers have come back and bought 00:16:26.959 --> 00:16:30.829 align:start position:0% customers have come back and bought again<00:16:27.959><c> and</c><00:16:28.079><c> so</c><00:16:28.199><c> you</c><00:16:28.319><c> can't</c><00:16:28.920><c> really</c><00:16:29.279><c> do</c><00:16:29.880><c> an</c><00:16:30.040><c> LTV</c> 00:16:30.829 --> 00:16:30.839 align:start position:0% again and so you can't really do an LTV 00:16:30.839 --> 00:16:33.470 align:start position:0% again and so you can't really do an LTV analysis<00:16:31.480><c> on</c><00:16:31.759><c> the</c><00:16:31.959><c> last</c><00:16:32.199><c> 2</c><00:16:32.480><c> 3</c><00:16:32.720><c> 4</c><00:16:33.000><c> months</c><00:16:33.279><c> of</c> 00:16:33.470 --> 00:16:33.480 align:start position:0% analysis on the last 2 3 4 months of 00:16:33.480 --> 00:16:35.189 align:start position:0% analysis on the last 2 3 4 months of data<00:16:34.120><c> because</c><00:16:34.360><c> these</c><00:16:34.519><c> people</c><00:16:34.800><c> haven't</c><00:16:35.040><c> had</c> 00:16:35.189 --> 00:16:35.199 align:start position:0% data because these people haven't had 00:16:35.199 --> 00:16:38.269 align:start position:0% data because these people haven't had the<00:16:35.399><c> time</c><00:16:35.720><c> yet</c><00:16:36.360><c> to</c><00:16:36.600><c> come</c><00:16:36.839><c> back</c><00:16:37.240><c> and</c><00:16:37.440><c> repurchase</c> 00:16:38.269 --> 00:16:38.279 align:start position:0% the time yet to come back and repurchase 00:16:38.279 --> 00:16:42.110 align:start position:0% the time yet to come back and repurchase and<00:16:38.440><c> spend</c><00:16:38.800><c> money</c><00:16:39.800><c> and</c><00:16:39.959><c> so</c><00:16:40.759><c> when</c><00:16:40.959><c> you</c><00:16:41.360><c> sum</c><00:16:41.880><c> this</c> 00:16:42.110 --> 00:16:42.120 align:start position:0% and spend money and so when you sum this 00:16:42.120 --> 00:16:45.670 align:start position:0% and spend money and so when you sum this entire<00:16:43.240><c> table</c><00:16:44.240><c> yes</c><00:16:44.639><c> the</c><00:16:44.800><c> top</c><00:16:45.000><c> few</c><00:16:45.279><c> rows</c><00:16:45.560><c> are</c> 00:16:45.670 --> 00:16:45.680 align:start position:0% entire table yes the top few rows are 00:16:45.680 --> 00:16:47.309 align:start position:0% entire table yes the top few rows are going<00:16:45.759><c> to</c><00:16:45.880><c> be</c><00:16:46.040><c> accurate</c><00:16:46.680><c> but</c><00:16:46.800><c> the</c><00:16:46.920><c> bottom</c><00:16:47.199><c> are</c> 00:16:47.309 --> 00:16:47.319 align:start position:0% going to be accurate but the bottom are 00:16:47.319 --> 00:16:49.069 align:start position:0% going to be accurate but the bottom are all<00:16:47.440><c> going</c><00:16:47.560><c> to</c><00:16:47.639><c> be</c><00:16:47.800><c> inaccurate</c><00:16:48.680><c> and</c><00:16:48.800><c> so</c><00:16:48.920><c> it's</c> 00:16:49.069 --> 00:16:49.079 align:start position:0% all going to be inaccurate and so it's 00:16:49.079 --> 00:16:52.870 align:start position:0% all going to be inaccurate and so it's going<00:16:49.160><c> to</c><00:16:49.959><c> automatically</c><00:16:50.639><c> skew</c><00:16:51.120><c> towards</c><00:16:52.120><c> a</c> 00:16:52.870 --> 00:16:52.880 align:start position:0% going to automatically skew towards a 00:16:52.880 --> 00:16:54.670 align:start position:0% going to automatically skew towards a worse<00:16:53.240><c> LTV</c><00:16:53.800><c> it's</c><00:16:53.920><c> not</c><00:16:54.040><c> going</c><00:16:54.120><c> to</c><00:16:54.199><c> be</c><00:16:54.279><c> a</c><00:16:54.399><c> direct</c> 00:16:54.670 --> 00:16:54.680 align:start position:0% worse LTV it's not going to be a direct 00:16:54.680 --> 00:16:57.470 align:start position:0% worse LTV it's not going to be a direct representation<00:16:55.240><c> of</c><00:16:55.360><c> what</c><00:16:55.480><c> your</c><00:16:55.720><c> actual</c><00:16:56.000><c> LTV</c> 00:16:57.470 --> 00:16:57.480 align:start position:0% representation of what your actual LTV 00:16:57.480 --> 00:17:00.269 align:start position:0% representation of what your actual LTV is<00:16:58.759><c> a</c><00:16:58.880><c> few</c><00:16:59.040><c> things</c><00:16:59.240><c> to</c><00:16:59.399><c> look</c><00:16:59.560><c> out</c><00:16:59.759><c> for</c><00:17:00.160><c> when</c> 00:17:00.269 --> 00:17:00.279 align:start position:0% is a few things to look out for when 00:17:00.279 --> 00:17:01.550 align:start position:0% is a few things to look out for when you're<00:17:00.480><c> running</c><00:17:00.800><c> through</c><00:17:01.000><c> this</c><00:17:01.160><c> analysis</c> 00:17:01.550 --> 00:17:01.560 align:start position:0% you're running through this analysis 00:17:01.560 --> 00:17:02.710 align:start position:0% you're running through this analysis you're<00:17:01.720><c> changing</c><00:17:02.000><c> the</c><00:17:02.120><c> metrics</c><00:17:02.440><c> around</c> 00:17:02.710 --> 00:17:02.720 align:start position:0% you're changing the metrics around 00:17:02.720 --> 00:17:04.230 align:start position:0% you're changing the metrics around you're<00:17:02.880><c> looking</c><00:17:03.040><c> at</c><00:17:03.160><c> the</c><00:17:03.319><c> data</c><00:17:03.600><c> table</c><00:17:04.000><c> is</c> 00:17:04.230 --> 00:17:04.240 align:start position:0% you're looking at the data table is 00:17:04.240 --> 00:17:06.990 align:start position:0% you're looking at the data table is number<00:17:04.559><c> one</c><00:17:05.520><c> aov</c><00:17:06.120><c> should</c><00:17:06.520><c> always</c><00:17:06.799><c> be</c> 00:17:06.990 --> 00:17:07.000 align:start position:0% number one aov should always be 00:17:07.000 --> 00:17:09.350 align:start position:0% number one aov should always be increasing<00:17:07.600><c> over</c><00:17:07.880><c> time</c><00:17:08.520><c> so</c><00:17:08.679><c> if</c><00:17:08.760><c> you</c><00:17:08.880><c> sort</c><00:17:09.199><c> by</c> 00:17:09.350 --> 00:17:09.360 align:start position:0% increasing over time so if you sort by 00:17:09.360 --> 00:17:12.350 align:start position:0% increasing over time so if you sort by the<00:17:09.480><c> average</c><00:17:09.760><c> order</c><00:17:10.079><c> value</c><00:17:10.319><c> metric</c><00:17:11.199><c> here</c><00:17:12.199><c> you</c> 00:17:12.350 --> 00:17:12.360 align:start position:0% the average order value metric here you 00:17:12.360 --> 00:17:13.909 align:start position:0% the average order value metric here you want<00:17:12.480><c> to</c><00:17:12.600><c> be</c><00:17:12.760><c> making</c><00:17:13.039><c> sure</c><00:17:13.319><c> that</c><00:17:13.679><c> average</c> 00:17:13.909 --> 00:17:13.919 align:start position:0% want to be making sure that average 00:17:13.919 --> 00:17:16.230 align:start position:0% want to be making sure that average order<00:17:14.160><c> value</c><00:17:14.439><c> is</c><00:17:14.640><c> increasing</c><00:17:15.520><c> as</c><00:17:15.760><c> people</c><00:17:16.039><c> come</c> 00:17:16.230 --> 00:17:16.240 align:start position:0% order value is increasing as people come 00:17:16.240 --> 00:17:18.189 align:start position:0% order value is increasing as people come back<00:17:16.360><c> and</c><00:17:16.520><c> repeat</c><00:17:16.919><c> purchase</c><00:17:17.600><c> as</c><00:17:17.799><c> when</c><00:17:17.959><c> people</c> 00:17:18.189 --> 00:17:18.199 align:start position:0% back and repeat purchase as when people 00:17:18.199 --> 00:17:20.350 align:start position:0% back and repeat purchase as when people come<00:17:18.360><c> back</c><00:17:18.480><c> to</c><00:17:18.640><c> your</c><00:17:19.000><c> store</c><00:17:19.799><c> they</c><00:17:19.919><c> should</c><00:17:20.160><c> be</c> 00:17:20.350 --> 00:17:20.360 align:start position:0% come back to your store they should be 00:17:20.360 --> 00:17:22.069 align:start position:0% come back to your store they should be more<00:17:20.679><c> confident</c><00:17:21.079><c> in</c><00:17:21.319><c> your</c><00:17:21.520><c> brand</c><00:17:21.880><c> they're</c> 00:17:22.069 --> 00:17:22.079 align:start position:0% more confident in your brand they're 00:17:22.079 --> 00:17:23.189 align:start position:0% more confident in your brand they're bought<00:17:22.280><c> from</c><00:17:22.439><c> you</c><00:17:22.600><c> before</c><00:17:22.880><c> they</c><00:17:23.000><c> know</c><00:17:23.120><c> that</c> 00:17:23.189 --> 00:17:23.199 align:start position:0% bought from you before they know that 00:17:23.199 --> 00:17:25.429 align:start position:0% bought from you before they know that you're<00:17:23.400><c> reliable</c><00:17:23.839><c> they</c><00:17:24.000><c> like</c><00:17:24.160><c> your</c><00:17:24.439><c> products</c> 00:17:25.429 --> 00:17:25.439 align:start position:0% you're reliable they like your products 00:17:25.439 --> 00:17:26.510 align:start position:0% you're reliable they like your products and<00:17:25.520><c> so</c><00:17:25.679><c> they</c><00:17:25.799><c> should</c><00:17:25.959><c> be</c><00:17:26.039><c> spending</c><00:17:26.360><c> more</c> 00:17:26.510 --> 00:17:26.520 align:start position:0% and so they should be spending more 00:17:26.520 --> 00:17:28.870 align:start position:0% and so they should be spending more money<00:17:27.240><c> if</c><00:17:27.439><c> they</c><00:17:27.640><c> aren't</c><00:17:28.439><c> it</c><00:17:28.559><c> means</c><00:17:28.720><c> that</c> 00:17:28.870 --> 00:17:28.880 align:start position:0% money if they aren't it means that 00:17:28.880 --> 00:17:30.270 align:start position:0% money if they aren't it means that there's<00:17:29.000><c> a</c><00:17:29.160><c> fundamental</c><00:17:29.720><c> issue</c><00:17:30.000><c> with</c><00:17:30.120><c> your</c> 00:17:30.270 --> 00:17:30.280 align:start position:0% there's a fundamental issue with your 00:17:30.280 --> 00:17:32.230 align:start position:0% there's a fundamental issue with your offering<00:17:31.080><c> you</c><00:17:31.320><c> might</c><00:17:31.559><c> not</c><00:17:31.720><c> even</c><00:17:31.960><c> have</c><00:17:32.080><c> an</c> 00:17:32.230 --> 00:17:32.240 align:start position:0% offering you might not even have an 00:17:32.240 --> 00:17:34.270 align:start position:0% offering you might not even have an offer<00:17:32.600><c> avaluable</c><00:17:33.120><c> for</c><00:17:33.440><c> people</c><00:17:33.679><c> to</c><00:17:33.840><c> spend</c><00:17:34.120><c> more</c> 00:17:34.270 --> 00:17:34.280 align:start position:0% offer avaluable for people to spend more 00:17:34.280 --> 00:17:36.430 align:start position:0% offer avaluable for people to spend more money<00:17:35.000><c> and</c><00:17:35.120><c> that</c><00:17:35.240><c> needs</c><00:17:35.440><c> to</c><00:17:35.679><c> exist</c><00:17:36.200><c> so</c><00:17:36.360><c> you</c> 00:17:36.430 --> 00:17:36.440 align:start position:0% money and that needs to exist so you 00:17:36.440 --> 00:17:37.710 align:start position:0% money and that needs to exist so you need<00:17:36.559><c> to</c><00:17:36.720><c> put</c><00:17:36.840><c> some</c><00:17:37.000><c> kind</c><00:17:37.120><c> of</c><00:17:37.200><c> bundling</c> 00:17:37.710 --> 00:17:37.720 align:start position:0% need to put some kind of bundling 00:17:37.720 --> 00:17:40.470 align:start position:0% need to put some kind of bundling together<00:17:37.960><c> maybe</c><00:17:38.240><c> release</c><00:17:38.559><c> a</c><00:17:38.679><c> new</c><00:17:38.919><c> product</c><00:17:39.840><c> um</c> 00:17:40.470 --> 00:17:40.480 align:start position:0% together maybe release a new product um 00:17:40.480 --> 00:17:43.590 align:start position:0% together maybe release a new product um have<00:17:41.320><c> careful</c><00:17:41.720><c> upsells</c><00:17:42.440><c> that</c><00:17:42.640><c> allow</c><00:17:43.240><c> clever</c> 00:17:43.590 --> 00:17:43.600 align:start position:0% have careful upsells that allow clever 00:17:43.600 --> 00:17:45.710 align:start position:0% have careful upsells that allow clever upsells<00:17:44.039><c> sorry</c><00:17:44.559><c> that</c><00:17:44.720><c> allow</c><00:17:45.000><c> for</c><00:17:45.200><c> increased</c> 00:17:45.710 --> 00:17:45.720 align:start position:0% upsells sorry that allow for increased 00:17:45.720 --> 00:17:47.270 align:start position:0% upsells sorry that allow for increased average<00:17:45.960><c> order</c><00:17:46.280><c> value</c><00:17:46.720><c> but</c><00:17:46.840><c> there</c><00:17:46.960><c> needs</c><00:17:47.120><c> to</c> 00:17:47.270 --> 00:17:47.280 align:start position:0% average order value but there needs to 00:17:47.280 --> 00:17:49.110 align:start position:0% average order value but there needs to be<00:17:47.440><c> the</c><00:17:47.600><c> ability</c><00:17:48.160><c> for</c><00:17:48.400><c> the</c><00:17:48.559><c> customer</c><00:17:48.919><c> to</c><00:17:49.039><c> be</c> 00:17:49.110 --> 00:17:49.120 align:start position:0% be the ability for the customer to be 00:17:49.120 --> 00:17:51.549 align:start position:0% be the ability for the customer to be able<00:17:49.280><c> to</c><00:17:49.400><c> spend</c><00:17:49.720><c> more</c><00:17:50.280><c> when</c><00:17:50.440><c> they</c><00:17:50.760><c> return</c><00:17:51.440><c> if</c> 00:17:51.549 --> 00:17:51.559 align:start position:0% able to spend more when they return if 00:17:51.559 --> 00:17:53.870 align:start position:0% able to spend more when they return if you<00:17:51.760><c> don't</c><00:17:52.000><c> see</c><00:17:52.280><c> this</c><00:17:52.480><c> increasing</c><00:17:52.960><c> over</c><00:17:53.200><c> time</c> 00:17:53.870 --> 00:17:53.880 align:start position:0% you don't see this increasing over time 00:17:53.880 --> 00:17:55.149 align:start position:0% you don't see this increasing over time that's<00:17:54.000><c> a</c><00:17:54.120><c> large</c><00:17:54.400><c> red</c><00:17:54.559><c> flag</c><00:17:54.799><c> and</c><00:17:54.919><c> that's</c><00:17:55.039><c> an</c> 00:17:55.149 --> 00:17:55.159 align:start position:0% that's a large red flag and that's an 00:17:55.159 --> 00:17:57.470 align:start position:0% that's a large red flag and that's an opportunity<00:17:55.720><c> for</c><00:17:56.080><c> growth</c><00:17:56.799><c> number</c><00:17:57.080><c> two</c><00:17:57.400><c> you</c> 00:17:57.470 --> 00:17:57.480 align:start position:0% opportunity for growth number two you 00:17:57.480 --> 00:17:59.510 align:start position:0% opportunity for growth number two you can<00:17:57.600><c> do</c><00:17:57.799><c> product</c><00:17:58.080><c> break</c><00:17:58.559><c> Downs</c><00:17:59.080><c> so</c><00:17:59.200><c> if</c><00:17:59.320><c> you</c> 00:17:59.510 --> 00:17:59.520 align:start position:0% can do product break Downs so if you 00:17:59.520 --> 00:18:02.149 align:start position:0% can do product break Downs so if you come<00:17:59.880><c> down</c><00:18:00.120><c> to</c><00:18:01.000><c> not</c><00:18:01.240><c> the</c><00:18:01.400><c> customer</c><00:18:01.799><c> one</c><00:18:01.960><c> it's</c> 00:18:02.149 --> 00:18:02.159 align:start position:0% come down to not the customer one it's 00:18:02.159 --> 00:18:03.990 align:start position:0% come down to not the customer one it's actually<00:18:02.360><c> being</c><00:18:02.600><c> hidden</c><00:18:03.000><c> here</c><00:18:03.559><c> if</c><00:18:03.640><c> you</c><00:18:03.799><c> come</c> 00:18:03.990 --> 00:18:04.000 align:start position:0% actually being hidden here if you come 00:18:04.000 --> 00:18:06.789 align:start position:0% actually being hidden here if you come down<00:18:04.159><c> to</c><00:18:04.440><c> cohort</c><00:18:04.960><c> inclusion</c><00:18:05.960><c> you</c><00:18:06.120><c> can</c><00:18:06.360><c> sort</c> 00:18:06.789 --> 00:18:06.799 align:start position:0% down to cohort inclusion you can sort 00:18:06.799 --> 00:18:09.110 align:start position:0% down to cohort inclusion you can sort this<00:18:07.080><c> by</c><00:18:07.360><c> individual</c><00:18:08.080><c> product</c><00:18:08.520><c> types</c><00:18:08.880><c> or</c> 00:18:09.110 --> 00:18:09.120 align:start position:0% this by individual product types or 00:18:09.120 --> 00:18:11.110 align:start position:0% this by individual product types or collection<00:18:09.600><c> types</c><00:18:10.360><c> and</c><00:18:10.440><c> so</c><00:18:10.600><c> you</c><00:18:10.679><c> can</c><00:18:10.799><c> do</c><00:18:11.000><c> this</c> 00:18:11.110 --> 00:18:11.120 align:start position:0% collection types and so you can do this 00:18:11.120 --> 00:18:14.190 align:start position:0% collection types and so you can do this full<00:18:11.440><c> analysis</c><00:18:12.080><c> but</c><00:18:12.200><c> you</c><00:18:12.320><c> can</c><00:18:12.559><c> do</c><00:18:12.720><c> it</c><00:18:12.919><c> based</c><00:18:13.200><c> on</c> 00:18:14.190 --> 00:18:14.200 align:start position:0% full analysis but you can do it based on 00:18:14.200 --> 00:18:16.270 align:start position:0% full analysis but you can do it based on an<00:18:14.440><c> individual</c><00:18:14.960><c> collection</c><00:18:15.520><c> so</c><00:18:15.919><c> does</c><00:18:16.120><c> this</c> 00:18:16.270 --> 00:18:16.280 align:start position:0% an individual collection so does this 00:18:16.280 --> 00:18:17.549 align:start position:0% an individual collection so does this collection<00:18:16.720><c> have</c><00:18:16.880><c> better</c><00:18:17.120><c> returning</c> 00:18:17.549 --> 00:18:17.559 align:start position:0% collection have better returning 00:18:17.559 --> 00:18:20.149 align:start position:0% collection have better returning customer<00:18:18.000><c> rates</c><00:18:18.240><c> than</c><00:18:18.440><c> this</c><00:18:18.559><c> one</c><00:18:19.159><c> and</c><00:18:19.440><c> a</c><00:18:19.840><c> very</c> 00:18:20.149 --> 00:18:20.159 align:start position:0% customer rates than this one and a very 00:18:20.159 --> 00:18:21.870 align:start position:0% customer rates than this one and a very specific<00:18:20.640><c> example</c><00:18:21.000><c> of</c><00:18:21.159><c> how</c><00:18:21.320><c> this</c><00:18:21.440><c> would</c><00:18:21.600><c> apply</c> 00:18:21.870 --> 00:18:21.880 align:start position:0% specific example of how this would apply 00:18:21.880 --> 00:18:23.950 align:start position:0% specific example of how this would apply to<00:18:21.960><c> your</c><00:18:22.120><c> brand</c><00:18:22.840><c> is</c><00:18:23.000><c> let's</c><00:18:23.200><c> say</c><00:18:23.360><c> that</c><00:18:23.480><c> you</c><00:18:23.600><c> sell</c> 00:18:23.950 --> 00:18:23.960 align:start position:0% to your brand is let's say that you sell 00:18:23.960 --> 00:18:27.390 align:start position:0% to your brand is let's say that you sell two<00:18:24.240><c> primary</c><00:18:24.840><c> products</c><00:18:25.840><c> both</c><00:18:26.000><c> are</c><00:18:26.159><c> $100</c><00:18:27.159><c> both</c> 00:18:27.390 --> 00:18:27.400 align:start position:0% two primary products both are $100 both 00:18:27.400 --> 00:18:29.190 align:start position:0% two primary products both are $100 both sit<00:18:27.640><c> at</c><00:18:27.760><c> a</c><00:18:27.880><c> five</c><00:18:28.120><c> row</c><00:18:28.640><c> when</c><00:18:28.720><c> you</c><00:18:28.840><c> advertise</c> 00:18:29.190 --> 00:18:29.200 align:start position:0% sit at a five row when you advertise 00:18:29.200 --> 00:18:30.870 align:start position:0% sit at a five row when you advertise them<00:18:29.320><c> on</c><00:18:29.480><c> Google</c><00:18:29.720><c> and</c><00:18:29.880><c> Facebook</c><00:18:30.520><c> so</c><00:18:30.640><c> you're</c> 00:18:30.870 --> 00:18:30.880 align:start position:0% them on Google and Facebook so you're 00:18:30.880 --> 00:18:33.470 align:start position:0% them on Google and Facebook so you're pushing<00:18:31.159><c> them</c><00:18:31.400><c> both</c><00:18:31.799><c> equally</c><00:18:32.200><c> as</c><00:18:32.400><c> hard</c><00:18:33.280><c> but</c> 00:18:33.470 --> 00:18:33.480 align:start position:0% pushing them both equally as hard but 00:18:33.480 --> 00:18:35.070 align:start position:0% pushing them both equally as hard but what<00:18:33.600><c> you</c><00:18:33.720><c> might</c><00:18:34.000><c> find</c><00:18:34.280><c> when</c><00:18:34.440><c> you</c><00:18:34.640><c> do</c><00:18:34.880><c> this</c> 00:18:35.070 --> 00:18:35.080 align:start position:0% what you might find when you do this 00:18:35.080 --> 00:18:40.110 align:start position:0% what you might find when you do this analysis<00:18:35.679><c> is</c><00:18:35.880><c> that</c><00:18:36.080><c> the</c><00:18:36.600><c> LTV</c><00:18:37.600><c> on</c><00:18:37.919><c> product</c><00:18:38.360><c> B</c><00:18:39.080><c> is</c> 00:18:40.110 --> 00:18:40.120 align:start position:0% analysis is that the LTV on product B is 00:18:40.120 --> 00:18:45.270 align:start position:0% analysis is that the LTV on product B is $250<00:18:41.120><c> but</c><00:18:41.240><c> the</c><00:18:41.320><c> LTV</c><00:18:41.799><c> on</c><00:18:42.000><c> product</c><00:18:43.000><c> a</c><00:18:44.000><c> is</c> 00:18:45.270 --> 00:18:45.280 align:start position:0% $250 but the LTV on product a is 00:18:45.280 --> 00:18:48.590 align:start position:0% $250 but the LTV on product a is 120<00:18:46.280><c> and</c><00:18:46.440><c> so</c><00:18:46.799><c> when</c><00:18:46.919><c> you</c><00:18:47.120><c> look</c><00:18:47.280><c> at</c><00:18:47.559><c> that</c><00:18:48.120><c> you</c><00:18:48.320><c> go</c> 00:18:48.590 --> 00:18:48.600 align:start position:0% 120 and so when you look at that you go 00:18:48.600 --> 00:18:50.230 align:start position:0% 120 and so when you look at that you go okay<00:18:48.720><c> we</c><00:18:48.840><c> should</c><00:18:49.000><c> actually</c><00:18:49.320><c> be</c><00:18:49.480><c> spending</c><00:18:50.000><c> way</c> 00:18:50.230 --> 00:18:50.240 align:start position:0% okay we should actually be spending way 00:18:50.240 --> 00:18:51.870 align:start position:0% okay we should actually be spending way more<00:18:50.480><c> on</c><00:18:50.679><c> customer</c><00:18:51.039><c> acquisition</c><00:18:51.440><c> for</c><00:18:51.640><c> product</c> 00:18:51.870 --> 00:18:51.880 align:start position:0% more on customer acquisition for product 00:18:51.880 --> 00:18:53.710 align:start position:0% more on customer acquisition for product B<00:18:52.080><c> than</c><00:18:52.159><c> we</c><00:18:52.280><c> should</c><00:18:52.520><c> for</c><00:18:52.679><c> product</c><00:18:52.960><c> a</c><00:18:53.480><c> because</c> 00:18:53.710 --> 00:18:53.720 align:start position:0% B than we should for product a because 00:18:53.720 --> 00:18:57.990 align:start position:0% B than we should for product a because we<00:18:54.000><c> unlock</c><00:18:55.000><c> a</c><00:18:55.200><c> repeat</c><00:18:55.720><c> purchase</c><00:18:56.240><c> of</c><00:18:56.640><c> $150</c><00:18:57.640><c> here</c> 00:18:57.990 --> 00:18:58.000 align:start position:0% we unlock a repeat purchase of $150 here 00:18:58.000 --> 00:19:00.549 align:start position:0% we unlock a repeat purchase of $150 here which<00:18:58.120><c> we</c><00:18:58.320><c> we</c><00:18:58.400><c> don't</c><00:18:58.559><c> do</c><00:18:58.840><c> here</c><00:18:59.760><c> and</c><00:18:59.880><c> so</c><00:19:00.200><c> just</c><00:19:00.400><c> by</c> 00:19:00.549 --> 00:19:00.559 align:start position:0% which we we don't do here and so just by 00:19:00.559 --> 00:19:01.990 align:start position:0% which we we don't do here and so just by making<00:19:00.840><c> that</c><00:19:01.000><c> analysis</c><00:19:01.480><c> then</c><00:19:01.640><c> making</c><00:19:01.880><c> that</c> 00:19:01.990 --> 00:19:02.000 align:start position:0% making that analysis then making that 00:19:02.000 --> 00:19:04.270 align:start position:0% making that analysis then making that change<00:19:02.240><c> in</c><00:19:02.400><c> spend</c><00:19:02.720><c> distribution</c><00:19:03.280><c> across</c><00:19:04.120><c> uh</c> 00:19:04.270 --> 00:19:04.280 align:start position:0% change in spend distribution across uh 00:19:04.280 --> 00:19:06.990 align:start position:0% change in spend distribution across uh customer<00:19:04.720><c> acquisition</c><00:19:05.280><c> based</c><00:19:05.520><c> on</c><00:19:06.000><c> skew</c> 00:19:06.990 --> 00:19:07.000 align:start position:0% customer acquisition based on skew 00:19:07.000 --> 00:19:08.789 align:start position:0% customer acquisition based on skew you'll<00:19:07.200><c> see</c><00:19:07.440><c> a</c><00:19:07.640><c> significant</c><00:19:08.240><c> uptick</c><00:19:08.600><c> in</c><00:19:08.679><c> the</c> 00:19:08.789 --> 00:19:08.799 align:start position:0% you'll see a significant uptick in the 00:19:08.799 --> 00:19:10.390 align:start position:0% you'll see a significant uptick in the profitability<00:19:09.360><c> of</c><00:19:09.480><c> the</c><00:19:09.640><c> business</c><00:19:10.080><c> and</c><00:19:10.280><c> the</c> 00:19:10.390 --> 00:19:10.400 align:start position:0% profitability of the business and the 00:19:10.400 --> 00:19:11.669 align:start position:0% profitability of the business and the revenue<00:19:10.720><c> of</c><00:19:10.840><c> the</c><00:19:10.960><c> business</c><00:19:11.240><c> as</c><00:19:11.400><c> well</c><00:19:11.559><c> is</c> 00:19:11.669 --> 00:19:11.679 align:start position:0% revenue of the business as well is 00:19:11.679 --> 00:19:13.630 align:start position:0% revenue of the business as well is you'll<00:19:11.880><c> have</c><00:19:12.039><c> better</c><00:19:12.320><c> repeat</c><00:19:12.720><c> purchase</c><00:19:13.120><c> rates</c> 00:19:13.630 --> 00:19:13.640 align:start position:0% you'll have better repeat purchase rates 00:19:13.640 --> 00:19:15.149 align:start position:0% you'll have better repeat purchase rates which<00:19:13.720><c> will</c><00:19:13.919><c> increase</c><00:19:14.360><c> returning</c><00:19:14.799><c> customer</c> 00:19:15.149 --> 00:19:15.159 align:start position:0% which will increase returning customer 00:19:15.159 --> 00:19:17.110 align:start position:0% which will increase returning customer Revenue<00:19:15.960><c> which</c><00:19:16.080><c> is</c><00:19:16.200><c> going</c><00:19:16.360><c> to</c><00:19:16.480><c> skew</c><00:19:16.840><c> monthly</c> 00:19:17.110 --> 00:19:17.120 align:start position:0% Revenue which is going to skew monthly 00:19:17.120 --> 00:19:19.149 align:start position:0% Revenue which is going to skew monthly Revenue<00:19:17.480><c> up</c><00:19:17.600><c> and</c><00:19:17.799><c> significantly</c><00:19:18.400><c> skew</c><00:19:18.760><c> up</c> 00:19:19.149 --> 00:19:19.159 align:start position:0% Revenue up and significantly skew up 00:19:19.159 --> 00:19:21.190 align:start position:0% Revenue up and significantly skew up profitability<00:19:20.159><c> because</c><00:19:20.360><c> it's</c><00:19:20.640><c> really</c><00:19:21.000><c> really</c> 00:19:21.190 --> 00:19:21.200 align:start position:0% profitability because it's really really 00:19:21.200 --> 00:19:23.029 align:start position:0% profitability because it's really really doesn't<00:19:21.520><c> cost</c><00:19:21.760><c> much</c><00:19:21.919><c> to</c><00:19:22.080><c> get</c><00:19:22.159><c> a</c><00:19:22.320><c> user</c><00:19:22.679><c> back</c><00:19:22.840><c> to</c> 00:19:23.029 --> 00:19:23.039 align:start position:0% doesn't cost much to get a user back to 00:19:23.039 --> 00:19:24.190 align:start position:0% doesn't cost much to get a user back to site<00:19:23.240><c> to</c><00:19:23.400><c> buy</c> 00:19:24.190 --> 00:19:24.200 align:start position:0% site to buy 00:19:24.200 --> 00:19:26.669 align:start position:0% site to buy again<00:19:25.200><c> and</c><00:19:25.320><c> the</c><00:19:25.480><c> third</c><00:19:25.720><c> thing</c><00:19:25.880><c> to</c><00:19:26.039><c> look</c><00:19:26.200><c> out</c><00:19:26.360><c> to</c> 00:19:26.669 --> 00:19:26.679 align:start position:0% again and the third thing to look out to 00:19:26.679 --> 00:19:27.950 align:start position:0% again and the third thing to look out to is<00:19:26.760><c> that</c><00:19:26.880><c> you</c><00:19:27.000><c> want</c><00:19:27.080><c> to</c><00:19:27.200><c> be</c><00:19:27.280><c> viewing</c><00:19:27.720><c> last</c> 00:19:27.950 --> 00:19:27.960 align:start position:0% is that you want to be viewing last 00:19:27.960 --> 00:19:29.549 align:start position:0% is that you want to be viewing last year's<00:19:28.480><c> data</c><00:19:28.760><c> once</c><00:19:28.960><c> again</c><00:19:29.120><c> if</c><00:19:29.200><c> you're</c><00:19:29.360><c> looking</c> 00:19:29.549 --> 00:19:29.559 align:start position:0% year's data once again if you're looking 00:19:29.559 --> 00:19:31.510 align:start position:0% year's data once again if you're looking at<00:19:29.679><c> LTV</c><00:19:30.280><c> metrics</c><00:19:30.960><c> so</c><00:19:31.080><c> that</c><00:19:31.200><c> you</c><00:19:31.320><c> can</c> 00:19:31.510 --> 00:19:31.520 align:start position:0% at LTV metrics so that you can 00:19:31.520 --> 00:19:33.590 align:start position:0% at LTV metrics so that you can completely<00:19:32.000><c> fill</c><00:19:32.240><c> out</c><00:19:32.440><c> this</c><00:19:32.640><c> data</c><00:19:32.919><c> table</c><00:19:33.480><c> and</c> 00:19:33.590 --> 00:19:33.600 align:start position:0% completely fill out this data table and 00:19:33.600 --> 00:19:35.230 align:start position:0% completely fill out this data table and have<00:19:33.720><c> an</c><00:19:33.919><c> accurate</c><00:19:34.240><c> representation</c><00:19:34.880><c> of</c><00:19:35.080><c> what</c> 00:19:35.230 --> 00:19:35.240 align:start position:0% have an accurate representation of what 00:19:35.240 --> 00:19:37.710 align:start position:0% have an accurate representation of what these<00:19:35.440><c> cohorts</c><00:19:36.080><c> did</c><00:19:36.640><c> over</c><00:19:36.880><c> the</c><00:19:37.000><c> following</c><00:19:37.360><c> 12</c> 00:19:37.710 --> 00:19:37.720 align:start position:0% these cohorts did over the following 12 00:19:37.720 --> 00:19:40.720 align:start position:0% these cohorts did over the following 12 months