Example of a Successful SEO Campaign

by Christopher Yee on May 19, 2012

I love optimizing websites for search engines so much I regularly do consulting work on the side.  But what I love more than THAT is showing clients the amazing year-over-year results of a successful SEO campaign.

The data from the images below come from an eCommerce website in an extremely competitive niche.  When I first started in April 2011, they received an average of 80 visits per day; that number jumped to ~200 visits per day – a 150% increase!

Here’s how their weekly organic traffic (excludes branded terms and not provided) looks like for the past year:

And here’s the month over month comparison:

It goes without saying that looking at overall traffic doesn’t tell you much so I segmented by their product category pages (excludes branded terms and not provided):

And the month over month comparison:

And yes, I know the user engagement rates are pretty terrible but there was nothing I could do about it since getting any UX/Design changes done was like walking through a (political) mine field.

What did I do to get all this free traffic?  Nothing you probably couldn’t find reading the various blogs out there.  If you’re looking for specifics, here’s a quick hit list in the order the projects were executed:

  • Keyword Research – they just weren’t targeting the right keywords.
  • Source Code Optimization – involved many crucial on-page elements such as the title, h1 and body text.
  • Technical Infrastructure Optimization - dealt with cleaning up the domain by addressing canonicalization issues, HTTP responses and robots exclusion.
  • Internal Link Building - cross linked their various category and product pages to improve crawler access.
  • Content Creation – managed a team of two outsourced content writers for the company blog.
  • External Link Building – hired, trained and managed a team of three link builders for website outreach.
  • Digital Asset Optimization - focused primarily on image optimization.

Other things that helped was a healthy dose of optimism, perseverance to succeed and a little algorithm change from Google.

Now that I’ve shared my example, how about you leave yours in the comments below?

{ 0 comments }

Bulk URL Checker with cURL

by Christopher Yee on May 13, 2012

I discovered the Search Commander’s URL tool awhile back when I needed a scalable solution to check the HTTP status for a large list of URLs.  It worked as intended but when I tried it with 1k+ URLs I pretty much broke the checker and took down the page along with it.  Thus, in my pursuit to learn programming I said to myself, “how come I can’t build my own?”

If you’re a Mac user you can use this right away since cURL is already built into your Terminal.  For Windows users you’ll first need to download Cygwin with the cURL package.

Without further delay, here is the string for the command line with INPUT_LIST.TXT being your list of target URLs to check:

xargs curl -sw “%{url_effective}\t %{http_code}\t %{redirect_url}\\n” < INPUT_LIST.TXT

Once you hit enter you should see something like this (but with your own data):

The first column is your target URL, the second is the HTTP status and the third is the destination of the link if there was a redirect.  Want to save your results?  Just add “> OUTPUT_LIST.TXT” to the end of the string.

The only caveat is if the page returns a HTTP 200 OK response, it’ll print the URLs source code on your screen.  The solution around this is entering the following code after every website in your INPUT_LIST.TXT file:

http://www.website.com -o /dev/null

This should be pretty easy to do with a simple =CONCATENATE function in Excel.  Although if you know of a way to programmatically insert this please let me know.

Now go ahead and give it a whirl – leave any questions, suggestions or concerns in the comments section below!

{ 0 comments }

Attending SearchLove SF Conference with Distilled

by Christopher Yee on April 30, 2012

I don’t have anything major to share this month besides the fact that I will be attending Distilled’s SearchLove conference in San Francisco (not an affiliate link).  I am super excited about it and can’t believe it’s less than 1.5 months away!  If you plan to attend please let me know and we’ll meet up.

Date: June 18th-19th, 2012
Location: David Brower Center, Berkeley, CA
Price: $849
Speakers (I look forward to): Tom Critchlow, Rand Fishkin, Wil Reynolds, Annie Cushing, Justin Briggs, Kate Morris
Sessions (I look forward to): Advanced link building strategies, latest ways to measure and action your metrics, link building in the age of social media, integrating social media into your SEO activities

The only gripe I have with their marketing scheme is the fact that BERKELEY IS NOT SAN FRANCISCO.  It is a 30-45 minute drive away from The City….what an insult to us San Franciscans so get it right ya bloody blokes!

{ 0 comments }

Certified with Google Analytics

by Christopher Yee on March 10, 2012

After delaying the Google Analytics Individual Qualification exam for an entire year, I finally decided to get it over with and I passed!  Here’s a screenshot of the certification PDF they sent me.

GAIQ Certificate

Below is my score card for the GAIQ test results.

GAIQ Results

In retrospect, I should’ve used the remaining 45 minutes to double check my answers and boost up my score but my over-confidence convinced me otherwise.  At least now I know I should read up on E-commerce Tracking – probably got dinged for the technical Javascript implementation questions.

I thought the exam was pretty easy but my exposure to Google Analytics may greatly differ from your own experiences.  For example, I’ve been using Google’s web analytics platform nearly everyday for the past 2 years (including weekends) so I was already familiar with the core concepts.  The only sections where I really had to focus on getting things right was properly installing the tracking code in its various forms and the advanced administrative functions.

I pretty much crammed everything the night before but here are the steps I took to pass the test:

  1. Watch all the Conversion University videos once.
  2. Anything I didn’t understand I would watch them a second time.
  3. Took notes about how metrics are calculated, definitions and the benefits & shortcomings the training modules listed.
  4. When I was ready to take the test, I had one of my GA accounts open, my written notes, the GAIQ videos and the Analytics Help articles.
  5. I breezed through all the questions I was 100% positive about and wrote down the topical questions that required me to think more than 30 seconds.
  6. By the time I had finished all the easy answers, there was still an hour left to research the answers to the remaining questions.
  7. Win.

Best of luck to you but trust me – you won’t even have to break a sweat. =]

{ 0 comments }

So You Want To Be An SEO [Insert Position Here] ?

February 17, 2012

In the first week of January 2012, I conducted a small research project where I manually extracted the text from SEO job postings on LinkedIn and plugged them into a word cloud generator called Wordle.  I was curious to know what hiring companies nowadays are looking for when they want to fill an SEO position in terms [...]

Read more…

Funny and Interesting Search Phrases of 2011

December 31, 2011

Happy new years eve, everyone!  To continue my tradition from last year, below are the top funny and interesting search phrases for CafePress in 2011.  Enjoy! Funniest Don’t ask me, ask google The sun is trying to kill me Pow! I just shit my pants I eat my road kill Dick cheney eats kittens Barack [...]

Read more…

Google Zeitgeist 2011: Year in Review

December 17, 2011

Enjoy the new 2011 Google Zeitgeist video below. We made it. =]

Read more…

Learning to Program & Code for SEO

November 16, 2011

In the past few months I’ve taken a new interest in learning how to program and code as it applies to SEO.  This came out as a need to research and evaluate SEO campaigns in a scalable manner where popular SEO tools didn’t work for my situation or I had no engineering resources available.  It [...]

Read more…

October SEO Link Round-Up

October 31, 2011

It’s been very busy for me this month so unfortunately I do not have anything to write about.  However, I am introducing my monthly link round-up where I share some of the most link worthy blog posts out there about SEO – I guess that’s my treat. As for the trick?  Well – there is [...]

Read more…

Rank Checking with Google Docs ImportXML Function

September 20, 2011

I want to share with everyone a very quick rank checking tool that I built using the ImportXML function from Google Documents. But first, a quick history lesson… Or you can just grab the G-Doc ImportXML Rank Checker here. Historical Context I used to love rank checking when I first started out as an SEO analyst. [...]

Read more…