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...

Showing posts with label answer SEO questions. Show all posts
Showing posts with label answer SEO questions. Show all posts

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

Monday, August 4, 2014

SEO

That's right, I am an SEO. So, what does that mean? It means that I optimize websites so that they show up on the search engines for certain terms. Those terms are usually focused on what your key audience might be searching.

Some Stats About SEO:
  • 93% of online experiences begin with a search on Google, Bing, or Yahoo!
  • Google owns 65%-70% of the market share.
  • 70% of users will click on SEO results over paid.
  • 70-80% of users ignore the paid ads, focusing on the SEO results.
  • 75% of users stay on the first page of search results (1-10th position).
  • SEO beats social media by more than 300% in traffic for most content sites.
  • Traffic from SEO has a 14% close rate, while outbound leads (such as direct mail or print advertising) has a 1.5% close rate.
  • For Google, 18% of clicks from SEO are on the 1st, 10% of clicks from SEO are from the 2 to 3rd.
I primarily work as an in-house SEO, which means I work for large companies within the organization rather than an agency or as a consultant. I have, in the past, helped some companies out as an SEO consultant, but if it takes time away from my job and career I will generally offer to recommend someone else to consult. Most SEO consulting consists of myself reviewing the website and any possible issues the company is finding. I review the analytics looking at the SEO traffic as well as traffic from other sources. I also look at Google's Webmaster Tools data to gauge how the current SEO is doing for the site, and how the impressions for key terms look compared to clicks. Sometimes just a simple change to meta tags for a different title and description can increase the click through rate from SEO therefore increasing traffic. In most cases, a complete restructuring of the site along with basic SEO implementation is needed in order to increase rankings. After I review the site, I will come up with a list of recommendations along with how much effort it should take along with the measure of impact. Your report will also include potential traffic and current traffic from SEO so that the client can see where the biggest gaps are. At times the reporting for SEO that I send over can be pretty technical, but rest assured I spend time making sure all the data is easy to understand, and a clear direction is not only explained, but in full detail in the final recommendations. From there it is up to the client to decide on whether they can do the work themselves, hire someone, have it done by their current employees, hire an agency, another consultant, or have me do the work for SEO. Since I have a background in design and development any work needed for SEO or to simply just increase conversion rates from SEO traffic, are fairly easy for me to do, and can happen pretty quickly. It all depends on how much I have on my plate at the time the work needs to get done with my full time job.

