Classifying keywords with the fuzzyjoin R package

A few months ago I tweeted a complex (and tedious) Excel formula on how to classify keywords: For the #seo who insists on completing their keyword/intent research in excel Philosophy: keyword intent is not absolute so it won't fall neatly into an assigned bucket. For this reason a keyword can live under multiple conversion funnels since we can't be 100% certain. pic.twitter.com/JcTl9P11mC — Christopher Yee (@Eeysirhc) April 24, 2019 I then ended it with:...

July 19, 2019 · Christopher Yee

Long Tail Search Keywords: Volume or Length?

I stumbled upon an interesting poll last week… SEO folks. When you reference “a long tail query” do you mean: (Trying again - deleted last poll as I phrased it ambiguously. Sorry.) — Will Critchlow (@willcritchlow) May 14, 2019 …and was amazed by the sheer number of incorrect responses. Ever the skeptic, I wanted to make sure this was a real phenomenon despite the 1.2K survey responses....

May 20, 2019 · Christopher Yee

July SEO Link Round-up

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....

August 1, 2012 · Christopher Yee

Example of a Successful SEO Campaign

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!...

May 19, 2012 · Christopher Yee

21 Lessons Learned: One Year of SEO

Wow - this blog is officially ONE YEAR OLD! I have learned a lot about the art and science of search engine optimization since my journey began and I must admit it has been quite an experience. Below are some of the lessons learned these past 12 months in no particular order of importance. Want to propose an SEO change? Justify it with numbers. People search for the darn-est things....

July 18, 2011 · Christopher Yee