Advanced Web Ranking allows you to export the rank data that it gathers to a CSV or XML file.
The data export uses the same mechanism as the printable reports, so you can create a custom export template and export the data with it whenever you choose to.
You can also use the scheduler to make the data export at a certain date and time and assign your own custom application to be run after the export is complete, so that the data can be parsed and changed into the format you require.
With the [Data Export] feature from Advanced Web Ranking, you can export [Websites Rankings] and [Top Sites] data.
For this, you must go to the [Data]->[Export] menu and create the template you wish to use for the export, by clicking on the [New Export] button.
When you create a new data export template, the first thing you must decide is the type of data you wish to export: Websites Rankings or Top Sites.
With the Websites Rankings Export Template, you can export the your current website rankings compared with the ones of your competitors.
Once you select the [Website Rankings] option in the [Create a new export] wizard, you can choose the file format of your export (CSV or XML) and if the template will be available in all projects or just the current one. With these preferences selected, all you need to do now is to press the [Create] button and your new export template is ready.
If you wish to modify the export template at a further point in time, you can edit all its settings in from the [Data] -> [Export] menu, by entering the [Edit] mode of the export in question.
The Report Settings
There are two fields available for editing the title of your export, and for adding a comprehensive and detailed description to it. Along with typing a new name, you can also append the Project Name, and the Date and/or Time to the export title, using the right click mechanism available.
-
Append project name. This option appends the project name to the export title name.
-
Append date. This option appends the input date to the export title. This is the date on which the file is generated.
-
Append time. This option appends the time when the export was generated.From here you can also edit the export's file name, using the same right click mechanism. Also, in this section you can edit the file format.
Further on, you can set the date range of the data contained in you export.
-
Date. Specifies the day the data of which will be used to generate the report.
-
Position Range. You can limit the ranking data displayed in your charts by selecting a range of positions that will be included in the chart. If your keywords or websites rank further than the selected range, they will not appear on the chart.
Output and Layout Options
Next, you can choose the output options:
-
Websites selected. This input section shows you the websites you will see in your export. To include all websites, make sure the Select all checkbox is checked. To display only part of them, uncheck it and select only the websites you are interested in. You can further sort websites here alphabetically, by index or by color, using the sorting tool next to the input section name.
-
Keywords selected. This section presents the keywords that you will see in the export. To include all keywords, make sure the Select all checkbox is checked. To display only part of them, uncheck the check box and select only those that you are interested in. You can further sort keywords here alphabetically, by index, color or by priority, using the sorting tool next to the input section name.
-
Search Engines selected. This section displays the search engines you will see in your export. To include all the search engines available in your project, make sure the Select all checkbox is checked. To display only part of them, uncheck it and select only those you are interested in. You can further sort search engines here alphabetically or by importance, using the sorting tool next to the input section name.
-
Report layout. This table shows you how search engine results are displayed in the columns and rows of the exported file. In this grid you can also select the columns you want to see in the export. Just click on the Select columns button, on the top left side of the report layout, and you will be able to select, deselect or switch the positions of the export columns.
-
Split the Result Type column into Organic, Images, Video, News, Shopping. When this option is selected, the Result Type column is split into five different columns, according to each result type.
-
Insert string into quotes. With this option selected, the strings in your export file will be inserted between quotes.
-
Execute command. In this section, you can enter the parameters you need and the command that you want to be automatically executed after your export was generated.
Filters and conditions
You can set the export to be generated only if a set of conditions is met. In this section you can add or edit the filters that the export generation depends on:
-
Filters. You can use the Advanced Web Ranking filters to condition the export generation. Just select one of the default filters from the list, define a new, customized filter or combine two or more filters to achieve the set of conditions you need.
-
Refine inputs. You can set a certain filter to be applied only to a segment of your project data. This means that you can use this button to select the keywords and websites you wish to apply the filter to. For each filter you set you may refine the inputs it affects.
Save to local file
This section allows you to choose the destination of the exports generated using this template.
-
Save to folder. Use this option to save the export to a certain folder. You can change the default location of this folder by unchecking the [Use default location] option.
-
Deploy. Here you can instruct the application to automatically generate the export after each project update. With global exports, that are available in all projects, you can specify if the export file should be automatically generated after all projects update, or only after the current project update.
-
Create separate folders for report type, year and month. By enabling this option your exports will be saved in a subfolder the name of which from the name of the project, the name of the report and the date broken down into year, month and day. This directory structure is useful when you create many reports for different projects and you wish to find them easily when needed.
Send report by Email
This section gives you the ability to adjust the settings for sending your exports via email.
-
Send Report by Email. When this option is checked, you are allowed to send the export to one or more email addresses. You can read more about this in the Email Settings section.
-
Notify on FTP upload. When checked, the application will send an email to the chosen addresses to confirm that the export was uploaded by FTP.
-
Ask for confirmation. Specifies whether the user needs to confirm the sending of the export by email before it is sent.
-
Email Address. In this section you can type directly your customer` s email addresses, or you can add them from the Address Book, from the Add button. Emails typed here will be automatically stored in the Address Book.
-
Address book. Opens the Address Book dialog where you can manage your contacts.
-
Show / Hide Bcc. This option gives you action to the Bcc section, where you can add other email addresses as Blind carbon copies to receive the export.
-
Email Settings. In this section you may customize the subject and the text for the emails sent, that contains your export.
Upload report to FTP server
This section is optional and is active only when you select the "Upload report to FTP server" option. It allows you to specify the FTP server where you want the export to be uploaded.
Below, you can find a description for each option you can change in this step:
-
Upload report to FTP server. Allows you to upload the export to your website using FTP. Read more about this in the FTP Settings section.
-
Create separate folders for each type, year and month. This option creates a folder for each export type and then breaks them into separate folders for each year and month.
-
Upload report as zip file. When checked, it specifies that the export should be archived before uploading it by FTP.
With the Top Sites Export Template, you export the position of all websites exactly as they are displayed in the search engines.
Once you select the [Top Sites] option in the Create a new export wizard, choose the file format you want to use and click the [Create] button. The steps to edit the newly created export template are similar to those for editing the Websites Rankings data export template, allowing you to select the input, output and destination settings of the exported file.