Tag Archive: seo

Finding Buried Treasure with Google Analytics

About once a month, I use Google Analytics reports to find out if any posts are getting a lot of hits from search engines. In Analytics, I click Content, Top Landing Pages, which pulls up this report:

Top Landing Pages Report

Top Landing Pages Report

What the heck?  #5 is a joke post about SQL Server 2010′s features being leaked.  That surprises me, so next, I want to find out why users are searching for this information. I click on that page name, then click Entrance Keywords:

Entrance Keywords Report

Entrance Keywords Report

Innnteresting.  I never would have expected that this post would remain popular long after I wrote it, since it was pretty much a throwaway joke.  I bet you’ve got pages like this too – you casually wrote a blog post to address one specific issue, didn’t really think anything of it at the time, and now there’s hits coming that you didn’t expect.

Now that I know the post has gained popularity, I can make it even more successful.

Helping Search Engines Find Your Buried Treasure

We’re going to make a series of changes in order to improve our search engine rankings. Ideally, we’d be doing this legwork for every post we write, but we don’t usually have that much time, do we? After all, we’ve got day jobs.

First, edit the post’s keywords to include more of the keywords that users were searching for. This will make it rise higher in search engine rankings. If you’re using the excellent All-in-One SEO Plugin for WordPress, edit the post and scroll all the way to the bottom of the page. Fill in each of the All-in-One fields, which are empty by default:

All in One SEO Plugin for WordPress

All in One SEO Plugin for WordPress

The fields are:

  • Title – defaults to empty, which just uses the original blog post title. If you wrote a funny post title that doesn’t really match up to the content, you can override it here. This override only affects how the search engines see your content, so you can be less funny and more accurate here.
  • Keywords – use the search keywords end users used to find your page.
  • Description – a one or two sentence description of the page that will show up as a search engine summary. WordPress uses the first sentence of your blog by default, but you might want to write something more descriptive.  It’ll show up in the Google results like this:
Google Search Results with Tweaked Meta Tags

Google Search Results with Tweaked Meta Tags

Presto! A nice, clean summary sentence instead of the article’s first sentence.

To be even more effective, we can tweak our post content too. I break up every few paragraphs of my posts with a header line. This uses the H3 tag in WordPress. Search engines give more relevance to your headers, so if you want to optimize your post for search engines, try to work keywords into your header lines.

Don’t go overboard. Readers can tell when you’re being slimy. It can be a tough line to walk, but at the end of the day you have to decide whether you want to be liked by search engines or by human beings. This post is a great example – my header lines here all talk about buried treasure, which frankly isn’t going to get me any search engine traffic at all. I’m fine with that, because this post isn’t the cornerstone of my blog. This is just for you, dear reader, and I’ll drive traffic to it another way.

Helping People Find Your Buried Treasure

Do a search in your own blog looking for related posts. You’ve probably written at least a couple of entries that somehow relate back to your newly popular page. Edit those pages, and add links directing people to your treasure.

If it’s a post you’re really proud of, link to it from every single page in your site. On BrentOzar.com, I have a Popular Articles section on the side of my site. It links to several of my most searched-for posts, plus a few posts that I just happen to think are spiffy.

Making the Buried Treasure More Valuable

If people are going wild and crazy over one of your buried treasures, put some elbow grease into it and polish it up. Add pictures, add sample code, and add most importantly, add links. If someone took the time to click on your link in a search result, they’ve probably got a lot of questions. Add a section at the end of the post called Related Reading, and include your own links plus the best you’ve found on the web. If you don’t know any offhand, take a few minutes to search. If you knew enough about the subject to write about it, then you probably know enough to pick out some good links in search that the reader would like. After all, they came to you for help – they may not know the good stuff from the bad right now.

Consider expanding your post to include more information covering the keywords that people were searching for. Let’s say you wrote about truncating SQL Server log files, for example, and people have started searching for how to truncate the log in SQL Server 2008 – which is no longer supported. You could add a paragraph or section to the post explaining that BACKUP LOG WITH TRUNCATE_ONLY no longer works, and include a copy of the error message users get when they try that stunt.

