SEOmoz Daily SEO Blog

Building a Technical SEO Process

Stephanie Chang — 2012-02-06T22:01:20+01:00

One of the biggest challenges many of my clients face is building the right SEO processes in place, so that any problems are quickly accounted for before they lead to bigger issues. Below are three things you should consider when trying to create a more streamlined process for making sure the technical foundation of the site is solid. Though none are considered "quick" or necessarily easy wins and can initially take a significant amount of time, ultimately in the long-run, they will help make monitoring the SEO on your site more efficient. This means less time spent identifying and fixing site issues and more time focusing on other aspects of SEO, like linkbuilding, developing a content strategy, etc... Overtime, the impact this will have on your site can result in high rewards.

1) Technical Annotations in Google Analytics

Currently, many of my clients with Google Analytics accounts either don't include any annotations in Google Analytics, annotate only their email, PPC, social campaigns or use it to keep track of search engine algorithm changes (like Panda updates). However, the value of annotating any technical changes made to the site in Google Analytics creates a more efficient internal process.

Scenario 1: Let's say that you have set up Google Alerts to alert you of any spikes and drops in traffic. Then, having technical changes annotated in Google Analytics makes it quicker and easier for you to specifically determine the cause of this spike or drop, instead of investing hours later on trying to determine the cause of these changes in traffic. In addition, any major technical issue runs the risk of being implemented improperly (in terms of SEO considerations), simply because there are so many issues to take into account.

Here is more information on how to setup a Google Alert.

Scenario 2: Often times SEO is not a technical priority for the development team, mostly because it is difficult to measure the ROI of what is often times, a significant amount of invested time and effort. Creating annotations in Google Analytics could help with this process- for example, if a spike in traffic were to occur and the team was somehow able to attribute this to a technical implementation on the site, the technical team could be properly recognized as being the cause of this change.

2) Sitemaps- Google/Bing Webmaster Tools

SEOs should create an internal process where Google Webmaster Tools is checked at least once a month to ensure there are no major issues with the sitemaps or with bots crawling the site. Sitemaps are only useful if they are kept up to date and well-maintained.

Why is this important? Duane Forrester of Bing has stated that "Your Sitemap must be clean. We have a 1% allowance for dirt in a sitemap." His definition of dirt includes 404 or 500 status code errors and redirects. He continues by saying "If we see more than a 1% level of dirt, we begin losing trust in the Sitemap."

Best practices include submitting a new Sitemap regularly, depending on how often new content is generated on the site. A publishing site might need to update every few hours, an e-commerce site every week, and a relatively static site every month.

Sitemaps should be checked at least on a monthly basis in Webmaster Tools to ensure there are no issues with the Sitemap.

These include:

Checking for error messages
Checking number of pages submitted versus indexed
Checking for malware (and address these immediately!)
Checking for crawl errors (like 4xx and 5xx issues)

Using Screaming Frog

If you do have a Screaming Frog account, you can also use it to verify Google Webmaster Tools errors, especially because Google Webmaster Tools do not always update their errors. Thus, you don't want to be looking for 404s that have already been fixed. You can also use it to check your sitemap for errors. To do so, simply upload the XML sitemap into Screaming Frog and crawl it. Craig Bradford of Distliled work a fantastic blog post on how to use Screaming Frog to accomplish these tasks and more.

If Google Webmaster Tools is not periodically checked, the number of errors can seem overwhelming. Joe Robison wrote a fantastic SEOmoz post on fixing an overwhelming number of errors in Google Webmaster Tools.

3) Creating Automated Scripts

404 Pages Returning Status 200 Codes:

Barry Schwartz wrote a blog post on how 404 pages should not return status 200 codes. The reasoning being that it could be confusing to spiders as they see a page that exists technically have no content. This can affect rankings over time because it is creates massive duplicate content as bots are crawling through the same content over and over again across several URLs.

He also suggests creating automated scripts to check for this type of issue.

However, to initially help you determine the extent of this problem on your site and provide an estimation of the number of 404 pages that return status 200 codes, plug a site search query into Google. See example below:

site:example.com/ "page not found"

If the query returns results, you know your site is returning status 200 codes for 404 pages and that this issue needs to be fixed.

SEO Score Card:

I've talked about creating an SEO score card before. I've also recently recommended another version of this to another client who had hundreds of thousands of URLs. In this specific instance, they had difficulty making sure that only high-quality, non-duplicate content would be indexed. Being an e-commerce client, the site also had tons of products that were very similar (resulting in identical product descriptions and content on the site).

I suggested creating an internal score sheet that would automatically be re-run every month to make sure that all currently indexed pages are still considered high-quality, while also offer an opportunity for pages that were once deemed low-quality to reviewed regularly. Once those low-quality pages became high-quality, they will become automatically indexed.

This process could be used to generate the sitemaps - but the goal is to future-proof the site against future search engine algorithmic changes while improving the overall domain authority of the site.

There are caveats that need to be addressed when creating an SEO score sheet- we want to be careful about noindexing pages, especially as overtime, this could result in less and less of the site being indexed. Once the initial script is written, check the results and see if these are actually pages that you want noindexed. If not, the script might have to be rewritten.

The ultimate goal is to make sure that only quality pages are indexed, while also keeping tabs on how many more pages on the site need unique content. This type of knowledge can prove useful when creating the site's linkbuilding/content strategy.

Conclusion

The overall goal is to build a streamlined process for technically auditing a site that can be described and thus, communicated internally. Creating a more efficient process means more time invested in other important elements- compiling quality content, building an online community, and social media to name a few.

Sign up for The Moz Top 10, a semimonthly mailer updating you on the top ten hottest pieces of SEO news, tips, and rad links uncovered by the Moz team. Think of it as your exclusive digest of stuff you don't have time to hunt down but want to read!

Find Your Site's Biggest Technical Flaws in 60 Minutes

Dave Sottimano — 2012-02-05T22:14:53+01:00

Posted by Dave Sottimano

I've deliberately put myself in some hot water to demonstrate how I would do a technical SEO site audit in 1 hour to look for quick fixes, (and I've actually timed myself just to make it harder). For the pros out there, here's a look into a fellow SEO 's workflow; for the aspiring, here's a base set of checks you can do quickly.

I've got some lovely volunteers who have kindly allowed me to audit their sites to show you what can be done in as little as 60 minutes.

I'm specifically going to look for crawling, indexing and potential Panda threatening issues like:

Architecture (unnecessary redirection, orphaned pages, nofollow)
Indexing & Crawling (canonical, noindex, follow, nofollow, redirects, robots.txt, server errors)
Duplicate content & On page SEO (repeated text, pagination, parameter based, dupe/missing titles, h1s, etc..)

Don't worry if you're not technical, most of the tools and methods I'm going to use are very well documented around the web.

Let's meet our volunteers!

Here's what I'll be using to do this job:

SEOmoz toolbar - Make sure highlight nofollow links is turned on - so you can visibly diagnose crawl path restrictions
Screaming Frog Crawler - Full website crawl with Screaming Frog (User agent set to Googlebot) - Full user guide here
Chrome, and Firefox (FF will have Javascript, CSS disabled and User Agent as Googlebot) - To look for usability problems caused by CSS or Javascript
Google search queries - to check the index for issues like content duplication, dupe subdomains, penalties etc..

Here are other checks I've done, but left out in the interest of keeping it short:

Open Site Explorer - Download a back link report to see if you're missing out on links pointing to orphaned, 302 or incorrect URLs on your site. If you find people linking incorrectly, add some 301 rules on your site to harness that link juice
http://www.tomanthony.co.uk/tools/bulk-http-header-compare/ - Check if the site is redirecting Googlebot specifically
http://spyonweb.com/ - Any other domains connected you should know about? Mainly for duplicate content
http://builtwith.com/ - Find out if the site is using Apache, IIS, PHP and you'll know which vulnerabilities to look for automatically
Check for hidden text, CSS display:none funniness, robots.txt blocked external JS files, hacked / orphaned pages

My essential reports before I dive in:

Full website crawl with Screaming Frog (User agent set to Googlebot)
A report of everything in Google's index using the site: (1000 results per query unfortunately - this is how I do it)

Down to business...

Architecture Issues

1) Important broken links

We'll always have broken links here and there, and in an ideal world they would all work. Just make sure for SEO & usability that important links (homepage) are always in good shape. The following broken link is on webrevolve homepage that should be pointing to their blog, but returns a 404. This is an important link because it's a great feature and I definitely do want to read more of their content.

Fix: Get in there and point that link to the correct page which is http://www.webrevolve.com/our-blog/

How did I find it: Screaming Frog > response codes report

2) Unnecessary Redirection

This happens a lot more than people like to believe. The problem is that when we 301 a page to a new home we often forget to correct the internal links pointing to the old page (the one with the 301 redirect).

This page http://www.lexingtonlaw.com/credit-education/foreclosure.html 301 redirects to http://www.lexingtonlaw.com/credit-education/foreclosure-2.html

However, they still have internal links pointing to the old page.

http://www.lexingtonlaw.com/credit-education/bankruptcy.html?linkid=bankruptcy
http://www.lexingtonlaw.com/blog/category/credit-repair/page/10
http://www.lexingtonlaw.com/credit-education/bankruptcy.html?select_state=1&linkid=selectstate
http://www.lexingtonlaw.com/credit-education/collections.html

Fix: Get in that CMS and change the internal links to point to http://www.lexingtonlaw.com/credit-education/foreclosure-2.html

How did I find it: Screaming Frog > response codes report

3) Multiple subdomains - Canonicalizing the www or non-www version

One of the first basic principles of SEO, and there are still tons of legacy sites that are tragically splitting their link authority by not using redirecting the www to non-www or vice versa.

Sorry to pick on you CVSports :S

http://cvcsports.com/
http://www.cvcsports.com/

Oh, and a couple more have got their way into Google's index that you should remove too:

http://smtp.cvcsports.com/
http://pop.cvcsports.com/
http://mx1.cvcsports.com/
http://ww.cvcsports.com/
http://www.buildyourjacket.com/
http://buildyourjacket.com/

Basically, you have 7 copies of your site in the index..

Fix: I recommend using www.cvcsports.com as the main page, and you should use your htaccess file to create 301 redirects for all of these subdomains to the main www site.

How did I find it? Google query "site:cvcsports.com -www" (I also set my results number to 100 for check through the index quicker)

4) Keeping URL structure consistent

It's important to note that this only becomes a problem when external links are pointing to the wrong URLs. *Almost* every back link is precious, and we want to ensure that we get maximum value from each one. Except we can control how we get linked to; without www, with capitals, or trailing slashes for example. Short of contacting the webmaster to change it, we can always employ 301 redirects to harness as much value as possible. The one place this shouldn't happen is on your own site.

We all know that www.example.com/CAPITALS is different to www.example.com/captials when it comes to external link juice. As good SEOs we typically combat human error by having permanent redirect rules to enforce only one version of a URL (ex. forcing lowercase), which may cause unnecessary redirects if someone links in contradiction to redirects.

Here are some examples from our sites:

http://www.lexingtonlaw.com/credit-education/rebuild-credit 301's to trailing slash version
http://webrevolve.com/web-design-development/conversion-rate-optimisation/ Redirects to the www version

Fix: Determine your URL structure, should they all have trailing slashes, www, lowercase? Whatever you decide, be consistent and you can avoid future problems. Crawl your site, and fix these

Indexing & Crawling

1) Check for Penalties

None of our volunteers have any immediately noticeable penalties, so we can just move on. This is a 2 second check that you must do before trying to nitpick at other issues.

