Featured Post

Update: SEO Issues - is it Penguin? Is it Panda? or is it me?

It was a little over a year ago that I posted the " SEO Issues - is it Penguin? Is it Panda? or is it me? " in which I detailed o...

Monday, February 19, 2018

Keyword Categorization

What is Keyword Categorization?

Simply put keyword categorization is the process in which you organize search phrases by common words. Organizing keywords helps structure your website capturing all phases of the buying process.

As mentioned in my post in 2013 "Categorizing Keywords" I cover the importance of categorizing keywords, but also a quick way to do it in Excel. This is a great strategy when working with a smaller set of terms, but what happens if you need to focus on larger sets including millions of terms to categorize that will most likely break you excel document?

There are tools like Conductor's Searchlight and Keylime that are great for dynamically tagging your terms with common words so that you can quickly categorize them. As more terms are added to your searches the dynamic tagging will add them without any additional effort from you. So easy!

Not every business has the thousands per month budget to shell out for these awesome tools so manually or setting up your own means of tagging is going to have to be done. Using Excel you can export your terms from Google Search Console and a simple sumif formula will pull in the totals for your terms.

For this lesson I am going to use my keyword list around auto make, models and year make model searches to categorize with the three distinct categories, and additional tagging to understand how many terms are reviews or the long tail and "for sale" that would be a high intent to convert.

We'll start with our exported CSV file that you'll pull from Google Search Console, Keylime, or or Keyword Planner. It should look something like this when you first open it up:
Downloaded CSV File from Google Search Console
Downloaded CSV File from Keyword Planner
 As you can see you will have three or 5 important columns. The Keyword column holds the list of terms you're going to set your lookup against. The data following falls under your Impressions, Clicks and additionally Click Through Rate and Average Position. We're going to focus on Impressions and Clicks for this exercise and use a formula to calculate the CTR from there.

Start by saving your document as an Excel Workbook. Formulas won't work in CSV.
Saving CSV as Excel WOrkbook
 Next up you'll want to create a new tab. I usually name the tab "Lookup" so that I know that this is where all my criteria I want to lookup is located.
Adding a new tab in Excel called "Lookup"
To make it easier to type in formulas and manage then I like to name the criteria that I will be using. In this case we are naming A2 through A55 "Make", doing the same with "MakeModel" and "YearMakeModel". I additionally will name the "All" tab columns as "Term" for the Keyword list, "Impressions", and "Clicks".
Excel naming feature

How to Sum Cells by List of Criteria

Using this formula and method only looks for exact match phrases to the keyword phrases in the cell and adds up all into a total. 

The formula will look like this:

=SUMPRODUCT(SUMIF(Term, Make, Impressions))

How the formula works is by using the first array which contains the TRUE / FALSE values that result from the expression (SUMPRODUCT) then using the SUMIF criteria to lookup the range (Term), Criteria (Make) and finally Sum Range (Impressions). Only the Terms that include the list of the criteria will be added up, or "summed".

Excel Sum cells by list of criteria

Excel Sum Cells by List of Criteria and is Included (not Exact)

In this case we want to add up all the keywords that include a few specific words within them. So we need to use the SUM formula to add up each of the words we have in our Lookup. In this case we have set three terms that we believe have a high user intent to purchase that are "for sale", "used" and "priced under".

A normal SUMIF sets the Range we want to lookup, the criteria of what to look for, and then what we want totaled. In this case the criteria involves a word that is located somewhere in the phrase so we will be using a wild card before and after. Ex: SUMIF(Term,"*for sale*",Impressions).

Because we are using criteria in a cell we need to concatenate the star to complete the formula. Ex:"*"&Lookups!E2&"*"

Since the Intent list just includes three words we'll SUM all three as a total.

=SUM((SUMIF(Term,"*"&Lookups!E2&"*",Impressions)),(SUMIF(Term,"*"&Lookups!E3&"*",Impressions)),(SUMIF(Term,"*"&Lookups!E4&"*",Impressions)))
Excel Sumif list within terms in cell
In order to calculate the Click Through Rate we'll just divide the Clicks total by the Impressions and format at a percentage.
=C3/B3

I have saved the excel document I used for this example in my Google Drive so you can download and play with. The numbers for the terms are completely falsified, so don't be using them to optimize your auto site. 

Depending on what data you need to look at for your terms, you can use these formulas to quickly add up totals to help you understand how your SEO is working, and determine what you will need to build out to capture new opportunities.

Tuesday, January 23, 2018

Updated: Looking for a Position in SEO? Interview Question Examples and Answers

Whether you are looking to hire someone in SEO or you are an SEO looking for work yourself this post should hopefully help you gain some insight into the most common questions asked during an interview, along with some sample answers I will tend to give based on my experience.

