Enterprise SEO - Four Pillars to Making In-House SEO a Success

I began my career as an in-house SEO in 2006 and while I have worked in a few roles as Director of all of Digital Marketing for startups and for an agency. However, I prefer working as an Enterprise SEO in-house. While there are many pros and cons to working for agencies (which I covered in 2009 SEO Career - Agency vs. In-House SEO) I have really found my place and have had great successes in-house for enterprise organizations. One major factor in this decision is that I have just one client and (usually) one website to focus all of my energy and efforts on. In the case at Nordstrom, in which I was the SEO Manager, I had an entire team helping me manage many aspects of the site. As the site gets larger, more complex, more people and other teams to work with and more revenue generating it becomes imperative that there are more people involved with SEO that specialize in key aspects that make the channel successful for the business. The main reason is that there are four major pillars to making SEO a success in an enterprise organization. Those four pillars include:

1. SEO Mitigation - error management and/or technical SEO
2. SEO Analysis/Reporting - calculating assumptions and reporting on successes
3. SEO Project Management - determining growth and managing projects for SEO
4. Relationship Building for SEO - Championing SEO to stakeholders and other teams

Some larger enterprise organizations will have robust teams that support the big four, with addition of SEOs that have expertise in various fields (for example an SEO that is focused on local in the U.S. or perhaps outside the U.S. for a specific country, LATAM, EMEA, etc). Some medium sized corporations or startups will often just have one SEO Manager that acts as an individual contributor that will cover all four of the key aspects on their own until the organization supports bringing on more people to take on one or a few parts (that was me in my early years). Whatever the structure for the SEO or the SEO Team in a startup, medium sized company or enterprise organization the success of SEO within that company relies on managing all four aspects successfully.

I'll dive into each one a bit more to help explain how each plays a role in making an enterprise SEO successful.

SEO Mitigation - error management and/or technical SEO

Engineers will overlook what's best for SEO.
It's up to the SEO to mitigate any issues that might arise.

No matter how supportive companies are of SEO within the organization, there are always going to be issues that come up that will negatively affect SEO. Whether it be a video project that one team launches in which the videos are in an iframe with no JSON or Schema to support them or a set of pages that generate filter URLs causing duplicate content.. The issues not only need to be identified quickly before causing any possible damage or inadvertent spamming, but they need a solution that is fully acceptable (white hat) and prioritized with assumptions associated in order to mitigate the situation.

In my experience, Since SEO equals revenue for the business, I have found it best, in an enterprise situation, to get the teams responsible for key components of the website that effect SEO to become the bestest of friends to the SEO involved. In most cases the individuals responsible for these parts of the site value SEO and understand that if they play by the rules set by Google that they will be successful in their roles. The struggle they face, though, is that they just don't know what all of the rules are; and they shouldn't be expected to. While an SEO might not know what color a button should be and where in order to drive conversions; or what merchandise should appear on what pages linked to from top navigation that an expert hired does, those experts shouldn't be expected to understand SEO at the level that a highly technical SEO does. Therefore, those teams may have a difficult time understanding the impact some of their decisions can make both negatively and positively for SEO, and look to the SEO to help them understand.

The SEO tasked with technical SEO should insert themselves into meetings, gaining trust, and being viewed as an authority in SEO to help mitigate any potential issues within the enterprise SEO landscape. In addition, staying on top of the landscape of the site and how it pertains to SEO is key. Tools like Moz (for medium sized companies), Botify, Deepcrawl, Conductor and Brightedge  allows the SEO to really dig into the site to identify any issues. For smaller sites that don't have the large budgets for enterprise SEO simply using Google's Search Console is a great way to see into how Google is viewing the site. SEOs can manage parameters, identify server code errors (,404, soft 404, and 500), understand page indexing, incoming and internal links, schema markup and many important factors that Google takes into consideration.

