Free SEO Reporting Template For SEO Clients 2018
Free SEO Reporting Template
What is up there SEO pros? How you guys doing? So today we’re doing some reporting, and I’m going to show you guys a free SEO reporting template that you guys can use on your own clients. I’ll show you guys how I do my reporting and how you can apply it to your own internal process. And Travis is here with me, you can see his shoulder. So we have a little bit of construction going on the background so if you hear some hammers I apologize.
So what we’re going to do is we’re going to showcase one of our clients, and I do all of my reporting live on my channel so you guys will be seeing some reports coming through in the next couple days, actually probably by Monday I’ll have all of them done. But this is somebody that we’ve been working on, and as you guys know he’s the chiropractor we’ve been working with. We’re on month two, and he signed up for our most advanced SEO package so we’ve been able to spend pretty much over 40 hours working on his stuff. So you can see this is kind of the results that we’ve driven this month. And if we compare this to the last month you can see making a huge improvement. So ideally we want to be able to address what we found in the road map versus what we’ve been doing, so what we do is we’re going to open up our road maps, and I keep all of mine in the drive, and let me just make sure I open this over here so you guys are not seeing my logins. So just opening this really quick. By the way if you haven’t done so already and you’re not in the Facebook group, make sure you text the word SEO to 66866 and I can give you access to my free Facebook group as well as you can sign up for my list and I can give you free updates on the giveaways that I do, I do about wanted to giveaways a month sometimes for a free road map sometimes, for a free consultation, whatever you need depending on what the group votes on. So I’m just going to go to clients.
And I’ll show you guys, this is how I do it. Sorry you can’t see right now, I’m going to bring it over one second. So I keep all of my clients in here like this, and the reason why I do this is because I want to be able to easily see who I have as clients, and at the same time I want to be able to build out case studies. And this is kind of what I talk about in the paid course. So we’ll go into the client that we’re currently working with, so we’ll go into peak performance which should be right here. Now you can see we have all of our different notes, but what we want to look at is the audit that we already did. So we have recommended blog posts for the content and then let’s go into here. And ideally we want to build it out where we have the top ten list that we’re working on each month and then we just cross-check this with our SEO profile which I’ll show you in a second, and what we do is we just keep track of our emails. So if we do month one, this is what we did, then we would put our report here. I haven’t added the old report here yet but I will be doing that and then I’ll put the video after that. And then I’ll put month two and then put that report as well so people can also see these case studies and I can start ranking for case studies around the stuff that I’m doing if that makes sense. At the same time I also have video overviews, and it makes you seem a little bit more legit when you’re actually doing videos of what you’re reporting, so it makes you seem a little bit more transparent and that’s what people want to see. So you can see this top 10 list, optimized titles so that they’re targeting the correct searches, not cannibalizing each other. Now let me just check my old report, and I can actually go to my channel I think and find this. So if we go here and then we go to report, it should be ranking reporting for chiropractor, and there it is. So if you guys do want to see month one I can just grab this link here. Not this guy. I actually bought this guy’s book just so I can see his funnel; it’s good to do. So I’m going to grab that URL and put month two, or month one report. And then what I would do is I would just take this email that I sent to Matt and I would put that right here as month one report and then also put that video link right there, so we can put that into the case study. So you can see this was the email that I sent, and we’ll just find that really quick, so just search through that for my email, it’s SEO implementations for April. It might be in one of my other mailboxes, so I have to figure out where that is. So what I’ll do is I’ll just put that in there once I find it.
And the other cool thing is you also get the audit for the content to rank, or as content to rank for as well. So I’m going to have to find that email, but once I find that email I’m just gonna put that in there like I was saying in the case study so we can use that as an SEO that that content for SEO for chiropractor case study and rank that because it’s going to be a lot of content. It’s also going to show step by step what we did so other people who are trying to figure out how to do this stuff they can see it easily. And I of course have a separate playlist for this, so you can see these are all the things we found, I’ll just put that in there. And then we would just take all the things that we talked about in month two. So in my reports what I do is I go like this, it’s pretty easy, I just do one, two, three, I do here’s the progress, so the analytics, here’s the analytics and search. So I’ll show you guys how to set this up in a second. Number two, this is what we fixed. So we just show what we fix from the road map. And this is what’s so cool about doing road maps guys is, it’s not just helpful for the clients but it’s helpful for you because you can just go over this, say, “Okay, we fix this, we fix this, we need more time there.” And then once you overview it you can just be like, “Okay, well these are the other things that came up as well.” And then all you have to do is put that into the new email. So this is what was fixed from the initial road map, this is what we found or what we need to continue fixing from the initial road map. And if you run out of stuff too you can always go and do a new road map and find things around other areas. So the idea of why you do this stuff everybody’s like, “Well aren’t you going to run out of stuff to think of?” It’s literally impossible because you can always focus on content marketing, search engine marketing, social. There’s so many other channels, building out funnel pages, all that stuff.
But right now we’re just looking at the report so what we’re going to do to get this data is what we just looked at through analytics, so all I would do is just take a screenshot here, except what I’m going to do first is I’m going to go to acquisition, all traffic source medium because we are reporting on Google mainly. But one of the things that can contribute is the fact that the branding here might contribute to this, so I think what we’ll actually do is we’ll actually just go like this, go to all traffic source medium, overview, and we’ll just take a screenshot. Actually let’s go back here, audience and review, take a screenshot of this. And sometimes the bounce rates will go up as the traffic goes up, that’s natural because you have more people hitting the site. So there we go. Save, and then we would want to name this with the file’s URLs because we are using this for SEO remember, to rank up web page. So we would just want to say reporting on analytics for month two, because the file’s URLs do matter. I didn’t put month two, but whatever. We just need to make sure we’re putting this in the right place. So I’m just going to put a new report folder, month two, peak performance. There it is, cool. And you can draw on it too if you want to do like highlights; we’re not doing that.
So the next thing that we’re going to report on is our conversions. So we’re going to go to conversions, and if you guys don’t have conversion tracking setup, this is the number one thing you need to do in any initial implementations is set up conversion tracking and rank tracking, online and offline. If you guys don’t know how to do that stuff I have tutorials for it. I might be taking Travis Baxter that stuff at some point if we need to get a refresher. So all we do is just go to conversions, overview, and then we want to make sure that we’re filtering by this. And then all we have to do is make sure we’re showing all of our conversions. So we going to go to all goals, there it is, and then we would just take a screenshot of that. And you can see the conversion tracking I don’t believe was set up until here, so that is something that we want to look at. Also we want to make sure that we’re showing the overall overall value of this, so this is actually not showing an average amount of money made from this, so let’s see if we can get the other one where it actually does show that. I think the best one might be Tags or something whatever it’s called, there’s a certain channel. Might be gold flow. No. I don’t know where it is anymore, they’re always changing this stuff up. So what we can do alternatively is just go to audience overview, and what we could filter by conversions. Now I think the best way to do this would be to go to acquisition, all traffic, source medium and just go by conversions. So we would filter by this and go to converters, apply. So this is just going to show us all of our conversions and then that’s how we get the actual amount of money made.
And the way I measure this is I just ask the clients, I say, “So out of how many clients actually turn into customers from the people who call you or hit you up off your website?” They say out of three, then we just take whatever average value of a customer is worth, hopefully their lifetime value. So if it’s worth $2,500 to them we would just take $2,500 divided by three and then that would be the price for each conversion, because out of the three that equals that $2,500 or whatever it is. And I apologize if that didn’t make sense, I’m not that great at math. So we’re going to go like this, press new, collect that, and take the screen shot. So you can see, $2,000. Now there was more conversions than this. Let me just see we’re making sure that this is going through correctly. So we’ve got contact us and calls. So ideally that should be more. So what we can do is I think maybe there’s two different ones you can filter. Let’s just see if we do all users and then just see the conversions that way. So here we go, now we’re seeing a little bit better. So this is 3,500 here, 2,000 there. That way they can see the Facebook converters as well, so let’s take a screenshot of that. Save. So let’s take conversions and put that in here, month two.
So of course we want to track our other channels as well because this isn’t tracking Google my business, so let’s go into here, go to Google, my business. We’ll go to manage. I think it’s on this account, it might be on a different account, we’ll just double check. Let’s see if it’s in here peak. No. Let’s try this other one. There it is, we just do manage location. And then you can see this is a good thing that we’re going to want to show, so we’ll just go like this, press new and then we’ll say… We’ll just take a screenshot of this, go to my business analytics, go to view insights. And then really we just want to look at this other this stuff right here, so 10 calls, so whatever that’s worth, that’s like 500 times 10, so $5000. Save, and then you can look at other stuff too. But we generally don’t want to show… this other settings is not as important.
Not the only thing after that is just go to SEO profiler and Search console, sorry, let’s go to Search console. Find peak performance, it’s on the other account. So we go here, filter by the last 28 days, do compare date ranges, there we go, and then we just do impressions click throughs and positions. And then all we have to do is take a picture of this, and you can see some of these rankings are going up which is great. One of them is going down for certain things but is not a big deal. So then we’ll just take a screenshot of that. Save. Search console data month 2, and then the last thing we need is the keyword alerts. So we’ll just go to peak or sorry, spine. Go to ranking monitor, alerts, last 30 days, update. And then we’ll just take a screenshot of that. There we go. So that’s pretty much all we need. Now we just have to put together the email, but we’ll put it together here first. So it will just say, “Hey Matt, we are making great progress. Here’s what we are seeing in analytics.” And then we would just take those screenshots, put them in there and we could just explain a little bit about what they are. A lot of the time you don’t really have to do that because the clients already know so we would just put like the most important ones, so we’d put Google Analytics. And then if we wanted to put a note like I said we could just say, “Traffic is definitely improving” or whatever we want to say. Then we put keyword rankings, conversions. And you can see how this can actually turn into a case study eventually. And then all we’d have to do… So then from there all we have to do is go and save. So here’s what was fixed, and that’s literally just going through the last email and figuring out what was fixed just by… And a lot of this stuff you can figure out what was fixed just by going through it, so ideally what you want to have is while you’re doing this stuff off of month two or off of month one, you just go in and as you fix these things you just say ‘fixed’ – like this, ‘fixed’. And then all you have to do after that is just put all the things that weren’t fixed and the things that you found while you’re fixing this stuff. And if you run out of stuff, like I said, you can always put more stuff in there for yourself. You can also go to SEO profiler and they have an audit report which will overview anything that’s going on, and you can take screenshots of this, that needs to be fixed as well. And then you just say, “Here’s what was fixed and this is what… So from notes and then you would say, “Here’s what we want to do for next month” – and then you would just put together another top ten list, one, two, three, four, five, six, seven. And ideally this doesn’t have to be super detailed, it just has to be a little bit of an outline so they know what you’re doing and so that you can keep re-adressing the stuff that you want to move forward with. So say like I said, maybe you run out of something you would just say, “Okay, this month we want to do AdWords. This month we want to do more content. This month we want to do more reviews.” – whatever it is. Because there’s always something you can do. And then all you have to do from that point is pretty much… I recommend if you can do some sort of screen recorder something and explain this, even if it’s not public on YouTube and explain what you’re finding and then show them this. You can do it over video or you can just get on a Skype call with them and do a screen share and say, “This is what we found.” It only takes like 10 minutes and you just put it into your billing process, just make sure you’re leaving some time for reporting. That’s all you have to do, and that’s pretty much it for the report so it’s pretty easy.
Just like I said you want to really make sure that you’re keeping track of what you’re doing, that’s why these road maps are so important. And then also making sure that you’re keeping track of your rankings as well as your conversions because you want to show what kind of value you’re providing so you can continue to show more value and increase how much money they’re making as well as hopefully keep the money that you’re making or even up sell what you’re doing on the way and say, “Hey we want to bring even more people in.”
We’ve got some comments. Dave says, “Chase what do you include in your most advanced SEO package?” So just to be transparent with you, I usually don’t say this, but my advance SEO packages is just me doing 20 hours of SEO for a client based off the initial road map. Bill says, “An SEO template, nice.” Dave says, “Bless you buddy thanks. Will you release that Google Doc after the video?” Yes, I can. I’d rather finish it first though. Bill says, “Chase when something has a position of six what does that mean, if you look at for that term will be the six option?” That’s just the average position so if you actually click on this you’ll see what the position is. So the average position is six but you’ll see certain queries as of lately are not even showing up for that, so Google will actually sometimes filter out the result and show you in different positions to test what people are actually doing to interact with these things. And it’s algorithms could change and the user intent could be changed for that certain search which means that your site might not be relevant for that. Bill says, “I have a site which has position six for instance but it’s not in the search.” Yes, so you have to make sure you’re actually checking not just the average but where it’s actually at as of lately. Because you could show up number one just for Google to test that for like five seconds and then the next day and then for the rest of the month you’re not even showing up for that keyword because Google likes to experiment with your actual keywords and see if people are actually interested in that stuff, which is why click-through rates are so important and bounce rates. Jason said, “You recommend having external links on your homepage to say local landmark pages; are you worried about sending visitors off your website?” So that’s why you do the target equals blank, and that’s what Bill just said. So they open it up in a new tab so they never leave your website. Well they do leave your website but then hopefully when they close that browser they come back. This is great, thank you, glad I had the opportunity to tune in. Thanks Ben. How do you invoice your customers? I just use PayPal.
So I hope you guys enjoyed that. It’s just doing it a couple of times and then once you get it you can always follow this video too – that’s the cool thing about the videos. So if you haven’t already, please leave a like on this video, and if you haven’t as I said earlier text the word SEO to 66866 to get to the Facebook group, and until I see you guys next time happy SEO-ing.