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

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 extension are documented, the rest only exist in my head – what if I got run over by a bus tomorrow?!)

Get Your Backlink Growth History with Excel

Let’s dive in with an example copy and paste query:

=majesticAPI_toFit("GetBackLinksHistory","historic","seogadget.com",,"item0")

You could quite easily use the fresh index, too:

=majesticAPI_toFit("GetBackLinksHistory","fresh","seogadget.com",,"item0")

If you copy and past that query straight into Excel, here’s what you’ll see:

majestic-data

Here’s Majestic’s definition of each of our data points:

1. TotalLinks: total number of external backlinks found in a given month

2. RefDomains: number of new referring domains found in that month

3. ImageLink: links with images, ie: <a href=”link”>&ly;img src=””></a> – note the SRC value is not used this case, only HREF part of A tag.

4. Mention: number of URLs on which root domain was mentioned (see http://www.majesticseo.com/glossary.php#Mentions) (it is NOT recommended to use these counts due to user confusion it may cause).

5. NoFollow: links marked with nofollow tag either as rel=”nofollow” or META NOFOLLOW tag.

6. CrawledPages: number of crawled pages from that domain

7. MentionDomains: number of new domains on which given root domain was mentioned (it is NOT recommended to use these counts due to user confusion it may cause.)

8. TextLink: number of text links (not images or any other type) found in a given month – it is recommended to use TotalLinks. (it is NOT recommended to use these counts due to user confusion it may cause).

9. DomainURLs: number of URLs found on that domain – this can be used as indicator of content growth

10. IndexCrawledPages: number of crawled pages globally by our system – this is useful metric to normalise found backlinks (but not referring domains) against total crawl

Multiple domains and pages in one API call

The Links API extension is pretty friendly to the Majestic API, caching calls so there’s no repetition (and unnessecary API load) – you’ll see how fast it is with cached calls. With GetBackLinksHistory, you can chain multiple domains and URLs in the call, like this:

=majesticAPI_toFit("GetBackLinksHistory","historic","seogadget.com,seogadget.com",,"item0")

Where “item0″ would be “seogadget.com”‘s backlinks and “item1″ would be seogadget.com

All of the data is fetched in the first API call, and cached. If you repeat the query, with “item1″ in the string, you’ll instantly get the data for the next domain / URL in the chain:

=majesticAPI_toFit("GetBackLinksHistory","historic","seogadget.com,seogadget.com",,"item1")

Very quickly you can build several tables, all with the back link history data for the sites you’re researching. Here’s a chart I made earlier:

majestic-data

This is so, so much faster than CSV file downloads

Learn this platform. For the sake of half a day’s investment in time, you’ll probably save yourself months of waiting for CSV file downloads from Majestic and OpenSiteExplorer. It’s easy, fast and a lot of fun.

Go have fun with it!



Stay Updated: Sign Up for Webinar & New Blog Alerts

2 thoughts on “Get Your Backlink Growth History in Excel with the Links API Extension For Excel

  1. juvy@cyberma.us says:

    Pretty good idea to monitor the growth of our Backlinks by month or per quarter! Why I haven’t come up this kind of idea? He he he, Anyways, thank you for sharing, this must be very helpful for me and for my business! :)

  2. Sahil says:

    Great one Richard! Thanks a lot for all these excel macros and tips which can help save the webmasters time. You and Neils Bosma are certainly the two unprecedented kings of Excel for SEOs.

Comments are closed.