need to calculate the customer lifetime value for your store well you're in the right place because i'm going to walk you through it step by step in this video let's go [Music] yeah yeah oh yeah okay so in this method i'm going to show you how to calculate the customer lifetime value for your store keep in mind that this does require you to have been running your store for some time you need to already have orders already made people have purchased from your store and you have customers with that in mind let's jump into my
computer and let's get into it hey guys so now we're in the shopify dashboard i've gone to the order section here so now we can see all the orders for the store and we want to click export all orders plain csv file and click export orders so once we do that it's going to take some time and then it's going to send us an email with a link to download all the orders for the store it can take a bit of time depending on on how many orders you have okay guys so now we've got
this email from shopify with a link to the csv that we exported we're gonna click the link it's gonna download that file once it's downloaded open that up it's gonna open up in whatever spreadsheet software you have if you don't have any spreadsheet software you can actually drag this straight into google sheets google drive and it will let you open it in there we're going to copy everything so i like to click click that triangle at the top and it copies it selects everything then you can copy go back into google sheets and create a
new google sheet and paste this i like to paste values only so it doesn't take all the formatting or anything like that that might be in there it does save a bit of time as well once it's pasted we've got it all there i do like to filter it just because then it allows me to manipulate that data later on what we're going to do is open up a new tab and this is where we're going to do the calculations i'm going to put the formulas in the description so you can just copy and paste
straight into your google sheets what we're going to do is we're going to put in equals unique what this is going gonna do it's gonna get all the unique emails for our customers so boom so it's listed out already all the emails for our customers which there's a lot for this store uh what i'm gonna do actually is i'm gonna put this at the very top so i can even just move this actually and that's gonna move all of them up to the very top fantastic so we have a list of all the customers even
if they've completed many orders it's only gonna show them once because it's the unique then the unique value next we're to do is equals countif so what this does is it counts how many orders we've actually had for each person so we're going to select all the emails in the sheet and then we're going to go back here and the criteria is going to be that email so once that's done press enter select and then we're going to copy this and then we're going to go all the way down to the bottom the bottom one
hold shift and click paste and then it's going to paste all of those in there and we're going to see already who all how many orders each person has had i'm going to change this to number of orders and the next thing we're going to do is we're going to get the total value of each customer so we're going to do the same thing but we're going to use sumif and we're going to go back and get the range and the first one we're going to get is the range of all the emails select all
of that comma we're going to go back and select the email again comma go back and then select the total which is what we're going to sum and so boom so we have that in there we're going to add the pricing so it changes to the actual price i'm going to copy this scroll all the way down hold shift select them all paste it's then going to paste in all the values it's basically what this formula is doing it's going back to that sheet and going okay if it's that email add it up keep adding
them all up and so once that have multiple purchases it's going to have them there all added up like that that's fantastic okay cool awesome so now that we have that what we can do here is get customer lifetime value and average purchases per customer per customer so these are both really awesome metrics to know about and so what we can do here is just really easy just go average and then just select all the orders here all the different people sorry so the average the customer lifetime value is 640 for this store and the
average purchases per customer same thing let's just select this column boom so not many but the average person purchases 1.0 six times basically so they're not getting many repeat customers so this is a good sign that maybe this store may not be delivering great products maybe they're not doing much retargeting or marketing after someone purchases so i would say it's a big opportunity here and this is the customer lifetime value so how much the each customer is actually worth and now we're going to go into some steps and tips on how we can actually improve
that so that should be everything to calculate everything for your store if you have any problems please leave a comment and i'll answer them as soon as i can thanks for watching this bit okay so now that we've calculated our customer lifetime value how do we actually improve this metric something that's really important to keep in mind here is that the customer lifetime value is made up of two main parts if you can increase either of these parts you're going to improve the customer lifetime value of your store and you're just going to be more
profitable generate more for your store it's going to be worth more if you want to sell it later the first one is the size of the order when someone buys from you the second is the number of times someone buys from you in other words get people to spend more money per transaction and then come back and spend more and you're going to increase your customer lifetime value okay so the first one how do we increase the average order value that is how much someone spends on one time on your store i've actually done an
in-depth video for calculating this and improving it so i'll leave a link in the description please go check out that video because i do go deeper into this section the first tip i recommend is having some sort of free shipping threshold usually i do recommend having free shipping across the whole store but if you can't do that then you can offer a free shipping over a certain amount purchased for example someone comes to your store they have to pay for shipping up to a hundred dollars but over a hundred dollars they get free shipping this
is going to incentivize people to spend more and get that free shipping tier because they think it's free even though you've included that into the actual pricing for your products the second one is very similar but you can offer discounts if they spend a certain amount so say for example someone spends 150 in your store that's great because it increases your average order value what you can do is give them a five ten percent discount if they spend over 150 dollars maybe 200 it's up to you what i recommend with all these tips is calculate
your own average order value and then set a goal save it's a hundred dollars and you want to get that up to 120 well then work out okay well then if people spend over 150 they get free shipping that's not going to help all orders but many of them they will go for that 150 and you're gonna see your average order value increase bit by bit another tip is you can have bundle deals so buy one get one 50 percent off that's pretty standard you can also do cross sells and upsells so cross sells is
when you offer another product that's similar but it's a replacement for that product that they're looking at someone might come into your store from google ads and they come in clicking on one product because they thought oh that fits my price point but underneath you can have related products and suggest a product that might be more expensive but they'll see oh this actually solves my need much better and they're willing to pay for that and boom you just increase the average order value the other one is upsells so this means they might get the checkout
and you can recommend different accessories and different other products that they can buy to improve their experience add more value to that order and boom that same customer acquisition cost and you've increased the average order value another one that's really easy is to add gifts if they spend over a certain amount so say if they spend over 500 which could be a big amount for your store you can give them a free cover or a free toy or some sort of free thing that does complement or help that product maybe in some way i wouldn't
make it totally unrelated i would make that related actually in your niche but you can have some sort of free gift and you can even pay for this at cost but just having it there as an incentive that's free can really help increase that average order value because people love free things just like free shipping and so having that there people are going to be more incentivized to to buy that higher price product or increase their order value and and then you can benefit from that from an increased average order value okay the second thing
that you want to do is increase the average amount of times that someone purchases from you we're talking about repeat customers here people we want people to come in buy from you and then later come back and keep buying keep buying you spent all that money in the start if you can get that person to keep repeat purchases from you that's going to be way better for your profit bill in your in the long run and this is really how you build a brand the easiest way to do this and what you should be doing
already is just have good value just provide great customer service this means free shipping swift responses to all the live chat emails and phone calls everything like that it means shipping as quickly as possible lower the handling times just make the customer experience as good as possible as good as you possibly can because if someone experiences good from your store they're not frustrated then they're going to come back and keep purchasing and that's really how you build a brand another thing you can do to increase repeat customers is to sell a product that people keep
on buying this might be something like a subscription box subscription service or even in a niche where people love to keep expanding and buying other items this can be a product that maybe runs out or expires and people want to keep buying to keep having a great experience one example i have is i have some buddies that sell travel sim cards and i help them scale up their store big time what they sell travel sim cards so people go flying overseas and they want to have data in overseas countries without paying crazy roaming fees well
they have a lot of travelers that will have a great experience the first time they pay all this money acquire them through ads and then they will go on their trip the next year and the next year and the next year and they keep buying and they didn't have to keep spending money on this this customer to keep getting them in the funnel they can just retarget them with with uh email marketing and also some basic retargeting ads and boom you've just got a repeat customer from a product that gets used up and people keep
wanting to use it it's a great great thing okay i touched on this a little bit but another big thing you can do is re-target past customers say if someone comes into your funnel they purchase you add them to an audience where you can do retargeting ads on the display network on facebook as well as email marketing and you can really pull them back in for a second purchase and you can set some sort of timer some delay so that you send out email campaigns some sort of post purchase flow after they've converted but wait
say 30 days and you really want to target this depending on your store what your products are like and what you think people will keep purchasing and this does require a bit of market research and even just looking at your data and going okay people that purchase the second time what are they purchasing why are they purchasing that is it for a friend or family member is it for themselves and then you can tailor all the copy in the emails in the banneras on the facebook ads around that sort of thing and the last thing
i really want to recommend is focusing on building a brand and this is something that very few people do in e-commerce and it's the big players the successful ones that have done this well and it's paid off in spades and what do i mean by this i mean think about a brand like apple they have people that would kill for their products they have people that would never buy anything else except apple apple apple it doesn't matter if apple puts out some piece of crap they're still gonna buy it you want customers like that because
these are people that are gonna go out into the world show everyone your products tell everyone about them and even argue on your behalf they go to war for your brand and you don't have to pay them anything they're doing it for free and this is the dream for an e-commerce store but no one's really thinking about this i've seen this in example in facebook ads and you look at the comments section and they'll be people maybe throwing shade on some sort of product that you're selling but then there are these loyal customers and you
don't even tell them anything and they come in and defend you when you have stuff like that people are gonna see those customers and that adds insane social proof and that's where suddenly you have people that are coming back and buying but they're also telling other people about your store and that's how you build a brand that just grows and grows and grows and you're not relying just on one channel of marketing or anything like that but you're building an organism that's almost has its own life form and it kind of just grows on its
own okay that was a lot of stuff to go over but i really hope it helps you understand customer lifetime value how to calculate it and then some tips on how to improve it if this video was helpful to you please smash the like button that really helps us keep making this content for you guys and if you want to see more and more content tutorials case studies all that sort of stuff please subscribe because we're gonna be putting this stuff out on a very regular basis and as always if you have any questions at
all please leave them below in the comments section i'll get back to as soon as i can until next time guys thanks for watching and bye for now [Music] you