If you're not sure you want to have me, or someone else, optimize your site for SEO, it's no problem. Most people can pick up on the basics of SEO themselves. I always like to see clients having some understanding of SEO before I work with them. If they don't have time to learn, that's perfectly acceptable, as I can explain how things work in ways most people understand and pick up quickly. The following is a check list I have come up with for SEO that will help anyone understand and get started in SEO quickly and easily. Of course, there are so many algorithms that Google and other search engines use to determine which site gets to show up for their respective terms, but this at least gets you on your way to understanding the basics of SEO.
  1. Keywords – you can't do anything with SEO until you know what keywords you are optimizing for. Once you have your basic list, then structuring your site, and any work you do with the site, around them will all fall into place. I usually recommend one or two broad terms that describe a website. These terms should only be one work, and very rarely more than two. From there a few two to three word terms that might describe a sub-category will help you structure your plan and organize for SEO. Your longtail (as SEO's will put it) or exact match (as Paid Search people call them) are the phrases that are more specific. These phrases then to be the biggest payoff for SEO since they represent terms that users will use when they really know what they want and are ready to buy. Therefore they tend to convert a lot faster and higher. I talk more about this in-depth in my workshops, and in my book titled “Search and Social” that is currently in the works. So stay tuned for the book that helps you really understand SEO on a very detailed level.

    Keywords in
     – Keywords should be in the following items for SEO.
    • Keywords in title tag  - The title tag is what show up in the browser top. It is also what search engines use for the title in the “snippet” that displays in the results after a search has been completed. Having your keyword in the title tag not only helps SEO, but will aid in the click as the user will recognize the word they searched for within your title encouraging them to click your result over the other's on the page.
    • Keywords in URL – Getting the key words in the URL is very important for SEO. Start with the broad terms in the domain if possible. If not, then in a directory with the category terms (2-3 word terms mentioned before) as a sub-directory, and then the exact match longtail terms as the name (or in the name) of the file. Your URL hierarchy is very important for SEO and having those keywords in there even moreso.
    • Keyword density in document text – Listing out your keywords over and over again in a short paragraph will harm your SEO more than doing any good. A good way to explain how to watch your densities is to look at a page that has 3 paragraphs, each having about 150 words. Let's say you need to mention your keyword 9 times in order to get rankings. If you mention your keyword 9 times in your first paragraph and then not in the others that's bad. The trick it to distribute your keyword evenly among the three. So mention that keyword 3 times in each paragraph and evenly distribute it throughout each one of the paragraphs.
    • Keywords in anchor text – The anchor text is the text that a user will click on within a page's content that sends them to another page. The text that links back to your website should include the main broad keyword that describes the site. The trick to this is to make sure that the page and the whole site linking to the site is relevant to the word in the anchor text. If the site linking to your site isn't relevant than that will actually get your site in trouble, and too many will cause you to lose rankings.
    • Keywords in tags - The alt tag is the alternative text that displays in the rare case that an image doesn't show up. It's a simple line of code that goes in the html that generates the image. For SEO purposes, the alt tag containing the keyword is important, and will actually help rankings. Be sure to stick with only the words relevant on that page, and don't list all of the keywords out with commas. That will get a site in trouble.
    • Keywords in metatags – Be sure to get your keyword in your SEO meta tags, that's the description, title, and keyword tag that resides in the background of the html.
  2. Metatags – meta tags are (as explained above) the lines of code within html for SEO that describe your page. This includes the title, description, and keyword tag.
    • meta description tag - The description tag should be no more than 150 characters, and include your keyword(s). Try to describe the page as much as possible for SEO while keeping in mind that the user will see this in the search results.
    • meta keyword tag - Some SEOs will say that keyword meta tags don't make a difference. Google doesn't really pay attention to them, but the meta driven search engines will, and there are thousands of other search engines aside from Google. So, for SEO purposes, and to help keep the focus of the page of the site, I recommend listing out the keywords in the keyword tag with the broad terms first, then the category, and the longtail. You never know, it might actually help SEO.
    • meta language - If the site is in English then adding the language meta tag will help the search engines know which language to display the site on. If you have other languages, then try to make sure the language is in the meta tag. In some cases it can really benefit SEO.
  3. Links – Internal – Linking internally to other pages of the site that are related to the page you are optimizing can be quite important for SEO. Almost as much (if not more) than external links coming in.
  4. Anchor text has key term(s) in links – As much as the links pointing to other pages, the keyword in the anchor text is important. I cannot stress just how important it is for SEO to have those internal links, and the keywords in the anchor text.
  5. Content Around-the-anchor text is relevant - If a section of pages are relevant to other pages, the cross linking with a paragraph mentioning the page before and after the link is very helpful for SEO.
  6. Content – content, content, and more content is the key to optimizing a site for SEO. Pages don't have to have large chunks of paragraphs, but can have words here and there throughout the page. Too many SEOs will put big blocks of content on the homepage of a website thinking that it will benefit it. Sure, it helps for SEO, but it looks horrible and users don't fall for it. A paragraph of 10 words at the top describing the site, and then perhaps another clock of text highlighting the value proposition of the product or service in blocks around the page are just fine. The trick is to search your term you are trying to rank for, look at the first few pages or sites ranking, and then look at how many words they have on their page with the number of mentions of keywords. Then, simply just do a little more. Once you have that content in place for SEO, you're on your way to rankings.
  7. Unique content – Unique content is very key to making sure your SEO is in place. Not only do you need to watch out for other sites having the same content that you have, but look at other pages of your site. If a block of content is repeated on more than one page, then the content just won't be counted towards SEO. If a page has less than 15% content then it will even work against SEO and even get a site penalized. Sites that use tracking tags, parameters, or might have issues with validating URLs can often run into the issue of duplicate content, and really harm the work they have done for SEO without even realizing it.
  8. Frequency of content change – A site that is recognized as a publication and pushes content several days a week (or even several times a day) will train the search engines to visit and see updates regularly. In this case SEO will work to their benefit with fresh content getting recognized and ranked quickly.
  9. Age of document - If a site is a brochureware site that doesn't update content often, the search engines will visit less, but give more value to the pages the longer they stick around. Pages that are years old will rank better than new ones added. SO keep this in mind for your SEO and your site. Are you a publication that pushes out content frequently and needs to get rankings fast, or are you a site that holds true with valuable content that gets better with age?
  10. File size – A page that takes a long time to load, or is extraordinarily large can be quite detrimental to SEO. So be wary of how big that file is that you are creating.
  11. Content separation – As mentioned before breaking up your content throughout your page is more beneficial to SEO than blocking out whole paragraphs. If the site is a known publication, or the section is a blog or article section of a site then whole blocks of content is perfectly acceptable for SEO. But pages that go up and stick around a while with the purpose of providing marketing information, should have content broken up throughout for SEO.
  12. Poor coding and design – This one gets overlooked a lot. Sure, search engines can't determine good design from poor design, but your user's sure can. If a user comes to your site from Google and then immediately bounces, Google will mark the value of that page for SEO down. Therefore, affecting your rankings. So pay attention to design, look at your bounce rate data in Google Analytics, and improve it as much as possible.
  13. Duplicating Content = NO – DO NOT DUPLICATE CONTENT… Just as mentioned earlier, this is very bad for SEO. If one page has more than 80% duplicate content to any other page on the site, then it can harm your SEO. So be sure that the content on every page of the site has more than 80% unique content.
  14. Invisible text = NO – Invisible text is content a site has hidden from users but allows the search engines to see. A div that is only on pixel high with the attribute to hide overflow, or white text on white background (both allowing search engines to see it in the code) is a huge no no for SEO and can actually get your site penalized. So don't do it!
  15. Domains & URLs – Check you domain and URLs often. Look for your keywords, check to make sure the hierarchy is clear and set properly for SEO, and make sure that there are no funky issues like parameters, easily changed (by typing anything in), or redirects to some odd UR. Check your trailing backslash or file extenions as well to make sure it either 404s if wrong or resolves to the correct one.
  16. Keyword-rich URLs and filenames – Watch for those keywords in URLs and filenames. Long URLs that mention more than one keyword will cause issues, so always check and double check the URL for SEO before going live.
  17. Site Accessibility – In some cases having an accessible for those with disabilities. Whether it be sight, or even hard of hearing if you have video. It can actually help your SEO.
  18. Sitemap – creating an page that links to all of your pages can ensure that all of your pages are getting crawled for SEO. Many times I have seen website have pages that they don't link to and wonder why those pages aren't getting rankings. If search engines can't crawl the page, then they don't know to rank it for SEO. You can also create an .xml file for Google, Bing, and Yahoo! site submission. But do remember that an xml sitemap alone just won't cut it, you have to have links pointing to pages from multiple locations. Otherwise it just won't do any good for SEO.
  19. Website size - Keep an eye on the size of your website. Large corporate sites like Amazon.com and MSN.com are expected to have thousands if not millions of pages. If your site is a mall to medium size company and website, yet the search engines somehow crawl millions of pages, then you need to relook at your SEO. Check your paramaters, or other issues that might be causing more pages than your site should have.
  20. Website/Domain age – The older the website the better. A brand new site that is loaded with pages and pages of content all in one day will get added to a sandbox as us SEOs call it. It will sit there for a few months before the search engines even give it the time of day. The reason for this is that search engines want to make sure the site is legitimate and not just a spam site there to just get rankings. To keep your site from falling under this category, having an older domain is key. If you have a new domain, then roll out your pages slowly. Push a section one week, wait a few weeks and push out another section. Having a blog is also good for SEO as you can add posts with content encouraging search engines to keep coming back regularly and learn that this site has something interesting and unique. Of course, the more traffic you can get in those first few months the better, so get your social media and advertising up and going.
  21. File Location on Site – This falls under the URL hierarchy category. Watch out for where pages and files are located on the site. For SEO and for your uses, the structure and location should make sense.
  22. Domains versus subdomains, separate domains – Watch out for the use of sub-domains for your site. Too many websites will put their blog on a sub-domain and not in a directory. This won't hurt your SEO, but it won't help either. What happens is that the search engines count the subdomain as it's very own website, and doesn't link the content with the rest of the site. It is more beneficial for SEO to have all of your content no matter what it is, on your main domain in a directory. Keep it out of the sub-domain unless absolutely necessary.
  23. Top-level domains (TLDs) – A top level domain is the main domain for the site. Even in the case of a www.yoursite.com, the “www” is considered a sub-domain. Yes, a sub-domain… So try to use http://yoursite.com if you can. If the search engines already recognize your www.domain.com then leave it alone, and let Google know that you prefer to use your www. Vs. just the domain. You can do this in your Webmaster Tools.
  24. Hyphens in URLs – For SEO, it is recommended that you use “-“ in your URL rather than “_” or even just a space (which ends up rendering to %20). Search engines just happen to prefer the hyphen to underscore or space.
  25. URL length – For SEO purposes try to keep your URL under 2000 characters, but really the shorter the better. Pay attention not to have more than 3-4 parameters, or a URL that has a really long sentence.
  26. IP address – Your IP address should reside in the country your website is ranking in. US and English should have an IP located in the US. French and Canadian, should have an IP in Canada.
  27. robots.txt – Blocking irrelevant content in the robots.txt will really make a difference for your SEO. It has been recommended in the past to block external css and image directories, but now Google has said they would like to crawl them. Search engines are getting more and more sophisticated to where they can decipher all of the code and really get a good idea of what the whole website is about. Some only block pages and content you really don't want search engines to crawl.
  28. Redirects (301 and 302) – For SEO, redirecting an old URL to a new URL will usually pass the old URLs value to the new URL. But be careful to use 301 redirecting sparingly. I personally have witnessed and dealt with sites that had issues with too many 301 redirects causing rankings to drop.
  29. Social Actions – Social actions like Facebook ‘like's, tweets, shares, Google +1s, and so on will really add  lot of value for SEO. Anytime a user has to take action to show that they see the value in the page will show the search engines that the page is relevant and valuable. Therefore, increasing your rankings for SEO.
    • Google+– Yes, Google loves their social media site, and providing a way for users to +1 your page and site will drive up rankings in Google.
    • Facebook 'Like' or 'Recommend" – The action of ‘Liking' a page for Facebook will sometimes help with Google, but really helps with Bing more than anything. Microsoft anf Facebook have a very close relationship allowing for Bing to use social actions that happen in Facebook to help drive rankings for sites.
    • Facebook comments – If you can, try to pull comments that happen in Facebook related to your site and the page into the page itself. It not only allows for more and unique content, but shows Bing and other search engines that the content on the page is valuable to the user, therefore driving up your SEO.
    • Twitter "tweet" - A simple tweet with your page's URL will always be counted as a “vote” for your page and website. The more you can get, the better for SEO.
    • OGP - Open Graph Protocol – OGP was developed and adopted by Facebook as  way to manage how a page or website looks when shared in social channels. Twitter, and other social sites have followed suit, and my prediction is that Google will start to pay attention to OGP soon. So be sure to spend the time and make sure your basic OGP tags are set for all of your pages. It could really help your SEO.
  30. Links – External – Links pointing to your site are important. As mentioned early, tread very carefully with your link building. Make sure that the page(s) linking to your site and pages are relevant to your site. Do not use directory submission websites, don't buy links, and be weary of link exchange requests. Just as external links can benefit SEO, they can also harm if not done properly. Keep the following in mind for your SEO:
    • Quality of source of inbound links
    • Links from similar sites
    • Links from .edu and .gov sites
    • Age of inbound links
    • Links from directories
    • Links from Social Media
    • Links on pages that include social actions
  31. Schema – Google places a high emphasis on schema tags and information. In the past they have said that if you can get it in there, then great. Now they look at schema information to help drive rankings for SEO. Not to mention that you can manage what is displayed in your snippet from star reviews, author information, embedded video, etc.
