Category: Affiliate marketing

Google Refine data cleaning tool

PCRepairMan

Many of us find the need to do serious data refining, so I’m always happy to find a new tool to have a play with.  This time it’s Google who have released code free of charge that will help polish, refine and tidy your data.

You can split data, export in a multitude of formats, reconcile errors, change formats all within the one program. It’s particularly powerful when it comes to dividing CSV files and making new columnar data.  Google’s Refine program allows export to the Freebase Open Data Store which can pull all sorts of data in to your project and cleverly append it.

Have a peek, there’s a few useful videos to get you started:

https://code.google.com/p/google-refine/

It runs nicely in your browser from a single executable, and the extracted files are only 48MB in size.

SERPBuddy review and free trial

PCRepairMan

SERPbuddy is a premier online SERP tracker that was built by SEO professionals. For those who don’t know, SERP stands for Search Engine Results Page.

The data that SERPBuddy presents is well formatted and offers everything that people need to accurately gauge the rank and position of a search keyword for any website. There is built in reporting and management for your Keyword Rankings, Backlinks, Pagerank and Alexa Rank. The dashboard is easy to use and the software is responsive.

 

SERPBuddy review – features

SERPbuddy will notify you by email of changes in your search engine rankings, or they can just notify you when your chosen keyword reaches the first page (or if you are lucky, the top position!).  This is a nice feature as it means that you can do other things and forget the daily check.  With all of the Google updates it’s also a nice way to see if your site drops off the radar completely.

The impressive thing about  this relatively new software is the SERP buddy free trial, so you can see if it suits you.

SERPBuddy review – reports

Creating attractive, branded reports is easy, so this would suit an SEO company just as well as an individual. Simply upload your logo and you can create rather impressive reports that clients will like. You can download to PDF or email the report(s) directly to your clients. Very simple, neat and efficient.

 

More information about SERPBuddy here