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

What’s In a Name – Angular.Marketing

So, I think I threw a few of you for a loop earlier today with this tweet saying that today was my last day at Virante. Technically, this is true, but not because I am leaving my beloved coworkers and business, but rather because Virante as we know it is no more. I am excited to announce that as of today, Virante is now Angular. I do want to say that I was very moved by the positive comments I received from so many of you. Why the Change Over the previous two years we have contemplated a rebrand for our company. When I first began at Virante in January 2005, we were a full service web development and marketing firm. We did everything from logos and brochures to web design and SEO. Like many small digital agencies, we did just about anything and everything we...

Dark Patterns and the Demise of Google Authorship

I won’t waste your time with yet-another-recap of the rise and fall of Google Authorship when it has already been done so nicely by the good folks at Stone Temple Consulting. Moreover, in a promise I made to myself, I will try and remain civil and polite in my brief analysis. I will begin with an open question to John Mueller, Matt Cutts and Google in general. Why should we believe this was a failed experiment and not planned obsolescence? Early in my career as an seo during the days of reciprocal link schemes, the black-hat thing to do was pretty simple. The formula is below: Create a link directory on your site Attract users of link directory, require reciprocal links Wait a few months Hide your outbound links from Google (Nofollowing “contribute...

Latest Research Project