Of course there are thousands, if not millions, of algorithms that search engines use to determine rankings, leaving the list I gave you here a small set of what really goes into optimizing a site. In all of my years optimizing websites, I try to write blog posts when I come across issues or get into deep level discussions with my peers on SEO topics. But again, there is so much involved, and sites are all different from one another. I have been teaching workshops since 2007, and have been through thousands of individuals trying to learn SEO and optimize their own sites, only to find that they still need the help of an expert.

What I suggest is that you learn the basics, as much as you can, and start optimizing your site yourself. If you have a site that is older and hasn't been touched in years, go through and see if there are sections and pages you can add with some unique content to add to what you already have. If your site is larger and the traffic just isn't where it should be, then look at what you can do to restructure it to reflect the categories and longtails terms you found in your keyword analysis.

If you want to see how your different categories of terms are performing, you can use this handy template I created along with instructions on how to grab the traffic you are seeing. For some clients, I have used the template to show the estimated traffic I see in the keyword analysis compared to the actual current traffic to show what is missing. I will use the top few terms in the keyword analysis to see how aggressive the category terms are going to need to be to get rankings during the competitive report for SEO. The categories with the most potential, the largest gaps, and the least aggressive with competition are the ones I recommend to tackle first. The competitive report will also help determine what all will need to get done to generate rankings. Is it just one page with a bunch of content and the word mentioned several times, or is it a whole directory with files and filenames that include a mired of terms for SEO that all link to one another?

