Speaker 1: Hi this is Daniel here and in this video I'm going to show you how to use my KPI tracking sheet and this is a very simple but effective tool that helps you run your business in a smarter way and get better results so I'm excited to share it with you. Now if you're already here you've also been able to so meaning if you're already inside this sheet like I am you've already been able to access that which is great but if not you will find the link to access this sheet this tool below this video so once you click that link and you're in here with me the first thing you want to do is you want to what's this training here so step one is learn how to set up and utilize KPS in your business so before you actually use the tool which is this you want to understand what KPIs are and how they work and how to make them work for your business. So how do you select the KPIs, what is the time frame you want to use and then how do you actually put them to practice in your business and with your team if you have one. So the first step is to learn how to set up and utilize KPIs in your business and you can do that for free by watching this video. Now once you've done that, step two is learn how to use this KPI tracking tool properly and that's the video you're watching right now. So you're already watching that. Step three is add the tracker to your drive. So once you watch the video which you're watching now in full, then after that complete step three. So to add the tracker to your drive so you have a version that you can actually edit and use for your business you just want to click on file and make a copy and then select the folder in your drive and make a copy and that's how you save a copy that you can actually use. And then step four is to set up your KPI tracker and use it religiously on a weekly or monthly basis. So right now let's complete this step and I'll show you how to use this tool. So the first thing you want to know, which you will have learned here in step one, is whether or not you want to use a weekly or monthly time frame. So we have both and depending on the business you're in and a few different factors, weekly or monthly will make more sense in your case. So I'll start by showing you the weekly. So usually this is better for for example e-commerce businesses, right? The weekly timeframe, Amazon FBA, things like that. So it's very simple. As you can see, we have the weeks here and we have a date. So what this represents is basically just the day that you input the data. So that would be, cause this is a weekly timeframe, that would be the data from the seven days before this date. before this date. So let's say it's Monday, January 10th, you're inputting the data, then you would be putting in the data from Monday 3rd to 9th, right? And that's what you put in on the 10th. And on the 17th, you would put in the data from 10th to 16th, right? So it's seven days combined. So I'm not gonna teach you again how to decide what the KPS are going to be in this video. that is back here in step one. So if you haven't watched that again, watch that first. But once you have the KPIs you want to use, then you simply write those in here, right? What they are. And then you will simply put in the number. So whatever the measurement is, each week you come in and you populate the sheet with the numbers again for the past seven days. So, you know, it goes on like this. five, seven, 10, eight, or nine, two, like it just depends on what the KPI is, right? But that's what you learn to determine, again, in the first video. Now, this is the weekly, and it's literally just that simple. You just put it in every single week, and that's how you track it. Now, I'm gonna show you one more trick here at the end, but that's the basic principle. For the monthly timeframe, it's actually less data. So this is usually better for things like, perhaps like a service-based business or a consulting type of business. Basically any business that has fewer transactions. So weekly, again, e-commerce, things like that, that have more frequent transactions, many smaller transactions, but businesses that have fewer, larger transactions, they will usually be a better fit for the monthly timeframe. So as you can see, this one has a slightly different structure, meaning we actually have the timeframe up here. So in the weekly, we have a vertical setup for the data. In the monthly, we have a horizontal setup. So the timeframe is up here. So this is just basically each month. So the way this works is that you would put in the data actually the day after this final day of the month. So for January, you would be putting in the data from or for the 1st of January until the 31st of January. So you can do this on February 1st. Likewise for February, you could do that on March 1st And that would be February 1st to February 20th combined, that data. So same goes, you will select the KPIs and write them out. And then you will simply put in the data points each month. And that's how you track it. Now, final thing I want to show you, it's really this simple. The power really comes from how you use the tool, like how you select and work with the KPIs and how you use this data to inform decisions and be smarter running your business and really keep track of it keep your finger on the pulse again I explain everything about how that works here in this video the final thing I want to show you is basically how to make this a little bit more visual because it's just numbers at this point so let's take this weekly time frame as an example same applies on the monthly but it's actually even more useful on the weekly I would say but both certainly works for both so one thing that Google Sheets has that's really useful is called conditional formatting so this allows you to color code the data so basically let's take the example again here with KPI 2 just using obviously a random example but let's say you know we had this data here and it was fluctuating a bit so I'll just create a sample data set something like this right so what we can do is we can come and apply conditional formatting you know for the entire for the entire column so you would come down here so format conditional formatting and then you can actually choose a color scale right and then you can choose a different way to do it so you could have you know the lowest number be with the strongest color or you could have the highest number of the strongest color so let's use this as an example so in this case it just helps me see it clearer visually what's going on so this KPI and you can do it for an entire data set as well which will make it even yeah even more insightful right but it will basically help you highlight the changes and the fluctuations so if this is like a positive thing where it's a good thing that it increases then this would be a good way to do it because it will highlight the good weeks. If the reverse were true so let's say a low score is like a very negative thing then you you could, for example, use this. So it would show you where it's really low and maybe that's something you need to fix and it's like an urgent thing, kind of like a red flag. So this would help you see that visually, right? So that's how that works. And you can use that to make your KPI tracker more visual and help things pop out more. So again, you can use it per column or for the entire data set. Usually it would make more sense for each column though, because they are individual KPIs, but it depends. You can check it out for yourself. And again, you can apply the same for the monthly. So that's how to use this KPI tracking tool properly. And I hope you really enjoy it and get a lot out of it. The main thing is to actually set it up and then use it religiously on a weekly or a monthly basis, depending on your timeframe. and use it religiously, never miss a beat, and really have it in front of you and in front of your team, let's say on a weekly meeting, or at least on a consistent schedule, and then use it to make better decisions, be smarter with your business, catch problems faster, prevent problems, and ultimately get better results in your business. So I hope you enjoy this tool and talk to you soon.