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
Pro Rank Tracker
SEMRush (Includes Tags)
SEO PowerSuite (see here for instructions)
STAT Search Analytics
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]>