For usedcars.com the location pages where we generated rankings for the terms “used cars in”… with city and state searches was fairly easy for SEO. The content has a few lines of text seeded with the city and state from the database (also known as templatized content). Content for the page also came from inventory (car listings) provided from the database, with a block from normal listings in that city and a block of deals in which there is a calculation done in the back end that looks at the price of the car and looks up that VIN and price against the Kelley Blue Book value and returns the percentage difference showing cars that are priced under value and are a good deal. Users love those listings. There is also a large map that shows dealerships in the usedcars.com system that are located in that area. The map is generated from Google and helps those pages get rankings for that location.

Those pages were pretty easy to get rankings (after a lot of the mess was cleaned up), and have help rankings providing close to 50% of the traffic from SEO for that site.

A more complex project for usedcars.com that required more pages, and the SEO to be more aggressive is what we called the Make/Model project. The goal was to get rankings in SEO for the brand of cars and the cars with years search trends. We found that users that search the “year make model” search know exactly what they are looking for and are more likely to purchase. So, ranking for all of those year, make and model combinations were highly valuable to the business. The problem is, that all the other car sites know the same strategy and have been very aggressive for their SEO.  A set of rules for syndicated and dynamic content was set in place along with a plan to roll out pages and content in phases. When I left in May of 2014 the project was still underway, but the pages were already seeing some traction. You can see how the pages were developed at http://www.usedcars.com/car/ - considering they are still intact and working on the pages as specified in the project.