How did I do it? Google search queries for exact homepage URL and brand name. If it doesn't show up, you'll have to investigate further.

2) Canonical, noindex, follow, nofollow, robots.txt

I always do this so I understand how clued up SEO-wise the developers are, and to gain more insight into the site. You wouldn't check for these tags in detail unless you had just cause (ex. A page that should be ranking isn't

I'm going to combine this section as it requires much more than just a quick look, especially on bigger sites. First and foremost check robots.txt and look through some of the blocked directories, try and determine why they are being blocked and which bots they are blocking them from. Next, get Screaming Frog in the mix as it's internal crawl report will automatically check each URL for Meta Data (noindex, header level nofollow & follow) and give you the canonical URL if there happens to be one.

If you're spot checking a site, the first thing you should do is understand what tags are in use and why they're using them.

Take Webrevolve for instance, they've chosen to NOINDEX,FOLLOW all of their blog author pages.

http://www.webrevolve.com/author/tom/
http://www.webrevolve.com/author/paul/

This is a guess but I think these pages don't provide much value, and are generally not worth seeing in search results. If these were valuable, traffic driving pages, I would suggest they remove NOINDEX but in this case I believe they've made the right choice.

They also implement self-serving canonical tags (yes I just made that up), basically each page will have a canonical tag that points to itself. I generally have no problem with this practice as it usually makes it easier for developers.

Example: http://www.webrevolve.com/our-work/websites/ecommerce/

3) Number of pages VS Number of pages indexed by Google

What we really want to know here is how many pages Google has indexed. There's 2 ways of doing this, using Google Webmaster Tools by submitting a sitemap you'll get stats back on how many URLs are actually in the index.

OR you can do it without having access but it's much less efficient. This is how I would check...

Run a Screaming Frog Crawl (make sure you obey robots.txt)
Do a site: query
Get the *almost never accurate* results number and compare them to total pages in crawl

If the numbers aren't close, like CVCSports (206 pages vs 469 in the index) you probably want to look into it further.

I can tell you right now that CVCSports has 206 pages (not counting those that have been blocked by robots.txt). Just by doing this quickly I can tell there's something funny going on and I need to look deeper.

Just to cut to the chase, CVCsports has multiple copies of the domain on subdomains which is causing this.

Fix: It varies. You could have complicated problems, or it might just be as easy as using canonical, noindex, or 301 redirects. Don't be tempted to block the unwanted pages by robots.txt as this will not remove pages from the index, and will only prevent these pages from being crawled.

Duplicate Content & On Page SEO

Google's Panda update was definitely a game changer, and it caused massive losses for some sites. One of the easiest ways of avoiding at least part of Panda's destructive path is to avoid all duplicate content on your site.

1) Parameter based duplication

URL parameters like search= or keyword= often cause duplication unintentionally. Here's some examples:

http://www.lexingtonlaw.com/credit-repair-news/economic-and-credit-trends/mortgage-lenders-rejecting-more-applications.html
http://www.lexingtonlaw.com/credit-repair-news/economic-and-credit-trends/mortgage-lenders-rejecting-more-applications.html?select_state=1&linkid=selectstate
http://www.lexingtonlaw.com/credit-repair-news/credit-report-news/california-ruling-sets-off-credit-fraud-concerns.html
http://www.lexingtonlaw.com/credit-repair-news/credit-report-news/california-ruling-sets-off-credit-fraud-concerns.html?select_state=1&linkid=selectstate
http://www.lexingtonlaw.com/credit-repair-news/economic-and-credit-trends/one-third-dont-save-for-christmas.html
http://www.lexingtonlaw.com/credit-repair-news/economic-and-credit-trends/one-third-dont-save-for-christmas.html?select_state=1&linkid=selectstate
http://www.lexingtonlaw.com/credit-repair-news/economic-and-credit-trends/financial-issues-driving-many-families-to-double-triple-up.html
http://www.lexingtonlaw.com/credit-repair-news/economic-and-credit-trends/financial-issues-driving-many-families-to-double-triple-up.html?select_state=1&linkid=selectstate

Fix: Again, it varies. If I was giving general advice I would say use clean links in the first place - depending on the complexity of the site you might consider 301s, canonical tags or even NOINDEX. Either way, just get rid of them !

How did I find it? Screaming Frog > Internal Crawl > Hash tag column

Basically, Screaming Frog will create a unique hexadecimal number based on source code. If you have matching hash tags, you have duplicate source code (exact dupe content). Once you have your crawl ready, use excel to filter it out (complete instructions here).

2) Duplicate Text content

Having the same text on multiple pages shouldn't be a crime, but post Panda it's better to avoid it completely. I hate to disappoint here, but there's no exact science to finding duplicate text content.

Sorry CVCSports, you're up again ;)

http://www.copyscape.com/?q=http%3A%2F%2Fwwww.cvcsports.com%2F

Don't worry, we've already addressed your issues above, just use 301 redirects to get rid of these copies

Fix: Write unique content as much as possible. Or be cheap and stick it in an image, that works too.

How did I find it? I used http://www.copyscape.com, but you can also copy & paste text into Google search

3) Duplication caused by pagination

Page 1, Page 2, Page 3... You get the picture. Over time, sites can accumulate thousands if not millions of duplicate pages because of those nifty page links. I swear I've seen a site with 300 pages for one product page.

Our examples:

http://cvcsports.com/blog?page=1
http://cvcsports.com/blog?page=2

Are they being indexed? Yes.

Another example?

http://www.lexingtonlaw.com/blog/page/23
http://www.lexingtonlaw.com/blog/page/22

Are they being indexed? Yes.

Fix: General advice is to use the NOINDEX, FOLLOW directive. (This tells Google not to add this page to the index, but crawl through the page). An alternative might be to use the canonical tag but this all depends on the reason why pagination exists. For example, if you had a story that was separated across 3 pages, you definitely would want them all indexed. However, these example pages are pretty thin and *could* be considered as low quality for Google.

How did I find it? Screaming Frog > Internal links > Check for pagination parameters

Open up the pages and you'll quickly determine if they are auto generated, thin pages. Once you know the pagination parameter or structure of the URL you can check Google's index like so: site:example.com inurl:page=

Time's up! There's so much more I wish I could do, but I was strict about the 1 hour time limit. A big thank you to the brave volunteers who put their sites forward for this post. There was one site that just didn't make the cut, mainly because they've done a great job technically, and, um, I couldn't find any technical faults.

Now it's time for the community to take some shots at me!

How did I do?
What could I have done better?
Any super awesome tools I forgot?
Any additional tips for the volunteer sites?

Thanks for reading, you can reach me on Twitter @dsottimano if want to chat and share your secrets ;)

How to Build an Advanced Keyword Analysis Report in Excel

Dan Peskin — 2012-02-04T09:04:41+01:00

Posted by Dan Peskin

This post was originally in YouMoz, and was promoted to the main blog because it provides great value and interest to our community. The author's views are entirely his or her own and may not reflect the views of SEOmoz, Inc.

Analyzing keyword performance, discovering new keyword opportunities, and determining which keywords to focus efforts on can be painstaking when you have thousands of keywords to review. With keyword metrics coming from all over the place (Analytics, Adwords, Webmaster Tools, etc.), it’s challenging to analyze all the data in one place regularly without having to do a decent amount of manual data manipulation. In addition, dependent on your site’s business model, tying revenue metrics to keyword data is a whole other battle.

This post will walk you through a solution to these keyword analysis issues and provide some tips on how you can slice and dice your data in wonderful ways.

With Microsoft Excel, we can create a report with all the keyword data you will need, all in one place, and fairly easy to update on a weekly or monthly basis. Then with all this data we can easily categorize segments of it to more quickly determine the better performing sets of keywords.

What we will need to do is push Google Analytics, Webmaster Tools, Adwords, Ranking data, and Revenue data all into one excel spreadsheet. Then we will put it all together into one master report and one categorized pivot table report.

To start, you should be especially familiar with pivot tables, the Google Adwords API, the Google Analytics API, and keyword research of course. Utilizing these APIs and being consistent in the formatting of the data you put into your spreadsheet will make it easy to update. If you aren’t familiar with these tools, I have provided resources below and some steps to organizing this data.

Here are some resources for learning to use pivot tables in Excel:

Excel for SEO
Microsoft Pivot Table Overview

Now let’s go fetch that data.

I Got 99 Problems, But A Keyword Visit Ain't One

First off we need to get our keyword traffic metrics through the Google Analytics API. I suggest using Mikael Thuneberg’s GA Data Fetch spreadsheet. You can follow the instructions, read the how to guide, and download the file here.

Make sure to build off the GA data fetch file or a copy of it, as it has the proper VBA functions (the Visual Basic code that allows for the API to work) installed for API calls. Once you have your API token and the spreadsheet setup you can perform your first API call.

We will be using the more complex query to extract organic keyword visits for a specific date field and filter by the number of visits. The query I use for example, will output visits, average time on site, page views, and bounces for any keyword with 5 or more visits in the last 30 days. However, you can modify the parameters to your liking. To see what other metrics can be used, check out the Analytics API documentation.

Your Analytics data should look something like this:

Google Analytics data called through the API in Excel.

Now select the whole keyword column and create a pivot table of the keyword list in another sheet. In the adjacent column create a table where the cells equal the values in the pivot table column. Label this table “KeywordList” or whatever you like. We now have the keyword table to reference for extracting Adwords data.

Pivot tables don’t have the same referencing abilities as regular tables, so the table in column B is what you will reference in future steps.

To Be, Or Not To Be Searched, That Is The Question

Next up is pulling in search volumes for our keyword table. Thanks to the wonderful Richard Baxter, there are a couple articles on using and installing the Adwords API Plugin. One on SEOmoz and one on Seogadget.

I know the Adwords API access is a bit of an issue for some, so if you cannot use the API, utilize the Google Adwords Keyword Tool (gathering data from this tool will unfortunately require a lot more work).

In a new sheet, use the Adwords API array formula called “arrayGetAdWordsStats” to pull in the average and seasonal monthly search volumes for your keyword table. Your formula should look something like this:

=arrayGetAdWordsStats(KeywordList,”EXACT”,”US”,”WEB”)

You should now have 12 months of historical search volumes and averages for all your keywords.

Results from an Adwords API call usually look like this.

Note: If your keyword list is greater than 800 keywords, you will have to break out the list into a few separate tables just to perform API calls for those keywords. If this is the case, make sure to keep each array of search volumes aligned in the same columns.

The Impression That I Get

No API required here, Google’s Webmaster Tools provides a pretty easy way to download its search query data. If you open up the Search Queries report in Webmaster Tools there is an option to “download the table” at the bottom. Download the table for the same date range you used earlier and drop it into a new sheet.

The report downloaded from Webmaster Tools. Note the “-“ is used for zero values, in the yellow columns I simply cleaned that up with an IF statement.

Impressions, CTR, and Average Rank can now been added to our metrics.

If You Ain't First Page, You're Last

Since we all know how accurate average rank is from Webmaster Tools, let’s get some current rankings into this report .Grab your main keyword list from the spreadsheet and run rankings for them with your application of choice. I usually use Rank Tracker, but I am sure everyone has their own preference. Once you have your rankings drop it into a new sheet.

The More You Know

The number of metrics we can add to the report are limitless, but there comes a point where adding too many can create more work for updating the report or create analysis paralysis. The only other metric I suggest adding in is the SEOmoz Keyword Difficulty if you have a PRO account. Again this may be very time consuming to add for large numbers of keywords, hopefully you have an intern for that.

Mo Money Mo Metrics