This is how my epic Twitter RT FAQ post got started. Originally, it was just a short post explaining what RT meant on Twitter because people kept asking me. Over time, I added more and more questions and answers because they were showing up in the search logs, and next thing you know, I’ve got a monster post going. The drawback is that my regular readers don’t see these added entries on such an old blog post, but frankly, I don’t write that material for my regular readers. I just keep adding to that post in order to help people who keep searching for Twitter information.

Rather than adding more and more to old posts, you can also write new posts to cover new information, and build links between your existing pages and your new ones. This comes back to the Related Reading topic we discussed earlier.

Sometimes, I find that I end up writing my Related Reading posts first! I start working on a post, and I realize I need some supporting material. That’s exactly what this post is doing here – it’s going to be link in tomorrow’s post. Stay tuned!

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts

My Weekly Bookmarks for September 4th

Here’s my bookmarked links for September 1st through September 4th:

Tech Links

The Junk Drawer

These bookmarks are automatically imported from my bookmarks at Delicious.com. If you’d like to get up-to-the-minute updates on what I’m bookmarking, you can subscribe to my bookmark RSS feed.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts

My Weekly Bookmarks for August 28th

Here’s my bookmarked links for August 23rd through August 28th.  I’m using an automatic plugin to build this list, and I can see that this probably isn’t going to work – I just found way too many things interesting in one week, and it doesn’t break stuff out into categories.  Blogger fail.  Here it is anyway as an example of What Not To Do during my Better Blog Week:

These bookmarks are automatically imported from my bookmarks at Delicious.com. If you’d like to get up-to-the-minute updates on what I’m bookmarking, you can subscribe to my bookmark RSS feed.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts

Blog Better Week: The Basics of SEO

This week I’m focusing on how you can improve your blog. Yesterday I kicked things off with why you should schedule blog posts.  Tomorrow I’ll break some bad news to you – your blog is boring.

I blog to help other people.

I’m only successful if they can find me.

Avoid the hot dogs.

No, not every player is a winner.

Picture yourself walking through a carnival jam-packed with crazy idiots, insightful geniuses, and half-clothed hotties all vying for your attention.  They’re all screaming at the tops of their lungs, enticing you into their carnival tent to see their freak show.  Some are free, some cost money, and all are desperate to get you inside.  When you finally pick a tent and go in, you find that even inside the tent, while you’re trying to focus on what you went in for, there’s even more barkers inside trying to get you to go to another tent.

The Internet isn’t fair. The Internet IS a fair.

You might be crafting the smartest, most well-written blog out there, but you’re still out there, and you’re out there along with a gazillion other carnies.  Some of them are trying to make money off their booth, and they’re going to do whatever it takes – fair, slimy or otherwise – in order to get people in the door.

Your one weapon, the great equalizer, is the search engine.

Search engines want to hook their users up with the best content possible.  The better the search results, the more likely the readers are to come back to that same search engine again.  Search engines make money off ads, so they too are carnies hawking their wares.  They want to help you help them help their users. (Triple score! I just won a giant stuffed banana!)  Making your site easier for search engines is called Search Engine Optimization (SEO).

Step 1: Break your blog posts into sections.

This assumes that your posts are longer than a couple hundred words – and frankly, they need to be.  The less content you have, the less search engines have to work with.  Less isn’t more when it comes to blog posts.

For every couple/few paragraphs, throw in a header like you see here.  In WordPress, you should use Heading 3, because Headings 1 & 2 are already used for higher-level titles in your blog (like the blog title and post titles).  Use descriptive words in those headings, words that match the kinds of things people are searching for.  For examples, check out my entry last week about truncate_only, and look at what words I used.

At the same time, you have to walk the line between serving the search engines and serving readers.  If you just stuff your headings chock full o’ keywords, your blog won’t be enjoyable to read.  Make the headlines fun first, and SEO-friendly second.

