Struggling to keep track of your SEO campaigns?
In this training, I cover how I track all my SEO campaigns with a few simple spreadsheets.
- 01:43 – What The Spreadsheets Look Like
- 04:34 – Referencing Your Spreadsheets
- 07:33 – Tracking Link Velocity
Want to get clients to pay you $x,xxx/month to do for them? Watch this free masterclass.
What’s up guys, this is Daryl Rosser here and in this video I want to walk you through how we track our campaigns, OK. So with SEO, the whole approach that we take is a very scientific approach, meaning that there is other types of SEOs out there and nothing against those guys or anything like that, but their strategy is more content marketing strategies, it’s not really directly SEO. Their plan is to create a ton of content, then get traffic on their site, naturally attract backlinks and stuff like that. And then they naturally rank through that process, OK. And that can work. It’s just a much, much longer term strategy. It takes several years to build up a brand that’s like getting traction and traffic and anything like that right? So what we do instead is a very scientific approach. Meaning we’re scientifically building backlinks. We’re using very specific anchor text and very specific link velocities and different things like that.
So we can deliberately and predictably control our rankings, right? It’s not 100% that we’re going to rank, but we do have a little control over whether or not we rank by following specific guidelines, which is basically a science behind our strategy, OK. So to do this is extremely important that you track every element of your campaign. So what I want to walk you through today is basically just a tracking sheet that we use for each individual website. We have one for each website and so it allows us to track exactly what’s happened to this campaign so far and just allows us to quickly look at it and go, OK, so this is where this is that now, right? So what this does is it avoids any sort of issues. A lot of people will over-using anchor text or something like that or script their link velocity.
And the reason they do that is sometimes because they don’t know what they’re doing, but secondly, because they don’t track it properly and you don’t realize that they’re over-doing it. Right? So using this allows us to quickly look over. All right. So nice short video. Let me just walk you through what exactly it looks like. OK. So we have these different tabs here. We have info, we have anchor text analysis, we have homepage, we have internal links, we have links, and we have affiliate links, if you’re doing an affiliate site, OK. Now the info tab is very, very simple, OK. Here’s what it is. It has a site login, so a cPanel or anything like that, so you can login to the site so you don’t forget it. Nice and simple. By the way guys, we’re using Zoho for this, so Zoho.com. Just allows us to host them very easily without giving them all to Google on Google sheets and anything like that.
I prefer Google sheets, but basically the same thing, it’s just the habit really of me to use Google sheets, but for all the rest of your projects they’re all on Zoho and as you can see basically the same thing, so a spreadsheet system, Excel, same sort of idea, right? So site logins at the top. Persona, so any information I have about this persona that I created. So the name, the birthday. Sometimes you need this for logging in, verification perhaps, and stuff like that. The email address, of course, the email password, the verification, number of years, a simcard or anything to verify the address, phone number, email and so on. OK. Basically all the information there for the accounts that we’re creating right. Then we have the social profiles and we list basically a bunch of them like Gravatar and what not, we’re not gonna use all of these maybe and have like the email, the username, the password, the URL and whether or not it’s indexed.
That basically counts towards how effective it’s going to be. Right? So that’s the first page, OK. Nice and simple. Just store any information about the profile, the website and the logins and all that sort of stuff. Okay that’s the important stuff. Alright. And then we go over to anchor text analysis. OK. So what this is, is analysing the sites that are ranking for our main keyword. We can have different ones for different keywords on this page, but this is for the main keyword which is in this test example, it’s not a real site, it’s just an example site. It’s like best table saws. OK. And what we’ve done is basically gone ahead and looked at the types of anchor texts. OK. So target, URL, brand, topic, N/A, miscellaneous and basically obviously the total as well, which is the total of all those links, right? What we’ve done is we look for every single backlink these sites, we have of analyzed which type of anchor text it is.
Now, this isn’t actually real data, um, it’s just something someone in my team put together as like a sample to walk you guys through, right? But basically we go through them and say, “Okay how many of these anchor texts are target anchors?” Target mean it has some sort of variations of the keyword in there, right? Then URL. And the URL is obviously domain.com, example.com, whatever right. Brand is like a brand name. Topic. So anything relevant to the topic that doesn’t include the target keywords that we’re going after. N/A is obviously anything that’s doesn’t really count, so it’d be blank or something like that. And miscellaneous would be anything like click here and stuff like that. Right? And you go through that and we calculate, OK, here’s the percentages that these sites have. On average, based on the top four to five sites, something like that. Right. And then this gives us a rough sort of ratio what to aim for.
Again, this isn’t real data, but this is what we normally do for every single site. So we have this data stored all the time. It’s not as something we do once. It’s constantly kept in a tap so we can constantly go back and reference it whenever we need to. Because what’s going to happen is as we’re building our links, we’re going to be referencing back to this data and analysing if we’re on track to kind of match the average anchor text ratios off the sites that are actually ranking. OK. So these are the top ranking sites. Another video on why you need to do that, but this is basically how we’re storing that. OK. Then internal links is next. OK. So this is very simple. We just basically just explain like which pages link to which other pages, OK.
So this page here, links to this page, right? And it has this anchor text and we do the same for every single link that we have. And what this allows us to do is basically just track the anchor text and obviously the internal links right. So for internal links, it does matter what anchor texts you use. If you use heavily optimized anchor text every single time, that will cause you issues, OK. So we can’t use “best table saws” every single time we link to that page, OK. So we’re using a URL here. We’re using obviously target anchors there and miscellaneous here and miscellaneous here, right? But we’re mixing up all the time because we don’t want to have a site at risk of over-optimizing the internal anchor texts, OK. And basically just tracking all these different links. So all of these link to the homepage, all of these link to the portable page, all of these link to the contractor page and so on.
And if you want to, you can have different sections down here for different silos and all that sort of stuff, right? But that’s basically how that works. Just tracking all our internal links on this page because it actually matters as well these days, OK. Next up is the links, which is links pointed to us. So backlinks, and this is basically how we’re tracking that, OK. So at the top we store information about social signals, so whenever we order a blast we can just add that here, right. But we keep a list of the social signals. We can insert a new row and we can put on this day which is March the 18th or something, I don’t know, 50 signals, right? And stuff like that. And we have a list there of every single time we’re updating social signals so we know exactly when we last did it. So we’re not overdoing it or anything like that.
Right? Then we have the different links. OK. So the website that’s linking to us is stored here, the URL that’s linking to is stored here. The anchor texts that they use is here and the date and the type of link it is here and obviously whether or not it is indexed. OK. So let’s just break it down a little bit. Nice and simple. The website address. That’s very obvious. OK. The link URL, what we do here is we have, we bundle them basically by page, OK. So these are all linking to the homepage, they’re all together. They have a separate section down here linking to the contracting page. A separate section down here linking to the portable page. OK. So you can kind of bundle that dependent on the URL, so it’s a different anchor text ratio per URL, right. Because that’s kind of how I see it works. So that’s how we do it.
Makes it much easier. We have the anchor text of course. And we color-code these. If you remember back by the way to, I didn’t really mention it here, the anchor analysis thing. So we have red for target and green or lighter green for the URL, darker green for brand and stuff like that, alright. So we go back to this tab and again, we’re basically color-coding these depending on which type it is right. So we’ve got some URLs, anchors in there and miscellaneous and stuff like that. Alright. So you can see kind of how exactly we’re storing that data. We track the anchor text. Then we have the date that the link was gone live, this is very important for referencing back in the future. If you want to keep a steady velocity, you want to track like whether or not a certain link moved in the rankings so you can check back. Like OK, this link went live on this date and this happened after that. Right.
Now it’s not exact if you do multiple things at once, but it gives you that data to look back on, OK. And then obviously we have the type as well. This is just important for just tracking purposes, so we can very quickly see, “OK, this is a PBN, this is a PBN, this is a guest post, this is a profile link”, whatever like that right. Now, indexed is the final bit of this which is extremely important and indexed is basically whether or not the link is indexed and what date it was indexed. OK? So this is really important guys, because if your links aren’t being indexed they’re not very good links, OK. So you need to make sure they’ve been indexed. So we constantly track when they were indexed and we update the date here so we know exactly which date they were indexed. Again, for looking back as well, this is very useful data, OK.
So it’s kind of how we’re doing that. If you want to, you can add in this little date of last link thing and say “OK, well the last link was today.” Then you put in today’s date, then you know exactly when the last link was built, just for a very quick reference. Then of course as we did this thing here, we also do the exact same stuff further down here. So for every different pages, so this is for the homepage, for the contractor page you do the exact same thing. And then for the portable page and what not we do the same sort of thing there as well. And we also have like this is within the portable, so the DWRS or whatever it is, that’s within the portable category so to speak. So that’s in the same section, OK. Does that makes sense? Now, that’s kind of the main elements.
We also have this, which is basically as we’re building the links, we update this little thing here. We update how many of each of these individual types of links that we’ve added, and then obviously that builds a percentage and then that automatically fills in into this table thing here, this pie chart, sorry. And then we can see exactly, “OK here’s the pie chart, here’s exactly, um, the ratio we’re at, and then also the percentages as well, and we can reference and go back to this and say, OK, so this is 14.29%. And then the top ranking sites have 22.92%. So we have a little bit of flexibility.” And again guys, this is made up data, just to show you guys how exactly we’re doing it in Zoho sheets. OK? Now the final tab for us is very simple, oh by the way, this little black line just indicates there’s a separate section, OK, that’s all we’re doing, it’s very, very simple.
Not very pretty, but it’s not me that’s in here managing this. It’s my SEO guys that do this. All right? So I’ve an in-house SEO guy, right? And then in last tab is the affiliate links, right? And the affiliate links is basically, if you’re doing an affiliate site, just for quick reference, here’s the product name, here’s the link, right? So we can very easily, whenever we’re doing a new blog post, anything like that, I can quickly grab the data and add the link, right? That’s all it’s really there for. OK? And that’s basically how we’re tracking our campaigns. It’s nothing too crazy, but it’s just allowing us to track all this data. OK? Now if I’m 100% honest with you guys, this changes, OK. So we don’t have an exact SOP down that never changes. SOPs change every week at least, right? So we’re constantly tweaking this and refining this and any realise if there’s any issues we have.
But as of right now, this is what we’re using. So I thought I’d share this with you guys. I know a lot of you guys struggle with systemizing this stuff and tracking it all, especially when you start adding a team and stuff like that. It gets confusing about what’s happening and mistakes happen. That’s completely normal by the way. People screw up, I screw up and everyone else screws up. OK? But if you want to know how to track your sites, this is basically the sheets we’re doing and maybe I could hook you guys up with a download for Excel or whatever you use so you can go ahead and use this. I’ll think about that. And the link will be below if I add that. But that’s basically it. I hope this video was helpful. A nice short video for today and that’s about it. So I’ll see you guys in the next training video, in the next content piece, interview whatever it is we put out. That’s it. I’ll see you there.