Revenue data may come from different places dependent on how your business works, so I unfortunately don’t have a one stop solution to importing that data. However, most applications usually allow you to download that data to CSV or Excel. If you have Ecommerce enabled in Google Analytics, you can use the API to pull in this data. As long as you have some metrics to relate to your keyword such as Average Order Value or Conversion Rate, drop it in a new sheet and you will be good to go.

Some of you may be asking yourself what to do if your revenue data does not tie back to the keyword visit. This is where the categorization of keywords plays an extremely important part in this report. In this case, we want to create a bridge between the revenue data and keyword data. This can be done through categorizing your keywords into a category that relates back to a field in your revenue data. For example, you might be able to associate keywords with product names or landing pages. These products or landing pages would then become categories. Once you have determined what your categories will be, you can assign them to keywords in a new sheet that simply contains keywords in one column and the category tag in the other. You can learn more about keyword categorization here.

Categorizing the keywords above not only lets me group them to aggregate metrics for analysis, but it allows me to bridge the gap somewhat between the keywords and conversions in this example.

One Report To Rule Them All

Finally we have all the data; we just have to put it all together. Create a new sheet and pull in your master keyword list by using =NameOfTheTable, drag this down until you reach the last keyword on the list (paste values after if you want sorting capabilities). Now select your keywords and create a new table. In the columns next to the keywords all you have to do is a VLOOKUP of each metric you would like to add to your report. Once you fill in the first cell of each column, the column should automatically be added to the table and populate the other cells with the equation. Repeat this process until all your metrics are in this table.

There will also be a need to calculate some metrics such as the Bounce Rate or Conversion Rate if you pulled in revenue data. Those should be added in adjacent columns as well. Additionally, if you didn’t need to categorize your keywords earlier, I suggest categorizing them now in an adjacent column. When completed your master report should look something like this:

The master report.

Amazing. We have all the data in one place in a simple to sort and use table! Just wait…it gets better.

Pivotal Success

Now you may be wondering how this report can get any better. Two words my friends: Pivot Tables.

Creating a pivot table of your master report will allow you to segment your data in a number of ways that weren’t possible before. In the Pivot Table Field List, the Row Labels, Column Labels, and Values will define the layout of your report. What we first need to do is drag and drop the Category and Keyword fields into the Row Labels respectively. This will set your top level metrics to summarize at the Category level and allow you to drill down into each Category to see the associated keywords and their individual metrics.

Next you will want to start dragging your metrics into the Values section, which will automatically populate the Column Labels section with the Values field. As you add your metrics in, you can edit their names and the way they are aggregated. You will want to think carefully about how you will aggregate certain metrics so that viewing those summarized numbers at a Category level makes sense.

This shows you how best to setup your pivot table fields and their value settings.

For instance, I might summarize Impressions and Visits, but average CTR and Bounce Rate. Seeing the average CTR and Bounce Rate for a Category will allow me to narrow down which sets of keywords are performing better than others. Then looking at the total Impressions and Visits for those well performing categories will allow me to see where there might be a higher potential to increase traffic to my site. While this may not be an absolute rule to determine keyword focus, it is a good rule of thumb and can be a way to prioritize which ones to focus on.

Pivot table reports also allow you to add report filters, letting you filter out data by any metric or even multiple metrics. With this you could analyze keywords that only rank on the first page of SERPs using the current ranking as a filter. Hell, you could add a field to the master report calculating the number of words in each keyword phrase, then filter by that and bounce rate, giving you your well performing long tail keywords. Get creative, let loose, play with the metrics, you will be surprised at what kind of conclusions you can make about your site’s keyword traffic.

The final product.

Conclusion

Updating the report is simple. Rerun the API calls with the new date range, rerun your rankings for the new keyword list, and export the other reports you need with new date range. As long as you kept your formatting and equations the same, the rankings and other reports should be dropped into their respective sheets without having to change anything. The master report should automatically be updated once you update the keyword column and the pivot report should update once you hit refresh under the pivot table menu. That’s it!

Well I should probably stop talking now and let you get to your hours upon hours of keyword analysis fun. Hopefully this was informative enough to make building a report such as this fairly easy. I would love to hear your feedback and will gladly answer any questions or comments about the post below. If you have issues later on, you can always contact me via Twitter.

Excel Template

Added by Keri, from Dan's comments on this post:
Since there was some interest in sharing the data set I used to better understand steps, I have provided a download on my personal site. You can download the excel template here. Hope this helps

The Hidden Factors in Accomplishing Your Online Marketing Goals - Whiteboard Friday

randfish — 2012-02-02T21:42:02+01:00

Posted by randfish

In this week's Whiteboard Friday, we go underneath the surface and bring to light some hidden factors in online marketing. These often overlooked details can have a huge impact in helping us accomplish our goals as online marketers. Please enjoy and don't forget to leave your comments below.

Please note that we shot this week's Whiteboard Friday on a brand new video camera and we still need to work out a few kinks. I apologize for the slight purple tint on the Whiteboard.

Video Transcription

Howdy, SEOmoz fans. Welcome to another edition of Whiteboard Friday. This week I want to talk about the goals that we try to get people to accomplish on the Web, the things that we're trying to accomplish as online marketers, and what we're trying to optimize for, things like: click-through rate from search results; getting people to subscribe to RSS and e-mail; getting them to click links that are posted on social networks; getting them to share things on social networks, on blogs, on websites of all kinds; getting them to convert from browsing to buying; completing a free trial or downloading a white paper and giving you their information; staying a customer of a subscription product. These goals that we have are traditionally done through optimization tactics that we've talked about many, many times here. But there are hidden factors. There are things that hide beneath the surface that impact and affect all of these, all of the success rates and the conversion rates and the goal rates that you have. They can be so subtle sometimes and so hidden beneath the surface that we don't even realize what's going on. That's what I want to talk about today.

So in terms of impacting all of these items, there's traditional stuff that we know, we talk about. So things like, oh, and the click-through rate for the search results, I know that position matters. I know that getting a rich snippet matters. If I can have little stars next to mine; if I can have a picture, a photo, or a video, that usually increases click-through rate. I know that if I'm in special kinds of results, that can either increase or decrease my results. I know if I've got a listing and an indented listing below, that can help me. I know that with subscriptions to RSS and e-mail, I can test different buttons, different versions of the entry form; different calls to action. On links that I click, I can test different titles. All this kind of stuff, there are those traditional testing kinds of things, right?

So in that traditional CRO, that's been covered a ton of times. We don't need to cover this because you often know a lot of the things that are in there. You can find them. They're well-documented. The subtle stuff, the weird stuff is oftentimes around just two questions.

Number one: Does the product or service or thing that you want me to do meet my needs? It could be as simple as: Do I think when I click on this result in the search engine that it will answer the question that I originally asked? But there are so many subtleties that are involved in that, that we never think about, that doing traditional kinds of CRO testing and optimization, we'll never get there.

The second question is: Do I trust and like the brand and/or people behind the brand? This goes to fundamental marketing and branding awareness, and it is so pervasive in all the things that we do, whether it's in web marketing or in offline marketing, and yet oftentimes ignored by marketers like us, who operate in the inbound world of SEO and social media and content marketing and these kinds of things, because we're so analytics driven, that we see a lower click-through rate than we want, a lower conversion rate than we want, a lower subscription rate, a lower sharing rate than we want, and we think, hey, let's test these traditional types of CRO things. Sometimes the problem or the optimization tactics are at a much deeper level.

Let's start with the product/service meeting the needs. There's a bunch of things that go in here. Uptime and reliability is one of the biggest ones. So essentially, if I click a website and it is not speedy, delivering the things that I need, and consistent, I'm going to learn not to trust it, and I'm going to be less likely to click it. This is why you see things like speed being a factor, webpage load speed in Google's rankings, granted a very small factor, but certainly a much bigger factor when you're talking about, "Hey, I'm going to click this, and boy, it's going to take a long time."

I'll give you a good example. I personally think that a lot of the writing at Forbes is pretty darn good. Same with The Wall Street Journal, same with Bloomberg online. But they almost all have interstitial ads and very, very slow page load times. At least in my experience in the past, those websites have done that for me. Almost always have the interstitial, almost always takes a while to load, and then I have to wait through the interstitial. I hate it.

So if I see something else in the search results, a site in social media, I'm going to be less apt to share it. I'm going to be less apt to click on it. I've learned through the conditioning that those brands have given me that the uptime, reliability speed issues are problems.

Same thing with pricing. So I think Radian6 is an absolutely phenomenal product. I've heard great things about it, met the CEO, know some people there. Terrific product. Way too expensive! No way that I can justify affording it. Right now, I'm using Google Alerts and some combination of Google searches that I do every day, some other brand monitoring stuff that SEOmoz is working on in beta, the Blogscape Project, which of course I get kind of alpha access to.

Pricing is wrapped in there by necessity. When you worry, "Hey, wait a minute. I'm attracting all these visitors. They're not converting or they're not taking this action." They may have heard, or they may know, or they may have seen that your pricing simply doesn't match their market, or they have fears around that. That's why I'm such a big fan of transparency here, because I think that you will weed out and save your salespeople time, and save your customer service people time, and save your website bandwidth, if you're transparent about this most of the time.

Features and perceived features. Features is: Do you do the thing that I want you to do? When I'm talking about features, I could mean in software. I could mean in a product, like I'm buying a digital camera, I'm buying a car, I'm buying a whiteboard pen, I'm buying a subscription to a software service. I'm looking purely for information. The features are: Do you do the things that I want you do to? Oftentimes, that comes through brand perception as well.

So I know that a lot of the times when I visit an eHow type of website, that it doesn't have the features that I want, which is a reliable source that I know I can trust. Wikipedia's the same way. I only semi-trust Wikipedia, and I trust it on some topics and not others, and I always want to back it up with something else from some reliable source where I know the person there or I know the brand there, because Wikipedia could be edited by anybody, and I don't necessarily know who's behind it.

So those types of brands, and this is even true sometimes at About.com, where the writers in some categories are phenomenal. Southern food, I think is terrific. Some of the digital marketing ones are good. Some of them are mediocre. It's a trust factor around the features and the perception of features. Perception of features is often very different from actual features.

We find, for example, when we survey customers of SEOmoz that they have no idea that we actually will help track their Facebook pages, Insights data over time, and their Twitter data over time. Many people don't even know that Open Site Explorer and SEOmoz are offered in the same subscription. So this is clearly a problem that we have had on perception of features, not even on actual features.

Presentation. The way and the style in which the features and the information and the pricing and reliability and the uptime, all of that is presented is another big one. The thing about presentation is that it's a layer that impacts everything else, not just up here, but down here as well. It's often done terribly, terribly wrong on the Web.

Because it ties so much to the, "Do I like and trust these people," let's talk about those. This question, when you ask the question, "Do I like and trust the brand, and the people behind the brand," that goes to a bunch of inputs that are very, very far removed, all so far removed from traditional CRO stuff. That's things like design and UX, which we talk about many times here on Whiteboard Friday and on the site. Higher quality, more professional, more consistent with what your audience is looking for, just does a fantastically better job than, "Oh yeah, we bought some stock photography of some people in an office working, and don't they look attractive, don't they have perfect skin? And now, you know, that's our homepage, and then there's Services, and Contact, and About. Great, we have a professional website!" No, you don't. No, no, you don't!