Step 2: Specify summaries and keywords for your posts.

If you go to a search engine and search for SQLIO, here’s what shows up:

SQLIO Search Results

SQLIO Search Results

See the one-sentence explanations below each page title?  Read through those more closely.  Which ones look the most inviting to the readers?

In the battle for visitors, this is like your opening shot.  You only get a tiny amount of screen real estate, and every pixel counts.  Instead of making the search engine guess what your article is about or using a random sentence from your post, why not tell it exactly what to show?  You can!

If you’re using WordPress, install the All in One SEO Pack.  After installation, it’ll warn you that it must be configured.  Just go to the settings page and click the Enable radio button.  All done.  Then, when editing a blog post, you’ll have these fields at the bottom of the post:

All in One SEO Pack

All in One SEO Pack

Without the All in One SEO Pack plugin, WordPress tries to guess the post’s Title, Description and Keywords.  The plugin gives you fine-tuned control over exactly what your post is about.

I don’t set these fields on every blog post I write, because I don’t expect most of ‘em to have long-lasting search engine power.  The more work I put into a post, though, the more likely I am to put some effort into the SEO fields so that more folks can find my work.

Step 3: Publish a sitemap.xml file.

If you’re using WordPress, all you have to do is install the Google XML Sitemaps Generator plugin.  There’s not much to configure, but set yourself a reminder in your favorite task management software to check the settings once a month.  I’ve had some problems when my file permissions changed and the plugin was no longer able to write the sitemap file.  If that happens, the plugin shows instructions on how to fix it, but unless you go into the plugin’s configuration page, you’ll never know there’s a problem.  It doesn’t send an email or alert you other than showing an error on the config page.

If you’re using a different kind of blog, I got nothin’ for ya.  It’s up to you to figure out how it works.

After publishing a sitemap.xml file, sign up for Google Webmaster Tools.  It’s a completely free service that gives you valuable statistics and diagnostics about your blog, your readers and your search engine optimization.  Once a month, I log into Webmaster Tools to find out if Google’s had any problems indexing my blog.

These steps take a little work, but I’ve found that over time they make a big difference.  Of course, if you’re lazy, there’s a solution for that too.

Enter the Snake Oil: Search Engine Optimization

Wherever there’s carnivals, there’s snake oil vendors: people selling mythical potions that will cure all ailments.  In this case, the ailment is your low search engine ranking, and there’s a long list of vendors who’d love to give you a hand with that problem.

If you pay someone $500 to do search engine optimization for you and boost your search rankings, how do you know if they succeeded?  They’ll tell you that it may take days or weeks for the search engines to notice the changes.  They’ll tell you that your mileage may vary, and that all sales are final, no refunds allowed.  You might even be working on your blog yourself at the same time, and it’s impossible to tell how much improvement was due to their efforts versus yours.

Some SEO vendors do a fantastic job, but they’re priced outside the reach of most bloggers (including me).  If you’re dead set on spending money on search engine optimization, check out the book Landing Page Optimization by Tim Ash.  It explains how to build out sections of your site specifically for search engine visitors and how to get them to stick around.

I’d recommend my favorite SEO company to you here, but then I’d lose my competitive advantage.  After all, the other carnies are reading this too…

WordPress SEO Tutorial Video from Google

Matt Cutts (BlogTwitter) is a member of Google’s Webspam team.  He spoke at WordCamp San Francisco about how WordPress bloggers can make their web site more searchable.  It’s a 45-minute long video, so warm up that plate of bacon and get cozy.

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts

How to Start a Blog, Part 2: Configuring WordPress

In part 1, I talked about the basics of why you might want to blog for yourself (instead of a third party) and how to pick your domain name.  In today’s installment, I’ll cover what blog software you want to use and how to configure it.

Use Self-Hosted WordPress to Run Your Blog

