Documentation > Campaigns > Import & Export

Historical Rank Data Import Tool

Once Campaigns are set up, manually or using our Campaign Import Tool, you can use our Historical Data Import tool to import your ranking history file with up to 2 years of history.

The historical rank data import tool is located in the Campaigns > Import & Export section of Rank Ranger.

Video: How to Import Rank History into Campaigns

Download Sample Rank History File

Open the Historical Data Import Tool:

Select Campaigns > Imports & Exports
Select Historical Data Import in the left menu
Download Sample File

Prepare Rank Import Files

There are two options for importing historical rank data, follow the steps in one of the sections below based on your campaign status and needs.

If the campaign is not tracking competitor URLs, then the simple Campaign Historical Import is all that is needed.
If the campaign rank history has already been imported and you want to add competitor rank history then the Competitor Rank History Import should be followed.

Campaign Historical Import

Create one import file for each search engine and domain.
Enter the campaign's keywords in Column A (leaving the keyword label intact). Keywords must already exist in the Campaign Settings > Keywords screen.
Enter the Campaign Name in Column B for all rows of the spreadsheet. Campaign Name must exactly match the Campaign Settings > General Settings Campaign Name field.
Overwrite the MM/DD/YYYY labels beginning in Column C with actual rank dates. Dates must be in MM/DD/YYYY format (some users have reported that it is possible to convert to US date format by copying dates that are in other formats into a Google Sheet and downloading to CSV, additionally, Excel Tips provides instructions for converting from European to US date format).
We have learned that some users experience a problem when saving a CSV file their computer's date settings change the date format, the work-around for that is to save the import file as a .XLSX Excel workbook file before importing.
Enter or paste the historical keyword rank for each date in the date columns.
Note: The Baseline rank accepts a value from 0-100. In case your import file has keywords whose rank position is 0 or not a number (for example "-" or "N/A") , change the listed rank to 100 for the baseline to show as 100.

Competitor Rank History Import

Create one import file for each search engine
Insert a column between the campaign_name and MM/DD/YYYY columns and title it domain
Enter the campaign's keywords in Column A (leaving the keyword label intact).Keywords must already exist in the Campaign Settings > Keywords screen
Enter the Campaign Name in Column B for all rows of the spreadsheet. Campaign Name must exactly match the Campaign Settings > General Settings Campaign Name field
Enter the competitor's domain (e.g., example.com) in Column C for all rows in the spreadsheet. Competitor domain must already exist in the Campaign Settings > Websites screen
Overwrite the MM/DD/YYYY labels beginning in Column D with actual rank dates. Dates must be in MM/DD/YYYY format (some users have reported that it is possible to convert to US date format by copying dates that are in other formats into a Google Sheet and downloading to CSV, additionally, Excel Tips provides instructions for converting from European to US date format)
Enter or paste the historical keyword rank for each date in the date columns

Import Rank Data

Upload Historical Rank Data Files

Upload Campaign rankings for each search engine separately

Click the Choose File button, and select the file
Select the Campaign
Select the Domain (this makes it possible to import competitor data)
Select the Search Engine
OPTION: If you want to overwrite all of the existing data, including rank data that Rank Ranger has collected, then check the Overwrite Existing Data option.
Click the Upload button

Repeat for each search engine.

View Rank History

The best way to confirm that rank history has been imported correctly is to view one or more of these reports:

Overall Ranking Performance

Overall Ranking Performance with Baseline Date enabled is a quick way to determine if the earliest date (that has rank) in the file you imported matches the baseline rank date.

Monthly Snapshot

Monthly Snapshot with Snapshot Day set to Average (this is in Report Options > Date settings). You can change the report date range to go back in history to match the first month reflected in your rank history import file.

Get the ultimate SEO tools with the Rank Ranger Software
Learn More About Rank Ranger

Featured SEO Tools

SEO Dashboard Rank Tracker Social Analytics Link Manager White Label SEO

Marketing Dashboard Keyword Finder Insight Graph API

Resources

Top 100 Websites Rank Risk Index Google Algorithm Updates Google SERP Features Tool Mobile SERP Features Tool Visual Guide to SERP Features SEO Glossary

Rank Ranger

Pricing Contact us Blog Help Center Documentation Brand Ambassadors

Search our Knowledge Base
	Search