Design UX isn't just about that. There are other inputs like domain name and brand name. One of the biggest reasons that I'm often against exact- match domains is because it is so tremendously hard to build up any sort of branding. If you name industries, you will very, very rarely hear that the generic, exact-match domain for what we call that industry is a market leader, a brand leader, and because of that and also because, to be totally fair, a lot of people in the domaining sphere and the affiliate marketing and SEO sphere noticed the power that these had in Google and abused them tremendously. So now consumers have an association, particularly savvy consumers have an association, a brand association with exact-match domains. That is, "Oh, that's probably a low-quality site. That's probably not the real brand. I don't know if I can trust it if I click on that," versus actual brand names.

I'll give you some very good examples. In the world of office supplies I've heard of Staples, right? I've heard of OfficeMax. I've heard of Office Depot. But if it's OfficeSupplies.net, I'm sure someone owns that domain. It could even be someone awesome. Maybe it's a great site, but if I see it in the search results, I'm going to be mighty suspicious. That suspicion just naturally creeps in. That's why domain name and brand name are so tied together in the perception of trust and can substantially impact things like click-through rate and conversion rate and subscription rate, etc.

Accessibility of contact information. It's funny, I was just on an e-mail thread yesterday night, and some folks in the SEO sphere said, hey, have you ever heard of this particular - it was an enterprise SEO software provider. I went, "No, I haven't heard of them. This is the first time. Let me go check out their site." I see they try and say a few futures, but there's literally nothing, no one mentioned on the site; no people who are using it, no people who are associated with the brand. The contact information is "Fill out a contact form" or "Here's our office." I think it was somewhere in the United States; I can't remember exactly where. But other than a mailing address and a phone number, there was no human being listed, which made me very suspicious, because why would you not show off the team? Like, here's the exec team behind it. Here are our engineers. That kind of transparency is natural in the software world. Something's weird if it doesn't exist there.

Being able to find that information - a phone number, e-mail, contact forms, here's our Twitter and our Facebook, and these kinds of things - you just expect those from web companies. When they don't exist, you become highly suspicious.

The authenticity of the content. One of my favorite examples is there's a brand that's been doing a ton of fantastic infographics. I think it's MBAonline or MBAeducation.com, one of the online education providers with a very generic name. They really do great infographics. They sponsor some awesome stuff. Sometimes they'll get featured on a Mashable or even a TechCrunch, or something like that. Tremendous work, excellent work getting that brand out there.

But I always look at them and think this doesn't have a relationship with what the services that you're trying to sell, which is you're an affiliate for a bunch of online education providers, which can be a little bit of a nasty, sort of spammy, aggressive field. The challenge here is, hey, yes, you've got the infographic, you've got the link. But when you're trying to tie back into consumers and earn their business, those of us who are savvy and sophisticated, we sort of get a funny feeling, like something doesn't match up. The content is not authentic to the brand. Why is it being produced?

I think a great example of this is OkTrends, which is OkCupid's blog. They essentially have dating content that matches up with what people are looking for from their site. So, here's how to optimize your dating profile, and by the way, we're a dating website. Great, makes perfect sense.

Hey, here's an infographic about the rise of Twitter or Twitter click- through rates or something - and by the way, we're an MBA online education provider. Why is that? It seems like it's just for the links and attention and awareness and has nothing to do with the actual brand. Highly suspicious, particularly in spheres that are very aggressive.

Industry reputation, word of mouth. I'll give you another example. So, there was another provider that was mentioned on this string in the SEO enterprise space. No, I'm sorry. It was another enterprise software provider, but not in SEO. There were some comments of, "Oh, hey, should we use this? Should we use this other one?" Someone remarked on an e-mail thread, "You know, the CEO of this particular company has treated women employees very badly."

You would never find that on the Web, right? That's not information that you're going to see. If you start searching for reviews, you won't find it on their website. It's something that's word-of-mouth only, but it's made its way to enough influencers that now that is an influential thing in the perception of, "Do I like the brand and the people?" Very frankly, I trust this source, and I know the source knows the CEO there, and I don't. I'm probably not going to buy from this particular enterprise software provider, even if they meet my needs up here. This is the type of stuff that influences conversion rate, that is so subtle and so hidden, that you're never going to realize it from a traditional CRO-type of perspective. And yet, it pays huge dividends to go and investigate this stuff and understand that perception.

The final one that I'll mention here is familiarity with the brand and social proof of the brand. A great example here, go to SurveyMonkey's website. If you're not logged in, the homepage is a woman from Facebook, her picture, she's a statistical analyst there, and she's giving an endorsement to SurveyMonkey. Now, Facebook is a phenomenal brand; they're very well-known. Their business practices are respected. People know that they're a great data-driven company, and so the fact that they trust SurveyMonkey strongly suggests SurveyMonkey must be a great provider. So, they've created that social proof, and they're using a brand that you're familiar with.

When you combine those things, it's absolutely excellent and incredibly powerful. When I go to websites and I see a lot of social proof from either people that are anonymous or people that provide only their fist name or people that I don't know, it's less powerful. When I have seen a brand, six, seven, eight times on the Web, at a conference, in various types of ways - I've heard from someone over e-mail, I know someone who's used them, I've had an experience with someone from that company - those types of things strongly influence these. Building up all of this builds up your conversion rates and builds up all of these metrics that you think about as an online marketer, and yet, we often have so little control or so little even ability to judge and record these things.

What I want to suggest is that, to those of you who are doing web marketing, when you're thinking about these metrics, remember that these are all inputs. Don't necessarily use them as excuses, but make sure that you're taking some action on them. Make sure that you're finding ways to measure them. Make sure that these aren't the reasons why your rates over here are low, rather than the stuff that you focus on, because it can be incredibly frustrating to find that, hey, the reason that we're not making good sales is because no one is familiar with our brand, and we don't have the right social proof, rather than, oh, it's because I didn't write the title tags correctly, and I don't have a compelling description for the content, and the page isn't optimized well. It doesn't have a good flow and conversion process and funnel. Sometimes these two things are mixed up together, and I worry about those hidden factors.

So, I hope you've enjoyed this edition of Whiteboard Friday, and I hope we'll see you again next week. Take care.

Video transcription by Speechpad.com

Are Your Titles Irresistibly Click Worthy & Viral?!

evolvingSEO — 2012-02-02T14:01:42+01:00

Posted by evolvingSEO

The 80/20 Value of Titles

Recently, Rand did one of the best Whiteboard Fridays I've seen in a while (I do watch all of them) about increasing the likelihood of your content going viral. He touches briefly upon the importance of your title for click through rate and sharability, but in this post I'd like to take a more in depth look at titles and how they help spread your content. (By the way, this is my first YouMoz - woohoo!)

In my opinion, the elements of writing click worthy titles deserve more attention. In the wonderful marketing book "Made To Stick", the Heath brothers note that any good news or editorial writer may spend 80% of their time crafting the title (or "lead") and then whatever time they have left on the body of the content.

For those familiar with 80/20, what this means is, the size of the title compared to the actual content (and time spent crafting it) disproportionately affects the success of that content. It's one small piece of text with a lot power!

Note: to clarify, I am not necessarily referring to the title tag exclusively. I'm referring to simply the title of a page, post, article... which as you will see below can be the same as your title tag, but doesn't have to be.

A Quick Analogy: The Internet As a Highway

If your webpage was a store on the side of a busy highway, the title's job would be to capture attention and get people in the door. As many of the right people as possible. If you've ever driven on Route 1 heading into Boston, MA, you know what I mean (see photo).

Lots of people may pass by your links, tweets and shares, but few may actually stop to come in and check things out.

I hope this little analogy illustrates the extreme importance of crafting a clickable title - and that you will join me as I suggest some ideas for making your titles more clickable. Let's go!!!

7 Ingredients of a Click Worthy Title

Assuming all other factors neutral for the moment, let's look at what I think are 7 most important ingredients of your titles;

Curiosity
Benefit
Emotion
Tangible
Appearance
Sound
Expectation

Ingredient 1: Curiosity

Your title should be clear enough that people know what they're going to get when they click, but also leave an element of curiosity - so you almost can't help but to click. You just have to find out what's on the other side. Some examples of elements that can entice curiosity;

Curiosity A: Unexpected

How do you make something unexpected? Combine two things that usually do not go together, like this;

"Diet Coke" is not something you usually expect to see in a post about SEO. 77 thumbs up.

Curiosity B: Incomplete Thought or Question

Pete's title here makes me curious, because he asks an open question, which I wonder how/if it will be answered within the post.

Curiosity C: Present A Conflict (Plot)

Rand does a great job here of introducing curiosity because there is an inherent conflict; a choice requiring resolution. Which one will he choose and why? Which do I choose and can I offer an alternative opinion? Will I agree with him?

Curiosity D: State What Something Isn't

I'm left thinking; It isn't? What Is? Do I know them? What's John going to say?

Ingredient 2: Highlight The Benefit

Benefit is congruent to differentiation. On the whole, people will visit a page because there is some sort of benefit to them. Useful content, entertainment, or even content that will make them look good if they share it. Why should someone click and visit your page? What are they going to get out of it? Some examples that imply benefit;

How to...
7 Ways...
Find Out How...
Introducing.... (implies newness)

These are all common elements of a title that hint at benefit. Like this;

Providing a clear benefit is also a way to differentiate your content from others, in that you're implying it holds unique value that can't be found elsewhere. I also like "face-off" - there's a lot of meaning (visual, emotion, tension, etc) packed into those two words.

Ingredient 3: Elicit Excitement/Emotion

People also act on emotion - excitement, fear, hope. Your title should conjure the right emotion in viewers. I don't think people always click purely on emotion, but emotion can certainly support the other ingredients. Things like;

Thanks for the tweet Tom :-) I think the emotional aspect (as in this case) can apply more to social media - the title you might craft in a tweet of something, such as Tom's "ridiculously awesome" text here. Some other emotional words are;

killer
amazingly
fantastic
FREE
mistakes
mind-blowing
surprising
staggering
surprisingly
uncommonly
unusually
myths
irresistibly
seductively
tempting
uncontrollably
unexpected
unbelievably
astonishing
astoundingly
remarkably
insanely
stupidly
wicked
viral
epic

You get the idea :-)

Note that adverbs (ending in "ly") are quite popular. Honestly, I'm just using the thesaurus for a lot of those :-) But if you're fine with describing your own work in such glamorous words, go for it! I typically reserve this for something I'm really confident about, or if I'm referring to something else, like a product review.

Also;

Exclamation points!!!!!!
ALL CAPS - You MUST Read This NOW
-------->Arrows. The Best Post Ever ---> Read Now
*Asterisks* - I Just *Love* The Ideas in blah blah blah....

Just remember that not all special type characters work well across different platforms (social, blog themes etc) so use carefully. And they can also get annoying quickly, so use sparingly.

Ingredient 4: Make It Tangible

The Health Brother's book "Made To Stick" talks a lot about making your ideas concrete or tangible. I highly recommend going to this page of resources and downloading the free PDF "Made To Stick Success Model" (and read their book!)

Great example here though by Mike King;

I'm sure we all get an instant clear picture in mind of the "Cat In The Hat", as it's a familiar tangible graphic. Also keep in mind that, in Mike's case especially, a great post can naturally lend its self to a great title.

Ingredient 5: Appearance & Length

Although, in my opinion, not as important as 1-4, but if you can get your titles to look aesthetically pleasing, even better. Like this;

I like what Neil has done here, however intentional or not. The title fits on one line. It looks pleasing graphically, and its seven words long (which is supposedly the recommended length of a title or headline).

Ingredient 6: Sound

I don't know about you, but I "hear" myself saying the titles in my head. Just like appearance, this is of secondary importance, but if you can put an artistic touch to your titles, it makes them that much better.