I'm always happy to talk SEO with anyone anytime. You can find me on Skype (as SEOGoddess) or fill out the contact form on my site here with any questions. I'm usually pretty quick to respond, and can help you in any quick SEO issues or questions as you try to optimize on your own. I have even been known to look at a website when an agency is working on the SEO just to make the site owner or boss feel comfortable that their agency really knows what they are doing.

There are also many resources other than myself or this blog, and plenty of SEOs with a lot of great experience. Ian Lurie is one of my favorite people in the world, and has a very successful agency with a lot of great SEOs he has taken under his wing and turned into skilled professionals. His company Portent can also help with website design, social media, and paid search marketing. Give them a glance over and see if they fit your needs. Bruce Clay is also a very close friend and someone I go to regularly myself for help. He works with very large corporations on a large scale including AT&T, CNN.com, Edmunds, and more. He is what some of us in the SEO industry call the “Godfather of SEO” since he was one of the original SEOs that has set the standards for quality in optimizing.

I do have a larger list of SEOs I know and trust, so feel free to contact me and ask me for someone in your area, or who might specialize in a site that is much like yours.

Either way, SEO can be fun and you can really learn a lot quickly if you want. You can know enough to be dangerous, but if you stick with the general rule of “don't trick the search engines” you should, for the most part, be just fine.

In the end a site that has increased traffic from SEO is a site that I generating a lot of money, and that's just good for business.

Tuesday, July 23, 2013

Categorizing Keywords

For those of you SEO's that manage very large sites and map your keyword categories to sections of your website - you know how difficult it is to categorize your terms and track their performance. Well, I have to say that after searching, asking, and digging around for a tool that does exactly what I am talking about, I finally came up with a solution. It's a bit of a workaround in Excel - but it's the best I can do until someone comes up with a tool that categorizes keywords for SEO.

Know Your Keywords and Categories


Before you get started categorizing the terms that come to your site, you should know what keywords you are targeting, and the combinations of terms as well. I'm going to use a flower shop's website as an example for this particular blog post. Categorizing is something you can do with any website. At the very least, you can categorize terms into "Broad" and "Branded", to get you started.

Most keyword tools can help you establish what categories to target. Google's Keyword Tool or WordTracker are just a couple of the many tools available on the web.

Another way to figure out terms that fit in categories is by grabbing search data (referring terms in Google Analytics) on your site for the past few months or year. I personally spent some time going through and categorizing keywords in Excel by using the filters and then having the sheet show all words including "anniversary" for terms around "anniversary flowers". It takes a lot of work and time, but in the long run you will have a more accurate account of the terms you will need to do the Lookup against.

Setting Up Your Template

Download the Template

Now that you have all the terms possible in all of your categories it's time to start setting up your template. You are going to want to Download the template I have set up in Excel. You can start from a fresh Excel document if you want, but the template has directions (in case you lose this blog post somehow) and the Lookup formula is in there.

Once you have downloaded the template it's time to get it set up to work for your keywords.

In the following steps - I am going to walk you through setting up the template and then categorizing the terms. If you don't have terms that you can use already, I have a zip file you can download and walk through the example with me to get familiar with how this works.

Copy and paste your first set of categorized terms and paste them into the first Tab marked "Broad". Since every site usually has a "Broad" category of terms, I figure that's probably the best to get started with. In the case of this example "flower shop", "online flower shop", and "best flower shop" terms are the ones that fit under the Broad category.

If you have the .zip folder downloaded, open up the "Terms" Excel doc and you will see the words already categorized for you. There are "Broad", "Branded", "Birthday", "Anniversary", and "Wedding". Click the Drop Down next to "Category" and click "select all (to deselect all) and then click "Broad". You will see all of the terms sort by just that "Broad" category.

Next select all of the terms in the "Keyword" list - copy and paste them into the "Broad" Tab.
We will then need to sort the terms in alphabetical order so that the Lookup string can go through them in order. If you don't then the Lookup won't work.


Highlight the Column with your keywords
Click "data" > "sort"
Select "My data has headers"
Select under "sort by" the column you keywords are under (should be column A)
Click OK

