Here is the first SEO case study report of the year, marking the 7th month of my SEO efforts.
I started these SEO case study reports back in mid-November, and now provide monthly updates on how my various SEO campaigns are faring.
If you want to skip all the details and get straight to the results, scroll down to the last image, as it gives a fantastic overall summary of last month’s results.
You Bought Yourself 1 More Month Sir…
In my last update, I mentioned how I was on the fence about whether or not to continue with my main SEO freelancer.
I understand that SEO takes time, but 7 months is not exactly the blink of an eye, even in the world of SEO.
I was very close to finding a replacement (see below), but after seeing a good increase on one of my harder affiliate keywords, I decided I’d give him another month. I jumped from around 100th spot to around 60th spot on Google for the keyword, and on November 5th, I wasn’t even ranked at all for it!
Unfortunately, last week the keyword dropped back down to around 100, but seems to be slowly improving again (currently 85).
It’s kind of funny. You’ll read later on in this post how I have a much better overview of my campaigns. Before I had this improved overview, I actually thought that the last 30 days SEO-wise were pretty terrible, dropping slightly overall or staying around the same at best. But now that I have a good overview, I can see that last month actually wasn’t bad at all. Pretty good, even.
So, it’s a good thing I didn’t jump the gun on “firing” my SEO guy… at least not yet.
And You Bought Yourself None
Early in the month, I was getting very frustrated with the lack of noticeable improvement on my keywords, and so had a fairly long conversation with a new possible SEO freelancer to take my current guy’s place.
He was recommended very highly to me from a friend who is having very good results with him, so I thought that my interview with him was really just a formality.
It turns out, however, that this guy was the most frustrating guy I’ve ever interviewed for a freelance job. He was extremely cocky, unprofessional, and just plain rude! He would say things such as “Listen buddy, I am the best at this…” and make assumptions on things without reading what I wrote (for example, he thought that I wanted the SEO done on my blog, and was ridiculing me for trying to target unrelated keywords on it).
So, I obviously didn’t hire him. I don’t know how my friend can stand him, heh.
SEO Firm Keywords Now Ranking
In my last update, I briefly mentioned how I hired a SEO firm for a couple of new keywords.
The 2 keywords are for my movie site and are EXTREMELY competitive, with a combined total of nearly 6 million exact searches on Google each month.
My campaign with the SEO firm started less than 2 months ago, but on January 9th, I started to rank for them!
Granted, they are only ranked 471 and 600 (dropped out of top 1,000 today) on Google, but remember that with this company I don’t have to pay them anything until I’m in the top 30, so it’s pretty much risk-free.
I haven’t gotten around to it yet, but I will be unveiling this company in a blog post soon so you guys can use them as well.
Month 6 Update
My last update gave the results up to December 14th, so in this report I will provide the stats from December 15th to January 16th.
Just a reminder that I am currently tracking 13 keywords across 2 search engines, so I won’t be able to focus on every single keyword, and will instead focus only on the ones that show the most change (good or bad).
Below is a rotating GIF comparing month 6 and month 7’s overall ranking positions:
While it may look like there was not really much improvement (if at all), it can be a bit deceiving. Be sure to keep reading…
Below is a graph of one of my main affiliate keywords that had a good spike for a while on Google. It dropped back down the past few days, but I’m hoping it will return to it’s previous level and spike again within another 4-8 weeks:
The two screenshots below are of the 2 keywords that are being handled by the SEO firm. Being ranked 500-600th is nothing to brag about, but it is free (for now) and they are very competitive:
Two months ago, my affiliate site brought in 5 leads, each worth approximately $60, making a total of roughly $300. This worked out to around a 14% conversion rate (from offer).
But last month, I oddly didn’t make a single lead! There were 27 clicks on my offer, so 14% should have brought me around 3-4 leads, but I guess the law of averages struck in full force.
Today, I finally got a lead after a 1-month dry spell, so it really gave me a much needed morale boost.
The means that I’m in the red SEO-wise for last month.
Awesome New Overview Chart
I’ve said it a number of times now, but I’ll say it again: I absolutely love RankTracker.
Watch my (already dated) screencast review of them here. If you’re doing ANY SEO at all, you’ll love this piece of software. I know I do.
Due to the large amount of customization options in Rank Tracker, I actually modified my layout halfway through writing this update so that I could give you guys a much better overview on how my campaigns fared.
I was originally going to revert back to my old layout after taking the screenshots for this post, but now that I see how useful the new layout is, I’m definitely going to keep it!
All I did was add 3 “difference” columns in each project, and temporarily changed the comparison date to 1 month and 3 months, as opposed to the previous run. What this allowed me to do was give a fantastic overview of my campaigns at a glance.
Below is screenshot of the rank changes from both 1 month ago and 3 months ago, as compared with today:
I love it! Also, now that I’ve changed the comparison date back to compare from the previous run (the previous day), I can quickly see the overall results at a glance (as opposed to individually clicking on each keyword).
So, as you can see, last month was actually not as bad as I thought! Checking your improvement daily for individual keywords can be very misleading, so it’s awesome that I can easily take a step back and take in a better picture
In any case, I’ll be back with another SEO update report next month. Hopefully month 8 will see some nice improvement and bring in more than just 1 lead!