I'm going to use Neil's title (noted just above) again as an example here. It sounds nice. It has a poetic ring to it.

The alliteration "Lessons Learned".
The "esss" sound in "Lessons" and "SEO" fit nicely
as well as the "sea" sound in agency.

Can you tell I am a musician?

Again, the appearance and sound of your title is secondary, I believe, to the first four ingredients, but in my mind if you can get all 7 elements into a title, you're a freakin' genius. :-)

Ingredient 7: Expectations

Don't advertise "the best burger in town" and then have it be a veggie burger. It could be the best veggie burger that ever existed, but you set the wrong expectation. This is where you need to have some serious alignment and harmony between what you promise in the title and deliver with the content.

For this, I'd like to cite an example where the wrong expectation may have been set;

While honestly, I've only skimmed this post, the 17 thumbs down and people's comments (some about the title directly) illustrate the point that you don't want misrepresent the content of your post. Whether intentional or not, this post unfortunately seemed to do that. But conversely it did get quite a bit of attention (101 thumbs up and promotion to main blog) so it was a well-written title, just may not have been best aligned with the content.

So some questions to ask yourself to double check this;

Does the title match the content? - What would YOU expect to see on the other side if you read the title? Does it match in what you imply the benefits will be?
Does it imply content type? - Do you use the words "photo, video, graphic, interview, read, slideshow" etc implying what the core content type is going to be? Does that in fact match what's in the post?
How long will it take to consume? - Do you call something a "complete guide", implying extensive length, when it is just a short overview? Do you call something a "quick recap" when in fact it's an in-depth look? Or say "7 steps" when in fact that's only a piece of the whole content?

Finally, note that you don't have to have all of these ingredients all of the time. Certain content may be more inherently exciting, or other content more controversial and thus evokes more curiosity.

Breaking The Rules

There are, of course plenty of exceptions to these ingredients in the real world:

Exception 1: Created By Influential Person/Business

If Rand or Danny Sullivan or Avinash posts a new article, there is an inherent trust and reputation built in. I think the concept of authority is explained well in Rand's post about thought leadership. Along those lines, when Roger (@SEOmoz) tweets out the newest blog post, since this is coming from a popular SEO company, Roger's reputation can boost up click worthiness and thus, the title is not quite as important.

Exception 2: Extremely Noteworthy or Newsworthy Content

During the time of SOPA or the Google (Not Provided) dilemma or now SPYW, if you were to post something with a decent title that was timely, this would be more likely to get clicks, just by nature of it being a hot topic.

Exception 3: Rebellion / Pure Artistic Liberty / Don't Care

Obviously there are sectors of the web or moments where you just want to throw your hair down and crank out an over the top, creative, artistic, rebellious title. Of course, as I'm now typing this, those sound like they'd get some good clicks as well! They just won't follow the "formula".

I shamelessly use my own example;

When I was first getting my SEO blog going, I didn't care so much about getting tons of traffic, because I knew I was just starting to blog about SEO, and thus it wouldn't be my best content. It was more for practice, and to have some content there to build upon. So why not have some fun right?

And as I imply, the "ingredients" as described above do not always have to follow this formula, depending upon your audience and industry and even goals.

Where / How The Title Appears Around the Web

When you come up with a great title, where do you put it? Should it always go in your title tag? Header?

Most often, some version of your title is going to be in three places;

Title Tag
Header (which should be the H1)
URL (in a "clean" format, with hyphens etc).

But there are exceptions and considerations. A balance needs to be found between what will appear on-site, in the SERPs in social media or even bookmarking. Some things to keep in mind about each;

1. The SERPs

1.The title tag IS the anchor text in the SERPs (unless Google decides to change it).

I know this is basic, but SO important to remember when we're composing the title tag not only for rankings but CTR. Doesn't help if it ranks but no one clicks!

2. (In My Opinion) The Title Tag Should Be 50% for SEO and 50% for clicks

What do I mean by this? Good practice technical SEO (for ranking) says to put your most important keyword/keyphrase in the title tag, and as close to the front as possible. I'm speaking more about blog posts in this case, but I feel that if the keyword needs to be towards the end, or split up/modified in some way, to create a click worthy title, this is essential. Obviously if you're trying to rank a page for an extremely competitive keyword in the e-commerce space for example, this is going to differ, but that case may be extreme.

3. URLs - This is where you can win for rankings!!

Look at the URL in Avinash's post;

His TITLE (with "change or perish" is click worthy) but his URL does not need "change or perish". Keep your URLs as clean, focused and optimized as possible. This again is simply my opinion and experience and what I would recommend to clients in most cases. I even recommend switching the order of your words in the URL to get the keywords in the front of the URL, if this was not possible in the title tag.

The header will likely NOT appear in the SERPs, unless it ends up in the description.

2. Twitter

What I find unique about Twitter is, the link anchor text is not the title, which differs from most other places on the web. Thus why I like Twitter as a tool for experimentation, because you can change the headline easily just by writing a new tweet, but it is important to know where the title can come from.

Via The Tweet Button

Normally, what will auto-fill by default is the title tag;

Yet another reason to optimize your title tag for CTR!!!

You can of course control to an extent what text auto-fills via the tweet button, and I recommend starting with the Twitter documentation for this.

What The User Inputs

Often it's the case that people will create their own text to tweet a link, but in many cases they will just copy your page header (this is what I do anyway if just sharing quickly) because it's the easiest thing to do. In many cases, your CMS (WordPress for example) will make your title tag and header the same thing by default (and also add the website name at the end of the title tag).

Twitter and URLs

This is an interesting and outlying example that Rand pointed out, where the URL can potentially help CTR. That is, when you hover over most URLs in Twitter, you can see the full URL as you hover;

Very useful, and this for me will make or break a click 100% of the time. I always hover before clicking. Obviously this is limited to desktop/laptop devices :-)

But here you can see that is not always the case, and in this case I am much less likely to click;

3. Facebook

Ahh... Facebook and the Open Graph. This is where things get interesting for sure. I remember when I first was learning about the Facebook like/share/recommend buttons, I was confused how it all worked. In short though - you have to properly add the Facebook open graph meta tags to your site to control what appears when people use Facebook share buttons, and even to an extent, when people simply cut and paste a link into Facebook.

And I would highly recommend reading this post and especially ---> this post by Aaron Friedman on Search Engine Land for more details on controlling your Facebook titles around the web.

4. Google Plus

As expected, Goolge Plus uses your title tag for the title of a link when sharing;

It's OK to share stuff about Facebook on Google Plus right?

So to conclude for implementation, in general:

Write Title Tags for CTR with enough SEO to help rankings.
Write URLs mainly for SEO but descriptive enough for clicks. Keep them clean looking.
Write Headers that closely match your title but also look and feel great on-page.
While all three elements should contain your core keyword, the three elements do not have to be exactly the same.

Analyzing The Effectiveness Of Your Titles

While an in depth technique for measuring CTR is out of the scope of this post (it still seems CTR is one of those Holy Grail metrics for SEO - deceptively hard to calculate average CTR and even actual CTR for specific sites. Not just in SERPs, but everywhere around the web. If SEOmoz developed a way to truly and accurately measure this, I would use it! Do you agree?) .. I can however point you to a few resources, which can help you get a basic feel for how your CTR is going;

Bit.ly Data

There are many options for URL shorteners, but I personally use and like bit.ly, so we'll focus on that here.

First, I recommend reading bit.ly's documentation on how they capture data and display metrics.

Secondly, Rand mentions how if you add the + (plus) sign to the end of any bit.ly URL, you can see the stats for that link. This is awesome!!

For instance, take someone like Tim Ferriss, who has a relatively high amount of followers on Twitter. I can take a link he's shared on Twitter and see how many clicks its received. Not only that, I can look through his entire list of publically shortened URLs.

That said, I'm sure there are technical geniuses who can figure out a more robust method to measuring and using publically available data like this, but just eyeballing it is worthwhile, to study what titles have been effective.

External Resources

Click Through Rate For Twitter - Rand wrote a great post, which attempts to measure Twitter CTR in conjunction with some other interesting metrics.

SERP Turkey - The new tool by Tom Anthony, which allows you to test CTR in the SERPs. Admittedly I have not tried it yet, but would also like to say it deserves more attention! Richard Baxter wrote about it here in a fantastic post about how search intention may influence CTR.

Practice Writing Titles!

A/B Test Titles

Again, using bit.ly, you can;

Create two (or more if you want to go nuts) short links to the same article.
Tweet them both using two versions of the title in your tweet - try to keep other variables as similar as possible.
Look at your bit.ly stats and see which one got more clicks and shares.

This isn't to be scientific, as much as to practice and have fun!!

Re-Write Other People's Titles

I love this one. I regularly will compose tweets to other people's content and write my own title, use bit.ly and measure the clicks. Again, we're just having fun and practicing here, not necessarily being super scientific.

Write Ten Titles in 60 Seconds

Sometime you just have to get those ideas moving. Try setting a timer and jot down ten titles as fast as you can!! Just do it!! The creative moment can be a powerful thing.

Study Non-Web Sources

As Gianluca pointed out in his comments to Rand's post, look at how newspapers and editorial print publications compose titles. This is not a new concept, in fact as you'll learn in Made To Stick, the idea of crafting a lead has been around a long time!! You can gain a lot of inspiration from non-web sources.

Try Identifying the "Ingredients" Of Any Given Title;

Curiosity
Benefit
Emotion
Tangible
Appearance
Sound
Expectation

Inspiration & Resources

The Class I'd Like to Teach - 37Signals - Love this little piece by co-founder Jason Fried. He talks about writing a "one sentence paper" but the spirit of it certainly applies to titles.

6 Tips for Improving Twitter CTR - Get Elastic - Fantastic article with a wide variety of suggestions for improving CTR in Twitter (not just Titles), but things like link placement, length, word types etc.

Irresistible Headlines - Jonathan Fields - I confess, a few of my "ingredient" ideas for titles came from this post, and although Jonathan's SEO tips are pretty basic, there's some fantastic idea in this post. One interesting suggestion he makes is that the use of numbers, specifically the number '7' has shown highest success.

Anything You Want - Derek Sivers - Founder of CDBaby, Derek Sivers (I think) is brilliant at tangible little headlines. His work in general is of inspiration. But specifically, in his book "Anything You Want" he tells an interesting story about the value of user feedback when sending out huge bulk emails to their mailing list. If one sentence was slightly unclear, they'd get thousands of confused replies back, that would take $5,000 of man-hours to respond to. Many of us do not get this type of feedback loop from our webpages and titles. If something is unclear or uninspiring, all we get is silence. He makes the point - imagine you were to email thousands of people your webpage/article - would you get lots of confused replies back? To that I'd add - imagine your title was the subject of the email. Would it get opened?

Made To Stick Resources - The Heath Brothers - Previously mentioned a few times in this post, I probably learned the most about crafting a good title and making your words and ideas stick from their book. Highly recommend you check it out!

The Thesaurus - One of my favorite SEO tools!! Helps you find that perfect word.

Final Thought: Titles Are Timeless

Perhaps what I love most is the skill of crafting a click worthy title is timeless. While so many things in SEO change so fast, this is at least one facet that is deeply rooted in the past, and will thus endure for a long time.

To me, it's worthwhile and inspiring to step back and identify these timeless elements in a field that changes so rapidly. And it helps me remember that, despite the strong technical aspects to SEO, there is plenty of room for art and humanity. That, and we'll still all have jobs in 20 years :-)

What Did You Think?

As mentioned, this was my first YouMoz. *Wild Applause!!* Perhaps a bit overdue by my standards (I'd drafted and scrapped two posts prior to settling on this one). I would LOVE to hear your comments, suggestions and questions below: I will respond to all, promise :-)

You can also hit me up on Twitter.

The 10 Golden Rules to Attracting Authority Links

neilpatel — 2012-02-01T22:08:14+01:00

Posted by neilpatel

In the world of link building, getting an authority link to your site/blog has been one of the most important aspects of growing your blog. Back in 2009 Page Level Link Metrics and Domain Level Authority Features accounted for over 46% of your pages own authority:

In 2011, that percentage has dropped, but only by 4% [42.58%], suggesting that link building will continue to be a critical factor to your blog/website’s success.

But we pretty much know that not just any link will do. The better the site the link is coming from, the better the link.

That’s why your link-building campaigns need to be built around attracting authority links. But how do you do that? And what exactly is an authority link? Let me explain.

Absolute and relative authority links explained

There are two types of authorities. There are the absolute authority sites like Huffington Post, The Daily Beast and Google’s blog. These sites are also labeled “informational” authorities versus navigational authorities like DMOZ.

On the other hand, you also have relative authority sites. These are sites run by bloggers or webmasters that are authorities in a niche. Bloggers like Robert Scoble, Dooce or Mashable are authorities in their markets. While the link juice they’ll give you if they link to you is not as high as what an absolute authority site could give you…they are definitely worth attracting.

But how do you actually get a link from these sites? Here are the ten golden rules to attracting authority links.

Rule 1: Write content that attracts Editorial In-content Links

The most fundamental tactic of attracting authority links is to write content that is worth a link. What does this content look like?

Cornerstone – this content fills an obvious gap in the web information world that you fill with expert advice, detailed posts and well-reasoned arguments. This content will also define you, so it’s important to establish up front what your blog/site is going to focus on. This is also a large portion of the content you share.
Personal content – About a quarter or less of the content should contain personal stories about yourself that helps your readers to understand who you are and where you come from. My How Being a Patel Made Me Somewhat Successful is a great example. It stays within the cornerstone content of the site, but it gives you a peek into my personal life.
Spicy content – This is a small fraction of your content and is made up of controversial posts you write about. Typically you attack a high-profile idea or person or explain why something popular is really dumb. These are for linkbait purposes typically, but generally also give your readers an idea of who you are.

Building up a blog/site with this kind of content will take time, so you may not pick up a natural authority link out of the gate. Better yet, once you have a solid archive of content, approach these authority sites and ask for a link. Give them a good reason, which could be one of the following:

You wrote about the author and now he might be interested in sharing with his circle the blog post that you published.
You wrote a post that works well with a series that he wrote our compliments it. You could even critique something he or she did, which might spark an across-blog debate. If that sparks a firestorm of other responses…then you’ve won!

Rule 2: Fix other people’s broken links

Links die all the time. People shut down website or pull web pages. When these documents or sites vanish all the links pointing to them are dead.

For example, if you work through a web page by a publisher who links out a lot and the page is a few years old, you are bound to find at least one or two dead links on that page. Work through the entire site and you could find dozens.

Mashable is a good example of a site that links out a lot and will probably have a lot of dead links on older pages since they tend to report on startups that don’t always last.

You can easily solve this in 2 ways:

Manual - Make a list of all the dead links you find, then approach the author of those pages. It’s better if you focus on one author/one person and offer several options for content instead of having to contact different authors for each dead link. That can become an administrative nightmare.
Link validator – Use a tool like the W3C’s Link Checker to find dead links on a website or blog. It’s pretty easy to do. Here are the steps I took to check Mashable.

Drop link into sub form:

Choose your options:

Click “done” and then wait 644.47 seconds:

You can then work your way through the status report:

From that report you can build a list of dead links, the pages that need to replaced and the authors you can approach if it is a multi-author site like Mashable.

Rule 3: Create a desirable image library

If you have high-quality images on our site, you can use those images as an incentive to get people to link to you. Imagine you have a gallery of large, high-resolution pictures…well, then offer a contact form that allows a person to grab the file and linking code right there on the page.

You don’t have to go all out like a photl.com:

Or freepixels.com:

But more like a Haw-lin:

The last site specialize in photos, for you though being a content publisher looking for ranking juice, you could build a sub-domain devoted to photos like these.

Here’s what you have to do, though.

Hire a decent amateur photographer - If you are not a good photographer and to keep it inexpensive you could hire a local photographer who is good but not really good to charge outlandish fees.
Use your phone - Now a days, however, most cameras on smart phones can take high-quality photos. It’s often the skill of taking a good picture…like having the right angle and light…that a decent photographer should know about. In any case, the better the photos, the more likely you will get interest in the images.

And to help you benefit fully from this tactic, keep this in mind when building a library of images:

The higher the quality of each image the better link building potential these photos will have.
Search out affordable ways to take pictures. This could mean hiring a inexpensive photographer or buying a decent smart phone with a great camera.
Each image should be posted on its own page.
The delivery service should be as easy as possible. Test different set ups and use the one that makes adoption easy.
Add images on a schedule, whether one a day or once a week.

Rule 4: Offer to write a column or do a guest post

Giving a publisher practical, highly-researched content as a guest post is a great way to get links to your site from him or her.

Keep in mind this tactic typically be easier to pull off for those relative authority content sites than absolute authority sites due to their blogging policy. But if you have a guest posting strategy that involves focusing on building links, traffic and exposure via guest posting on a select few relative authority sites, you’ll eventually have an arsenal of content that you can pitch to the absolute authority sites.

Some authority sites like Open Forum or Huffington Post have so much need for content that you can usually get a post on there. But you typically still have to provide a portfolio of posts so they can understand what level of writing you are at and not just someone off the street.

Here are some resource to help you write, submit and get published guest posts:

A Quick and Dirty Guide to Writing Your First Guest Post
Neil Patel’s Guide to Writing Popular Blog Posts
Write a Guest Post for I Will Teach You to Be Rich (while Ramit Sethi focuses on tips on how to write for his blog…they are valuable for any blog, really.)
Why Submit Your Best Posts as Guest Posts?
How to Land a Guest Post Without Fail: 21 Secret Tips

Rule 5: Go to where your target audience hangs out

As bloggers and people of the internet we often forget about all of the face-to-face connections that can provide us with valuable links from relative or absolute authority site publishers.

For example, travel to conferences and hook up with some of the people you want to influence and convince to link to your site. Don’t be a pest to these people, but hang out, be cool to them, and then leave them alone for the rest of the events. You then need to go to the after-event event at the bar. This is where you can make things happen by simply buying them a drink or two.

If you really want to take it to another level, offer to take them out for dinner and pick up the check. During that dinner suggest they link to you in some purposeful way…perhaps you offer to create an infographics or a beginner’s guide.

But even if you don’t get some agreement like that you can say as you grab the check, “No, let me get this. You give me a link or something.”

That way the person thinks, “A $50 dinner for a link? You got it.”

Rule 6: Fill gaps in content

As I mentioned above, when you are talking to content publishers, ask them what content they are missing…and offer to create it for them. It could be a video interview of Guy Kawaski or a periodic table of the fundamentals of link building. It could be an idea they’ve had for an ebook.

Whatever it is, offer to create it for them.

Once you create the content you will get the credit as a link back to your site. Make sure you offer content that you can create professionally and will attract people who are in your target audience. Creating a weight-loss calculator for a site when you are in real estate will drive traffic to your site…but it will be the wrong traffic. You might as well done nothing.

Rule 7: Contact big media at the right time

When you are trying to attract the attention of big media sites like CNN or The Economist, knowing when they publish their content is important.

For those sites who are less tied to a content schedule, like a Drudge Report, you will not need to know when they publish their links because they do it pretty much as the story breaks.

Still, having some kind of bead on when that time is will improve your chances. Here’s a guideline to follow:

For many absolute authorities like the one I mentioned above, you can be certain that they will plan Monday’s content on Sunday.
Around 6:30 am to 9:30 am, the media staff will put together a list of their top 15 stories for the day. This is the news list. Contacting them during this time is more likely to influence their decision even more than if you called or emailed them the day before.
The next step for the media staff is to present the completed list of news stories to a team who will then decide which stories will get front page billing. This usually happens around 9:30 am to noon. This is your last chance to send anything. Do it now, because unless you have something spectacular, sending anything over after 1 pm will end up in the trash.

And even if you do get coverage…it won’t be a lot and it probably won’t be a link. Late content entries are typically reduced to the show that doesn’t impact SEO at all.

8. Approach government or education sites

A sure sign of an authority site is a .edu or .gov. This could be a link from a college like Harvard or Stanford or a link from the White House or Usability.gov. Getting those links are not always easy.

One example is to look for ways you can register accounts with these institutions. For example, Harvard has The Harvard H20 Playlist Project. It’s simply a series of links to books, articles or content that hopes to spark content.

Simply create a playlist and add a link to a useful post inside your site.

Creating meaningful, researched content or break an interesting story and these sites might naturally attract these sites might link to you. Examples of content that you could write that might actually grab their attention include:

Write a solid, thorough review about one of their programs, pulling in information from historical data sets, current events and future predictions. This will likely catch their eye.
Sponsor a student event. This will not cost very much.
Volunteer to be a guest speaker for graduates.
Approach their business school and offer to be a case study.

The kind of content you could create that would attract a government link could be:

Create a community page/sub-domain on your site that supports some club or event in your city.
Create content that supports some sort of charitable cause.
Put on an event. Not only the .gov sites will approach you, but the local press will do so as well.
Run for an office in your community. The commitment is usually low, so it’s not like you will be consumed with it.

In some cases you will just have to approach these institutions. When you do, you are more likely to get an answer however, and a positive one at that, if you inspect their site, identify the content gaps and then offer to fill them.

Again, it’s going to be important that you have something to show that you can pull off the content professionally, so don’t try this tactic until you have a good catalog of posts in your archives.

9. Buy links without penalty

It’s no secret that buying links violates Google’s policy and the penalty can be very stiff. So you may be wonder why I’m suggesting you buy links.

There are ways to buy links that will not be a violation of Google’s policy. Here are two:

Donate to a charity – Depending on how much you donate, some organizations will display you name and donation amount on their sites.
Offer to pay influential bloggers to post on your site – The content is simple. Give an authoritative blogger some kind of incentive like cash to write a post you can post on your site. In all likelihood they’ll link to it once it’s published.
Fund research – Sometimes when you fund research projects people will link back to your website to show people who provided them with the funding. It’s their way of saying “thanks” and showing appreciation.

As you can see these examples are based on an exchange of value between two people and their websites that can relate to the relevancy of content…so it’s an ethical way of buying links.

Rule 10: Know the difference between a good and a bad site

Finally, one of the most fundamental rules to link building is knowing the difference between a good website and a bad one. This might sound obvious but it’s sometimes easy to get tricked into asking a site that looks like an authority but is in reality spammy.

What are the elements that determine if a website is a bad one? Here are five ways:

Negative PPC – If you come across a site that has SEO links based on pills, casinos or porn, then it’s not a good site to get a link from.
Link overload – Also avoid sites that have a high link-to-content ratio. Anything above 20% links to 80% content is probably too high.
Keyword stuffing – Some sites that rank high in search engines will be notorious for keyword stuff. You’re first clue is the title description. If it looks like someone treated it like a keyword meta tag, they are probably employing spam techniques elsewhere, too. Perhaps it’s in the footer, behind images or in the source code.:
Ad overload – These sites will be like a sore thumb when it comes to the number of ads they have. They’ll have ads down both sidebars, above the header and multiple times throughout the content.
Poor content - Another clue this is not a great site is the low content-to-ad ratio. This one can be tricky because even absolute authority sites can push the limits when it comes to displaying ads. Look at Marketing Pilgrim, for example:

Ads easily dominate 2/3 of the real estate. But it’s a legitimate website with pretty good content. If that’s the case, then evaluate the copy. Is it well written, heavily researched and specific? Is there an author attached to it? Is there a convincing author bio page? These are all elements you need to look at to determine whether you should write a guest post for them or not.

Poor design – Does the site look like they used a free theme? Are the fonts irregular in size or shape? These are usually signs that someone has not spent anyone on the site…which is a signal they could be spammers.

Conclusion

Trust me when I say that you will not be wasting your time if you invest it in attracting authority links to your website or blog. Remember: nearly half of what determines the rank of your site is based upon the types of links driving to your site. Hopefully this guide has given you the tips and the tools necessary to help you succeed.

About the author: Neil Patel is the co-founder of KISSmetrics, an analytics provider that helps companies make better business decisions.

Find New Keywords: Simplifying Keyword Research

Karen Semyan — 2012-02-01T14:12:35+01:00

Posted by Karen Semyan

In December, we rolled out branded keyword rules and metrics to campaigns to help you segment your branded traffic. Now, we’re excited to introduce a companion feature to make your keyword research easier: Find New Keywords. With this feature, you can view keywords sending you organic search traffic, filter on your brand rules, and determine if you want to track them in your campaign.

First, the basics.

You’ll discover the Find New Keywords feature in a tab under your Manage Keywords section. (This feature requires that you connect your campaign to Google Analytics, so if you’re not connected to GA, you’ll find instructions on how to do this on the Find New Keywords tab.)

But wait, where did the Manage Brand Rules page go?! We’ve moved your brand rules page into a tab under Manage Keywords, as well, so you can easily move among these sections as you manage your keywords.

Now, on to the hunt for new keywords!

1. View the top 200 keywords sending you traffic that you’re not currently tracking.

Why stop at 200? We want to make it easier for you to add the keywords that may be most interesting to track because they are branded terms or common words heavily associated by searchers with your site. After that, you can go straight to GA to manually grab more terms. If we see high demand for showing more keywords, we’ll consider showing more terms in the future (so let us know what you think!).

2. Decide which keywords are candidates for tracking.
We show you a number of factors:

Keyword's position or "rank" in your current list of 200 keywords sending you organic search traffic.
Keyword’s traffic from the last week and last four weeks.
Branded vs, non-branded keyword filters, based on your brand rules.
Quick access to a full keyword analysis for keyword difficulty and full SERP analysis.

3. Add keywords of interest to your managed keywords list.
With some information in hand about the keyword’s relationship to your brand, traffic, difficulty, and SERP analysis details, you’re on your way to finding some keywords of interest to track.

One thing to note: If you are tracking all 200 (which we don’t necessarily recommend--please make your choices carefully), you’ll see a message telling you to check later for new keywords that have moved up the list.

We’d love to know what you think of the feature, so let us know! Leave a comment right here, e-mail help@seomoz.org, or share a feature suggestion in our feature request forum. Happy keyword finding!

The SEOmoz Help Team: How We Do Customer Service

Aaron Wheeler — 2012-01-31T21:51:49+01:00

Posted by Aaron Wheeler

If you're reading this blog, congratulations! You are a customer of SEOmoz. I've probably personally spoken to at least a few of you, and provided help and support to many more of you. Have you ever wondered how SEOmoz supports 15,000 PRO members and over 250,000 free members and blog readers? After all, Roger can't personally answer every email we receive here. He's not Santa Claus! Instead, the six mozzers that make up the Help Team answer all of the emails, phone calls, and chat requests we get every day. I want to tell you a little bit more about them and give you a look at the way we've built the SEOmoz support channels to meet our overall goal: to provide the best customer service on the planet. It's a hard goal to reach, but I can't think of any more worthwhile endeavor.

The Help Teamsters

Crissy Hall

Crissy is old school! She came to SEOmoz in the spring of 2010. Back then, the Help Team was just Sarah Bird (our COO) and Crissy, and I joined soon after. She loves the fact that she’s been able to watch our team and SEOmoz grow since she started. Things are always changing with our site and tools, and as she says, it keeps us on our toes! Her favorite part of working at SEOmoz is the balance between fun and productivity that makes our team and company such an amazing place to work. Crissy spends her time helping users with their tool and billing questions, planning kick-ass Help Team outings (we made terrariums together last month), and helping the Marketing & Ops teams keep track of our weekly membership reporting.

When she’s not in the office, Crissy likes to take her son Sam on adventures around Seattle. She likes to sew up a storm, particularly to make clothes for her toddler (instant gratification, according to her). In the "warmer" Seattle months she rides her bicycle, named "Tom Selleck," to work and back.

Megan Singley

Megan's been a help teamster for a little over a year now and loves connecting with our users. With several years of experience in customer service, she really strives to make every interaction with SEOmoz users a positive one. Besides responding to emails, calls, and chats, Megan plans and organizes our weekly software demos and investigates billing issues to keep any possible fraudsters at bay. She's also been known to do some writing, whether it be on the SEOmoz blog or in product messages throughout the site.

When not at the MozPlex, Megan likes to watch The Daily Show and Battlestar Galactica with her cat, Lily, and her awesomely-cool-fun-amazing neighbor across the hall, me! (Those are her words of course.) She also enjoys reading anything she can get her hands on (lately, it's been The Hunger Games series) and even started a library for the office. On weekends, she hangs out with friends (including lots of fellow Mozzers), goes dancing to anything from funk & soul to 90's hip hop, and cooks as much as possible.

Kenny Martin

Kenny joined up last year and is one of our few Washington natives! He grew up in a small, sleepy Northwestern town, thus is afraid of the sun. He compensates for a lack of natural energy sources by drinking copious amounts of black coffee. Kenny spends most of his time pursuing the TAGFEE dream by diagnosing tough technical issues, getting his hands dirty with a little web design, and filming each week's Whiteboard Friday.

He never wanders off too far away from his MacBook and for this reason alone his girlfriend mistakenly thinks he loves it more than her. It's probably because most of his spare time is spent designing websites or leaning about some fantastic new technology on the internet. He also loves the Daily Show, puppies, pizza, and tacos.

Nick Sayers

Nick joined our team in September last year and got up to speed lickety-split! Like the rest of our team mates, he answers customer emails, phone calls, and live chat questions. Nick has also spear-headed our new help documentation project that gives customers the resources learn anything about SEOmoz's tool set. This effort makes our company more scalable by answering customers' questions before they call, write, or chat with us, which gives them more instant gratification, as well. Needless to say, he spends a lot of his time creating screencasts and typing up FAQs. Nick has a passion for educating and helping others, so is constantly looking for new resources to show SEOmoz's customers.

Nick enjoys film, video games, reading, and cooking. He is an avid reader of anything from Eastern Philosophy to some of the nerdiest sci-fi/fantasy novels ever written. When not at work, Nick is usually spending time with his wife and partner in crime, Becky. On most nights, they cook new recipes together, play an unhealthy amount of Left 4 Dead 2 or Skyrim, and watch movies. On the weekends, Nick and Becky explore Washington and go to retro theaters. Nick is also involved in independent film-making and has produced, written, and directed a feature film and many shorts. On the sci-fi geek front, Nick has a huge collection of memorabilia from the Alien(s) films. He also has a cat named Ash after Bruce Campbell's character in the Evil Dead series. Of course, this means Nick calls her Evil Ash when she is bad.

Chiaryn Miranda

Chiaryn is the newest addition to the team, having been here for about two months. Don't let that fool you though: she's caught up real quick-like! She's been doing customer service for a long time and is working on learning new things about SEO every day. What better place to learn, eh?

When she's not in the office, she likes to make art and take photographs. She's been working on a sketchbook that will be going on a national tour. She also likes to take trips around the beautiful Seattle waterfront with her camera. When she can, she tries to take candid portraits. Check out some of her artwork on her Art House Co-Op page. She's also an avid movie fan, with a particular love of horror movies, and reads as much as possible. In her words, she'll gobble up pretty much any nonfiction book you put in front of her. That's why we call her Turkey Miranda! Just kidding - that's not why we call her that.

Aaron Wheeler

If you've made it this far, you've probably figured out that this is me! I started at SEOmoz in the summer of 2010 and am loving every minute of being here. A couple months ago I became the manager of the Help Team, which means I do what I can to support the lovely members of our team, and provide our customers with the best service on the planet. It's a tough goal - we have very discerning customers - but a goal I think we can eventually fulfill. Some background: I studied sociology and cognitive science at UC San Diego, but starting doing SEO after graduating. Turns out that ranking for attorneys in San Diego is tough work! I left San Diego early 2010 for Seattle, and eventually found my way at SEOmoz.

Besides working at a place I love, I enjoy reading (currently Steve Jobs), watching great shows (currently my third run of Deadwood), and seeing my favorite bands in Seattle's historical music venues (this month: Junip, Nada Surf, and The Asteroids Galaxy Tour). I also enjoy trying out vegan recipes with my girlfriend, Holly Haymaker, who has the coolest name in the world and a whimsical interactive e-cards site, to boot!

What Do We Do?

You know how, sometimes, you have a question about our site and tools? Or about your account or payment? We're the people you call, email, live chat, and post to our help forums for. Unlike huge companies with call centers and many tiers of support and different people doing phones and chats, though, everyone on our team does everything. It's a great way to keep everyone fully informed about site issues and keep our support fresh and agile. That's not all we do, though! Let me show you all of the ways we keep our customers happy:

Email: Using a Robust Ticketing System

When you send an email to help@seomoz.org, it gets forwarded to our ticketing system. We use ZenDesk, the same help desk software used by companies like Groupon and Box.com. ZenDesk allows us to manage customer emails, assign them to specific people, and easily share them with engineering and product so we can get answers to questions quickly! This is important because we receive over 2,000 emails a month: way too many to respond to from a single email address effectively.

How Does It Work?

When we receive an email, the sender gets an email back with a ticket number. As you see, it gets added to our queue of tickets to reply to. We try to answer 80% of tickets within 8 hours, but if it's a situation where someone has a billing problem or can't access their account (lost password, etc.), we try to answer even faster than that. Our goal is for each member of the Help Team to answer 20 tickets per day. If we don't have the knowledge to answer a question, we'll send the ticket to our engineers and product managers to get an answer. If it's a bug, we let the customer know and open a bug fix with our Triage team. They assign the bug to an engineer, who fixes it and lets them know. Triage sends it back to us when it's fixed, and we email the customer and close the ticket.

When we close a ticket, we send a one-question survey through SurveyMonkey asking how happy we made a customer with our customer service. We try to make 90% of our customers happy, and 30% of our customers delighted. Sometimes, though, we fail to satisfy a customer. When this happens, we ask for the customer's email address and ticket number so we can get in touch and make it right. I've found that when a customer has had a bad experience, reaching out to them to make it right almost always turns the situation around.

Phones: Not a Phone Bank

We get a relatively small amount of calls at SEOmoz: about 100 to 150 a week. Makes sense, as most SEOs do their research online. =) We don't have a sales team and don't do phone marketing, so the only employees that really have phones here are in Operations or the Help Team. We get a lot of calls from potential customers asking about what we do, though we do get a few from PRO members, too. Here's a chart with our phone stats for last week:

How Does it Work?

When a person calls in to SEOmoz, they usually start out talking to Hillari, our fantastic office manager. She makes sure they're not a spambot and, when they're a lovely customer, transfers them to the Help Team pool. The first available person picks it up and starts helping! Pretty straightforward process, as you telephone users know. After the call is over, we try to create a ticket and follow up with the customer to make sure they had all their questions answered. If it's an SEO question, we refer them to the Q&A or to our list of recommended SEO consultants.

Live Chat: What You Need, When You Need It

When potential customers are browsing our software sales pages, they often have questions they want answered now. Same thing goes for existing customers with questions about a payment or their account status: these are the kinds of questions people want to know the answers to quickly. Live Chat comes to the rescue! Instead of requiring a customer to call or send in an email, we usually keep someone logged into Live Chat throughout the day so customers can get help immediately. This leads to happier customers and cuts down on our ticket and phone levels. We use the awesome chat widget SnapEngage, and installed it to a few choice pages.

How Does it Work?

Kenny coordinated with SnapEngage to create a custom view of the widget. When you click "Chat Now," it pops up a dialog box that displays three FAQs, and has a field for the email address of the customer and the question they have. When they've typed those in, all they have to do is click "Message" to open a ticket, or "Live Chat" to start talking! Interesting point: we didn't always have those three FAQs. Adding them reduced chats about these topics about 90%. Yay for preemptive answers!

After we finish chatting with a customer, the chat transcript is automatically added to ZenDesk as a ticket, where we can save it for future review and for long-term tracking. We can also follow up with a customer there. If we're offline, or if a customer chooses the "Message" option instead of the "Live Chat" option, it creates a ticket from the get-go instead.

We can also track the types of computers and browsers people are using when they chat with us, which helps us diagnose the issue faster and get an idea of what our average customer needing immediate support looks like. The chart to the left is a look at last month's chatters.

Forums & Documentation: Help More People More Quickly

We maintain both our customer service and API forums through the SEOmoz help desk. We've also started adding all of our tool documentation, videos, and walkthroughs here to make them all available in the same place. This makes our Help Desk a one-stop shop for looking at frequently asked questions, checking out known issues with the site or tools, and just generally getting more knowledgeable about how to use a PRO subscription to its fullest. It's also where we ask customers to submit feature requests.

How Does it Work?

When a customer has a question, they can go to our Help Desk and do a search for the answer, or browse existing questions and documentation. Many of the forums are straight-up questions and answers, but a lot of them are longer-form pages that are part of our documentation project. We want to document the bejewels out of our tools! Yes, there will always be questions from customers, but the more information you can put in their hands early on, the more happy they'll be, and the more scalable our service becomes.

One cool feature: the Feature Request Forum has a voting system so customers can vote on the features they want to see most. Our product team reviews this feedback to get an idea of what to prioritize and what to put further down the roadmap. It's a great way to get customers more involved in SEOmoz's future!

This, That & The Other: Events, Office Tours, Webinars, Demos, Cookies...

We do a bunch of other stuff to help our customers, and it's hard to get it all down in words! We give weekly software demos to help new customers get the most out of PRO,

represent at MozCations,

give tours of the MozPlex and help out at MozCon,

and bake plenty of cookies (you gotta help your fellow mozzers out, too!):

All in all, it's a wonderful life. SEOmoz has the best customers around, and there's no other place I'd rather be. I'd love to share more with you and hear your stories about great customer service, as well as get feedback on what you'd love to see more of in the customer service biznez. Please feel free to write me in the comments, shoot me an email, or tweet me at @aaron_wheeler. See you around the site!

5 Steps To Bootstrapping Your PR Efforts

AndrewDumont — 2012-01-30T21:12:23+01:00

Posted by AndrewDumont

Public relations is just one of those things.

It's something that every company knows they should do, but only see two ways of making it happen -- hire an expensive PR firm or cross their fingers and hope for the best. The latter is, well, not really much of a PR strategy. There is a third option, however.

Bootstrapping.

I've written in the past about how to bootstrap your PR efforts, but never really dug into the nitty gritty. It's a time intensive process, but if you're up for the challenge, getting coverage in some of the top outlets in the world is possible, and even likely. I've tried many methods, failed many times, and ultimately boiled it down to this process.

Here it is, Moz family.

Step 1 - The Mirror Check

The first step is what I like to call the mirror check, something that gets glossed over far too often. You need to put yourself in the mind of a writer. People don't want to read shit stories, and writers don't want to write them; it's a simple relationship. Before you dig into the rest of the process, make sure you've got a story that you'd be interested in reading. Honestly. If you can't look yourself in the mirror and say that you would love to read what you're pitching, hold off.

Save your time, and more importantly, everyone else's.

Step 2 - Building Your Publication List

Once you've got a solid story, it's time to start building your list of publications. I've found it helpful to break it into larger categories, such as tech blogs, mainstream media, local press, niché publications and so on. That'll give you a good outline to begin digging into the specific publications you're looking to reach out to.

It's important to note that PR isn't a numbers game, as many think. It's a quality and relevance game, not a shotgun spray. To determine relevance, you really need to engulf yourself in the content of the publication -- read at least 5 articles. Without reading the content, you aren't able to truly understand the writing style and typical news they cover. Once you've done this, add only the publications that would be interested in your story, and omit those that wouldn't. It'll save you time when we get to the next step.

Step 3 - Finding the Right Contact

This is so important that it deserves its own step. Again, it's all about relevance, even more so when you're looking for the right person to pitch your story to. What's the sweet spot for one writer, may be completely irrelevant to another. If you pitch the wrong one, well, you blew your shot. You've got to dig deep on this step. Here's the info that my list usually contains:

The first three fields are fairly self explanatory, then we get into the meat of it. The "relevance point" refers to the overlap with the writer's past work. A good way of finding the right person to pitch your story to, is to go to the publication and search for relevant content.

For example, if I'm looking pitch an article on company culture, the best way to find the right person is to search the publication for the term "Company Culture". Crazy, I know. This will bring up a great list of past content that you can dig through to find the writer that normally covers the type of story you're pitching.

Once you've got the right person, the real investigative work starts happening. Depending on the publication, when you click the author's name, you're usually taken to a page with their contact info, bio, social profiles and the like. If you're not as lucky, you'll have to resort to a good ol' Google search (or Bing search :) to find what you're looking for.

For each author, I like to make sure I've got at least their Twitter handle, Linkedin profile, Facebook profile and personal site (if they have one). What this allows you to do, is not only track down an email address in most cases, but it also allows you to gain a good understanding of their personality. Make note of things they like, what they've done recently, where they're located -- it's all publicly available, and goes a long way in making you stand out. Like anyone else, writers appreciate when you take the time to do it right. Drop these hints of deep research in your pitch.

Finally, if you aren't able to track down their email address, use tools like Rapportive to help in guessing the right contact address. If it clicks and data appears, you've got the right email address.

Step 4 - Crafting Your Pitch and Subject Line

A lot of people mess up on the pitch, the eventual email that gets sent off. They get wordy, dance around the purpose of the email, attach a press release and ultimately fail miserably. Like this kid. The pitch needs to show relevance, be compelling and maintain brevity.

To provide an example, here's a pitch that I've used in the past:

Subject: Introducing Leatherbound, An eBook Search Engine Built in 48-Hours

Hope you’re well, *editor name.*

Wanted to pass this along for a potential post on *publication name,* as I thought it was a good fit after your post on climbing eBook sales.

The Pitch - We’ve been knee-deep in code for the past 48 hours during Rails Rumble, a worldwide developer competition. The result, a beautiful web app called Leatherbound that makes the search for eBooks simple, powerful, and efficient.

The Problem - The reading experience on Kindle, iBook and Nook apps are nearly identical, yet it’s extremely tedious to find the book you’re looking for, at the price you want for each platform. Sometimes the book is cheaper on Kindle, other times iBookstore doesn’t have what you’re looking for, but Nook does. That’s where Leatherbound comes into play.

The site is dead simple, as it should be. Enter any book title or author and Leatherbound pulls book results on the iBookstore, Kindle and Nook in a single click, along with price, availability, description, etc.

Here’s a good example of the site at work -- not bad for 48 hours of work, if I do say so myself. ; )