Double click the Tab and rename it with the one word name of your category.
Highlight all of your keywords in the column (just the cells that have words, not any blank cells).
Type the name of the category (stick to one word naming) into the upper left field. You have now named your table.

Do this for "Branded" and the other categories as well. You are going to have to create a new tab in the template to fit all the categories.

If you have not downloaded the .zip file and are working off of your own terms, creating new tabs and naming them is probably going to be something you will need to do. But don't worry, the template will still work.

Now that you have all of your keywords in your Template's Tabs with names and sorted it's time to set up your Lookup string.

Setting up Your Lookup


The way the Lookup works in this case is we are going to ask Excel to look at one Keyword (one cell) and match it up to one of the terms in the Tabs we have set up. If it matches one of those terms then we tell Excel to place the word into that Cell. If it doesn't, then we just leave that cell blank.

The string looks like this:
=IF(ISNA(VLOOKUP(B2,Broad,Broad!A$2:Broad!A$999998,FALSE)),"","Broad")
  • B2 is the cell of the keyword we want to look for.
  • the first "Broad" is the Table name we want to look for that keyword in.
  • Broad!A$2:Broad!A$9999998 is the Tab and range that the Table exists in.
  • FALSE is telling the Lookup to do an exact match. TRUE would look through to see if letters from that Keyword exist in the Cells we are looking in, so in this case it won't work.
  • We leave the ,"", as a blank - but you can put "not categorized" or "misc" to show that it isn't in a category. Though for our purposes here, we keep it blank.
  • ,"Broad" is telling Excel to put the word "Broad" in the cell if the keyword matches one of those in the Broad Table or Tab.


See - it's that easy...

What you are going to do next is replace the word "Broad" or "Cat1" with the name of your table, Tab, and category. This is why we name the Table, the Tab, and the Category the same so that our life is much easier when setting this string up.

Now your template is ready for you to paste some keywords with data and grab some numbers.

Gathering Your Data


Open up your Google Analytics account - if you don't have Google Analytics, pretty much any tracking tool that has a list of referring terms with some sort of data is fine. You can expand and contract the columns to the right of the terms as you wish. The template you will download will have the columns set up just for the purpose of exporting referring terms with visits and such from Google Analytics though.

Log into your Google Analytics account.
Click "Traffic Sources" > "Sources" > "Search" > "Organic"
Select the date range you would like to report on.
Scroll to the bottom of the report and show 5,000 rows.
Scroll back to the top and click "Export" the select "CSV".
After the file has downloaded, open the excel file.
Highlight JUST the cells that include the keywords and your data (ignore the first few at the top with date and information, and the bottom that summarize the data and below).
Copy those cells, and paste into your "Master" Tab.

Note: If you have multiple dates you would like to track, you can export the different date ranges, and then add which keywords go with what date in the Master Tab. This will allow you to see trends of categories.

I added an Excel doc called "Analytics Organic Search Traffic" with some terms and fake data that you can play with. There are three tabs that I added dates for each day's data. Start with just the one day and play with that to get familiar with percentages. From there you can play with all three dates and work on your trends to see what categories are trending up and down.

Completing Your Lookup


Now that you have copied and pasted the keywords into the "Master" Tab it's time to get all of those terms categorized.

Select the top row with your categories and your "All Categories" cell
Copy just those cells in the top row
Highlight the next row (same cells just below) hold down the "shift" key
Scroll down to the last keyword record
Holding down the shift key select the last cell under the "All categories" - this highlights all of those cells for those categories to Lookup the keywords.
Hit "CTRL+V" on your keyboard (this quickly pastes the Lookup formulas for each line)
Be patient, as it may take a while for your Lookup to complete (depending on how many keywords, and records you have)
The "Master" Tab should look something like this:

Playing With Your Data

The most efficient way to gather information from your data is to copy the entire "Master" Tab and paste as values into a new Excel sheet.  This way you won't have to wait for the Lookup to complete each time you sort, pivot, etc.

Click the top left "Arrow" in the "Master" Tab
Right Click and select "Copy"
Open a new Excel Doc
Right Click and select

From here you can create pivot tables then sort them into pie charts, graphs, and all sorts of fun reports to see how your keywords are performing.

I personally like to start with a quick pie chat to see what category of terms brings int he most traffic. At times we will have a drop or rise in traffic, and it's good to understand which category of terms are fluctuating. By copying and pasting terms by dates (weeks, months, or even a set of a few days) will help me see which categories are fluctuating on a timeline trend. Knowing which categories bring int he most traffic, I can then make decisions on which parts of the website we need to focus our efforts on to increase traffic.