There’s a bunch of ways to get your domain name up and running on the interwebz, and I think WordPress is the best because:

  • It’s open source, so it’s likely to stick around for a while
  • It’s absurdly popular, so there’s a ton of documentation on it
  • There’s a bazillion plugins to extend it in cool ways

The easiest way to get started is to use a hosting company.  BlueHost, GoDaddy, and Hostgator offer one year of web hosting for around $100. (There are many more hosting companies, but I’ve used these two for a couple of years and been very happy.) Between this and your domain name, we’re talking about $110 per year, which is a lot more than a free hosted solution, but this is an investment in your career.

After setting up your blog, it’s tempting to start working on the way it looks so that it suits your personality. I’m going to hold off on that particular topic for now because it’s a monster, and it involves designing and building a personal brand. I think that’s really important, but it needs to be a separate article. Instead, I’m going to keep going and hit the technical side of blog setup first.

Configure WordPress for Search Engine Optimization

Ugh, that phrase Search Engine Optimization is so slimy. It’s an industry of snake oil salesmen. I hate it. But here’s the reality: if people are going to find you, you have to show up in search engines, and there’s a few easy tweaks we can make to WordPress to help Google do a better job of analyzing your content.

With the WordPress default setup (as of this writing, WordPress 2.6 in late 2008) the default WordPress link to a blog post looks something like this:

http://www.myblogname.com/?p=125

That means nothing to me, and it means nothing to search engines either. Go into WordPress, Settings, Permalinks and choose Custom.  Put this in the edit box:

/archive/%year%/%monthnum%/%postname%/

And click save. (There are some people who don’t recommend using the year & month fields, and skipping those is completely OK too.)  That will make your blog post links look something like this:

http://www.myblogname.com/archive/2008/12/how-to-write-a-stored-procedure

That makes more sense to end users, and it’ll make more sense to Google too. Search engines use lots of bits of information to determine exactly what is on the web page it’s looking at, and the URL is just one part of that complicated formula.

Show the Full Post in Your RSS Feed

(Thanks to Jason Massie of StatisticsIO.com for reminding me of this one!)

Go into WordPress, Settings, Reading and set “For each article in a feed, show” to “Full text”.  That puts the full text of your blog posts in the RSS feeds.  RSS feeds are a convenient way for readers to stay on top of dozens or hundreds of blogs without pulling their hair out.

The other option is to just show the first paragraph or so in the blog post, and then force readers to click on a link to visit your blog site.  Readers hate that because it slows them down, and the whole reason they use RSS in the first place is to read more blogs faster.  Readers (me included) will simply unsubscribe from a blog that pulls that trick.

Why would people ever use that option? Because they have ads on their web site and they want people to see the ads.  We’re not that kind of people, remember, because we decided early on that we were blogging for career development, not to make $15 per month.

The All-In-One SEO Plugin

This does some behind-the-scenes housekeeping to make WordPress blogs more accessible to search engines.

To install it, go to the All-in-One SEO Plugin web site and download it.  Unzip it and FTP the contents to your web site’s /wp-content/plugins directory.  WordPress automagically detects plugins in any subdirectory of that, so I like to make a subdirectory per plugin to keep the housekeeping simple.  After uploading it, go into WordPress, Plugins, and scroll to the bottom where it lists plugins that can be activated.  Click Activate on this plugin, and you’re in business.

It works great out of the box, but if you’re really ambitious, you can pay attention to these fields when you write a blog:

Title – the text that appears in your browser’s title bar. If you look at the top of your web browser right now, the title of the program window is “Best WordPress Plugins | BrentOzar.com SQL Server DBA”. If you scroll down and look at the text at the top of the article, though, the page starts with “How to Start a Technical Blog, Part 2: WordPress.” The All-in-One SEO Plugin makes this magic happen. There’s a lot of weird science here, but in a nutshell, the Title should be very search-engine-friendly, whereas the blog article title should be short, funny and friendly. Don’t take this as the gospel truth, by the way – this is just what I hear from our SEO guys.

