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

Blue Sense Digital

YouTube 수집: 2026-11-05 게시: 2024-01-11
https://youtu.be/DnpYApVNu-Y

내용

[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

이 자료가 속한 분류

리텐션 전략 개요
Shopify 애널리틱스
CAC·LTV
코호트·리텐션 분석

← 돌아가기