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:
You could quite easily use the fresh index, too:
If you copy and past that query straight into Excel, here’s what you’ll see:
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:
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:
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:
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!