You can bulk import new or updated link data in CSV format into Link Manager. 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:
- Click the Tool Options button and select Import Data from the drop-down menu.
- 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.
- Check the Link Monitoring box to add link monitoring to all imported links.
- Click the Upload Links button.
The majority of Link Record fields can be filled in with bulk imports, though only the Status field must be filled in. Additionally, the Status field also must be a status that currently exists in Raven such as Queued, Requested, Active, Inactive, Declined, Ignore or any custom link statuses.
The following columns are accepted when importing link data into Raven:
Column header: Status
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
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
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
You can download a sample CSV 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","Social Media","8","Jon Henshaw","firstname.lastname@example.org","123",
"Active","Paid (Temporary)","internet marketing tools","http://yourwebsite.com/","My Blog","http://theirwebsite.com/blog","Corporate Blog","4","Jon Henshaw","email@example.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:
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.