Prepare Bulk Import Data
Download the Link Import Example file
and enter the required Link data, and any optional data that you might need in the future. Entering optional data using the spreadsheet will save you time in the future because after you've imported the file, changes must be made manually in each Link Details screen.
Column A manager_id
(required) This is very useful if you assign responsibility
for specific links to individuals in your company (or contractors). It
needs to match the ID number of a Sub-user. This feature enables filtering by user in the Link Dashboard
, Link Distribution
and User Summary
reports. If you plan to utilize this feature,
it is advisable to create Sub-users
first. Then add the ID numbers to
the Links in the spreadsheet before importing. If you do not want to use this option, you may leave the cells empty, but the manager_id title must be at the top of the first column in cell A1.
Column B profile_id
(required) Profiles allow you to organize rank tracking and link tracking campaigns into associated groups. Create Profiles
using the a customer name, industry name, project name, URL, etc.
Column C supplier_id
(optional) This field allows you to attach a Link Supplier from your Contacts to a Link and filter the Link Dashboard by suppliers, as well as analyzing supplier performance in the Supplier Summary
report. Refer to Add and Manage Contacts
Column D link_from
(required) This is the source page URL, the page that contains the link and anchor text to your target page.
Column E linking_to
(required) This is the destination URL, the target of the link_from page.
Column F anchor_text
(required) This field should contain the exact Anchor Text of the Link that is on the link source page (link_from).
Column G price
(optional) If you have paid links and want to analyze them in the Link Dashboard or the Activities & Expenses
report, you should enter those prices in this field (in order to avoid having to manually enter them in each Link Edit screen later).
and I start_date
(optional, but required if you want to be able to filter reports by date) These fields are used to filter reports and label links as
live or expired. Dates should be in MM-DD-YYYY format.
Column J link_currency
(optional) If you have paid links in multiple currencies, you can use
this field to enter the 3 letter currency code
for the currency of each link
payment (e.g., USD, EUR, GBP, etc.).
Column K ip_address
(optional) If you know the IP address, you may enter it. If not, Rank Ranger will discover it for you.
Column L invoice_number
may use this field to enter invoice numbers for paid links if
you plan to view that data in reports and upload invoices to links.
Column M notes
(optional) You may use this field to enter any Notes about the link for your own records.
Column N link_type
field can be used to help distinguish between the
following link types, so if you will need that information in your
reports, it should be completed before importing the file:
Column O link_position
(optional) This field may be used to record the position on the page of the link that was agreed upon:
Compiling the data for thousands of links can be a challenge!
You might consider adding one Profile or small batch at a time. Then after
importing the first batch of links, you can view the reports for to help determine if there is additional information you want to include before importing more links.
When your data is ready click Campaigns > Link Manager
in the top navigation area.