Streamline Your Document Signing Process With Sales Funnels for Restaurants in NDAs

How to create outlook signature

howdy so in this video what I'm going to do is I'm going to show you how we do our trackable marketing for restaurants bars essentially Hospitality businesses that want to run advertising on Facebook and Instagram and see how many people come in how much they spend if they're first-time customers if they've had a good experience or not now I broke this mic the other day so if it sounds terrible that's my bad so what I might do is I might show you what the ad looks like now hopefully it's going to pop up on screen magically and then I'll also show you sort of what it looks like when you go through the click or send message button and you go through so what I will do is I'll also show that on screen um and well you're seeing this pop up I just want to remind you that I did a full breakdown of how to go to Facebook how to make the ads how to use the software mini chat which is what we use to build out this advertising flow such that we get the customer's data provide them with the coupon and so they can show it when they come into the venue but what I'm going to do in this video so if you haven't seen that out please check that out I'm going to put a link below above definitely below so go watch that because I think it'd be really good to have a good understanding of that first before diving into this video so what I'm going to do here is I am going to jump into the computer and I am going to break down the reporting and tracking that we use so that we can present to venues how many people have come in how much they've spent all this sort of stuff because if you're a venue you've probably seen uh probably seen two things one is you've probably got marketing done in the past and they haven't been able to track it and then you know you feel good and then after a few months you're like hey look there's these photos are really nice these ads are great but how much money am I making so this video will help you if you want to do it in-house to do that and actually track a result but also you've probably seen other agencies out there like us and there's a bunch of other people out there who are doing trackable marketing and you're wondering like what is this trackable marketing for restaurants thing so this video will show you what it is in most of the cases if they're not using this system then typically they're using some other coupon voucher system where they can track how many redeems there has been so what I'm going to do now is I am going to dive into the computer and show you how we do the tracking in the comments below will be a link to like I said the other video there will also be a link to the Google sheet template that we use for tracking there'll also be a link to the mini chat flow that we used to build everything out so you should have everything you need there if you're going through this video and you have questions I do believe I say it when I'm in the computer as well the best way to ask these questions if they're technical is to just make a loom video so go to loom.com make a video um about with your question put it in the comments and then I can make a loom video and response showing you how I would troubleshoot it because there will be issues no doubt there will be issues but everything here is based off logic mini chat's based on of logic Google Sheets are based off logic so it'll just be something logical that's gone wrong so I can help you troubleshoot that if you have any problems so let's dive into the computer and get into it okay so now that I'm on the computer what I'm going to do is I'm going to break down this tracking template in a little bit more detail so that you can build your own and sort of see what we're doing here and why we're doing it in a certain way I wouldn't recommend copying it exactly what I would recommend is coming up with the key metrics or the kpr is that you really want to show your clients and then figuring out how you can build a system that gets that data easily what we found was setting out or sending out monthly reports to clients was really a hassle and most of them wouldn't look at it and it would take a lot of time for us to do so I would recommend giving it a go but you'd probably want to start sending out really really simple reports to begin with and just say hey if you want more information email us here so what almost what we did is we're just send them in Roundup email each month to the venue and say hey there was we'll just use these ones typically there was 500 opt-ins they'd say there was 60 redemptions the average check was 40 resulting in revenue of blah blah blah so that's and then at the bottom of the email I would say if you want more please respond to this email saying uh more in-depth report and we'll see one over within 48 hours or within 72 hours or whatever things reasonable and then you can give them a more full breakdown of what's going on if they ask for it but 95 videos won't ask for it because to be honest a lot of them like they're operating off emotion anyway so even if you can say hey look I've got heaps of people coming to the door if emotionally they don't feel that then they're not going to keep paying but being able to report is super valuable and especially if you are a finger yourself you really do want to report um so what I'm going to do is I'm going to duplicate this so this will be linked below um you're going to want to go file make a copy and I'm going to do this of the copy is going to be tracking template and then what you do is change this so here's the copy that I've made please don't edit the main one because it'll end it up everyone so you're going to come here and make a copy and as you can see on the top right I've got a little key here so the red stuff is updated at the start the pinky stuff is updated end of each month and the more on stuff is auto populated through miniature so what I'll do is you'd come in here this is how we've set up and let's say your monthly ad spend was 500 and the monthly marketing fee that we were charging them let's say was 650 okay what these red things are is some of these we don't ask for how much money there's been done for example if we're doing a birthday uh promotion which I think I made a video on in the past uh if I haven't I'll definitely make one on the future we're not going to ask them the average check when they make these birthday bookings but the venue knows the average spin per person roughly on a birthday booking so let's just say it's uh well to be a nice restaurant so on average they're going to spend 45 per person let's just say that's maybe a main and one drink on average you can go through and pull these out um we don't really do the small plate box or the date night box or the girls know boys no Bots much anymore they worked really well for some venues um essentially what they wear is some venues don't do table bookings but we still want to run birthday promotions so you can run birthday promotions for a small plate meaning that let's say you're a smaller sushi restaurant you might do like free XYZ on your birthday if you don't take table bookings date night bot Slimmer idea you just are running promotions around date nights and tracking out people are coming in girls night boys night again your own promotions around girls night supporters nights with a promotion checking when they're coming in cost of goods so most venues operate between 25 to 35 on the cost of goods the reason why we're wanting all this information is because we actually want to know if we're making the money like many agencies out there and I completely understand why you are trying to fluff it up a little bit so they always feel good about the results they get because it can be quite punishing a lot of time to feel like you've done all this work on the marketing front and they're not actually making that much money but without actually solving that problem you're never really going to be successful so we have to check the cost of goods and unfortunately with the restaurant industry it's quite high so you can say like hey look we did a two for one Burger promotion and they spent you know fifty dollars or whatever but they've had to do two burgers cost of goods they haven't made that much money okay um month one cost of offer so what we're doing here is if we're doing a two-for-one we also need to know the cost of the free thing we're providing them right so let's say for example we're going to do two for one fried chicken the cost of the fried chicken is gonna cost the free fire chicken that we're giving them let's just say costs five dollars okay so that's what we're putting in here and as you know the cost of the next offers let me put them in there as well venue name um we're gonna do it off Daniel's manager account so Dan ielle's burgers program type and wait this is where this is just internal information would be like um database coupon program some of this okay so that's the information that you need to update at the start at the end of each month we'd want to come in here and update the total reach total engagement the reason why we don't have an integration with Facebook to pull this in is because it all really really expensive and we found it's easier to just have a VA go and do it or you do it yourself again you're not it is a bit fluffy like telling a venue hey we reached 20 000 people they'll feel good about that for the first month and then after that they won't care because they just care about the money that they're making and that's completely fair enough because what you're selling them isn't reach you're selling them people and the door bumps on seats uh total spent on ads so we want to put in how much we spent total on ads so the monthly ads means 500 so after month one month will be 500 after two months it'd be I felt a thousand Etc same with total spent on fee month one opt-ins month two opt-ins one three opt-ins into the database so how this is going to happen is at the end of month one you're just going to put the number in here so if total opt-ins at the end of months 500 you're just gonna put 500 in here and then at the end of month two it says it's a thousand you'd get a thousand minus 500 equals this one we used to have it you know set up so that this would equal this what's this which is fine but the problem is it's gonna be filled with Data before we even get to that month and so it can be a little bit confusing so we just do it manually each time it's fine I'm sure you can definitely definitely make a way better reporting um Google sheet than this but this is the way that we're doing it um but feel free to write your own code to make it make more sense to you so what I might do from here is as you can see all these ones should automatically get pulled in through the mini chat flow that I'm going to be using is I will build this photo on Mini chat and in the last video that will be linked below that'll show you exactly how to actually do the build um so I might just quickly do that now and then jump ahead to showing you an example okay so what I am going to do now is I am going to just test the flow and show you how the data pulls in to minichat so go and do that okay so now we're ready to test the flow one thing that I would say is before you test a flow you really do want to just go into the contacts on Mini chat and delete yourself as a contact so see if we can find me just delete myself so here I am so you want to delete contact good data this way is going to remove all the tags that have previously been applied to you well testing flows and that way they should operate like you're a first time customer into the bot so I'm just going to go to the add intro and click edit flow and then click preview and messages and click preview here we go so this is the first message this is me testing earlier how do you want to your coupons on Twitter we just have a few quick questions for you and as you can see I have pulled into here already and then if you want to click the notify me button if you were having issues with this notify me button popping up while going to the last video the reason that that would be is because you need to go to the advanced settings in messenger and allow for me sitting outside of a 24-hour window which will allow you to use this button so then I'm going to put my email in and as you can see email has popped up here okay awesome last thing to your phone number and again the phone number should Auto populate in here because Facebook knows your phone number and then it will pull it into here or it should pull it into here okay let's just quickly troubleshoot this why isn't it pulling it into here so if I go to it's probably good that we do some troubleshooting where we go if you go to welcome and then this is going to be the email question and then the phone number question so what are we doing here so we are asking for a phone number we're saving that phone number okay so probably you'd want to save it to system field and then we are updating the row just checking that we're updating it to the correct sheet so what we were likely doing wrong is I likely had it set up such that this was saving as a custom field and if we really want to be saving to a system field so I just need to have this ticked on um because what I'm seeing here is that I'm putting the custom sorry the system field phone into this phone number thing so if I click publish after that and then preview and go from this step I'm hoping that this will allow me to just go back to this and for my phone number in lastly into your phone number okay now for my phone number so hopefully it's now says as a system field and built into here okay and it has so that is how you solve that problem right here's a two-for-one Fried Chicken this is just not pulling up at the moment because mini chat's having a weird thing I can see that on my phone it will be pulling up hold on a second yeah so it does work on my phone so I wouldn't worry about that for now if this is continuing to be an issue for you where the the coupon isn't pulling up so the coupon should look something like this what is happening the coupon should look something like this if it's not populating or not showing up on your phone then that'd be odd but mini chat is having a little bit of issues with images right now but I wouldn't worry about that so then what we're going to do is you can click redeem coupon and it's going to ask you to redeem coupon again okay great so now if you go to Redemption data you can see that I pulled in because I've redeemed the fried chicken coupon how much was my bill I'm going to say it was 50 total so now that I've spent 50 on this first offer which was fried chicken is this your first time to Daniel Bachelor to venue name um yes this was my first time or would you rate your experience from one to five so I'm just going to say I had a bad experience so if you have a four or five what we're going to do is send you to a Google review but I'm going to say I had a bad experience one next time um poor service so if they give me a bad review we don't send them to sing to leave a review should obviously just ask for feedback okay and in the feedback data as you can see um I've accidentally said it's for offer three so I can go and change that should be for offer one so feedback and feedback flow it's going to three somewhere yeah first time so let's just go through this again and I'll find out where it is off of three sit after three so this is where you can see this um offer three pulled in because of this so we're just going to change this to one I'm not going to go through the whole flow again I'm just going to change this here okay so hopefully now you see how a poster subscriber data then it pulls through Redemption data then it pulls through feedback data and now on here we can go through and I'll just show you what a few of these means so total opt-ins is just how many people have come through with subscriber data So currently there's one cost per opt-in is going to be your total opt-ins is it yeah it's going to be a total opt-ins divided by your total amount spent on ads that makes sense total emails is how many emails are in the subscriber data tab same with phone numbers for number tab birthdays collected same with birthdays so the way that we've set this up is now that you've already got my email and phone number if I opt in for us another coupon let's say two one Burgers people that you're on a month too instead of asking for email or phone number that the flow is going to ask for your birthday okay so that's the third bit of data the reason why I don't do it all in the one flow at the beginning is because we find that asking too many questions stops people so that's why we do it those two on the first time they enter and the next time the interview ask for a different piece of information with this which is their birthday okay and then again redemptions it could pull how many people on the Redemption data um the average check so how many people like what adding this up and then dividing it by the amount of people coupon sales just the total amount of sales so we because some of the dump into the average year we just do the average check multiplied by the amount of redemptions which is why this is 45. the percentage of people that redeemed off at one so from opt-ins to redemptions um list redemptions and redemptions so essentially if they're coming off the ad or if they're coming up the list determines whether it's going to be a list Redemption so ad redemptions so obviously a month when they're all going to be ad redemptions uh birthday bookings all this and then what this is going to do is so then you've got your total coupon Revenue your total redemptions your cost of coupon offers etc etc and what you're going to do is at the end of month one you're going to put your total coupon Revenue down here so your your total redemptions down here you're gonna put your totals down because at the end of one month one your month one is also your total okay and at the end of month two you're gonna come and you're gonna put this your total minus month one is your month two and your month three will be your total minus your month one in your month two it's your month three right so we just then pull everything down so hopefully this explains how and again this is total visits totally new visits to return visits so hopefully again this explains how we do our tracking so essentially we build a Google sheet that pulls in all the starter and if you have any issue with any of them because you know no doubt there'll be mistakes in the sheet you just want to click on them and you're going to read essentially what the formula is so right let's just do birthdays collected so it's going to go to subscriber data which is this one here and you're going to look at essentially it's counting the amount of inputs in the G column minus one subscriber data G column minus one why are we minusing one because there's obviously something in this top cell here so we're going to minus that off there so hopefully this makes sense and help some people out again below I will link the first video that explains how to do the build out I'll link this tracking template I'll also link the mini chat flow so you should have everything you need to do this for yourself for your own venue or if you are helping other local businesses out or local venues out through this I hope this has been helpful if you have questions please leave it below I'll do my best to get to it if they are quite technical what would be really helpful to me would be if you made just a quick Loom recording explaining the issue and just put that link and below and then I can make a loom recording and respond to that Below in the YouTube comments as well and we can go from there so please subscribe if you haven't already please ask for future videos of what you'd like me to cover again we help restaurants bars bar and grills Etc uh mostly do more private events right now but we also have a portfolio Appliance where we help get more bumps on the seats through doing coupons this sort of thing as well as birthday promotion so hopefully you got some daily out of this and I will see you in the next video peace