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
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
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
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
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: