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".
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.
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 status of the import from 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]>