This article covers the manual rankings data import process. However, we can also automatically import rankings from a large number of other rank trackers.

You can use the process below to import historical rankings data from:

Data is imported by uploading a .ZIP file, which contains a series of .CSV files. This article will walk you through the process. All instructions must be followed exactly or you may receive error messages.

Data is contained in separate files for each metric. You'll need to create a separate .CSV file for each metric in the bullet list below, then add each of those .CSVs to a .ZIP file, which you will then upload.

Click here for a sample ZIP file containing sample CSV files for each metric.

These metrics are currently available for import, and are displayed with the name that should be used for their associated .CSV file. File names MUST be in the format described here:

If you're not using any of the above metrics, you can import the ZIP file without them.

Here's how to set out each of the above CSV files.

A location field must be included in each .CSV file for every keyword. Location should be in the format of "city,state,country" (or simply "state,country" or "country", depending on the location that you're tracking). 

For example, a location can be "united states", "california,united states", or "los angeles,california,united states".

Multiple different locations are allowed in one .CSV file. Simply put your desired location beside each keyword. To apply different locations to the same keyword, simply list the keyword multiple times, each time with a different location.

All dates must be in the YYYY-MM-DD format, for example "2018-12-31".

Keyword rankings should be a number from 1 to 100. A rank of zero ("0") indicates "not found". A hyphen ("-") in the ranking cell indicates that the keyword was not being tracked on that specific date.

Make sure that the file structure for the ZIP file that you will upload to AgencyAnalytics is as follows:

Then, navigate to the campaign where you wish to import the data, click "Settings" on the bottom of your left side menu. 

Note: Only the admin user on your account will have the import/export options available.

From the Setting page menu, click Import / Export. On the Import/Export page, click the button that says "Import a Campaign", then browse for your .ZIP file, and click "Open".

Your data will then be imported automatically, and will appear immediately.

You can also import integration settings.

Note, however, that these integration files cannot be created manually or pulled in from competing platforms. Integration settings files can only be created using the bulk export process. 

Integration settings files must be placed in a folder named "integrations", in the root of the ZIP file you're importing. 

If you are importing both integration settings and rankings data, this must be done at the same time: 

Place both the "integrations" folder and the "keywords" folder inside a .ZIP file, and use the instructions above to import the data.