Advanced Web Ranking offers an export feature that allows you to automatically push CSV files to an FTP (File Transfer Protocol) location. These files include ranking, visibility, and market share statistics for the selected projects, facilitating efficient data management and integration with other third-party applications.
What is an FTP location?
An FTP (File Transfer Protocol) location is a server-based directory used for storing and transferring files between a client application and a server. By configuring AWR to export data to an FTP location, you can automate the process of backing up or sharing your SEO data with third-party reporting tools or stakeholders.
How to Create an FTP location?
Select an FTP server provider: Choose a hosting provider or server that offers FTP access. Many web hosting services provide FTP capabilities as part of their packages, but you can also use dedicated FTP hosting providers if needed.
Set up an FTP account: Create an FTP account with a username and password. This account will be used by AWR to access the FTP server.
Configure FTP settings: Configure your FTP server settings, including the FTP address (hostname), port number (default is 21), and any specific security settings such as encryption or secure FTP.
Create upload directory: Specify the directory (folder) on the server where the files will be stored. This can be a default directory already existing on the server, or you can create a new one specifically for AWR exports.
Configuring AWR for automatic FTP exports
This feature is available with Enterprise monthly plans and all yearly subscriptions.
To enable automatic exports to your FTP location, follow these steps:
Log in to your AWR account and go to the Settings > Connectors & API section.
Check the option labeled Enable CSV exports to FTP to activate the feature and choose the projects for which you want to enable automatic exports.
Configure the export settings based on your needs:
Ranking export: Includes an option to
Include non-ranked keywords.Visibility Export: Options to
Split by keyword groupsandSplit by search engines.Market Share Export: Options to
Split by keyword groupsandSplit by search engines.
Input your FTP server details, including:
FTP server: The hostname of your FTP hosting.
Username and password: Credentials for accessing the FTP server.
Path: The folder path on the FTP server where the export files will be placed.
Use the Test FTP settings button to verify that AWR can successfully connect to your FTP server.
If the connection test is successful, save the FTP settings to enable the automatic exports.
Export process
After setup, AWR will automatically generate and upload CSV files to your FTP location each day, if at least one of the selected AWR projects has been refreshed with rankings. The exported files will be organized into separate folders on the designed FTP location:
Visibility data: Contains the export files named visibility-yyyy-mm-dd.csv, where yyyy-mm-dd represents the date when data was updated.
Ranking data: Contains files named ranking-yyyy-mm-dd.csv
Market Share data: Contains files named marketshare-yyyy-mm-dd.csv
This naming convention ensures that files are easily identifiable and organized by date, facilitating efficient data management.
Requesting an export sample
To request a sample export or if you encounter issues, please contact us at help@advancedwebranking.com.
Do you have any other questions? Don’t hesitate to get in touch and we will keep building the FAQ.