Import keyword ranking history to SE Ranking from AgencyAnalytics – Knowledge Base

You can export keywords and their ranking history from AgencyAnalytics and import them to SE Ranking. For this, choose one of the suggested ways—export data for a single dashboard or bulk export rankings and integration data.

How to import keyword ranking history from AgencyAnalytics to SE Ranking

By exporting data for a single dashboard , you can export keyword ranking data with a click.

Please note: Before doing that, make sure that you choose only one search engine in the project settings to avoid any errors during the data import.

For this, click the "Share" button, and choose your file type.

Import keyword ranking history_EN_06.png

Import keyword ranking history_EN_07.png

The file will then be available for download from your notifications menu in a couple of minutes.

2. To export and download all rankings data and integration settings for a particular campaign, choose the campaign, and open the "Settings" tab at the left side menu:

Import keyword ranking history_EN_08.png

3. From this window, choose "Export This Campaign" to start downloading your exported files.

After downloading and opening a ZIP file, you will access two folders: "keywords" and "integrations.” Each folder contains several CSV files, with each containing data on a given metric or integration, for example:

Data Type	Export File
Bing Ranking	`bing_ranking.csv`
Google Ranking	`google_ranking.csv`
Google Mobile Ranking	`google_mobile_ranking.csv`
Google Local Ranking	`google_local_ranking.csv`
Cost Per Click	`cost_per_click.csv`

4. Then, log in to your SE Ranking account.

If you want to create a new project, click on the "+ Create Project" in the header.

Import keyword ranking history_EN_01.png

Add the project name, click "Import keywords" in the "Keywords" tab, and choose "Import from CSV/XLS with positions history".

Import keyword ranking history_EN_02.png

Import keyword ranking history_EN_03.png

In the "Format" drop-down list, select "CSV from AgencyAnalytics". Then, select the search engine, location, and language. Next, upload your CSV file and the keywords will be added to the project.

If you want to add AgencyAnalytics’s data to an existing project, go to "Project settings".

Import keyword ranking history_EN_05.png

Select the "Keywords" tab and follow the same steps as we described above.