See how much fun categorizing your terms can be?
Now that I have a template I work off of, when traffic goes up I can quickly categorize the terms and let our executives know if our recent efforts have worked.

Friday, January 18, 2013

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

The following story is one that has been several months in the making. It's one that I have lived through one too many times as an SEO, and it is one that I am sure other SEO's have faced. I fought with the thought of writing this for fear that someone from the company might read it and get angry that the story is told. But, it's something I think that not only people out there could learn from, but speaks to so many others in this industry to show them that they are not alone.

It's long, it's a bit technical (I tried to keep it simple), and it has some personal frustrations laid out in words. My only hope is that you get value out of reading this as much as living it has made me a better person (or well, a better SEO).

It Begins


I started working on this website's SEO in May 2012 at which time I was told the site's traffic was declining due to Panda updates. In February of 2012 the traffic from SEO was the best they had ever seen, but soon after that there was a steady decline.
Traffic from February 2012 - May 2012
Before digging into any possible SEO issues, I first checked the Google Trends to ensure that the decline isn't searcher related. Often times a drop in traffic could just mean that users aren't searching for the terms the website is ranking for as they were in the past.

Top Key Terms in Google Trends
Looking at the same time frame as the traffic data, I noticed an increase in searches for the top 3 terms the website ranked for, and there appeared to be a decline around the same time from March to April that the traffic was reflecting. But there was a drop in the website's traffic in April from the 23rd to the 24th and then significantly on the 25th. The website I was working on had two SEO's already working on it: an agency and a consultant. Both had already done a numerous amount of research and some work to get the website on track. Both were stressing that the drop in traffic was due to the Panda updates by Google. I looked at SEOmoz's Google Algorithm Change History and found an update to Google's Panda on April 19th and an update to Penguin on April 24th. Given that the traffic significantly dropped on the 24th my best guess is that it was possibly Penguin related, but still needed further exploration.

Figuring Out What Was Hit by Penguin.


The site is/was broken up into sections by keyword focus. At one point, I could tell that someone really had a good head on their shoulders for SEO, but the strategy that was used was outdated. Perhaps the site was originally optimized several years before, and it just needs some cleanup now to bring it up to 2012's optimization standards. So, understanding Penguin and identifying which part of the site was driving the bulk of the organic traffic was going to be my next step in solving this mystery. Once I understood why, and where, then I could start to establish a what to do to solve the problem.

I broke the site traffic report by sections as best I could in Google Analytics. There was a bit of a struggle as all of the pages of the site resided on the main domain. Without a hierarchy in place, breaking out the sections had to be accomplished with a custom report and a head matching for landing pages. I hadn't had to do this before, so the agency that was working with the site already helped build the first report, and I began building out the other reports from there.
Click to View Larger
Section 1 over 72% of traffic

Just focusing on April and May I created a Dashboard in Google Analytics focusing on organic Traffic and identifying the sections of the site. Looking at the different sections - Section 1 was the bulk of the traffic with over 72% and Section 2 coming in second with just over 15%. Subs of Section 3 and other one-off pages make up the difference.

Both Section 1 and Section 2 dropped off after the April 24th date, so clearly they were the bulk of what was pulling the overall traffic numbers down. Since Section 1 was the majority of the traffic, I presented to the executive responsible for the site that we address any issues with that page first.

Actual screenshot of Section 1 presented
I took all of the research from the agency and consultant and we quickly reworked the pages to represent a hierarchy in the URL structure, and cleaned up any issues from the outdated optimization that was done.

Soon after Section 1 was addressed, we did the same with Section 2, and then worked on Section 3 (and sub pages, rolling them up into a solid section) and then added a few pages to grab any new opportunity.

Not Quite As  Easy as it Looks


The projects were launched in increments - first URL hierarchy fix to Section 1 and then the page redesign. Next was a full launch of URL fixes and page redesign to Section 2, and then lastly Section 3 and the new Section 4.
Section 1 - Section 2- Section 3 Launch Dates and Organic Traffic
Soon after Section 1 was launched traffic started declining rapidly. I was asked several times why traffic was getting worse, and I started digging some more. Every time I looked at the Impressions of the new URLs from Section 1 they weren't getting any traction, but the previous URLs were still.  I began looking at the history of the website, trying to find out why it was doing so well at one point, but was not doing well at that time. One of the things I noticed was that there was a lack of priority linking to these pages, but at some point there were links to some of them individually from the homepage. Google matches a hierarchy of pages to a directory structure that links are presented on a site. This site had every page on the first level, and linking to those pages from the homepage, which was telling Google that every page was the most important page. It worked at one time, but as Google has been rolling out their 2012 updates these pages were getting hit, and those links on the homepage weren't there anymore. Before the launch of Section 2, I had them put links to the main directory for each section on the homepage. The links would tell the search engines that these are important pages of the website, but not be so obnoxious with a dozen or more links on the homepage to discourage users (avoiding the appearance of spamminess).

