I updated my aHrefs bulk link analysis script to improve its functionality by adding two features.
- The script now returns the results in a CSV file called ahrefs_results.csv
- Introduces the .map Ruby enumerable for a “cleaner” syntax
The source code for this Ruby script can be found at my Github repository.
My next task is defining individual functions to eliminate any code redundancy and ultimately speed up the API calls. Stay tuned!
This post is super late but if you didn’t know already I left my short tenure with Macy’s earlier this month and joined the SEOgadget family!
You can read my first SEOgadget blog post here.
I’m helping out Laura Lippay expand the US office so I’ll be getting a taste of both agency and startup life. Business is already booming and I’ve got so much work ahead we are looking to hire another Organic Search Strategist. Yes – that’s right – I need a partner in crime!
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.
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.
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
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.
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.
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: