September 2011

I’m very happy to announce an updated version of our Excel Interface to the seoMoz LinkScape / Mozscape API. Your suggestions have been heeded and the new version is a great improvement over the first.

What’s new?

  • Run On-Demand: No more auto-updating. Now, just press Alt+F8 to run when YOU want.
  • Rate Limiter: Helps to keep us out of the seoMoz doghouse. Allows 2 URLs to be processed per second. As of early 2012, the rate limit has been changed to 1 URL per 10 seconds. (for free accounts)
  • Cleaner Spreadsheet: Removed the “raw” seoMoz response and handles all parsing within the macro.
  • Conditional Formatting: Automatically compares scores against all others on the sheet. Highlighting opportunities FTW!
  • Stand-Alone Macro: Save the macro to your personal workbook and you can run it against any list of URLs. No need to use *this* spreadsheet every time. (minor tweaks required)

BusinessHut seoMoz LinkScape API Excel Spreadsheet

Please visit this page to download the latest version of the Excel spreadsheet: Excel Interface to the seoMoz API

— Make it more awesome with this post by John Doherty
— And for even more info, check out John’s post on SEOmoz

********* UPDATE 12/13/2011 **********
Rolling out December, 16th, 2011, the SEOmoz Free API will be severely limited.
The new rate limit for the Free API is 1 request every 10 seconds.
(Compared to 2 or 3 per second that we’ve been running.)
And batch requests for the URL Metrics Call has been limited to 10 URLs for every POST request.
You can read the official SEOmoz API update here.
**************************************

********* UPDATE 9/5/2012 **********
Version 3.0 is now in beta testing.
Rather than a vba macro, this new version is an installable Excel Add-in.
Check it out here: http://www.businesshut.com/seo/seomoz-mozscape-add-in-for-excel/
**************************************

Suggestions and support are welcome. Thank you to everyone who has given feedback thus far.

How to Buy a Domain

by Jason Green on September 13, 2011 · 0 comments

To claim your presence on the web, the first step is usually to buy a domain. For those not familiar, a domain is the “name” given to a particular website, such as BusinessHut.com. Having your own domain is important for branding, and provides freedom to build the site how you see fit.

It’s pretty easy to buy your own domain, and you’ll have plenty of success if you follow these steps.

1. Choosing a Domain

Generally, the domain name should be the name of your company. However, if your company name is long or difficult to spell, you might want to go with a word or two that accurately describe your business. For example, if I couldn’t buy BusinessHut.com, I might have gone with something like TechnologyConsulting.com. If the domain you want isn’t available (eg. already registered by someone else) your only options are to buy the domain from the current owner, or wait until it expires. (both topics I’ll have to save for another discussion) Do your best to find a domain that isn’t already registered.

*Try to avoid numbers, hyphens (dashes), and homonyms in your domain. You want to be able to say your domain quickly to someone and for them to know exactly where to go. If you buy to-golf.com you’ll basically have to write it down because there are so many variations. (to, too, two, 2, and then with and without the hyphen)

Domain Resources:
DomainTools.com – Allows you to check whether a domain is available and also offers research tools to suggest similar domains.

2. Buying the Domain

I buy nearly all of my domains through GoDaddy and have for the past 10 years. The prices are good and the domain management features are useful. Unless someone can provide a good reason to switch, I plan to buy all of my domains through GoDaddy.

The process for buying a domain is pretty simple. Once you choose a domain to purchase, just go to www.GoDaddy.com and type your domain into the box. (you’ll see it) They’ll tell you whether the domain is available or not and you just need to click the button to proceed with the purchase. They’ll offer you all of the other available versions of the domain, such as .net, .org, and .info. Generally, they give you a really good price on these, so it’s usually a good idea to pick these up if your budget allows. However, try to avoid most of the other offers throughout the checkout process. We’re going to use a different company to host your website and most of these features will be included.

Once you complete the purchase of your new domain, it’s time to find a web host…(That’s our topic for next time.)

Until then, please contact us or leave a comment below if you have any questions.

Disclosure: I am an affiliate of GoDaddy and might receive compensation if you purchase your domain through the links on this website.