Let's say an SEO identified a set of pages that are extremely valuable to the business in which they generate traffic from SEO but the average position is low as a result of issues with duplicate or very similar content, and even thin content (falling under Google's Penguin updates). Ecommerce websites are the biggest culprit of developing hundreds of thousands (or even millions) of URLs that are all similar to one another. Because of the way users browse of search for products in different ways, most product teams want to develop multiple touch points in which the user can access products. Let's use a simple heel shoe for example. A user that is searching for a specific shoe like a dress shoe with a thick block heel might search "block heel pumps" but they also might search "chunky heel pumps" or "block platform heels". Unfortunately you end up with search results that look like this:

All of these pages are from the same website that all have the same (or very similar) content on them because block heels, chunky heels and block heels for women are all essentially the same.

Most enterprise companies will have a dedicated SEO focusing on the technical side of the SEO, but smaller companies that don't have the budget for large teams will most often hire just one SEO in which that person should be spending a good amount of time monitoring and mitigating any issues that might come up.

SEO Analysis/Reporting - calculating assumptions and reporting on successes

Identifying growth for SEO and reporting on successes
 are key to gaining buy in from stakeholders.

Proper SEO should never be focused just on identifying issues and fixing them. A really good SEO and SEO Team will be more proactive than just reactive. In order to grow traffic and revenue from SEO a company needs to constantly innovate and add to it to grab new opportunities.

Keyword analysis plays a major role in identifying opportunity for SEO. Using a tool like Conductor or Brightedge allows you to plug in a few terms that are driving traffic to the site and suggest additional terms that the site may not show up for that are similar. By bucketing those terms you can develop a strategy around a set of high volume and additional long tail terms with a strong user intent to purchase that will grab searches you might not necessarily show up for. With these reports come average search volume that will give you an estimated number of how many times those terms are used in a search. By using these numbers, an SEO can calculate an estimated percentage of ranking that they believe the site could obtain the first month (and subsequent months as Google indexes and places the pages of site for these terms). This number with a break down from an estimated click through rate and conversion rate with average purchase number will allow the SEO to show what the value would be if a project for those terms were to be completed. A great example of this is a keyword analysis I had completed around search for car makes, models and the long tail high intent to purchase year make model (ex: 2012 honda accord). During my research I had identified additional terms around reviews, for sale, used, and more that all would provide value to the user, but the website wasn't generating much traffic from SEO for. Using this analysis in conjunction with a report on what traffic and revenue the site was generating for these terms I put together a presentation for the company's VPs and CEO. The numbers generated from this report were also used to report against after the launch of the project.

In addition to a Keyword analysis a good enterprise SEO will know how to draft up assumptions of revenue increase when any work around SEO is done. Even the fixes that are talked about above that mitigate SEO for issues. Using the duplicate and similar content mentioned before, knowing how to fix this isn't enough. SEOs know just by looking at the situation that the issue is a problem and by making the corrections there will be an increase in traffic. However, expressing what the increase in traffic will be when the issue is resolved is what is required by an enterprise SEO. By understanding how much the click through rate will improve with an average position increase the SEO can then calculate the current click through rate adding the percentage increase if the average position of those pages saw an improvement. From there the SEO would take the average conversion rate with average order value to show the estimated revenue increase if the correction were to be made.

The SEO isn't finished with estimations and assumptions. Most enterprise SEOs are asked "what happened with that project we did?" or "How did that fix we did impact the business?". Using tools like Google Analytics in conjunction with Conductor the SEO can then report against the assumptions originally set. Conductor even has a great tool in Searchlight for Business Cases in which you plug in your estimates and it will track performance for you. For smaller sites setting up custom reports in Google Analytics works, and monitoring average position for a set of keywords that include a common word (or a few) as well as pages in Google Search Console will work.

SEO Project Management - determining growth and managing projects for SEO

SEO isn't just about being reactive.
It's about being proactive with projects that capture new opportunities.

Using the keyword analysis an SEO will often complete a full evaluation of a set of terms that could potentially constitute a project. In my role at Classmates in 2006 I had developed two major projects around developing pages for schools (we called "affiliations") and a set of pages around people's names. The idea behind the two was to have a page show up in the search results when a user would search for their school or an old friend. We even set the pages up so that they would also show for users that would be trying to find an old friend from school in a specific city.

