How to Take Your Content Inventory
what we want is a list of all the pages that we rank for how much traffic and keywords they have and then we want to know what kind of drove that traffic and keyword volume was it the number of words that we have on the page. So we should track that was it, the title tag and meta description. So we should grab all those and put them in line with everything else. So here you have all the pages that rank currently in google, You can see that we rank for €27,000 now with the guru account. I can just export all these. No problem. But if you didn't have a guru account you can filter a little bit and cut down on that number and over time you can just that's really cutting down. You can really cut down on that number and then over time you can just take all of them out. So right now I included the parents directory And I think it will be around €15,000 Yep. So next to get the other, the remaining 30 I can just exclude and it should be around the same and that will allow me to easily export ev...
erything. But as I mentioned previously I have the guru account so I don't have to do that. And so let's just exit and we could export, we're exporting and through the magic of television it'll look something like this at the U. R. L. The traffic number of keywords, traffic percentage number of keywords and then total traffic and that's for all the girls that are ranking in google's index now that we have the performance data that we're looking for. Let's go and check out our old friends site bulb. Site bulb will tell us what the contents about. What's the title tag, the real canonical tag, all that kind of stuff. So let's go to site bulb again. Dashboards. Okay, let's view the project view audit out. I'm assuming that you've already run the crawl in the past. You've you did a full site crawl or you did a site map and therefore all this is loaded up. If not, you can just grab the U. R. L. S. That we just encountered and paste them into cycled. But if you already ran the crawl, just click on view or data Explorer and then what you'll notice is just all of the girls that we rank for in different information about them. The crawl depth, the parent, the anchor. And what we want to do is add a couple of columns. One is definitely a title tag. Next we want to add the meta description description. There you go. Now for an important one. Number of content this tells us how many words are in the page between the paragraphs and so if we're building content we want to know how much copy we need to create And then how about does it have an H1? And then finally let's check the real canonical Alright, update columns. Now when we print out, we'll get a list of all the girls and we'll also know how many keywords or how many words are on the page and everything like that. Note that if you previously ran a site pub crawl and you didn't click on advanced options and click on readability, then you might want to go back and redo this crawl because one thing I almost just forgotten now too is that you have readability metrics, Reading time in the flesh can cade score, which talks about reading ease. Easy, hard, difficult. This is all important when you're planning your project and then from here you can just press export. It'll look something like this. Now I I deleted a couple of columns because I wanted to make this a little quicker video but um it looks something like this. You can see this list is filtered for traffic. I just filtered for ones that had traffic but there's plenty that don't or have zero traffic. And that's also interesting. The question is why do they have zero traffic? These look like regular, your Ls, but they just don't have traffic. Um Okay, and we couldn't crawl them either. It could be something wrong with them. Here's our error pages. We can remove more of them from this because they really don't count what we're trying to show you also get the crawl depth and a lot more. Um So the other thing I should mention is now we want to join our two tables together. You can see I've already done that here. And the way to do that is if you look up you can see the formula here, you join on the U. R. L. Then you put the table number in which already made these tables. Um You can see here this table too one and then the column which you're trying to pull. So traffic was in the fourth column here 1234. So I pulled that I wanted to pull other stuff into this. I could I could do that as well with the V. Look up formula. And this is what I use as like a base content inventory because I also know as I mentioned before the reading time for many of these. Okay. Not with these ones because they have errors but everything else. Okay. All right. So you can see the reading time, you can see the number of content words which is something that we can shoot for when creating our content, the ease, the H. One, the meta description and the title and all this is important as we take stock of how each urals ranking. If we have your girls that aren't ranking well we should go through them like we just did um and try to identify why they're not ranking well and fix it and that's what we do with this content inventory