How to Build a Big-Data Cluster for memSQL 4.0 on the Cheap

So, now that memSQL has rolled out a community edition which is completely free to use, I thought I might show you an easy way to build a huge cluster for cheap that you can run memSQL on quite easily. I know it works because we have been running this in production for quite some time at GREPWords and SERPScape. There isn’t really any magic to it, just finding the best hosting company for the job. What you want is a hosting company that offers a lot of exactly what you need – multi-core, high RAM servers – with no extra perks. I think I found the perfect host for this – CloudSouth. Yes, that is an affiliate link, judge for yourself if you think the prices are amazing. They keep their prices low by simply only offering a couple of types of...

Get em’ All – How to Grab All the Keywords for All the Results

Building a comprehensive keyword set can be daunting some times. There are so many potential keywords out there and trying to find every variation can be a nightmare. Well, hopefully the nightmares are gone with this new bookmarklet that comes with SERPScape. The process is simple. Install bookmarklet Search for your keyword Press bookmarklet Get CSV of every keyword that the URLs on the page rank for Tags: bookmarklet, google, keywords, PageRank, Search engine optimization, seo,...

Pop the Filter Bubble

Ever want to know which results are personalized and which are not? Are you tired of opening up an incognito window, setting the right parameters in Google, and using a proxy to get a clean result, then go back and compare the results to your initial ones? Try the Bubble Popper extension that comes with SERPScape. Tags: bubble popper,...

Daily SEO Schedule Survey

Daily SEO Schedule Survey* Number of minutes spent in Google Analytics daily* Number of Minutes Spent in Google Webmaster Tools daily* Number of Minutes Spent Checking Backlinks Daily?* Number of Minutes Spent Producing / Editing Content Daily* Number of Minutes Performing Site Audits Daily?* Number of Minutes Spent Checking Rankings Daily?* Number of Minutes Spent doing Link Outreach daily?Add your email if you want to be notified of the results when complete. No tags for this...

2015: The Year of Broken Link Building

Every year begins with a flood of questions to seo experts about their predictions or recommendations for the upcoming year. I am normally careful not to get involved into too many of these forays because they seem speculative or risky given Google’s penchant to change courses so quickly. When your target is moving so fast, so frequently, and seemingly erratically, it is hard to make predictions and recommendations. So, how should we proceed? One of the common responses is to give very generic, holistic tips like “build your brand”, or “users first”. While I think these are absolutely true, they don’t offer much in the way of actionable advice. Some of the lengthier responses by good SEOs do go into detail on these issues, and...