Knowing that we wanted to target those search terms wasn't enough for SEO. I was tasked with writing up a project brief that would detail out exactly everything that was needed in order to get any sort of results. With SEO, content is key so I had added requirements around content that was valuable to the user. Working with other teams we brainstormed what users might find valuable that the business would allow us to expose outside of being logged in. I even had our legal team in the room to weigh in on what was legally allowed to expose to the public. Unfortunately, there wasn't much we could use that was provided by users so we identified data driven content (ex: people with similar names from different schools, nearby schools, rival schools, etc)  that would provide value and would be unique to each page. Requirements around friendly URLs with a hierarchy (directory to file structure), breadcrumbs, etc all were added to the project brief. I was assigned a Project Manager who I worked closely with to ensure the project was moving along and all things SEO were being addressed.

At every enterprise company I have worked with in SEO I have developed major projects. From the names and schools at Classmates to location pages at usedcars.com and Nordstrom, and even the make model and year make model project from the keyword analysis example I mentioned earlier. Each and every one of the initiatives was set up with a Project Brief and managed through a Project Manager for SEO and overseen by myself.

Relationship Building for SEO - Championing SEO to stakeholders and other teams

Nothing will ever get done for SEO
if there isn't buy-in from other teams.

One of my favorite lines to say is "90% of an in-house SEO's success stems from relationships." I covered this a bit in my post in 2007 "In-House SEO Isn't Just Optimizing" in which I state:

But what I am most thankful for is the ability to communicate and work with other individuals within the company. While my main responsibilities may be to not only increase traffic to the website through natural search marketing, my success stems from the success of others.

I wrote that post during my time at Concur in which I was on a team that was extremely collaborative. We all seemed to help each other out with our roles even though we had specific responsibilities. There were a few people on the team that knew SEO and that I could bounce ideas off of. We would work together to come up with a plan. The team included the engineering team, designers, copy writers, and paid media channels. I specifically remember a project in which the directive came from above to create a community website around travel stories for our users. Using Eloqua as an email marketing tool we all sat in a room and developed a plan around user sign up with email touch rules that encouraged engagement. I was representing SEO, but was asked to provide ideas in all aspects, even the emails (which had nearly no value to SEO, though I snuck in some ideas around link sharing encouragement).

While I wrote my post while at Concur, my realization of how much the success in my role was reliant on others was years before while working at Classmates. I found myself in heated discussions with the head of engineering and often pushing the analytics team out of their comfort zone that wasn't getting me very far. I soon took the approach of  inviting key stake holders to lunch and even set up weekly happy hours every Thursday that the CEO would attend to help build relationships I needed to gain buy-in for SEO. I soon became everyone's closest friend and was able to work through issues identified without arguing. As a result, over 10 years later I am still very close friends with quite a few people I worked with and had the head of engineering speak at one of my conferences a few years back.

During my time at Nordstrom I set up the goals of the team around strengthening relationships with other teams and being viewed as one voice of authority around SEO. I encouraged each team member to communicate often and stressed the importance of grabbing a cup of coffee or inviting people on other teams to lunch from time to time. I even found by going to lunch with a few of the stakeholders they worked in conjunction with me to prioritize projects where the team had gotten empty promises or push back in the past. Had I not have built those relationships and gotten to know the people I would not have the friends I have now, nor the support that SEO needed during my time there.

I'm not quite sure how most enterprise SEOs structure their work, if they focus on the four key aspects that I mentioned or if they have other structures they have established that work for them. I do know that after nearly 20 years working in SEO that the success that comes from SEO stems from these four key parts. For without one or another SEO would be simply just rolling along relying on the brand that a company has established as authority. But to show actual growth in enterprise SEO outside of the usual industry trends and relying on social media or PR to do it, a successful SEO will have a keen ability to mitigate SEO issues,  analyse and report on SEO, develop and manage projects for growth and have strong relationships with others within the organization.

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-10^th 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 3^rd.

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+1 – 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.

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 out the struggles I had faced with recovering a website that had been hit hard by Penguin and Panda updates. I had first identified which section of the site that was hit the most, and presented my findings to the head of the corporation's division. 

In the months that followed, there were projects quickly rolled out that were designed to fix the site, and to recover the traffic that was lost. After months of the site losing traffic and still getting penalized there was a light at the end of the tunnel in recovered traffic just before I wrote and published the blog post.

I am sure a lot of you who have read the article are wondering where the site is today. Sure, a quick hockey stick of recovered traffic is great, but did that traffic hold throughout the year? 

I am happy to report that traffic has held:

Traffic continued to grow throughout January 2013 (just after the jump in traffic in November 2012) and through February. The industry the site is in sees an overall rise in traffic and consumer interest to purchase from the last week of December through February with a downtrend through the rest of the year every year. While we saw the site follow this trend, in July we saw a boost in traffic. After careful research, it was determined that a Google Panda update confirmed on July 24th was the boost we needed. Ironically, what had taken the site down in the past was now helping the site improve as we continued to clean up issues remaining causing the hits from Panda and Penguin.

Most important issues identified:

1. Too many on-page links
2. Top level pages
3. No site hierarchy
4. An extremely high number of URLs
5. Duplicate content
6. Not enough unique content

In general - the site was not following the core of the Webmaster Tools Guidelines which is the Bible of SEO. If a site isn't following the core of what Google says, then there is virtually no hope for it.

As 2012 was focused on recovering from Panda and Penguin hits, 2013 was focused on cleaning up the remaining issues from parameters, thin content, duplicate content, finalizing the last pages to the hierarchy, and so on. I am happy to report that the site is now 96% complete of all issues, and the first of many projects are underway that are designed to grab new opportunity for the site. Traffic has seen increases in August, October, and another boost in December with continued growth as we are in the peak of our season again.

Courage is Grace Under Pressure

It was what was stated in the image I had added to my post along with the description of the pressures I had faced in 2012.

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.

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.

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. 

It was a lot to bear, and lot to live through. Sadly, what I had experienced in the organization was not unlike the experience many SEOs face. We are constantly questioned and second guessed. Many coworkers and bosses will even take it upon themselves to learn as much as they can, only to find that there is a lot of arguing among the experts in the industry as to what is the "right" way to optimize, and what is "wrong". But for SEO there is no right or wrong way, only what works. My philosophy behind optimizing is to always follow the rules. Start with the guidelines, organize the website, provide information for the user and present it in a way that makes sense. No shortcuts, trickery, or "optimizing". It is a philosophy I fight for every day (and boy do I fight).

Today I am happy to say the tune towards myself and the SEO work that is getting done has completely changed. My Boss now gives me rave reviews, the company has belief in the work done for SEO, and the team (product and engineering) is extremely supportive with any issue or requests needed for SEO. We are a cohesive and supportive team, and the results from the work we are doing is paying off.

Many people in the industry have told me to look for work elsewhere. That not only included people in the industry and some of my supportive coworkers, but the person my Boss reports to had even recommended it. I will admit I had interviewed at a couple of places. What discouraged me was that I knew the work that had been done up until that point would eventually pay off. If I had left then credit would have been given to the next SEO hired, or worse, it would be ruined by someone focusing on getting instant results. Most importantly, leaving the team that is now supportive was just not what I wanted. I love working for this company (the benefits are good), and everyone that I work with is like family. I call us the "Scranton branch of Dunder Mifflin." since we are a small office within a very large organization. We are a close family that support one another and they all seem to welcome my quirkiness.

Until Next Year

So until next year, I will be continuing my job and the work for SEO. I have big plans for the website, and will continue to fight for what I believe in for SEO. I will also try to get more informational posts on here as we continue our last bit of cleanup on the site and continue to see results. I am even contemplating writing a book (as I have been told I should for a few years now), but am still reluctant with all those great SEO books already on the shelves - most of which have been written by some very dear friends. Until then - keep optimizing, and fighting for what you believe in SEOs.

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.

Why the Google Changes? Ooh Ooh - I get it!

 Stripping out "+" in searches and not providing keyword referrals in analytics
Last week I posted about Google's announcement to stop reporting on referring key terms in Analytics, and I have been keeping up to date as much as I can with all the news around it since then.

2 Days ago Barry Schwartz posted an article to SEL about the changes in how we search on Google. Google has removed the ability to use the "+" in our advanced search.