Feel free to reach out if you need more info or want to chat, thought it’d be an awesome post for you guys.

Cheers,

@AndrewDumont

There's a few subtleties to highlight here. First, you've really got to take advantage of the subject line, craft it as if you were writing the article yourself -- turn the mirror your way. Pull the core "hooks" from your pitch and blend them together for your subject. Make it count, it's a make or break piece.

Next, you've got to keep it brief and call out the important parts. I usually like to clearly call out (in bold) the problem that the product is solving, the pitch, and a quick way to see what you're pitching in action. With the number of emails that a writer gets each day, you've got a second or two to grab their attention, this tells them exactly where to look for the info they need.

Finally, I try and add a little personality to it that matches up well with the personality of the writer (as I learn from their social profiles) -- no one wants to cover dull. Have fun with it, and allow them to find more info on you with your signature.

Step 5 - Let it Rip

Or, you could make it rain. Whichever you prefer.

This is the culmination of all the work you've put in. Obviously, you can't always time your news in the case of product launches and breaking news, but I've found that Sunday evening is a great time to put it out there. Most folks are lazy, and they aren't willing to put in the time on a Sunday, this leaves a nice window for your pitch and a Monday release date in most cases. It's not a necessity, but it may give you the best odds.

Also, this sounds obvious, but make sure you're ready for responses to your pitch. If the writer is interested, you'll hear back and they'll want more info. Respect their time and get back to them as soon as you can.

