Reporting, Dashboards and Tracking Metrics

00:00 um yeah so I thought today we'd go through do a little bit more of a date of it to report it, um and the dashboard in particular, but also the orders screen. 00:16 All the sorry all the filters on the order screen in particular. Um and we might even try and cover off some in the customer screen as well. 00:24 And if we really want we can go into um see a sphere as well. Um although. You know don't necessarily need today need to database a lesson on these phase. 00:37 Um so do you guys have any questions in particular around the dashboard? I mean it's you know why we built why we built the graphs that we built. 00:51 Um so any initial feedback on it? Um I guess one question is um it looks pretty um comprehensive. Uh what's fading and what's the outcome? 01:04 And what's it kind of? How's it going to help the winery? So in the dash so you can actually hover your mouse over this little eye um on every graph to see what is you know where the data is coming from. 01:18 So um. So for example here umm you can see we've taken into account cancelled orders umm if we look at club growth and churn you can see you know for example if exclusives maybe ships that have been transferred right so we kind of go in and say every graph. 01:36 If this is what what what's behind the numbers umm the reason why we kind of started off with these graphs umm and we we want to do a lot more but this was kind of like a starting point was really basically. 01:53 These sorts of figures here you know like just total sales is really kind of a bit of a meaningless number. 02:00 Umm the real umm indicators here are umm your growth figure and that can be year on year. Year growth month on month growth. 02:09 Umm but also your average order value. Umm a lot of people would be doing a lot better if they just got their average order values up. 02:17 Umm especially at the moment when you know umm you know visitation to the seller doors is down. Umm so you know we might just want to increase umm average order values that are going through going through the system. 02:32 That's why we broke it down into total sales. Then we broke it down by each channel. You're pouring a sour, you're wine club. 02:40 The website orders umm and so we broke it down by each channel. Umm so the same data shown for different ways. 02:50 So total pause, clubs, websites. Then down the bottom. Let's explain the relevance of it. Yeah so let's go back. Yeah so let's say we want to see the data for last month. 03:07 Right? Umm so we so this first one here is. You know show me data for last month this year this financial year last year and you can actually select on the date range as well and just go back as far as you want in time. 03:21 Umm and so you know this is the period I want to look at so at the moment we're comparing last month and we're comparing it with. 03:28 The previous period which is the month before. Umm now we can go well I want want to compare it with the previous year so I want to compare first of April to the 30th of April 24th with the same month into. 03:44 Um and then we've got this fun. Yeah yeah and then we've got um so yeah so you can compare as I said previous period previous month or previous year and then we've also. 04:00 I've also got this breakdown um we can say I want to see the the data being on a daily basis or on a weekly basis so and you'll see this is the little refresh thing up here so you can you can change it out. 04:15 Now if you're doing this. It's small if you're doing um like a shorter a shorter time frame um I can actually go down to our le right you got our le in daily so you can actually go down to the our le level where you can start to see. 04:32 At what times people were um we're putting those orders through. Um so let's go back and we'll go last month and compared with the previous year. 04:42 Year on year growth is really the standard you don't necessarily want to be comparing April with March because. You know you might have done your club running March and no club runs in April. 04:52 Um but you know year on year is certainly the sort of the standard go to indicator. Um so I think these ones are pretty straightforward. 05:04 Thank you. You can see the grade line is the comparison of the pink line is you know the actual. Um and yeah and then we've put in the the growth or growth or decline after each. 05:18 Um. Going down here mailing list and club membership so. Uh three graphs each. Obviously you're you're running total. Um your growth and your churn. 05:31 So you know obviously you want your growth to be bigger than your. Um and we've done it also where um if the growth so let's say for example if the churn is decreasing. 05:48 Um we've actually made you know that's a green. Because it might be minus 40% but um you want less churn therefore we've made it green instead of red. 06:03 Umm so yeah and then um churn is attrition if some. We use churn some people use attrition some people use another thing but basically just you know how many of you lost how many be gained and what's your running total so you can actually see how things are tracking over a period of time and if we did 06:21 so let's say we do this financial gear or actually. If we do let's do this financial gear. Umm there you go you can so you can see the the previous year uhh the financial year 23 compared to the financial year 24 you could see. 06:40 Growth was a lot better in the previous year. Umm for club memberships and then this year it's they pretty flat. 06:47 This is all testing diver obviously. Umm. So yeah so you can get those insights umm to see so how you tracking. 06:56 So as I said this was sort of like our first you know our first V1. Umm but there's like another there's a there's about another 16 that I'd like to do. 07:08 Umm but umm yeah we'll just we'll get to it. One thing too. That people may not be aware it's this is your your daily summary as well. 07:17 Umm so you can actually click on these as well. Umm so if you want to see the graph for mailing this growth or club growth you can do that. 07:28 Umm and this is where like you might sort of you know you might be able to start drawing out some imprints as well. 07:34 People tend to join the wine club later in the afternoon for example. Umm so this is sort of being able to see your data in a graphical format is obviously. 07:44 I'm much easier way to to comprehend it. Umm so that is sort of the the graphs out of the box. 07:53 Now something that we've been working on on the side. Umm and it's not officially released yet but umm. We have been umm demoing it to a few clients. 08:04 We actually had one yesterday. Umm and the need I don't know if you've seen this all night yet but umm. 08:10 We've been working on an integration with Power BI. Umm do you know what Power BI is? Yeah. Yeah cool. So Power BI for those who don't know Power BI is umm just it's a Microsoft product like you know they've got word they've got Excel they've got Power BI. 08:27 Umm and Power BI is essentially just umm. Graphs uhh is just like a graph and analytics program so umm if you've got data in an Excel spreadsheet or if you've got data in a database like we do umm you can just have that data position. 08:54 So we kind of go okay out of the box this is what we've got umm but you know some people have some very granular, or different reporting that they'd like. 09:06 So for that we go okay well you can get a uh a bi dash umm built and the the default dash is pretty bloody cool umm so we've partnered up with a group called Forecast umm where it works a little bit like websites do so we integrate with WordPress and there are external agencies who go off and build the 09:32 website. Um same thing with this we integrate with Power BI and there's an extra latency that goes off and builds the dash because they know how to do it and then the winery has the relationship with that agency because they might be oh hey I want a new page I want to start tracking this metric oh hey 09:49 I want to change this I want to track this. but basically they can dig into all the data that is in with wine and crunch it however you want and you can even do formulas on that data as well so you know with wine has revenue data but if they say the forecast well actually I know that this is what our 10:11 this is what our are Yeah and I think this is going to be pretty interesting because no one's really done this before. 10:29 Um well like the the kind of have but not very well. Um and sort of you know well we're always saying sell smarter with data so one thing about data is like you. 10:40 A lot of people sit on data but then they don't know how to get it out and how to do something with it but also how to interpret it and that's where the forecast guys can come in as well. 10:52 Have you checked out a question? Umm allows for multiple users and let's just say multiple sell-it-or frontline staff. Yum. Is there anything in the pipe to maybe extrapolate some of the user? 11:12 Umm user orders data that by by user. So by staff member perhaps. So is that what you mean? And look at performance perhaps. 11:23 Yeah so umm if we jump so there's actually that in the- well actually so this is the other area where the reporting is so obviously we've got the sort of- the high level umm. 11:34 The high level pretty- pretty graphs on the dashboard. So you log in, you get the dashboard. Umm. Now obviously in the order screen. 11:42 There's more. more detail that you can- that you can draw out. It's not an a graph but obviously if you if you want the insights you can- you can get all of that. 11:52 So umm. Up here is obviously we've got all the filters over here so you know and we're always running this. 12:00 Umm. So my outstanding orders. I've got a hundred and seventy four of them and they're worth fifty six thousand bucks. 12:09 Umm. If I wanted to umm see how my s- stuff are going for example. I can say umm you know I want to see umm for last month for show orders for last month. 12:28 Umm and then I can drill down and say you know I want to see the orders that have been placed by umm David or Matthew or Sam. 12:38 Umm so if I think is that you've got the detailed summary so you can go into a detailed summary and say well I want to see the 16 thousand dollars broken down by channel or by staff member or by payment type or category or you can just do all of them so that's six thousand three hundred I'll just click 13:07 all and what this does is it gets every dollar, every deposit, every customer, every customer tag, every product, every payment type and it just stitches it into one into the one report so here you go with a year on So the total order value is 16,312 last month. 13:27 Um here the channels that those orders came through. Um here the staff members that sold it and we also said well customers did it. 13:36 themselves so you get oh customers are doing more themselves versus versus um versus not. Uh but you get to see what staff members made the sales. 13:45 Um what their tips are if you're in the US payment types product types. Um and then individual line items as well so you know what products are selling and how well. 13:58 Um we break it down by what coupon codes were used during the period. Uh if you're using reporting lists. Umm so if you've got your products organized into food and merchandise obviously you can report on that. 14:13 Umm. Order tags are umm. Order tags are for example if you've got a if you send an email and you put in a. 14:24 A tag in the email campaign so you can track the conversion. It will show up here so you've got umm. 14:31 Or show me you know if you've got a tag for all emails in Q1. All emails in April and all emails in April. 14:40 In week one it will say all right well here's the total dollar value of Q1 that was done in March. 14:48 Um, oh sorry April. Uh and week one and April email so you get the dollar value you know how. How much money did I make from my email campaigns in the month of April? 15:00 Um and then we also go down to the level of the customer tag so if you're tagging um locals millennials and corporates you can see you know millennial sales are up local sales are down. 15:12 um so then obviously you can go in use those sand tags go into the customer screen and do a campaign to your to your locals and millennials. 15:21 Um and the moment. Yeah. Sorry. Can you just show us how you got that little window up over across the screen again? 15:28 . Just use that. Yeah. So um just here. Let's add summary. Um we're in the order order screen. In the order screen, detailed summary. 15:40 And if you if you want to see if you want to see just. There's just the breakdown of my channel. 15:46 You can do that. Um and you can add more sections to it or you can just do a an all report. 15:55 And it'll crunch everything. Now this can take depending on how many products and customers. You've got this can take a couple of minutes to load up. 16:03 Um but it's usually pretty good and pretty quick. Um and also you can export that. Excuse me. Also you can export this into Excel. 16:14 Um so you can. And um you know you can just hand it over to someone and say he is the monthly report. 16:20 Um and the payment processing fees is included in this as well. Right so we're going. Umm. You've got your columns unpute debits credits. 16:31 So. Obviously sales is a credit refunds are a debit. Um payment processing fees are a debit. Um if you refund an order and we're refunding the payment processing fees as a credit and so on and so on. 16:46 Um so. I've always liked this. It's just like for a sort of health check, a very simple health check. Um, business health check. 16:55 I just think it's a great report. And um, there's someone, um, one of the James up in the hunter. Um now. 17:04 Working for a smaller winery, but they used to be the head of marketing for a very, very, very B. Um corporate business and I showed them this and they just went Jesus Christ. 17:15 That used to take my stuff six hours to compile all that. Thank you very much. So yeah. Yeah. Yeah. So it's actually really um really impressive what it can do. 17:26 Um yeah, since we just talked about the deposits and I know I've jumped people this before, but just for the sake of um being thorough. 17:35 Um we've got um a needer I know you've seen this before too, but doing the reconciliation of deposits. Um at the end of the day or at the end of the week. 17:47 Um again very simple so show, show. Using this top one up here show orders for picky company. So most people will have one company. 17:57 Um that they're using. And then this is going off to strike. Whoops. This is going off to stripe and loading up all the deposits that have been made into your bank. 18:09 So you can go in here and find the deposit that you want to reconcile. Um so let's say if I want to reconcile you know this one here. 18:17 It will then go. Okay well we made a deposit of 433 dollars and 95 cents into your bank account. Um these are the order. 18:26 This is the order or orders associated with that deposit. So um and then it's just a simple case of you want to check a couple of things. 18:38 So um. Now this is the total dollar value of the orders. Um and first of all you want to check that um. 18:48 The payment type is all with wine or there might have been some cash used. Um so some orders might be paid for with. 18:56 With wine and cash. So obviously you want to deduct the cash component. Um if there's a credit balance use, you want to deduct the credit balance. 19:04 But to do your reconciliation, it's a simple case of just going, here's my total order value, here's my deposit value. 19:12 Um, I need to get the transaction fees out. Um and then it's just a case of going 452 spot 96 minus 9 dollars and 1 cent equals 4 for 3.95. 19:30 And that's your rec done. Now if you want to pull out if you want to extract products or whatever it is, umm, you can do the same thing. 19:42 You can do a detailed summary on. These orders. So you can do a detailed summary just on the deposit. Umm, so here you go. 19:52 So it was a club run. You know this much for this club run is this much for this point of sale. 19:58 Um, this much was. Um, um, um, um, done by this staff member. These products, blah, blah, blah. Um, so we kind of do this so that if you're doing your, if you're in your P&L, you're recording just here to see revenue. 20:14 That's an easy number to punch here. If you're. Breaking your P&L down into channel, then we go cool. Here's the breakdown by channel. 20:21 If you're breaking your P&L down into product categories or reporting categories, you know, wine, merchandise, food, you can do that. 20:32 Generally, I like to keep the accounting clean, like just, you know, do you see revenues here and then you do your reporting and you break down reporting and something else. 20:41 Um, but you can also get and again imagine just this has got 20 orders underneath it. Um, you can export that. 20:48 Into, um, you know, all these different formats so you can say all right, well I want to upload my zero. 20:56 Um, my sales fee into zero so it'll go cool. Here are those 20 orders in a zero format. So yeah, it makes sense. 21:04 That's easy. Um, just to get that data across. Um, do we, while I, while we here should we just go over some of the filters because there are a couple of changes, um, a couple of weeks ago on those as well. 21:19 Sure. Yeah. So we changed the order status, um, stuff. That was really the big change that we, that we made. 21:30 Um, because before it was, um, an order's been, um. In order's kind of been paid or canceled and that was it essentially. 21:41 Um. And so we wanted to break it down. So there are more variations that you can have. So the main ones are a payment status and a fulfilment status. 21:52 Um so you can see here so same thing show orders for last month. Um and I want to see all orders for last month that have been paid or unpaid. 22:02 Um or that have been canceled. So um. You know show me show me. All orders that were canceled last month. 22:10 It'll show you. Okay. Well here, you know, he's all the. He's all the cancellations. Um. All the orders that have been unpaid. 22:20 Now the only orders that can be unpaid in with line are invoices as. So it's associated with, um, sorry orders associated with an invoice. 22:28 Um. So that's really what that's there for. So if you want to say only, uh, unpaid invoices, it'll show you all the orders associated with an unpaid invoice. 22:38 And then the fulfillment. Status over here. Um. Any status shipping or picked up or I just want to see shipping. 22:47 I just want to see picked up or you can see. I want to see. Unfulfilled shipping or unfulfilled picked up. 22:54 We broke this. This one up. is before. Or it was like fulfilled equals shipping or picked up and we actually broke it up so you could say well which ones were picked up and which ones were shipping. 23:03 Umm. Particularly good for say you had two or three users in there and each person that would know exactly like a few. 23:12 If someone said I'm not picking it up to next week, they would be on the delayed pick up or something like that. 23:19 Yeah just say everyone would cross what status they're all in. And then of course too. So you can actually go in and say you know if you. 23:28 So I just want to I have a lot of I have a lot of people I have a lot of delayed. 23:34 Umm orders. You can just go cool. I want to see all the orders that have been delayed. Umm. And so it was. 23:44 So right. Umm. So okay. Umm. Good example I don't I hate. Here we go. Umm. So I might just move that forward. 23:54 What a month. I probably don't have any in this demo environment. No I don't have any in this demo environment. 23:59 Umm. But this is actually and when I pick the delay option that's where it goes you can go forward in time and see sort of you know it's showing you it only shows you an order when it's ready to be shipped because we're trying to prevent people from buying a shipping label. 24:16 and putting it on a box before it's meant to be you know before it's meant to be shipped but um so we're kind of putting it's a bit of a protection in there. 24:25 Umm. But you can save all these searches as well though. Umm so. If I said uhh you know show orders for you know this month umm that have been uhh unpaid for example I can go call on a save the search All right. 24:54 And then I can save that search and it'll save it up here. Just here. Oh yeah. So this search. So a better one might actually be if you said umm. 25:11 Any query. I want to see any uhh anything that's unpaid and this is a dynamic search as well. So umm and that's. 25:20 So if to your account it's not safe. So all the staff members won't log in and see that search, So it's your save search. 25:30 So you can easily keep track of what invoices, without scanning because you can just save the search and go call all unpaid orders. 25:40 So it's not like you have to be going in and filtering every time. Umm. We've also moved the shipping label filters down to here. 25:52 It used to be up here. We've moved them down here. So umm. I guess it's so that if you're doing a that are umm. 26:10 Show me the orders that are umm. Unfulfilled. But I've purchased a shipping label for them. Or I haven't purchased a shipping label for them. 26:20 So then we go. Cool. Unfulfilled orders without a shipping label. There's many so then I can just go and buy a shipping label for them and bulk. 26:27 Umm. And then down in here we've got this catch. Kind of catch all additional settices. Umm. So this is where I can find orders that have been marked. 26:40 Is for a gift recipient if you treat them differently. Umm. Invoice orders so you know few people are using them for wholesale. 26:48 Umm. And then for review orders so review orders for review we actually put that's a new. Feature that was a couple of weeks ago. 26:58 Umm that's where if a customer rings up and says I hey umm just don't ship it yet I'm not sure if I've got my friends address right can you just hold it can you put it off to one side. 27:12 Or umm something that some people get is umm orders that umm are for a very expensive product going to a warehouse with a umm with sometimes a file. 27:28 Or in sounding name umm, I touched the order so you might want to review that one because it could be a fraudulent order so you can just go into the order umm and then umm market for review if I've got uhh if it's not completed this is actually already. 27:44 If I say uhh uhh. The chair really for shipping or pick up. umm ahh I the delayed whoops. Ready for shipping or pick up. 28:00 Umm. Going to here and then that's where I can over here market for review. Umm. Add my notes, add my tasks and all of that. 28:12 Umm. Actually and while I'm here. Umm. Some people may not know you can add a task to an order or add a note to an order so. 28:23 Umm. I might say add a task. Umm. Assign it to Abby and then say. Umm. Can you gift wrap this one? 28:36 Umm. So I can save the task to the order and then when Abby logs in the morning. Umm. She will have a task here that she and is to tick off. 28:46 Umm. I think that's false a lot. Confusion because you're fine with users, they log into a system and they'll seal these painting orders and actually sit there going, what's the story with this one? 28:55 Why hasn't that gone and what, you know, what's this one held up for? And yeah. And I was someone sort of I'm going to wait, then you got that. 29:10 And obviously I won't go into Excel because we don't want to do a whole video on Excel but obviously you can get. 29:16 Um, well actually I will show you one thing in Excel. we did add some additional uh with this release that we did a couple of ways ago. 29:24 We did to go down with one item equals one row. Umm so if I go up here, oops. I can get over here. 29:47 Uh the columns we added. So obviously we've got more, We've added the uh fulfillment status, the payment status, umm the pickup reminder sent date. 30:01 So umm if you've got orders that are ready for pickup. Umm. You may not have let people know that they're ready for pickup. 30:12 So you can just go Marcus picked up. I'm sorry you can say send pickup reminder. So it's saying here there are 82 people that you haven't sent a pickup reminder to. 30:21 So you can just click that umm and it will send out the pickup. And it logs the date that you've done that. 30:28 So can see. Okay. I sent a pickup reminder on this date. I still haven't picked it up. So you can you can see it again. 30:35 Um. Uh pickup reminder is. It's for review. Um yes no delivery date. And then we added over here. These. Columns here. 30:51 So. Um we had a couple of people. So hey look. I just want to see how many bottles we're selling versus mixes like what orders what's my proportion of orders where people are ordering individual bottles versus people ordering mixes. 31:07 They wanted some reporting based on that. Um and obviously uh two. Uh product, product types are wine and other products. 31:16 Um and then um just also two just red wine versus white wine. Now obviously this is where you can do all of this in how they are but in the absence of that. 31:25 Umm you can do it in in excess. So as well so that's just a couple of additional things we added into um into that export. 31:34 Umm something else for the larger guys. Umm you can um club members and customers can actually have an account manager. 31:45 So know some wineries have someone on the phones and they go these are my customers don't touch em. Uhh you can actually assign a sign customers to an account manager. 31:55 Umm so then umm. In um in here you've got this you know show me all the orders that are outstanding managed by Sally. 32:08 Umm so Sally can get all that reporting on her and all she can manage the orders herself. Umm but that's. 32:19 So you can you know log in and say show you know I want to see my customers. Umm and yeah managed you know segment your database or even you know show me. 32:32 Customers on my mailing list managed by Sally. Umm so Sally will send out an email with her style. Umm and then show me emails managed by Scott and then Scott will write. 32:44 He he's an email a little bit differently so you can do all of that as well. Umm. Questions? I am back to the dash, the um how BI driven dash. 32:59 Oh yeah yep. It's curious to know. I mean there's a lot of information in there. And it's you know be smarter with data scenario. 33:06 Um if you've got any um thoughts or tips of how um winery or sellable managers in particular might actually be able to use this in a- very efficient streamline way. 33:22 Like you have some thoughts when you're building it. Um yeah so- so for example um this sort of- this sort of data provides- insights that can help drive your marketing strategy or your sales strategy. 33:42 So for example, we've done it, um we've seen that with some clients where um because you've got age group um you've got age data in there. 33:52 Because we we mandate the collection of um data birth. Um now changes state by state country by country. But we you know some states say you just need to have a tick box saying they're over 18 or over 21. 34:10 Others say you've got a clutter and age band. Um we go down to the lowest common denominator which is data birth. 34:20 Um because we want to verify the data birth legally we need to. But we also want to get the data. 34:26 Um so now yes a lot of people go I'm born on the 1st of January in 2000 and there's not much we can do about that. 34:33 But when you when you plug that age data into. You click on what you can do is click on you get a bell curve. 34:46 You these this is the distribution of your customers by age. And so you can highlight the customers aged. Uh 18 to 25 25. 34:55 So you can just. So I want to select customers 18 to 40. So you select those bands. And then the pie chart of uh showing the breakdown between wine clubs will change. 35:09 So you'll see oh the. People young people below 40 are joining club A. People over 50 are joining club B. 35:21 I wonder why that is. And so we had a live example where um younger people were joining. The one make is selection club. 35:31 Older people were joining the choose your own adventure club. Why? Umm and there could be a couple of reasons but I think you know one sort of simple logical explanation. 35:44 Is that you know within the database um younger people despite you know there's a lot out there more choices better and all that but but you've also got the paradox of choice which is a lot of people there's so much choice that they can't actually make a decision. 35:59 Thank you much. So um so young people or this is a generalised statement but quite often young people would just say just make the decision for me please I'll join the winemakers pack. 36:11 Umm you know I don't want to have to like so I'm actually a member. A member of a winemakers uhm selection club because I don't have to do anything. 36:20 Umm but um. Scott you would probably be the sort to be you know you're probably more the type to say no no no no I want to log in and queue rate what box I want to get. 36:32 This month whereas I'm I'm much more like surely what you got. Umm so that means that when you see that data you might go and have a conversation with the front line guys and say hey guys for the next month if you see a young person walking only talk about this wine club. 36:48 A solution if you see an older person walking talk about that um club solution because you might be losing club or you might not be dead in club members because you're pitching the wrong club to the wrong segment of your audience. 37:03 Thank you. Um. Yeah. Yeah. Yeah. With product. Can you drill further down into? Yeah. You can drill down to that group is just buying a skado and this group is only buying peanut. 37:16 This group is buying my, is buying my sell it all released. This group is buying my reserves. Umm. You can drill down by vintage. 37:24 You can drill down by you can even do in, I don't have the picture of it, but can, you get a, umm, the forecast guys have built one with a, a heat map. 37:43 Umm so you can go show me in my club members and it will show a map of Australia, you know, with, with plumes in Sydney and Melbourne and, and little dots everywhere else. 37:54 And then you go, well show me people on my database and the map will update. Umm, to show the distribution of your mailing list. 38:01 Umm. So, uhh. Yeah, this is, it's, it's really cool and, and now we don't have it yet, but where, where we want to take it is where, because obviously web sort of got a spread of, umm, clients on the database that we then want to bring in, umm, uhh, benchmark. 38:25 So you might be patting yourself on the shoulder because you increase your sales went up 5% last month, but everyone else's sales went up 15%. 38:35 So, umm, that's what we want to ultimately bring to the table at some point. Thank you. And I think this is sort of where on an on an industry level, you know, we want to be able to, we will start producing our own reports on the industry because, you know, we're not asking people to fill in surveys. 38:52 Um, uh surveys online where they're kind of just going. You know, rounding things up and, and guessing where actually we've got hard data, um. 39:03 Of what's actually going on. Um, you know, so like. No, zero actually do that now right across. . Yeah. Well, yeah, if you put a thing there reports. Yeah. Yeah. Exactly. Yeah. That's, that's the sort of thing we want to do. Um. I mean, and the benchmarking stuff is, is um, you know, it can be pointed 39:27 in. Sometimes like right now, for example, a lot of people might be saying, oh, um, know, I, um, yeah. My club attrition is, is, my club attrition is through the root for my sales of down or my post sales are down. 39:41 Well, not that you can see it. Um, but everyone's sales are down and everyone's club attrition is up. So, um, that can bring some comfort. 39:52 You know, it's not just you. Um, so. Yeah. Especially with the industry today. Um, you know, it's not it's not easy out there and it could bring some comfort as you say to someone who feels that they could be failing but in actually in actual fact. 40:11 There actually might be don't alright. Comparatively don't alright. Um, another thing. Is like say, see this um, I know it's not very big so you probably can't see it too well but um, this um, this uh, breakdown of red wine, white wine. 40:29 Uh, but also breaking it down into individual. Umm, so for example, um, I won't do it now because it's life data but um, I could go, you know, I was so we used Power BI. Um, across the board so we can go in like I could show you a graph. 40:50 Um, that's been bought by 18 to 40 year olds in the last three years period and yep, I mean I don't know about you, you may see the graph done, you know, going up. 41:04 Yeah. Might see a graph of another variety going down within that age group. Um, but it gets really, really fascinating to sort of see, you know, what is actually going on. 41:14 Um, because you know, then people might go actually well now that I've got that done or I might. I might plant something else or I might try something else when I'm doing my next, doing my next vintage. 41:26 And it also, I guess, eliminates any anecdotal evidence because you've actually got data there and you're not just going on hearsay. 41:34 It just happened. But it's like, oh, mellow sales are down. It's like, yeah, yours are, but mine aren't. Well, and well, here's another one. 41:43 So, this is a live example. Um, a a friend of mine is a, is an analyst. Um, and um, we pointed him towards one of our clients. 41:58 And um, the clients said, look, could you just do a bit of a bit of an analysis of some of my business? 42:04 Um, and he took a look and said, hey, um, you know, you're not selling much fortified. Um, but you've got, you know, you've got five fortifieds used taking up this much based on your website, but fortified to counter for less than 1% of your sales. 42:23 Um, how much does it cost to produce a fortified? How much effort does it take to produce a fortified? Is that investment worth this less than 1% return that you're getting? 42:35 Um, another one is, um, another winery was, um. It's saying, you know, the, the, um, you know, they're saying club members in Western Australia. 42:49 You know, because the club membership, they get a discount on the wine and then they get free shipping and then the box is going to WA and it just wipes out any margin that's been made. 43:03 So, um, if you have that data, you can say, well, okay, maybe it's free shipping if you're on the eastern seaboard, but it's not free shipping. 43:12 If you're on the western seaboard or you just don't sign up people from WA and say, oh, I'm sorry, it doesn't, you know, it's not actually economically possible for me. 43:19 And you might find that the people from WA would say, oh, I'd be happy to spend a couple of bucks, you know, because you know, you don't know if you don't get to sort of- see it and crunch it and play with it. 43:35 Very good. Cool. So yeah, kind of a basic one today, but as I said, just go into it. Go into it. 43:43 Go a little bit more, dude. I wouldn't say basic actually rich. I would say this is quite powerful. Umm it's compact, but not too complicated. 43:52 Umm and it's important that I think wineries in this, you know, when it's tight, like it is at the moment. 44:00 them. Wineries really monitor performance quite heavily and work out what's not working in their business. Yeah, we'll look at it. 44:08 Not what to say, you know, why put death at either something that's not getting a return. Maybe we'll get targeting some other. 44:16 Various. Yeah, I mean as I say, like you you might, if you're looking at umm if you're watching the wrong metrics, umm it can be a negative as well. 44:28 So as I said for example, if you're tracking inside. Okay, well you know this financial year, our um. Our pause order count has gone down 33%. 44:42 Umm. Is if you're looking at that you go, oh shit that's the worst thing in the world. But if- if your pause average order is going up by um 20% or 30%, maybe that you don't care about the count anymore because you're making it up in the average order value. 45:01 Umm. If- and- and that's- you know that's why we sort of we- we built these graphs because we just figured this is the stuff that no one's ever- everyone's looking at- everyone's looking at the dollar sales going- how much money did I make today and where it going? 45:13 Well you know that's not a very indicative umm. Umm. It's not a very indicative number whereas this one is. Umm. 45:24 And I think especially if we you know when we bring in benchmarking data against that then that's going to be super interesting. 45:32 Umm. So anyway but that's all the exciting stuff that-