Data Management
Managing Workspaces
Workspaces are an extremely useful feature of WebSite Auditor. With it, you can create advanced filters allowing you to unclutter your working area and sort out the information you don't need. You can quickly switch between your workspaces using the dropdown menu.
WebSite Auditor comes with several ready-made Workspaces in both its modules and you can easily edit them or create your own new ones. Five workspaces for website analysis data (in the Website tab of your main window):
- All Pages
- PageRank Statistics
- Pages With HTML Validation Errors
- Unavailable Pages (Client or Server Errors)
- Popularity In Social Media
And you-ve got four workspaces for content optimization data (in the Webpages tab):
- Single-Word Keywords Only
- Multi-Word Keywords Only
- All Keywords (Compact View)
- All Keywords (Detailed View)
You can edit the predefined Workspaces or create custom Workspaces of your own. To add, remove or manage your Workspaces, use the Workspace button next to the dropdown menu, or go to Preferences > Manage Workspaces...> and choose between workspaces for the Website and the Webpages Tab.
Whichever way you choose you'll get to one of the Manage Workspaces windows.
Here you can add, remove, clone, modify or move the existing Workspaces up or down.
For instance, to edit one of the Workspaces, click the Edit button, and WebSite Auditor will show the Edit Workspace window:
Note: When tuning workspaces for the Website tab, you can also use the Group By option to organize your pages into a tree-like list by any factor included in that workspace.
Using Quick Filter
You can use the Quick Filter whenever you need to narrow down the main view to sort out specific pages or keywords that match some condition. You can type a word (or any part of it) into the Quick Filter, and WebSite Auditor will instantly limit the view to the URLs or keywords that contain the word.
You can configure the Quick Filter choosing from the many filtering conditions available. Just click on the icon in the left hand corner to open the menu.
Then pick a filtering condition you need. For example you might want to only view keywords starting with 'SEO'. To do this choose Keyword > Starts with:
Then if you type 'SEO' into the Quick Filter, WebSite Auditor will show you only the keywords that start with 'SEO'.
The same way you can view the pages with URLs containing a certain word, or with a specific title. Quick Filter is a quick and easy way to find specific items fast, without creating Workspace filters for this purpose.
Exporting Data
(Works in Enterprise version only)
WebSite Auditor lets you easily export the data from your website optimization project into TXT, HTML or SQL or XML format. You can export your pages' ranking factors, as well as page content data. To do this, go to File -> Export -> Pages- Ranking Factors or File -> Export -> Page Content Data:
When you initiate the export for the first time WebSite Auditor will automatically offer you to create an Export Template. A wizard will take you through the set-up process. All your export settings will be saved in the template. Next time you need to export the data you can just pick the template you need and export it in a mouseclick. You can also edit and remove the export templates in the Properties menu.
Creating New Export Template
You create templates for the two types of export (pages- ranking factors export and page content data export) separately. Yet, the steps to follow when creating both types of templates are identical.
Step 1: Select File Type
In this step you choose the target format to save data in.
Note: If you select to export into a .txt/ .csv file you'll be offered to choose the type of delimiter in step 2. There's no such step for all other formats and you'll get straight to step 3 as described here.
Step 2: Choose Delimiter (only for Text File)
Choose the symbol that will be used to delimit the data taken from different columns. You can export your project data into a comma or tab separated file, as well as use a custom symbol to separate the entries. To export the data into Excel, choose comma as a delimiter.
Step 3*: Choose Columns For Export
In this step you can specify the columns that you want to export and the order in which they will appear in the target file.
*Step 3 for all export formats except .txt file
Step 4*: Preview
In this step you get a preview of the export file format. Click through to the Code tab to edit the export file code if needed.
*Step 4 for all export formats except .txt file
Step 5*: Set Template Name
Here you choose the name for the export template (not the export file). Use a descriptive name that will state what the export template does, e.g. 'Export to .TXT file'
This template will store all export settings you specified and will quickly apply them whenever you select to export the data using this template.
*Step 5 for all export formats except .txt file
Managing Export Templates
You can manage Export Templates in Preferences -> Export Templates -> Pages- Ranking Factors or Preferences-> Export Templates -> Page Content Data.
After you-ve chosen the type of export templates you want to work with, you can see the list of available templates. Select a template and press Edit to change its settings. WebSite Auditor will give you access to the code of the template. You can edit the code and get a preview of your changes in the Preview tab.
You can also delete any template by pressing the Remove button or change the order of templates with the help of Move Up/Down buttons.
Exporting Data Using Export Template
Once you've created an export template you can use it to export the data to your preferred format. Go to File -> Export -> Pages- Ranking Factors or File -> Export -> Page Content Data and select the export template you need.
Step 1: Choose Export Template
Pick the export template that will be used to export the data from WebSite Auditor.
You can edit the templates, or create a new export template to change the settings or select a different export file format.
Step 2: Choose Which Records To Export
In this step you need to choose what records from your active project you want to include into the export file. You may export all records from the project, the records from the current workspace or just the currently selected entries.
Click Finish and you'll be able to select the storage path and name for the target export file.
Copying the Data to a Spreadsheet
To copy your data to a spreadsheet for print out for instance, please do the following:
- Select the entries you wish to copy. You can hold down CTRL (or CMD on a Mac version) or SHIFT keys to select multiple keywords.
- Right-click and select Copy To Clipboard, or simply hit CTRL+C (or CMD+C on a Mac version).
- Now open your favorite spreadsheet and press CTRL+V or right-click > paste to import the data.
That's it! You have successfully transferred your data to the spreadsheet. Now you can easily sort, modify or print it.
