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…

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.

Read more…

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

by Christopher Yee on 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 of perception (job description) and qualifying factors (job experience).

A small disclaimer: I make sweeping generalizations for each image so it may not apply to every position, description, experience or company.  That being said, feel free to offer your own explanations in the comments section below as I am always open to hearing how others interpret this.

Read more…

Funny and Interesting Search Phrases of 2011

by Christopher Yee on 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 you like a hurricane
  • I’m sick of hearing what rich people think
  • Page me like it’s 1997
  • A little whiskey makes me frisky
  • Dinosaurs are jesus ponies