All Collections
SEO Tools
How To
Bulk import historical keyword rankings from another provider
Bulk import historical keyword rankings from another provider

Select "Data Import" from the sidebar on your root dashboard, click "Import", then follow the prompts.

Matthew Davis avatar
Written by Matthew Davis
Updated over a week ago

How to bulk import keyword rankings from another provider

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.

To import your rankings data, click on "Settings" from the left sidebar, then 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.

You'll be prompted to choose the source of your data. Make a selection, and click "Continue".

Next, follow the instructions on the screen. Depending on your rankings provider, you'll need to either enter an API key to access the data.

Once you're done, click "Save".

or upload a file containing your keyword data. Click "Continue" to proceed to the next step.

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

Next, you'll be prompted to select the destination campaign for the rankings data. You can choose to import the data into an existing campaign, or to create a new campaign. 

If you're creating a new campaign, you'll enter the campaign name, campaign URL, and the report delivery timezone. 

You'll also need to set a keyword location. The location you choose here will be used as a fallback; if a valid location is already available when importing keywords, we'll automatically use that location instead.

If you're using an API to import your keyword rankings, you may need to specify how far back in time you'd like your historical import to cover, via the "Start Import Keyword Date" option. This allows you to choose how much historical rankings data to import.

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 status of the import from the Data Import dashboard. The keyword rankings will be fully imported when the status reads "Complete".

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"/]>
<[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]>

What's Next

Did this answer your question?