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:
Click on 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 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
Column header: Link Type
Indirect / Other
Column header: Link Text
Column header: Link URL
Column header: Website Name***
Column header: Website URL
Column header: Website Type
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)*
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 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.