Prepare Bulk Import Data
Download the Link Import Example file, obtain your Profile ID and Manager ID lists
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. The example file is in .xls format, make sure that when you save it you save as an Excel spreadsheet in .xls format.
Compiling the data for thousands of links can be a challenge!
Consider adding one Profile or small batch at a time. Then after
importing the first batch of links, you can view the reports to help determine if there is additional information you want to include before importing more links.
Import Field Definitions
Column A manager_id
) 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. Before utilizing this feature,
you need to create Sub-users
first. Then add the ID numbers to
the Links in the spreadsheet before importing.
Column B profile_id
) 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. This field must match the ID number of a Profile
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
for instructions. This field must match the ID number
of a Contact.
Column D link_from
) This is the source page URL, the page that contains the link and anchor text to your target page. URL format must include http:// or https://
Column E linking_to
) This is the destination URL, the target of the link_from page. URL format must include http:// or https://
Column F anchor_text
) 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). Do not enter currency symbols, only numbers
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 must 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: