Analyze & Strategize SEO using Logarithmic Charts

by Christopher Yee on January 25, 2013

Just like the natural world SEO traffic adheres to a Power Law, more commonly known as the long-tail or the 80-20 rule for you MBAs.  Applying this to search, it means approximately 80% of your organic traffic is attributed to the top 20% of your keywords.

When you visualize this type of data though an inherent problem occurs…

…the number of visits for the head terms far exceed that of the torso and tail keywords, thus rendering the graph useless.  And if you wanted a YoY comparison of your SEO performance?

No actionable insight – a fallacy of linear graphs.

Read more…

Bulk Link Analysis with the aHrefs API using Ruby

by Christopher Yee on December 20, 2012

One of my top blog posts this year is the bulk URL checker and has become my staple tool for HTTP checks en masse when I don’t want to fire up third party software.  This accomplishment got me hooked (on coding) and to keep my momentum going I decided to write a Ruby script which interfaced with the aHrefs API and emulate their batch analysis tool.

If you’re only interested in the bulk link analysis script then you can find it here.

It may look simple but it took me a couple hours to complete and needs some cleaning up on my part.  This file is a good start for anyone who needs a quick analysis about a list (big or small) of URLs and their links.  Regardless, I’ll continue to build upon it so it resembles that of the aHrefs tool.

What Does It Do?

The script is built with the Ruby programming language and analyzes a list of URLs in bulk by accessing the aHrefs API then responds with the appropriate data (exact match).

The current version returns the target URL and the following link metrics to the page: total backlinks, linking root domains, unique IP addresses, .COM links, .EDU links and .GOV links.  It will also indicate the remaining API calls in your account upon completion.

Read more…

Google Zeitgeist 2012: Year in Review

by Christopher Yee on December 14, 2012

2012 was such an amazing year for me I can’t even begin to describe how grateful I am for everything that has happened. Anyways, check out the “Year in Review” video by Google below…they always get me all teary-eyed.

Let’s hope for an even better 2013. =]

If you liked this video you may also want to check out the one from last year.

How to Painlessly Combine Multiple Adwords CSVs

by Christopher Yee on September 17, 2012

When I first started doing keyword research I found myself easily downloading 10+ CSV files from the Google Adwords Keyword Tool.  This became a (painful) problem because I had to manually copy and paste all the data into a single Excel file.

Fast forward a few months when I finally found the perfect solution: using the CAT function (short for CONCATENATE) within the command line.  Mac users can get started immediately with their Terminal (located in the Utilities folder); Windows users will have to download Cygwin.

Are you ready for the super secret code to painlessly aggregate all your CSV files into a single document?  Here you go…

cat *.csv >> OUTPUT_FILE.csv

Read more…

How Friendly is that SEO on Twitter?

by Christopher Yee on August 23, 2012

I occasionally browse my Twitter feed to stay in touch with SEO news and random internet shindigs.  One thing I’ve noticed is some SEO’s only interact with a certain group whereas others are more open to “outsiders.”

This social phenomenon shouldn’t be too surprising since it’s easily observable in high school where you have the popular kids, jocks, math geeks, environmentalists, goths and so forth hanging out with their own clique.  In fact, we can sum it up with one timeless quote…

Birds of a feather flock together.

With my growing interest in programming I thought it’d be fun to see who the friendliest (and not-so-friendly) SEO’s are on Twitter.

Read more…

July SEO Link Round-up

by Christopher Yee on July 31, 2012

I’ve been preoccupied this month with my recent job change so I don’t have anything insightful to share.  However, that doesn’t mean cool things aren’t happening on other websites!  Below are my top five favorite blog posts for the month.

Web Analytics Consulting: A Simple Framework For Smarter Decisions
Avinash does an incredible job detailing the different components of consulting as a web analyst.  I’ve always clumped the three aspects together but his framework has helped identify my strengths/weaknesses and what clients I should take on in the future.  That being said, I believe every SEO should be competent in data analysis (DA).

MozCon 2012 Presentation Slides
I took a quick glance at a handful of the PowerPoint slides and must admit that I’m already impressed.  There is a total of 28 downloadable decks with topics that address the recent Google algorithm updates, advanced keyword research, Excel wizardy and even project management.  I plan to plow through the ones that sound interesting this weekend with a nice hot cup of coffee.

Read more…

Goodbye CafePress, Hello Macys.com

by Christopher Yee on June 30, 2012

There are many pivotal moments in a life time and one of mine occurred earlier this month when I made the difficult decision to resign from CafePress as the in-house SEO Analyst.  After nearly two years of dedicated service I felt my time was up as my professional long-term vision no longer aligned with company goals.

This is not to say CafePress wasn’t a great place to work.  In fact, that could be further from the truth because I absolutely LOVED my time there.  I worked with some of the brightest minds in the online marketing industry and learned a lot from everyone.

Read more…

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:

Read more…

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.

Read more…

Attending SearchLove SF Conference with Distilled

by Christopher Yee on April 30, 2012

Update: Conference has unfortunately been cancelled.

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

Read more…