Skip to main content

Bulk Import Historical Keyword Rankings from Another Provider to AgencyAnalytics

Learn how to bulk import historical keyword rankings from another provider like BrightLocal, Moz and more into our Rank Tracker tool.

Written by AgencyAnalytics Team

Moving to AgencyAnalytics from another rank tracking tool? We allow you to import your historical keyword rankings data from the following providers:

  • Advanced Web Ranking 

  • Authority Labs

  • BrightLocal 

  • Klipfolio

  • Moz

  • Pro Rank Tracker

  • Rank Ranger

  • Rank Tracker

  • Raven Tools

  • SEMRush (Includes Tags)

  • SEO PowerSuite (see here for instructions)

  • SE Ranking

  • Serpstat

  • STAT Search Analytics

  • WebCEO

  • Zefo

This means you can keep your entire ranking history and use our Rank Tracker to track your keywords after you've imported the data.

If your provider isn't listed above, you can also manually import rankings data.

How to Bulk Import Historical Keyword Rankings from Another Provider

Step 1: Click your profile icon in the bottom-left corner of the screen. From the dropdown menu, select Settings.

Step 2: Select Data Import from the settings page menu. From the Data Import page, click Create Import in the upper right to open the import wizard.

Step 3: You'll be prompted to choose the source of your data. Select an option and click Continue.

Step 4: Depending on your rankings provider, you'll need to either enter an API key or upload a zip file to import your rankings. Follow the on-screen prompts for your provider, then click Continue in the bottom left.

If you're using an API to pull in rankings data, you may be required to specify the exact website to import before choosing an AgencyAnalytics Client for the data to import to.

Step 5: Next, you'll be prompted to select the destination Client for the rankings data. You can choose to import the data to an existing client or create a new Client. 

Once you're done, you'll have the option to import more data or to finish and return to the data import dashboard.

You can monitor the import status on the Data Import dashboard. When the status reads "Complete," the keyword rankings will be fully imported.

Important Information for SEO PowerSuite

To ensure compatibility, SEO PowerSuite users should use the following code when exporting rankings from PowerSuite:

<[DEFINE name="dateFormat" value="exportData.createDateFormat('yyyy-MM-dd')"/]>
<[DEFINE name="keywords" value="exportData.keywords"/]>
<[DEFINE name="searchEngines" value="exportData.searchEngines"/]>
date,keyword,search_engine,rank
<[FOR_EACH name="keywords" id="keyword"]>
<[FOR_EACH name="searchEngines" id="searchEngineType"]>
<[DEFINE name="history" value="keyword.getHistory(searchEngineType)"/]>
<[FOR_EACH name="exportData.reverse(history)" id="historyRecord"]>
"<[ECHO text="dateFormat.format(historyRecord.checkDate)"/]>",<[ECHO text="keyword.query"/]>,<[ECHO text="searchEngineType.getName()"/]>,<[DEFINE name="position" value="exportData.getPosition(historyRecord)"/]><[IF condition="position != null"]><[THEN]><[ECHO text="position"/]><[/THEN]><[/IF]>
<[/FOR_EACH]>
<[/FOR_EACH]>
<[/FOR_EACH]>

How to Fix Historical Rankings Import Errors

Our rankings import process requires formatting and naming conventions to be followed precisely, or you'll receive an error message when you attempt the import. If you hit an error, work through these checks in order.

Are you importing into an empty Client?

Data can only be imported into an empty (new) Client. If you've connected any integrations or added any keywords to be tracked in that Client, the import process won't be allowed.

Is your CSV file formatted correctly?

Follow the instructions above exactly. Does your CSV file look exactly like the sample CSV here, with the exact same column names?

Is your file structure accurate?

You should upload a file with the ZIP extension, containing exactly one folder named "keywords" (all lowercase). That "keywords" folder should contain your CSV files, following the naming conventions in Import Data.

Your ZIP file may also include a second folder titled "integrations," but only if you're importing integration settings. The "integrations" folder should be at the root of the ZIP file, with the integration settings files inside it. Integration settings files can only be generated by our system during the bulk export process.

Why am I seeing a date format error, like "xx/xx/xx is not in the correct date format"?

This usually happens when you export historical rankings from our system, open the file in Excel, and re-save it. Excel can automatically reformat dates in the file, which can trigger this kind of error.

Our system requires dates to be formatted as YYYY-MM-DD (for example, 2016-05-27). By default, Excel reformats dates as MM/DD/YY (for example, 09/07/16) and can sometimes reformat other data types as well. This causes our importer to throw an error.

There are two solutions:

  • Manually re-format your data in Excel to use the YYYY-MM-DD date format

  • Use Numbers (on a Mac) or Google Sheets to work with your .CSV files instead of Excel

What to Check Out Next

Need help?

If you have any questions, please contact our friendly support team by following these instructions. We are available 24/5 to help.

Related Articles
Managing Keywords in Rank Tracker
Import data
Troubleshooting Historical Rankings Import Errors in Rank Tracker
Filter and Organize Keywords in Rank Tracker and Reports
Rank Tracker FAQ
Did this answer your question?