The rest is out of your hands.

Some General Don'ts

Before we wrap this up, I want to go over some general don'ts with PR. By no means is this list comprehensive, but it'll steer you away from the big screw-ups.

Avoid the Embargo - Generally speaking, writers don't like embargoes. It's a liability and a pain in the ass that many would like to avoid. Send your news out when it's ready and available for consumption.
Lose the Press Release - In my mind, the press release is dead. They're bloated, impersonal and a thing of the past. If you just want links on Yahoo! news, sure, go for it. It's not going to give you the coverage that's really valuable, though. At the very least, make sure not to attach a press release to your pitch. Do it for me, please.
Don't Double Pitch - Don't send the same pitch to multiple people at the same publication. It shows that you're just firing off as many emails as you can, and it's a sure way to get you ignored.
Skip the General Address - Most publications recommend that you send to a generic email address like news@publication.com, it's the catch-all for poor pitches. People that don't want to see success usually go this route, it's the easy way to spray the shotgun, but it rarely yields results. Use it as your last option, but not the default.
Put Down the Phone - This may be unconventional for most folks that do PR, but I believe that we live in a digital age, where phones are a secondary thing. Sure, if there's interest, hop on a call by all means. But don't do your pitching via a phone call. It catches folks off guard, and makes the encounter confrontational, with only a few seconds to tell them what they want to hear.
Don't Suck - Most importantly, don't suck. Be a good person, not someone that's just on the hunt for links. Provide the writer with value, help them do their job and be awesome. It's amazing what good intent can do.

Conclusion

Executing on a PR push is time intensive, and demanding of finesse. It's why PR firms demand upwards of $15,000/month, with no guarantee on output. I'm not a public relations pro. By no means is this the end all be all of PR processes, but it's what I've found to be successful in landing press -- earning coverage in Wired, The Wall Street Journal, TechCrunch, Fast Company, Mashable and many more. That said, what worked for me, may not work for all.

As with everything in tech, iterate, iterate, iterate.

If you run across any specific questions as you're working through it, feel free to drop them in the comments or just shoot me a line, I'm always happy to help.

Go forth!