Google themselves said:
"We're streamlining the ways you can tell Google to search for the exact keywords you type, whether it's an exact phrase or a single word, by focusing on the functionality of the quotation marks operator. So, if in the past you would have searched for [magazine +latina], you should now search for [magazine "latina"] to get the same results."

So it hit me this morning...

Since the launch of Google+ several months ago, as an SEO, I have at times found it difficult to search for "Google+" or even the "+1 button". I am sure that since the launch, Google themselves are having trouble seeing referring key terms. In the past the referring URL would have "+" in between the terms. So if someone searched "Google+" then the referring URL would strip out the "+" and those monitoring the referring terms for Google+ would just see "Google" as the referring term. So their question would be: Did people search "Google" or "Google+"?

With Google+ itself being under a microscope after the dying "Google Wave" and "Google Buzz" I can see someone saying to the powers that be that this needed to get fixed. Otherwise they couldn't accurately decide if Google+ is going to succeed.

The next step in this process is to strip the referring URLs of their "+" in between key terms. This unfortunately directly affects analytics as companies won't be able to accurately see referring search terms anymore.

So now Google just needs to fix the tracking of referring terms somehow. Google doesn't want to miss out on that data any more than we do. So be patient, it will come back again...

Google Secure Search and what it means for SEO's

I was editing videos from Search and Social Hawaii diligently and getting ready for my talk on SEO this Thursday when I saw a post update from the Google Analytics Blog addressing the announcement that Google is going to make search more secure. So I came out of my hole for a moment to draft up a quick blog post to clear up any questions.

Google says:

"As search becomes an increasingly customized experience, we recognize the growing importance of protecting the personalized search results we deliver. As a result, we’re enhancing our default search experience for signed-in users. Over the next few weeks, many of you will find yourselves redirected to https://www.google.com (note the extra “s”) when you’re signed in to your Google Account. This change encrypts your search queries and Google’s results page. This is especially important when you’re using an unsecured Internet connection, such as a WiFi hotspot in an Internet cafe. You can also navigate tohttps://www.google.com directly if you’re signed out or if you don’t have a Google Account."


What does this mean for SEO's?

Rankings:
It doesn't directly effect rankings as a whole, but it does effect the individual user's results as they will see a more personalized list of websites in their search results. In all honesty, that doesn't change anymore than what us SEO's have been working towards for several years now since Google setup Gmail and a login feature for their products and searches. It just means that instead of a few users seeing personalized results, more users will start to see personalized results. So dont' focus on whether or not your target audience is going to be logged in and what they might see in their personalized results, assume that all of them are.

Analytics:
Now here's where it gets tricky. The Google Analytics team is working very closely with the rest of the company to ensure that data is being passed showing the referring URL and Terms from paid and natural search results.

"How will this change impact Google Analytics users?
When a signed in user visits your site from an organic Google search, all web analytics services, including Google Analytics, will continue to recognize the visit as Google “organic” search, but will no longer report the query terms that the user searched on to reach your site. Keep in mind that the change will affect only a minority of your traffic. You will continue to see aggregate query data with no change, including visits from users who aren’t signed in and visits from Google "cpc"."

What is Google Analytics doing about it?
We are still measuring all SEO traffic. You will still be able to see your conversion rates, segmentations, and more.

Which is great for those of you that have Google Analytics installed on their websites, but what about Omniture or Webtrends?
In 2005 when I was working with Omniture to start showing referring key terms for SEO and streamlining our PPC within the system they were able to crack the code and get us the robust tracking we see today. While I don't see a blog post on either Omniture, or Webtrands blogs (I'll add the links in a comment as soon as I see something) I can assure you that Google doesn't want to hide anything from us SEO's and Marketers. They want us to be able to see the referring traffic and asses what is working, and what isn't. If we don't see it, we can't create a better user experience, and that would go against all of Google's ideals.

For those of you that rely solely on Omniture (or have clients that do) take a moment and reconsider adding the Google Analytic tracking onto the website (or talk to your clients about it) for the time being.

So never fear, rankings will still go on as usual, and the ability to track in Google Analytics won't be effected in any way...

Carry on...