Depending on the size of your team, you might find that some things apply and don’t apply to your average day. I am going to explain in present day today what I do at my full-time job working in SEO and what I do for my own website. Some of the things include pulling traffic reports, keyword reports, checking on the health of the site both in Google and Bing, reading up on search changes, and so much more! Obviously there are other things that come up during the day that need immediate attention, but this is the basic blueprint. Here is what I work on for a day-to-day and a weekly basis. If you are interested in getting help for your site, I recommend checking out the SEO services page.
Pull Previous Day’s Organic Traffic
Getting in the habit of exporting your data into Excel will save you time down the road. It’s easier to view trends with a pivot table especially when you start looking at year over year data. A drop in organic traffic can be spotted in a pivot table and can be analyzed in all sorts of way. An increase in traffic can work the same way by looking at past optimizations made.
Ways to speed up this process is to have a custom report already set up in Google Analytics. If you have that, you can go right in and export the data. If you have a lot of traffic and landing pages, I would suggest download Analytics Edge for Excel to help with this mass exporting. If you have a lot of data, you might want to consider using Microsoft Access as the database to store all this data.
Pull Daily KW Rankings
This one might be controversial, but let me explain. It’s not to sweat or get excited by rankings daily, but it is supposed to act as a benchmark on weekly and monthly averages. Just like the traffic pulls, you can spot an increase in a particularly strong KW ranking to traffic changes. Same as before, you can start to figure out what key pages are losing traffic by seeing a decline in certain target theme keywords. What you can’t see in the picture above is that I have the real each day and weeks that are hidden inside the monthly averages.
Some tools that I use are AHREFS, Rankaware, and Rank Tracker. Both Rankaware and Rank Tracker are free, but will have their limitations like only pulling desktop rankings. Another good tool to check out is Moz if you want to have Keyword ranking checks.
Review Data from Search Console + Bing Webmaster Tools
I check about 30-40 main target keyword themes which takes a bit of time to check, so I jump right into Google and Bing to start reviewing data. Each tool is slightly different, but I look at some of the main things in each tool. Are more pages being crawled? If so, I want to know if this is expected or not. I want to see how many pages are indexed per both tools. I check to see what the crawl errors are with both engines, the crawl stats, and how the sitemap ration appears.
I take all this data from both search engines and put that in excel. The idea again is to not look at things from a micro level, but to archive as much data as possible. Now, Google only goes back 90 days, so you should get in the habit of pulling this data daily. Bing can go back 6 months, but you will lose that data after that. Google Search Console also will give you a clearer view if there is anything more seriously wrong with your site than Bing. Look to see if there are any red explanation marks showing issues with the robots.TXT file or server.
Review New Search Term Opportunities
After looking at Search Console and Bing Webmaster Tools, I like to spend about 30 minutes looking at the KW rankings that were just pulled and look to see how things are trending. This is where I use AHREFS for my next analysis. I will put in a main keyword theme into the tool to see how a theme or page is fairing over time. I can start analyzing new search terms based on search volume and keyword difficulty that might be overlooked from the main theme. Depending on what I find, I like to export these search terms and highlight the terms I want to add to my SEO blueprint for my site or my company’s view. This example above shows a target keyword and the suggestions that fall underneath it. This is a great way to constantly keep touching an account for optimization and to never stay stagnant.
SEO Blueprint Sheet
So many things will come up through the day that you will get lost on what you wanted to do. Same goes with sharing PowerPoint reports to clients or internal team members showing the work that you have done. If you don’t start writing down what you did, you will start to forget everything you did. This will affect you when you are analyzing keyword and traffic changes since you might be unsure what you already did.
Here is an example above on where I write down things that I’ve already accomplished. This will eventually help me go back into my traffic and keyword reports and see if I am making strong process in a few areas. An example of this is that I tweaked the load time on the page recently, so I can check to see if this has helped me in any positive way.
This one sounds like a waste of time if you are reading this as a potential client, but the world of digital marketing is honestly changing faster than the speed of which articles can come out. Things like MozCast weather updates, updates to Google algo updates, reading up on some interesting tests people have done, and more.
One thing that I like to do is check out Whiteboard Friday’s on Friday and see what Rand says. Sometimes when you are in SEO (or in my case the only SEO), you feel alone when it comes to making decisions. It’s a blessing and a curse at times because you might have blinders on that might not allow you to see what’s happening in search. I like reading the comments from blog posts too just to see how others react.
Load Time Check
The load time on your site should be something you are constantly auditing. When it comes to WordPress, you might be tempted to get a plugin that does one thing well. However, I have seen that many plugins will slow down your site, so you should be comfortable with adding code to the site manually.
Here are some of the things that I don’t do daily, but I still find important to look at when it comes to SEO. You can add these things to your daily report, but sometimes this would be better if you had a dedicated team to help with the workload. There is more that you can add to this, but here is a basic breakdown
Screaming Frog Redirect Chains
Checking for redirect chains is such a simple yet effective process to work on that can have such a big benefit for your site. This is important especially if you are working on a big site that has a lot of cooks in the kitchen.
Check the log files
This is something new to me, but I am getting into the habit of looking at the log files. I pull this monthly from my GoDaddy files just to look at what happens. One of the things that I want to start using is the Log Analyzer tool from Screaming Frog.
Check in with Old Co Workers
I love checking in with past coworkers to hear their thoughts on different updates in Google. It’s also especially important because I know that they are looking at this for their own site, so I am curious to hear what they are doing. It’s also a good way to bounce ideas on what you are doing and share success so other things down the line can be shared with you
So, there you go. Here is a basic view on what SEO’s do daily. A lot of this comes down to what is comfortable for you. I’ve concluded that my daily work does not say the industry, but I know that it has helped me. If you have anything else, you want to add please share it below in the comments section.