what’s up everyone it’s the nomads Brad in this video I’m gonna share a really cool tool for tracking your paid traffic campaigns so by the way uh if you don’t know who I am I’m again the nomad Brad and I teach a lot of stuff about traffic and affiliate marketing so if you’re interested in that then hit the subscribe button hit the bell notification icon so you know whenever I put out a new video so I want to share this with you this is a tracking sheet template so this doesn’t track your clicks this tracks your revenue your spend and your your profit I first built this spreadsheet years ago when I was first learning how to run traffic for a company that I worked for and it was really hard to keep track of the spend and profit every day so I built this spreadsheet where I would just copy and paste the you know the sales will be made in in each place you know like Clickbank or whatever that product was running on Clickbank so I copy and paste the profit that we made on Clickbank and then I would go copy and paste the ad spend that we did for each ad source so I built this spreadsheet and suddenly the whole job of tracking how I was doing with each campaign became very simple so this is missing for a lot of people and I want to show it to you show you how it works and then actually just give it to you for free because I want to help people you know be more successful with their paid traffic campaigns so let me show you how it works so I’ve set it up here theoretically if you were running several different offers and you can see there’s a difference between the pink and the yellow so this column is the spend so this is where every day at the end of the day you would track your however much you spent on ads for the day so let’s say you since spent $15 this day the next day you spent 30 five and then the next day you spent you know 17 so you can already see that some numbers are starting to shift and it’s got some really cool features that I didn’t add initially but actually I met up with a good friend of mine who’s an accountant and a finance guy and so he deals with spreadsheets all the time and he was like oh let me let me add this feature and I’ll show I’ll share this with you too this basically and this is so beautiful it makes the job of running traffic so simple and easy is it predicts how well you’re going to do for the rest of the month so if you haven’t run a lot of traffic before it’s not really about the day-to-day it’s about the month-to-month like every month is that’s what you want to be measuring your performance by it’s not every day so what you want to care about is your average for the month and so this spreadsheet doesn’t just give you the daily spend and profit and profit and loss and stuff it actually projects what’s going to happen for the rest of the month which is really really awesome I’ll show you how it does that so these pink sheets you can see are taking an average of everything before it basically so this is saying how do I get that to go away okay so this is saying on average so far based on what you’ve spent every day you’re spending on average 22 dollars and 33 cents and then it will guess based on the average of what you’ve been spending you know how much you will it will guess how much you will have spent at the end of the month so it estimates that you will have spent 692 dollars by the end of the month now the clicks don’t really have anything to do with any calculations here it’s just for extra data when you’re running a lot of traffic sometimes you want to keep track of your conversion rate again it doesn’t I’m not gonna focus on those things but it doesn’t affect any calculations it’s just for extra data you know you need as much data as possible when you’re running traffic so these other columns are just additional you know if you want to keep track especially if you’re running traffic to your own offers then you can put your own data here for for like you can add some other calculations like let’s say every time you sell something it’s worth you know fifty seven dollars well you could start making a calculation where you put in three and then over here under revenue you could say you could change this from a straight manual entry you could say equals you know D D 32 times what did I say each one is worth $50 or whatever so now you could put in a three and it would automatically go with one hundred and fifty dollars right so that’s like if you’re running your own traffic then you can use these other columns to your own products but if you’re not and I’m assuming you’re doing affiliate marketing if you’re watching my channel right now if you’re not then you’re probably just gonna use the straight you know raw data so every day you’re just gonna go into like your clickbank account or your you know max bounty or whatever and you’re just gonna paste how much did you make today so let’s say today we spent fifteen and we made one sale of a product that was like you know twenty twenty three dollars Commission so now the spreadsheet shows you that you profited by eight dollars today then the next day you spent thirty five and let’s say you made you know a couple sales and it was 48 so now you’ve profited eight dollars and then 13 the next day now this day you spent seventeen and well let’s just leave it at that you you made zero so now you can see that there’s a few different awesome things I can’t believe I’ve never shared this before this is so cool this thing it really makes running traffic really easy so there’s a few things happening right now so we’ve put in you know it’s it’s got the date this is how much we’ve spent every day and it’s telling you how much you’ve made every day if you highlight over these and look down here and look at the average it says the average of these three days is a dollar 33 well if you look above the spreadsheet has already guest has already figured out that you’ve been averaging about a dollar thirty three profit per day and then it projects if you average the same thing for the rest of the month a dollar thirty three if you maintain that average it’s gonna you’re going to at the end of the month have made forty-one dollars profit and it’s also calculating the same thing for revenue and it’s also calculating the same thing for spent so it’s gonna be guessing what your average profit is going to be now let’s say you didn’t well okay now that now let’s let’s move on to okay so now it’s not the third now it’s the fourth right so what we’re gonna do is you’re just going to highlight this row that’s yellow and drag it up one and now it’s going to apply all the same rules of down here to up here so the pink column or the pink rose have one set of rules that are all finding averages and then the yellow rose have their own set of rules so as you go through the month you’re going to highlight the row and drag it up and it’s gonna change but you always want to keep the yellow ones and the pink ones separate until you get to the end of the month and then you can you know duplicate this over into another month month the month tracking is the way to go so let’s say you’re just spending $17 every day that’s fine and then you’re gonna make twenty two dollars and fifty forty four dollars and seventy seven dollars and twenty three dollars fifty six dollars twenty four dollars forty four dollars twenty three dollars all right so actually let’s throw a couple you know lighter ones some negative ones in there this should turn red but you can fix that if you want I’m not gonna worry about it let’s say you made 0 again this day ok so now again if you highlight all of these you know these are the this is the daily profit that you’ve made every day so by the way if you want to change that you just go to conditional formatting and you could say if it’s let’s see sell know if it’s less than zero then we’re gonna just make it red there we go so that’s that’s all you’re gonna do if you want to change this and make it look better but I don’t know if it’s gonna be like that I don’t think it’s gonna be like that when you download it sorry this will just add it makes it very easy to just look and see how you’re doing and now based on these numbers you can see you know this this day you spent seventeen dollars and you only made eleven so you lost six this one you spent seventeen you you made 24 so you made seven etc etc etc so again if we highlight all of these and find the average eight dollars and 36 cents well the spreadsheet is already calculated that you’ve you’re averaging eight dollars and 36 cents per day and it’s and it’s projecting that if you continue on that path then you’re gonna make two hundred fifty nine dollars profit and you will have spent about five hundred seventy two again it will do the same thing for clicks and stuff it’s just it’s not gonna affect you know any of the number calculations it’s just gonna be for your own data but you can but it will still the pink ones will still guess how many clicks you’re gonna get and you know you can do these I don’t yeah you’ll have to figure this other stuff out but honestly if you’re just running affiliate campaigns you don’t really need this stuff you just need the spend and the revenue this is cost of goods sold you’re not gonna need this obviously because if you’re promoting affiliate products then it’s you know zero cost of goods sold but if you are selling your own product you can use this too and then you just calculate your costs for each product there’s upsell calculations if you want to use those conversion rates if you want to keep track of that but mate lonely maze mostly if you’re an affiliate you’re just gonna be using those two columns revenue and spend and then the other thing it’s gonna do is this is like a rolling total so this is how much you’ve profited so much or so far this month so you know on day one you made $8 so you’re $8 positive right on day 2 you made $13 so now your $21 positive on day 3 you lost 17 so now you’re only $4 positive for the month on day 4 you mean five so now your $9 positive so it’s gonna keep this rolling total as you move through the month again so again all you have to do is make sure to drag the yellow up into the red to apply all the same rules and then just go in and change each date right so this date you spent $33 this one you spent 23 this one you spent 44 32 etc so again it’s gonna keep calculating it’s gonna guess that you’re gonna spend 600 you’re gonna make 794 so you’re gonna profit by 133 so this is kind of like a secret weapon for if you were to hire a consultant to or at ad agency or whatever to run your paid traffic for you this is probably similar to something that they would use and if you’re doing paid traffic you need to track everything you need to track all of your numbers every single day and the room remember that it’s not about the day like if you make $20 today you might lose 30 tomorrow and you might make a hundred and twenty Tom the next day it’s not about the day-to-day it’s about the month-to-month so well you know what you want to do for for each offer or each traffic source you can use this however you want but what I would do is do one sheet per month so this is you know I mean obviously this says August whatever but you can update the dates and then what I would do is I would save this you know I would duplicate this and I would name it renamed you know Clickbank offer one whatever it is you know right and then just say August well let’s see what its March 2019 so you could do that and then you can start you know just doing that for all the months so I hope that’s really useful to you if you’re serious about running traffic you need to track every single day what’s going on and this thing is gonna make it so much easier I remember when I was starting to learn traffic and I was spending you know a few hundred dollars a day of the company that I was working for and it was just getting crazy I couldn’t keep track of it and it was really hard for me to do the math every day and then I built this system that kind of does it for me and that my friend made it even better by making it project and so I will say as well that the more data it gets the more accurate the end of the month projection is right so like on day two oh here’s the last part I forgot about this to get projections you know there you just have to drag the pink rolls back so now it just over wrote all that data and now it’s just gonna be the pink is always just gonna guess based on averages I hope that makes sense if it doesn’t just ask me a question underneath this video and I’ll be you know I’ll try to answer your question but if you want to download this well first off first off thanks for watching secondly if you want to learn how to run traffic using my favorite platform for anybody to start out with then I recommend you watch the video at the end that’s recommended or you can get a link below this video as well and it’s going to show you the the ways to start out with Bing ads which is my favorite platform for people to start out with especially for affiliate marketing and how to start out with you know the best chance of profit on day one so look for that video at the end of this one or in the card above here or below this video and I highly recommend you go watch that video next and if you want to download this spreadsheet then check the links below this video as well and you can get it for free so thank you so much for watching the Nomad Brad and good luck running all of your ads and making a lot more money and feeling a lot less overwhelmed by the whole thing