Description – the text shown to users when they see your web site in search engine results, like this:

Keywords – a few words or phrases that really describe what the blog post is about.  For example, in this blog entry, I might use these keywords:

  • blogging
  • WordPress
  • WordPress plugins
  • configuring WordPress

Whew – what a pain in the rear, right?  I know, I rarely screw with that stuff too.  But before you abandon hope, forget manual configuration – there’s a few more plugins we can install that’ll make it much easier for people to find your blog.

Use the Google Sitemaps Plugin and Google Webmaster Tools

This builds a sitemap file that Google’s bots use to analyze the contents of your entire web site without having to actually scan your entire web site. It’s a map of your site, and for each page, the Google Sitemaps plugin notes how often that page has been updated. That makes it easier for Google’s bots to find what’s new on your web site more frequently. This is only anecdotal evidence, but I can say that before I had a sitemap, my blog’s front page wasn’t updated very often in Google – say, maybe once a week if I was lucky. Now, Google updates its cache of my site’s front page every single day. That’s helpful because I blog about recent technology news, and when people search for information about breaking SQL Server news, they can find it on my site easier – instead of not seeing it for a week or more.

Next, tell Google about your newly created sitemap. Go to Google Webmaster Tools and set up your web site. Tell Google about your site’s sitemap, and check back a day or two later. Google Webmaster Tools will tell you about any problems it’s encountered on your site (which shouldn’t be the case if you haven’t done anything nasty in WordPress) and provide you with some interesting metrics about how many sites link to yours, how many people are reading your RSS feed, and so on.

That’s only scratching the surface of metrics, though. To really dive in, Google gives us another free tool…

Use Google Analytics

Go to http://analytics.google.com and sign up for web site reports about your site. Google will give you a small snippet of code to put on your web site. The easiest way to make that happen is to install the Google Analyticator plugin for WordPress, which will automatically insert the Google ad tracking code on every page.

Even if you don’t care how many people are reading your blog, I’d suggest setting up Analytics because if you start caring down the road, you’ll have a nice in-depth history of your site’s activity. It doesn’t cost anything, doesn’t slow your site down, and doesn’t affect your readers.

Google Analytics tracks a ton of metrics about your site. Here’s some quick definitions:

  • Visits and Pages/Hits – Visits is the number of people who came, and pages (or hits) is the number of pages that were viewed.
  • Bounce Rate – the percentage of people who saw one page and left. Obviously, you want that as low as possible.
  • Avg Time – how long people are spending on the site. I don’t think this is really useful for the site overall, but it IS useful when you’re comparing your pages. I like to know which pages people are spending the most time on, because that means they’re reading it carefully and digesting it.
  • Entry pages – Entry pages are where people came in, and no, it’s not always your home page. Search engine users will land on whatever page they found in the search engine, and referred people (folks who clicked on a link to you from some other site) land on whatever page the other site linked to.
  • Exit pages – The last page the user saw before they screamed in horror and closed their browser (or clicked on a link to go somewhere else.)

I’m a DBA, so of course I love to slice and dice my data, and that’s where Segments come in. Segments break up your audience into groups like Search Engine Traffic, Referrals (people who clicked into your site via a link) and Direct Traffic (people who came straight to your place). If you’re just getting started, then you won’t have too much data to slice and dice, but just make a mental note of that capability and come back to it in six months.

That’s a Good Start

Even if you don’t do anything else to your blog, you’ve already made a big difference in your ability to be found by readers.  But there’s a whole lot more, and in my next post, I’ll list the rest of the plugins and techniques that I use to help people interact with me.

Continue to Part 3: The Best WordPress Plugins

Brent Ozar

Brent specializes in performance tuning for SQL Server, VMware, and storage. He's one of the very few Microsoft Certified Masters of SQL Server, a published author, and a Microsoft MVP. He likes travel, Jeeps, Apple gear, jokes, and writing about himself in the third person. Read more and contact Brent.

Website - Twitter - Facebook - More Posts