New and Improved Backlinks Export!

March 30th 2020: Prompted by feedback from @thegamingseo , we’ve added ‘Indirect Target URL’ and ‘Indirect Target Type’ fields to the export as detailed below.
Post Originally Released: January 21st 2020

We’ve revamped our backlinks export for 2020 to bring you more data with less cryptic column headers.

Majestic is a great source of backlinks data – but as one of the most established players, our data export options have begun to show their age in places. We’ve received customer feedback asking for more data from more of our exports in a more industry standard way – and we are happy to oblige!

To avoid disrupting existing workflows, these changes will be introduced gradually – initially running as an optional beta.

Benefits of Full Export

Improved column headings

The new Export uses “industry standard” column headers which are grouped together logically. We view this change as an important first step to enhancing the clarity of how data is presented across the Majestic toolset.

Link Context Data

Link Context data for Top Links has been available for download in the Link Context tab since the feature was released in September 2019.

The Majestic Web Crawlers have now aggregated sufficient data to add this valuable data to the “Full Export”. We’ve taken some of the key datapoints from Link Context and included them in this download.

New Data Columns

Majestic collects many data points from the web, only a few of which were included in the old backlinks export. We have used this opportunity to review our offering and added a number of new fields to the export.

For those keen on link audit – we hope these new data columns facilitate even deeper backlinks analysis. New fields include Flow Metrics scores of the source domain; source URL outlinks count, and the detected Language of the source page of the link.

How can I try the new backlinks export?

To avoid breaking existing workflows, the new backlinks export is being operated as an opt-in public beta.

#1 Click the existing “Raw Export” icon in Site Explorer.

#2 To access the new data export, open the Full Export panel using the down arrow (1), and click try now (2).

#3 The new Full Export is now activated. Click ‘Build Download’ to prepare the download.

#4 Download the file

Your download will appear at the bottom-left corner of your window. Unzip the gzip file using a third-party tool such as 7-zip. You can now conduct your own analysis on the spreadsheet!

Full Export will become the default format on successful completion of the download. The legacy format will still be available to use, by clicking the text in the bottom-left of the dialog. Once you click the text, the old Raw Export will be your default format.

The new data in full

The New Export includes new data fields, and has renamed some cryptically named fields like “Flag Old Crawl”. A full breakdown of fields are shown below:

(Old) Raw Export Column Headers	(New) Full Export Column Headers	Description of Data
	Ref Domain	Backlink pointing to the Source URL
Source URL	Source URL	URL of the page
	Source Title	Title of the Source URL
SourceTrustFlow	Source Trust Flow	Trust Flow of the Source URL
SourceCitationFlow	Source Citation Flow	Citation Flow of the Source URL
Anchor Text	Anchor Text	Anchor Text of link (lowercase)
Target URL	Target URL	URL the link points to
	Link Type	The type of link
	Link SubType	Detailed description of the type of link
	Link Context Before	The text including key html elements before the anchor text
	Link Context Middle	Anchor text of the link (as found)
	Link Context After	The text including key html elements after the anchor text
	Link Density	Percentage of surrounding content that is made up of other links
	Link Context External Links	Number of external links before and after the anchor text.
	Link Context Internal Links	Number of internal links before and after the anchor text.
	Link Ordinal	Index of the link on the page
FlagRedirect	Is Redirect	Is the link a redirect link
FlagFrame	Is Frame	Is the link a frame
FlagNoFollow	Is NoFollow	Is the link a NoFollow link
FlagImageLink	Is Image	Is the link an image
FlagOldCrawl	Is Lost	Was the link  found during the last crawl
FlagAltText	Is AltText	Is the link is the alternative text of an image
FlagMention		No longer available in Full Export
Source First Found Date	Link First Indexed Date	The date the link was first crawled
Source Crawl Date	Link Last Seen Date	The date the link was last crawled
	Link Lost Date	The date the link was not found by the crawler
	Link Lost Crawl Result	The response code of the Source URL when the link was lost
	Source Internal OutLinks	The number of internal outbound link of the Source URL
	Source External OutLinks	The number of external outbound link of the Source URL
	Source Total OutLinks	The total number of outbound links for the Source URL (Internal + External)
	Source External OutDomains	External outbound links grouped by domain
	Source Page Size (KB)	The size of the Source URL page
	Source Language	Detected language of the Source URL
	Source Language Description	The full name of the detected language of the Source URL
	Source Language Confidence	Confidence the language of the Source URL is the language detected
	Ref Domain Trust Flow	Trust Flow of the Ref Domain
	Ref Domain Citation Flow	Citation Flow of the Ref Domain
	Ref Domain IP	The IP of the Ref Domain
Target Trust Flow	Target Trust Flow	Trust Flow of the target URL
Target Citation Flow	Target Citation Flow	Citation Flow of the target URL
	Indirect Target URL	The original target of a backlink, where a backlink is passed through a redirect or canonical link
	Indirect Target Type	The reason for the backlink being passed through
SourceTopicalTrustFlow	Source Topical Trust Flow	Website categorisation of the Source URL
RefDomainTopicalTrustFlow	Ref Domain Topical Trust Flow	Website categorisation of the Ref Domain
	Target Topical Trust Flow	Website categorisation of the Target URL

In Conclusion

We hope you like the new data and layout in raw export and look forward to any feedback you may have on the new format and enhanced data provided.

We believe the new format is in the best interests of new customers, but recognise our valued customers may have processes built around existing formats, and are therefore aiming to phase in introduction of the new format.

At present – we plan to offer support for the legacy data extract format for the foreseeable future. However, the new format is planned to become the default format for onsite downloads in due course, and it is likely to become opt-out rather than opt-in when the beta period finishes. Please contact support if this is likely to cause you concern. We do not foresee the need to make any breaking changes to the existing API.

All existing subscribers can try the new Full Export. To get the most out of the Full Data, New subscribers are encouraged to try the PRO plan at a monthly cost of £79.99/€94.99/$99.99. New Customers benefit from a 7-day money back guarantee for Lite and PRO plans. Try it out

Back