Knowledge Base/SEO/Link Tools FAQ

How do I import links to the Link Manager?

Alison Groves
posted this on April 05, 2011 04:54 PM

 

Link Manager: Import Links from CSV

You can bulk import new or updated link data in spreadsheet format into Link Records. You can upload up to 500 links per upload. If there are more than 500 link records in a CSV import, only the first 500 will be imported. Here are the steps:

  1. Click on the Tool Options button and select Import Data from the drop-down menu.

    Screen_Shot_2013-08-11_at_2.56.11_PM.png
  2. Go to Link Import Form and browse to your CSV file by clicking the Choose File button. You can see how your CSV should be formatted below.
  3. Check the Link Monitoring box to add link monitoring to all imported links.
  4. Click the Upload Links button. 

The spreadsheet must be saved as a .CSV file and supports the following data.

All columns must be present in the CSV, but Status is the only field that cannot be empty. Status also must be a status that currently exists in Raven such as Queued, Requested, Active, Inactive, Declined, Ignore or any custom link statuses.

Column header: Status

  • Queued
  • Requested
  • Active
  • Inactive
  • Declined

Column header: Link Type

  • User Submitted
  • Content Exchange
  • Paid (Permanent)
  • Paid (Temporary)
  • Blog Comment
  • Organic Link
  • Indirect / Other

Column header: Link Text

Column header: Link URL

Column header: Website Name***

Column header: Website URL

Column header: Website Type

  • Social Media
  • Personal Blog
  • Corporate Blog
  • News / Media
  • Community
  • Directory
  • Other

Column header: Original PR***

Column header: Contact Name

Column header: Contact Email

Column header: Content ID (located in the Content Manager)

Column header: Cost*

Column header: Cost Type (Payment Frequency)*

  • One Time
  • Weekly
  • Monthly
  • Yearly

Column header: Payment Method*

Column header: Payment Reference*

Column header: Start Date*

Column header: End Date**

Column header: Creation Date (leave blank unless you want to force it to a past date)

Column header: Comment

Column header: Owner Name (leave blank unless you want this link to be marked as created by another user in your account)

Column header: Tags

* Only applicable to links assigned a Paid Link Type, including Paid (Permanent), Paid (Temporary) or custom link types

** Only applicable to links with the Paid (Temporary) Link Type

*** Deprecated: Website Name and Original PR are no longer used, but are kept to maintain backwards compatibility

Sample

You can download a sample here: sample.csv

A good strategy to ensure correct formatting is to use your favorite spreadsheet program of choice and export your data as a .csv file using the specific columns.

The above sample CSV file has this text:

Status,Link Type,Link Text,Link URL,Website Name,Website URL,Website Type,Original PR,Contact Name,Contact Email,Content ID,Cost,Cost Type,Payment Method,Payment Reference,Start Date,End Date,Creation Date,Comment,Owner Name
"Active","User Submitted","seo tools","http://yourwebsite.com/","Twitter","http://theirwebsite.com/folder"... Media","8","Jon Henshaw","jon@domain.com","123",
"Active","Paid (Temporary)","internet marketing tools","http://yourwebsite.com/","My Blog","http://theirwebsite.com/blog","Corporate Blog","4","Jon Henshaw","jon@domain.com",,"25.00","Yearly","Paypal","REF123","2008-07-01","2009-12-31","2008-06-01",

You can think of this text being visualized in this way:

table.png

Tip: Make sure there is just one line break between each row of text in your CSV file. In other words, there should be no rows of space in your CSV file. Wikipedia has a good overview of CSV if you'd like more in depth information on the format.

 
Topic is closed for comments