The following questions are a list pulled together from various interviews I have been through throughout the years. My answers are from recent work, and from past, in order to best portray my experience and knowledge for the work I would be performing for my potential employer. I also added some notes to give insight into what the interviewer might be looking for, and why I choose the answer I used.

For SEOs Looking for Work


The point of this blog post is to give you some insight into how a seasoned SEO might answer these questions. Please... please, please... do not use these for your own answers. A lot of what is in here is very specific to my experience, and will not be beneficial for you to use yourself during an interview. These answers might not necessarily be best for all positions with every company either. The idea here is for you to take these questions and formulate how you might answer them, helping you to be more prepared when that time comes.

For Companies Hiring an SEO


The idea behind the questions is to help you start drafting the basics of what an SEO could be asked, and examples of what the answer could be. Please don't base your hiring an SEO on what my answers are. SEO is part art and part science. Every answer from any SEO will be different, as all SEOs have a different approach to how they optimize. The main goal for SEO is that rankings increase, traffic increases, and therefore revenue increases. How you get there is all subjective, just as long as you know the SEO will be able to get there.

  1. Tell me about yourself.

  2. Note: In some cases I get the "How did you get into SEO", but in most cases the usual "tell me about yourself" is what starts off most interviews. In general I usually try to throw them 3 words that describe me and then follow-up with a bit to highlight my experience and skills that will fit the position they are looking for. This answer could change if the job description focuses more on a certain personality or skill trait.

    Answer: Well, I'm Fun, Organized, and Passionate. I generally love the people I work with. I have, in the past, become very close with my team, and across other teams. I believe in order to get work done for SEO, you must have a good relationship with everyone in the organization. Being a part of the team that helps plan fun activities, or just plan lunches, happy hours, etc myself allows me to really get to know everyone. My organizational skills have allowed me to be able to function well in SEO. To prioritize and organize the tasks and projects needed to get done for SEO. Understanding the impact to level of effort has been important to getting buy in, and championing work through. My "Passion" as I put in quotes comes from a few of my previous bosses. I was called a "bulldog" by my CEO at Classmates.com and my previous boss at ADP barked at our agency to "show the same passion that Jennifer has". I am passionate about SEO, about the company I work for, and want to drive them both to success.

  3. Explain the difference between Search Engine Optimization (SEO) and Search Engine Marketing (SEM)

  4. Note: I have found quite often that if you are going through a recruiter, being hired as an SEO where there are no other SEOs within the organization, or the hiring manager (potentially your boss) is not an SEO and does not understand SEO may not know that all of search marketing or what they call "Search Engine Marketing" includes both paid and natural search. In fact, in the past I have been asked paid search questions like "What process do you usually follow to determine how you set your bids?" when interviewing for an SEO position. Quite a lot of companies nowadays will consider SEM or "Search Engine Marketing" to be paid search (Adwords, Bing Advertising, Yahoo! Advertising) and SEO or "Search Engine Optimization" is considered natural search optimization. What I usually do is simply explain what I see as the difference between the two giving a bit of the history to show my years of experience.

    Answer: It used to be that Search Engine Marketing was considered all of paid and natural search. Paid search or PPC eventually became SEM, and now people refer to natural search as SEO which is more on-site work and link building to get the website to show up without having to pay per click.

  5. What is your SEO Super Power?

  6. Note: This question isn't asked often, but can come up in this form or another. What they are looking for are possible strengths or approaches for SEO. Every SEO has a different approach. Some focus heavily on link building, some on database development, some on user generated content, etc. 

    Answer: My approach is highly content and structural based. I highly believe that a well structured site followed by unique content is key to success for SEO. The content can be written by hand, or developed from a database with thousands of pages produced with data driven content unique to each page. What I have become known most for in my years of optimizing is local SEO. At the agency in 2004 our team managed to optimize a lot of local lawyers, Realtors, and various businesses for local terms. I later translated what we did on a larger scale for Classmates.com as we optimized for what they called "affiliations" which where high schools, colleges and universities. There was a page for each one developed from the database and structured by location. So you could search any school in a city and/or state and see the page for that school show up. I carried that to my savethebreakfastsandwich.com site that was started in an attempt to convince Starbucks to keep the breakfast sandwiches. The site had gotten quite a lot of press, and was even mentioned in Howard Schultz's book. I had pulled a database of every city and state from the USPS.com site, and optimized pages for the term "starbucks in.." followed by each of those city and states. In 2013 I optimized the usedcars.com site at ADP to show up for "used cars in..." followed by any city and state.  In some instances a user would see a city page show up for the city they are in when searching just "used cars" because Google recognizes the location. I have been able to translate what works for local SEO to other projects such as optimizing for brands of cars for usedcars.com, and into more general terms. In 2018 I directed the team at Nordstrom around a local initiative that not only included reworking the local landing pages that were in existence, but to incorporate a strategy for listings in sites like Yelp and Google My Business with a vendor called SweetIQ to help manage. The project also included the Nordstrom Rack team, and initiatives around the various services Norstrom has to offer (alterations, spa, restaurants, cafe, etc) as well as drive product encouraging users to reserve online and try in-store to bridge the gap between online and offline shopping. 

  7. What does your typical work day look like?

  8. Note: What the interviewer is looking for with this question is how much of your day is spent focusing on SEO and the business. I will usually roll in how I approach all of my positions at any company and then move into my most recent work with reporting since that was a huge focus at ADP and tends to be important to a lot of larger corporations these days. The trick s to look at what appears to be most important to the hiring company in their job description and align your typical work day happenings with that they are looking for.

    Answer: I'm a pretty early riser so I get in around 8 am, sometimes as early as 7 am. I like to use that part of the day in the office before meetings start and everyone gets in to go through all my check points for SEO. I will of course check email and answer any that need immediate attention. Then open up Google Analytics and look at the numbers for the day before. I open up Webmaster Tools and look for any warnings, or any issues that might stand out. If a Moz report has ran, I will look at that and dig into any issues that might come up. If all checks out OK, or the issues are pretty quick to deal with, I will look at the SEO groups I belong to for any updates in the industry, check my Twitter for updates from Google, Matt Cutts, and other SEOs. Then browse through articles and blogs to see if there are any updates or forecasts that I might need to pay attention to. My most recent position at ADP required me to manage all of the reporting and analytics for the usedcars.com website. So, I would update what we called the "daily reports" with traffic numbers, spend, lead volume, and update revenue. Then report on trending numbers, week over week, projected revenue for the month, etc. A report would go out in email every morning with the numbers and any details as to why, if there was a noticeable rise or fall. 

  9. What tools do you use and why?

  10. Note: Believe it or not, this one used to stump me. I've never been a huge fan of automating SEO for any reason, so tools was one of those faux pa questions for me. My answer would be "I don't use tools, I optimize naturally". Well, that was wrong... Because I did, and still do, use tools to help me do my job. In this case now, I mention everything that I use to help me monitor, optimize and evaluate for SEO.

    Answer: Most of the tools I use are to help me gain insight into what is going on with a website. I believe it's important to be able to evaluate how a crawler sees a site before launch preventing any issues, perform keyword and competitive analysis, and to monitor performance regularly. I have a Moz account, and have had one for years. I use that to check for Errors and pinpoint what the source of the error is so that the fix can get prioritized. Unfirtunately Moz doesn't work for larger enterprise SEO though, so tools like Botify and Deepcrawl are great for getting into deeper insights. Conductor, Brightedge and Searchmetrics are all very good for reporting on SEO, quickly gathering opportunity data and helping to strengthen relationships within an organization by giving others access. I also use webmaster tools to monitor for messages from Google, to track performance, and to watch for errors that the other tools did or did not catch. For enterprise SEO it is good to have a Keylime account to capture more data from Google Search Console and to be able to run comparison reports that are older than just 90 days. I use xenu to crawl the site, or a section/project before launch to gain insight into how the bots will crawl and address any issues that might show up. I use Google Analytics, Adobe Anlytics/Omniture, Coremetrics, Tableau (or other analytics tool), and internal reporting to monitor performance. I also use the analytics tools to gain insight into what is working and where there might be any room for improvement. I look at Adwords search terms reports for campaigns to identify what terms perform well, ad messaging with a high click through rate for meta tags, and see if there are any highly expensive terms we can target for SEO that we could get for free to maximize revenue. When performing a competitive analysis I have a few tools to check keyword count and densities of ranking pages, I will also often look at spyfu to evaluate how the competition is doing.

  11. What SEO Blogs and authors do you follow?

  12. Note: This question can go one of two ways, either the interviewer is an experienced SEO, or is learning SEO and knows who they pay attention to. So if I were to miss any of the ones they follow then that's a bad sign. The other possible scenario is that they do not know SEO at all and they were instructed to ask this question. If that is the case, then they might have the basic few that should be mentioned written down somewhere. In either case, I always make sure I answer with the important basics to follow for SEO. Another thing to note on this, in the years I have learned that even though a lot of the people I follow are acquaintances, friends, or even very close friends I have in the industry, I leave the name dropping and association out of it. I'm not getting hired because I know people, I'm getting hired because I know how to optimize a website. 

    Answer: I mostly focus on the Google Webmaster Tools blogs, with some on Search Engine Land, ClickZ, and Moz publications. I will occasionally pay attention to Ian Lurie, Bruce Clay, and Barry Schwartz for insights and updates on algorithms. I also hit up the SEO Group on Facebook that includes a lot of the thought leaders that participate regularly. If I have a complex question I usually go there or to my closest SEO friends for help or verification that I'm making the right decision. 

  13. Give an example of how you increased SEO for your recent employer.

  14. Note: I honestly haven't gotten this question a lot. I found it off of a couple of articles that had questions to ask during an interview for hiring an SEO, and it also came up in a recent interview with a pretty large company. If you are hiring someone as an SEO, I would recommend asking this one, and listen for numbers. This way you know they really pay attention to the business and their impact on it. As an SEO, you should be able to answer with key numbers to back up your statements.

    Answer: I would have to say my most recent success was the usedcars.com website for ADP. When I started the site had taken a huge hit from the Panda and Penguin updates by Google in 2011 to 2012. The site had dropped by roughly 80% in traffic from SEO and while an agency and a consultant were both working on it, the traffic was dropping daily and even more with each update. I spent some time digging through the analytics for the past 2 years, and looking at each section (or keyword category) of the website and quickly identified that the local focused pages were the largest driver for SEO traffic and had taken the biggest hit. Since location is my strength, and I noticed the exact same drop around the same time for one of my other sites, I met with the CEO and we quickly developed a plan to fix the pages immediately. In 3 weeks the project was complete, but there were so many other issues with the site that still needed fixing, so the pages took some time to show results. In the 2 years I was there, the location pages jumped to providing over 45% of the traffic from SEO, and overall traffic increased to over 85%. 

  15. How do you measure success?

  16. Note: Most SEOs look at traffic and keyword ranking reports. I add a bit of a different approach that shows growth from SEO. If you are someone interviewing, it's good to come up with your own unique approach that makes sense that will set you apart from the rest. If you are interviewing an SEO to work for you, the basic traffic increase and ranking reports will suffice, but if the position is a more advanced role then look for someone that thinks outside the box and is passionate about the numbers when it comes to reporting.

    Answer: I will most often look at revenue generated from organic traffic. I will also look at the usual traffic increases from SEO, and occasionally look at keyword ranking reports for newly released projects. But what I look at most for myself, not usually reported up, is the growth in the number of keywords driving traffic week over week. I also do this with the number of pages indexed and referring traffic week over week for new projects that are rolling out. This way I know that the work we are doing is grabbing new opportunities and growing the business. With usedcars.com and the hit they took from the updates, I looked at the number of pages with duplicate content, too many on-page links, the number of pages with parameters, and anything that reflected improvements on the issues we were finding.

  17. What sort of issues have you faced with SEO, and how did you resolve them?

  18. Note: With this I tend to focus on issues I have faced within the company websites I worked with. Getting buy-in and communicating effectively across teams and working with sites in which I have full freedom to optimize, and stay within the SEO rules, tend to stick around well when it comes to rankings. The Nordstrom project prioritization and the usedcars.com site getting hit by Panda and Penguin before my hiring really gave me some great experience in addressing issues for SEO. I detail out what the main issues where with the site, and follow-up with some of the technical aspects that went into the corrections to demonstrate my level of knowledge of SEO from the technical side.

    Answer: Upon starting my time at Nordstrom I got a good sense of what the team was working on as well as what projects they would like to do. Local was on the roadmap, and had been for a couple years. Local is extremely important for brick and mortar businesses that have eCommerce as well so I knew immediately that Local needed to be prioritized for the year. I worked with the team to calculate the assumptions for not just the site, but for the entire business (Estimating SEO's influence for in-store purchases). With that we came up with an estimated increase that would be upwards of several hundred million in revenue per year. I used those numbers to prioritize the project with key stakeholders gaining buy-in that supported an additional head count of 4 people (including a PM and Devs) to it. The project prioritization alone is a huge success as gaining buy-in from executives and other teams is crucial to the success of SEO.

    Another great example is upon my hiring at ADP in 2012 to address the hit that usedcars.com took from the Panda and Penguin updates. A majority of what issues that caused the drop where too many links on a lot of the pages, top level file structure with parameters. no site hierarchy, there were 48 million pages indexed and only roughly 300 thousand really existed on the site causing a webmaster tools warning of "an extremely high number of URLs" every month, a large chunk of duplicate content as a result of the too many URLs and the parameters, and not enough unique content. It took the majority of the first year to get everything cleaned up from redirecting how the bots crawled the site, removing a mega menu, cleaning up the use of parameters, rewriting URLs and setting a validation, and then building out new content after a massive database overhaul and pages developed from syndicated and data driven content.

  19. Give an example of how you developed a strategy for SEO and championed it through.

  20. Note: I happened to have an example of a major project that I worked hard to push through at ADP. This, for me, is my usual answer to this question, and it is a question I get just about every time I interview for an SEO position. I recommend, if you are an SEO looking to ideas on what to do during an interview, to find that one project you conceptualized, planned out, championed through with stake holders and teams, and saw to completion. If you don't have one, come up with one in your current role so that you have that one project you can use as an example. 

    Answer: One of my favorite projects that I started from concept to near completion is a major project I worked on in my last position. In speaking with a few friends of mine in the business and looking at traffic outside of the location pages, I noticed that searches for a very specific type of terms in exact match and longtail around year, make and model (ex: 205 Toyota Corolla) that were very prominent. I created a large excel document that listed out every keyword in three hierarchical categories for each term and began completing a keyword analysis report for every one of them (you can view that document from my Google Drive). It took me a couple of months to get through all of them in-between my usual daily tasks, but in the end I found that there were millions of searches total for all three categories, and was able to even see which terms within the three categories were the most popular. I used that data to calculate current traffic from those terms against potential by figuring out what percentage of the terms we had rankings for, current click through rate for those terms, and conversion rate from those terms. It allowed me to show the gap of what traffic we were missing out on by not doing the project, and then show incremental growth both in traffic and revenue as rankings improved. I also completed a full competitive analysis for the top 20 terms and documented it all. I developed a plan based on what data, structure, and content we had available and presented it to my boss. After discussing it, he wasn't too thrilled with the idea, so I worked with our current consultant to break down the project into a workflow that was a bit easier to digest. I went back to presenting it to my boss again revised and he was thrilled with the project. I then presented it in our bi-weekly SEO meeting in which my boss, his boss, a few developers, the consultant, and the head of Engineering attended. After some questions were answered the project was given the green light to go ahead. It took months of working through a lot of the database development that was headed up by another team member and overseen by myself, then developing the pages to incorporate the information from the database. The project still wasn't complete upon my leaving, but was about 80% done and gaining some traction when I left. 

  21. You found an issue with the site that can be very detrimental to SEO, how do you come up with a solution and get work prioritized to get completed? 

  22. Note: This is one of the questions I love. It clearly shows my ability to catch issues with SEO hopefully before they become too detrimental, and demonstrate my ability to state my case, champion the work, and show my ability to work with whomever I need to resolve it quickly. This is a key trait that every SEO needs, not just fully grasping the technical side of SEO, but to be able to work with other people to get what needs to get done quickly.

    Answer: Yes, well sadly this happens often with SEO. After spotting an issue, what I like to do is determine who it is I will need to work with on the issue to get resolved in the end. It could be something that was there for usability sake and is hurting the site for SEO, a business decision that caused the issue, or a simple bug or oversight during development that is causing it. Of course, I always go to my boss first for communication purposes and show them what I am seeing. If usability, then I go to the ones responsible for user interface design, if a business decision then I more often than not will just show my boss the issue and the numbers of potential impact to the business, If a development bug or oversight I will take it to the lead developer or possibly the one that worked on the piece that caused the issue and let them help me come up with a solution or perhaps they can determine a quick fix. My approach is different depending on how big, who, and what part of the business the issue affects. Then I either act as the trusted expert that I was hired to be, or a part of the team that works together to come up with a solution. 

  23. If someone within the company doesn't agree with what you recommend how do you deal with them?

  24. Note: Sadly this happens oh so often to an SEO. Whether it is as an in-house SEO as I tend to work in, or even as an agency SEO. Gaining trust in your ability, stating your case, and championing work for SEO has a direct affect on your ability to do your job. You aren't always going to agree with everyone, and not everyone is going agree with you. The finesse in getting buy in from them, or at least working with you somehow is going to make or break SEO.

    Answer: I have found a way throughout the years of approaching each situation and person differently. If I have done my due diligence in stating my case for SEO and someone still doesn't see the benefit, or agree with my recommended approach then I will try my best to work with them as much as possible on a compromise or allow them to help me come up with another solution. I find that involving them in the process and perhaps showing them what I see, how I see it, and then giving them the opportunity to present their solution has always been the best approach. The outcome to the solution may in-fact change as I see their solution might actually be better, but in the end, as long as it works and is best for the business, I am more than happy to work with them. If what they propose just isn't going to work, I will usually let them know why and perhaps show them examples of case studies or where sites have tried that already and failed to help them see what I have been seeing that got me to my conclusion. Either way, my take is that what is best for the business is what we all should be working towards. 

  25. Key stake holders find SEO to be very important, how do you communicate with them in a way they understand what you are working on, and how it will (and did) benefit the business?

    Note: Yes, the stake holders. SO many companies place so much value on SEO, and for good reason. The work the business puts in now can have a huge return long term. Some businesses thrive on traffic from SEO and simply supplement the traffic with some advertising and even paid search. But that all costs money, and traffic that comes for free is nearly 80-100% profit (taking into account the salary and time spent getting the work done to get those rankings). So it shouldn't be any surprise that key stake holders (executives and CEOs) all know the importance of SEO, and want to understand it as much as possible to know that the business is growing, and will continue to grow. If an SEO cannot clearly articulate what work is needed and what the impact is for SEO then they shouldn't be working in SEO. 

    Answer: My approach to working with key stake holders is to use visuals, numbers, and typical business terms. I leave the technical side of SEO, development needs, and so on for the other teams that I need to work. Occasionally I will get an executive that really understands SEO, and in that case I will dig into more detail with them. Though really focusing on the impact to the business and keeping things as visual as possible has worked best. When working on the location page drop and the example I used for concept to completion, I had dug deep into the data and truly understood the business and the competition for my own benefit. When I presented the projects to the stake holders I mainly focused on the total numbers as impact to the business in terms of traffic and revenue. Often times showing where we are today with traffic and revenue for those terms the project is targeting, and potential incremental growth (since SEO doesn't happen overnight). I then leave opportunity for questions and be fully prepared to answer the why, how, what if, and so on always knowing the numbers to back up my statements.

That's It?


I'm sure I am missing a question or two (or three) in here, and of course, every role is completely different from the next, so each potential employer is going to have their own set of questions to gauge whether the SEO they are looking for not only really knows their stuff, but will fit what they are looking for in a role, and the personality of the company and team. I have to admit, there are positions I have interviewed for that I was a perfect fit for as far as ability was concerned, but my quirky personality doesn't always mesh well with very serious environments. Don't get me wrong, I can be serious and am very professional, but I do like to have fun and really get to know people on a personal level. So, during the interview process I look at the personality of the hiring manager, and try to gauge the dynamic of the team I will be working with before making any decision to work there.

If you are an SEO and have experienced other questions you feel should be added to the post, please add them in the comments below, along with your example answers. The more we can help our fellow SEOs the better this world can be.

Other Sources:


The other articles I grabbed some of these questions from:
The SEO Interview: Questions to Prepare for Before Your SEO Job Interview
Competency Based Interview Questions for Hiring SEO Professionals

Thursday, December 3, 2015

Domain, Subdomain and Subdirectory for SEO

I want a WordPress Blog for my Website

Whatever your business may be, chances are you have a website that is developed that promotes your business or, in some cases, is your business. More often than not, the website developed is managed by the development or engineering team, and to be able to add pages, edit content, or get any changes done for the website is a development process (whether it be a waterfall or agile project flow) that can take days, weeks, or even months to see any progress on. Even most content management systems reside on a server that doesn't allow for a blog like scenario that the marketing or public relations team can easily update quickly. This is where most companies will turn to WordPress. Wordpress is easy to install, fully customizable, easy to edit, easy to update, and is virtually impossible to screw up.

"You'll Have to Put It On a Subdomain" ...WRONG!

Bad for users - Bad for SEO

I have personally experienced the scenario of coming into a company that had already been through the discussion on setting up a WordPress website on another host than where the rest of the website exists. What the people involved at the time advised the company to do is set up a subdomain of their website and link to it in the top navigation. When users click the link in the navigation they go from www.thewebsiteinquestion.com to blog.thewebsiteinquestion.com. Sadly, when doing this, the blog will often look entirely different than the website. Not to mention that the content that is being written (often for SEO) is supporting just the subdomain and not the entire website.

A great example of a larger company using WordPress as a blog that looks completely different from the website is Twitter. Yes, the famous means of microblogging and staying connected with others through quick updates, images, videos, and links has a blog that resides on a subdomain and doesn't look anything like the website.
Not only is this a poor user experience, but the content on the subdomain is counted for the subdomain as it's own website, and does not support the main domain. One way to quickly rectify this for SEO is to have links from inner pages pointing from the subdomain to the website and from the website back to the subdomain where the pages all are similar to one another. Unfortunately, this just isn't the most ideal for the user especially when the website and the blog don't behave in a seamless way, and Google has been cracking down on linking both externally and internally. If not properly or carefully executed the website could inadvertently be flagged as trying to trick Google.

My recommendation, as with most white hat SEOs, is to have the blog reside in a subdirectory of the website rather than on the subdomain. In addition, the blog should look and act just as the website does.

Subdomains are aren't Fine for SEO

When you make the decision to have your WordPress blog reside in a subdirectory of your website you might get some push-back from developers or some of the people on the engineering (or possibly other) team. Working with one of my client's recently I was referenced the YouTube video by Matt Cutts (former Head of Spam Team at Google) in which he states that using subdomains for a website is just fine. My response was a bit of a lengthy one in which I cited a few trusted resources that supported the benefits that having a blog on a subdirectory have.

While most SEOs are familiar with the video of Matt Cutts, it is from 2012 (a few years ago). Rand Fishkin of Moz.com talked about this in his more recent video this year (2015):
https://moz.com/blog/subdomains-vs-subfolders-rel-canonical-vs-301-how-to-structure-links-optimally-for-seo-whiteboard-friday

He states: "You're asking, "Should I put my content on a subdomain, or should I put it in a subfolder?" Subdomains can be kind of interesting sometimes because there's a lot less technical hurdles a lot of the time. You don't need to get your engineering staff or development staff involved in putting those on there. From a technical operations perspective, some things might be easier, but from an SEO perspective this can be very dangerous."

In addition he says "I can't tell you how many times we've seen and we've actually tested ourselves by first putting content on a subdomain and then moving it back over to the main domain with Moz. We've done that three times over that past two years. Each time we've seen a considerable boost in rankings and in search traffic, both long tail and head of the demand curve to these, and we're not alone."

An article I have found that supports the subdomain question:
https://iwantmyname.com/blog/2015/01/seo-penalties-of-moving-our-blog-to-a-subdomain.html Blog traffic after switch to subdomain
...and yet another example of a site seeing improvement after changing to a subdirectory: ​http://www.bloggingflail.com/subdomains-vs-subdirectories-seo/

"I went from somewhere out of the top 100, and I know for a fact I wasn’t even in the top 200, to being number 57 in the SERP’s simply by changing from a subdomain to a subdirectory.  Everything else related to my site remained constant.​"

Championing the work through is usually 90% of the work when getting the WordPress blog into a subdirectory. As Rand mentions in his video it is much easier to just add a subdomain and point it to whatever is hosting the WordPress site. Unfortunately the implications of the WordPress blog residing on the subdomain rather than in a subfolder of the website is too great to take the easy way out. Using the above articles to help state your case and to continue to persevere through the challenges of those pushing back will get you to where you need to go, and the site will be successful as the end result.

Two Hosts - One Website

In the case where the WordPress blog has to be hosted on a different server and IP than the rest of the site, there is a process to take that will show a seamless website under the same domain. I have completed this task several times now and now have it down to a streamlined process (discussions to state benefits for SEO and all). I will tell you that if you do not have the technical background to understand some (or all) of this process, don't feel you should as it has baffled every developer, CTO, Engineer, and even some of the most genius of individuals I have worked with each time I do this.

Step One - Set Up WordPress Blog

Whether there is an existing blog that the website links to on a subdomain, or the blog doesn't exist yet, you want to set up a hosting account and install the WordPress blog under a subdomain. You will eventually point your new subdirectory to resolve to the subdomain, but for now you want everything on your WordPress blog to look and act as if it was a part of the website. A great example of a successful separate WordPress blog to website is the usedcars.com advice section. I worked for ADP managing the usedcars.com website SEO, SEM, Social, and Analytics from 2012 to 2014. Upon my first arrival the previous social media manager has worked with the agency to create a WordPress blog that the agency hosted and had designed. Unfortunately the WordPress blog looked nothing like the rest of the website, it resided on a server nowhere near ADPs servers, and it was in a completely different language from the rest of the site. You see, usedcars.com was/is hosted on Windows servers and written in .NET. WordPress is written in PHP using Apache.
This is what the usedcars.com homepage looked like in 2012This is the blog that the user would go to when clicking the link in the top navigation of the site. 
The site had a lot more issues going on with it that were bigger than the blog being on a subdomain could solve. However, the strategy of moving the blog to the site and it being a part of the site was on my list of things to do for SEO.

In this case the idea was to have a sort of "advice" section with car buying tips, ownership tips, and so on. So we decided to have the URL www.usedcars.com/advice be the new home page of the WordPress blog.

In this case the blog had so very little traffic to it (we're talking just a few hundred a day) that I started work on developing a custom theme for the WordPress blog that looked and acted much like the website.
The usedcars.com homepage
The WordPress blog with custom theme
Now that the blog that was hosted on blog.usedcars.com looked just like the website it was time to get the blog to show up when someone would go to usedcars.com/advice, and all of the pages within to work under that subdirectory.

Note: in the case for usedcars.com we wanted the WordPress blog to be hosted on ADP servers where the site could be managed by the company and be more secure. So the process of moving the files needed to take place before rewriting the URL. Since this is not a usual case, I am skipping that part and going straight to the URL rewrite.

Step Two - Rewriting the URL

When discussing the strategy of rewriting the URL I often find myself having to explain how the URL behaves to those that aren't quite technically inclined, and find myself having to correct those technically inclined that it is not a redirect.

When working with others and to help you understand what a rewrite is let's first cover the difference between the two.

Redirect vs Rewrite - What's the Difference?

Redirect
When a user visits a website from a browser, that browser is hitting the server that the website resides on. The server will return a series of codes when that happens. Among those codes is the common "404" error you often see when you come to a page that doesn't exist, but more commonly is the "200" code that tells the browser it is okay and shows the page. The code we are talking about here is the "301" redirect code. This is telling the browser that the URL that is being accessed has moved to a completely different URL and then send the browser to that new URL. For example - click on this link: http://jennmathewsconsulting.com/that-301-redirect-goes-to/. Notice how the URL in the address bar changes to http://jennmathewsconsulting.com/301-redirect/

The redirect is what we call "client side" meaning that it is the browser on the computer of the user (or client) that creates the action, and the URL will always change in the browser as a result.

Other types of redirects:
  • 302 – Found 
  • 303 – See Other 
  • 307 - Temporary
The page request flow goes like this:
  1. The browser requests a page
  2. The server responds with a redirect status code
  3. The browser makes a second request to the new URL
  4. The server responds to the new URL and displays the page
Rewrite
When talking about rewriting the URL the behavior of the page is completely different. A rewrite is on what we call "server side" side meaning that the response happening when the page is requested is happening on the server. With a rewrite the browser is going to a URL and the URL stays bringing up the files that reside under a different URL, but stays the same. For example take a look at our client's blog we created for them under https://health2.drinkhint.com/. When you click through the links you will notice that the subdomain stays the same. This is the subdomain where the WordPress blog resides. Then go to https://www.drinkhint.com/health/ and you will see that the homepage and all the pages are exactly the same. The https://www.drinkhint.com/health/ URL is rewriting to the files at https://health2.drinkhint.com/ telling the user and the search engines that the blog for https://www.drinkhint.com/ is located in the subdirectory /health/.

The page request flow for this works as follows: 
  1. The browser requests a page
  2. The URL Rewrite then rewrites the URL and makes the request for the updated page
Everything is happening on the server side, and completely friendly for SEO.

How to Setup an SEO Friendly Rewrite
There are quite a few steps to get to this point where the URL is staying the same while clicking through the site and the CSS, JSS and Images from WordPress are pulling in correctly.

1) Relative URLs - The first step in rewriting is setting up WordPress to have relative URLs for images and stylesheets. A couple of recommended plugins can make this job an easy one.
  1. Relative Image URLs
  2. Relative URL
You may also need to add a few lines of code to your htaccess file in addition to the plugins, but these should get you to where you need to be.

2) htaccess Rewrite - The next step is to add a few lines of code to your htaccess file on the server that your main website is hosted. It won't work if you add it to the WordPress htaccess since the URL that will be rewritten is the main domain and if you're reading this chances are your WordPress blog is not on the same hosting as your main domain.

The code that needs to be added to the main domain's htacces on the server:

RewriteEngine On
RewriteBase /
RewriteRule ^blog/(.*)$ http://blog.yoursite.com/$1 [P]

Note that the "^blog/" part of the code is the subdirectory you would like your blog to be on and the "http://blog.yoursite.com/$1" part is the subdomain that your WordPress blog is currently on. My two examples I used earlier are the http://blog.usedcars.com (usedcars.com is on a .net platform and WordPress on Apache) andhttps://health2.drinkhint.com (drinkhint.com is on an apache eCommerce CMS and the WordPress is on another hosting platform). You can read more about rewrites at apache.org.

3) Redirecting Traffic - the next step you will most likely need to make is redirecting traffic to your blog. Each server is different, and every blog is different, so explaining this part in detail is a bit more complicated to cover all of the different scenarios. Apache servers have a means to set up a proxy.

This part is best left to the experts to manage for you, or you can always ask myself and my team to help you through the process since we have done it a few times we can usually determine what steps need to be taken fairly quickly, or troubleshoot if needed.

4) WordPress General Settings - Lastly you will want to check your WordPress Address (URL) and Site Address (URL) in your WordPress Admin General Settings. The URL doesn't always need to be set, but in some cases just the Site Address (URL) will need to be set to your subdirectory. Once again, I suggest having an expert help you with this part as you can run into issues with redirect loops and/or URLs just not working.

If you follow each one of these steps and you are still having issues, or you need help with getting through the steps, you can always count on myself and my team to help you through the process. As you can see, the impossible task of getting a subdirectory to rewrite on a completely different WordPress host on a separate server is doable.