How to Build the Moz Keyword Difficulty Tool in Excel with Moz and SEMrush

building-tools

How exciting is that? By combining SEMrush’s “phrase_organic” with Moz’s URL Metrics API call, you can cobble together a prototype keyword difficulty tool. My example in this video is a bit scrappy, but I’m sure you get the point: Check out the rest of our instructional videos on your Youtube channel: http://www.youtube.com/user/SEOgadget No SEMrush Account? If you don’t have an SEMrush API account, get a 700,000 API credit account for $59.95 per month here: http://seogadget.com/semrush/ Don’t forget to take a look at the how to manual – download here, and of…

Find New and Lost Back Links with MajesticSEO and SEOgadget for Excel

lego-bricks

One of the most pressing issues in current SEO strategy is developing your ability to monitor new links, and track lost links. It’s a sad fact of our day to day lives as marketers in search. Some of our time doesn’t get spent on marketing at all, it gets spent on undoing bad marketing through link removal and penalty reconsideration requests. If that time’s going to get spent, let’s spend it efficiently. If you want to save yourselves some time on the day to day task of link auditing, you’re…

SEOgadget for Excel: How to Get Your Back Link Data with MajesticSEO’s API

bottle-house

One of the biggest problems we’ve always had with our new users getting to a confident user level with SEOgadget for Excel is simply put, the level of accessibility of the documentation. Learning a completely new syntax for 6 different API services is, hard. I really hope we’re helping there with the instruction manual, but I’m also in the process of recording some short videos on getting started with the tool itself. Here are the first two: How to Install SEOgadget for Excel Here’s the long over due “how to”…

Creating Efficient Data Collection Systems for SEO and Social

gears

As marketers we only have so many hours in the day. Nothing is worse than having your team spend time on menial tasks (like data entry) when there’s real work to do. That’s why it’s crucial for managers to create efficient systems – so teams can get more accomplished and make a bigger impact. Most data entry work is delegated far down the totem pole. Managers are removed from data entry, so making the process as efficient as possible isn’t always a priority. If you aren’t “technical,” it’s easy to accept…

Introducing SEOgadget for Excel

geordi-worf

For the longest time I’ve loved working with Excel in new ways. Our plugins for Excel have been hugely popular in the SEO community and today I’m hopeful you’ll love the next generation of our Excel Extensions, SEOgadget for Excel. Get the Brand New Downloadable PDF Guide There are lots of headlines for features, the main thing being a particularly handy new guide to everything the extension can do. That particular element of our tool has been a long time coming – basically, if you weren’t a member of my…

Mining User Data in Excel with the FullContact API

put on your data mining helmets

Recognized and prominent brands (like Target) are turning to big data to mine user information to find the best ways to reach and retain their customer base. Why let the big guys have all the fun? If you have a list of your users’ email addresses you can access your users’ personally identifiable information and social profiles. All you need is the FullContact API, NetPeak Checker and some Excel skills. FullContact’s Person API is amazing – If you have someone’s email address, Twitter handle, Facebook ID or phone number, you can use FullContact’s…

Forum Spam – A Practical Guide

Skydive Easter 13

If you’ve landed on this page hoping to find tips on enhancing your forum spam strategy, I’m afraid you’re out of luck. This guide is intended for those poor souls tasked with cleaning up the aftermath of a merciless spam campaign that has plastered your lovely domain across countless hell-holes of the internet with all the accuracy and subtlety of a sawn-off shotgun. So, as part of your clean-up operation you’re faced with some wretched old forum within whose monstrous spammy bowels lie a few hundred links to your domain.…

LinkLove 2013 – Thanks for Coming!

me-at-linklove

I love a good SEO conference – it’s extremely rewarding to meet lots of nice, interested and passionate people. It’s always sad when something comes to an end, but Distilled did a great job of their final LinkLove. Ask and you shall receive @richardbaxter hey Richard, I know it’s a tad cheating but could you make your demo Excel doc from #LinkLove available? — Matt Evans (@DigiMatt) March 25, 2013 In my session, I did a live demo of our Links API Extension for Excel and Niel’s SEO Tools for…

Get Your Backlink Growth History in Excel with the Links API Extension For Excel

dj-cdj

Back in late November, we added Majestic SEO to the Links API Extension for Excel. If you’re using the extension in Excel, you can do pretty much everything the Majestic API will let you do (there are 19 API calls, I think) including URL metrics, anchor text and top pages and a lot of other stuff. Anyway, when we launched the tool, I didn’t have a lot of time to document anything but the main API calls. That’s got to change (seriously – 25% of the features of our own Links API…

SEOgadget’s API Now Available in the Links API Extension for Excel

beans-I-like-them

About a month ago, I had a penny drop moment. We’ve had the Links API Extension for Excel available for free download since July – initially launching it with Mozscape, and later Majestic SEO. We’ve had a free API that does a ton of stuff for about the same period of time. Until that penny drop moment, I hadn’t thought of putting the two together. Until now. Get site contact details, easily! Here’s the kind of story you can tell with this tool: “Show me the contact URLs for my…