But - even after adding the links to the homepage, the traffic to those pages was still declining. Pressure was put on me to figure out what was wrong. In addition, accusations were flying that I single-handedly ruined the SEO for the site, I spent every waking hour looking at reports, and trying to figure out what was going on. I consulted friends in the industry, and read every article I could find to figure out what Panda or Penguin updates were affecting these pages.

Then it hit me - just as the links to these sections would help them get recognized as important pages, so were the other pages that were being linked to from the homepage. In fact a set of them linked to the website's search results with queries attached to them mimicking pages, but showing search results. On those search results pages, there were over 200 links with multiple (we're talking hundreds - possibly thousands) combinations of parameters. The bots were coming to the homepage, going to the links to the search results pages, and then getting stuck in this vortex of links and combinations of parameter generating URLs - not allowing any crawl time for the pages that once were getting rankings. This also explains why the new URLs weren't showing very many impressions in the Webmaster Tools Data - those pages just weren't getting crawled.

There was a project underway that would solve the many links on the search pages, and there was also talk of using ajax to show the results. When this project would launch, the bots would go to the URL from the homepage, but would then essential not go much further. With this project a few months out, I made the case to add the search page to robots.txt to allow the bots to then recognize the Sections as important pages. After several weeks of attempting to convince the powers that be, the URL was eventually added to the robots.txt file.

Immediately after the search page was added to the robots.txt Google Webmaster tools presented me with a warning:
Warning in Webmaster Tools
In most cases, a warning from Google should never be taken lightly, but in this case it was exactly what I wanted. In fact it proved to me that my theory was correct, and that the site was hopefully headed down the right path.


Panic, Questioning, and a Third Party


As with every up in the SEO world, there must be a down. Soon after the search result page was added to the robots.txt the organic traffic to the site dropped, and continued to drop. Throughout those grueling three months there were several Google Panda and Penguin updates. I documented each and every one of them in Google Analytics, and continued to answer questions, gathering data, and dealing with being under close scrutiny that the work I was doing was complete BS.
Organic Traffic from September 2012 - November 2012
I sat in numerous meetings, some of which I walked out crying (I'm not afraid to admit it), being questioned about the road I had taken and why we weren't seeing results. There were people within the company recommending that they roll the pages back to where they were before, and even changing the URLs. I fought hard that they don't touch a thing. I sent an article posted on Search Engine Land by Barry Schwartz citing Google's patent that "tricks" search spammers.

The patent states:

When a spammer tries to positively influence a document’s rank through rank-modifying spamming, the spammer may be perplexed by the rank assigned by a rank transition function consistent with the principles of the invention, such as the ones described above. For example, the initial response to the spammer’s changes may cause the document’s rank to be negatively influenced rather than positively influenced. Unexpected results are bound to elicit a response from a spammer, particularly if their client is upset with the results. In response to negative results, the spammer may remove the changes and, thereby render the long-term impact on the document’s rank zero. Alternatively or additionally, it may take an unknown (possibly variable) amount of time to see positive (or expected) results in response to the spammer’s changes. In response to delayed results, the spammer may perform additional changes in an attempt to positively (or more positively) influence the document’s rank. In either event, these further spammer-initiated changes may assist in identifying signs of rank-modifying spamming.
 But the article and my please fell on deaf ears...

It had gotten so heated and there was fear that nothing was being done while traffic was significantly declining that the company brought in yet another SEO consultant to look at the site objectively.

Just as the consultant was starting his audit, and the traffic hit the lowest I ever thought it could possibly go, the next day traffic went up. The last week in November (roughly 3 months after we blocked the search result page) I saw an increase in traffic in Google Analytics to Section 1:
Section 1 Organic Traffic
I quickly pulled up my report to check the Section's impressions from the Webmaster Tools data, and there was a significant increase as well:
Section 1 Impressions from Webmaster Tools Data
On December 3, 2012 I logged into Webmaster Tools and saw that the warning had gone away:
It was the "halleluiah" moment that every SEO dreams of, and very few get. All the work I had done, the fighting for what I believed in, it all finally paid off.

To this day traffic continues to increase - we can now focus on some of the cleanup still left to do, and then onto projects that will attract new opportunity.
Organic Traffic from November 2012 - January 17, 2013 (day before this post is written)
Quick Note: 
I forgot to mention a post I wrote months ago while going through all of this - SEO - Panda and the Penguins. It helps to give a bit of perspective of some of the linking stuff I didn't get into in this post.