SRAP Parcel Evaluation Spreadsheet

From DGPWiki
Jump to: navigation, search

The SEO Research Analysis Package HUD, or SRAP for short (pronounced Ess-Rap), analyzes the same HTML pages the GSA uses when building the search indices for Second Life's In-World Search. As a result of the analysis, SRAP spits out a pretty large amount of data ... data that can be useful when briefly reviewing it, but data that can be a lot more useful when put into a format that allows comparison with industry standards and comparison against other (possibly competing) Parcels.

As part of the SRAP Package, we provide a Microsoft Excel Spreadsheet Template that may be used to help evaluate the data provided by the SRAP and then compare it against other Parcels in a format that is readily visible and easily understood.

Spreadsheet Overview

The SRAP Parcel Evaluation Workbook template allows you to rapidly create and analyze up to six parcels at a time based on up to six keywords. The available template is compatible with Microsoft's Excel 2003 but can also be uploaded to Google Docs or imported into many other spreadsheet programs as well.

Before you can get started, you need to download and extract the Template file into the Templates folder. Please refer to the help for your spreadsheet program for more help on locating the proper folder location for template files. Once the Template file is saved, create a New Workbook based on the Template.

The Summary and Parcel Worksheets

A new workbook created from the Template will contain seven Worksheets. Across the bottom you will see the various Worksheet tabs similar to those shown here:

Worksheet Tabs

The first sheet in the new Workbook is named Summary. The Summary sheet is where you will enter the keywords you wish to compare. The remaining six sheets are used to enter the Parcel Analysis Data created by the SRAP HUD.

Generating the Data

Before you can start analyzing the data, you have to actually get the data. The two functions of the SRAP that are most important for your analysis are the Basic Info and Top Kwds functions. You must also remember to enable Keyword Display in CSV Format using the Options menu before you use the Basic Info function.

If you are using a Viewer that allows you to clear the Local Chat box before starting, it can help a lot when it comes time to copy and paste the data for the spreadsheet. In the Emerald Viewer for example, you would enter the command "clrchat" in the Chat Bar at the bottom of the screen to clear the Local Chat already displayed.

Step 1 - Choosing the Parcel to Analyze

If you are standing on the Parcel you wish to analyze, skip to Step 2 below. However if you wish to analyze a Parcel other than where you are located, use the option to Scan a Remote Parcel first.

Step 2 - Creating the Basic Info Report

When you click the Basic Info function button on the SRAP HUD, it will retrieve the HTML page for the selected Parcel, pull out the Name, Description, Boost Rating and a few other details then present those in a simple report displayed in the Local Chat box. The report will also include an alphabetical list of the Keywords found in the Parcel Name and the Description. An example of a Basic Info Report might look similar to this:

[11:16:18] SRAP HUD: Retrieving Basic Parcel Information - Please wait a moment ...
[11:16:20] SRAP HUD: Retrieving Parcel Keyword Information - Please wait a moment ...
[11:16:20] SRAP HUD: Details for this parcel: DGP4SL Main Store - Teleport Slideshow Window and Door Store
Web Page URL:
Description: DG Products for Second Life - Teleporters slideshows tipjars venetian blind windows doors mailbox DG Flyer Teleporter InstaFlyer Teleport 1-Prim Slideshow 2-Panel Slideshow Teleporters Slideshows
Slide Shows Teleport Teleports
Category: Shopping
Rating: Mature
Owner Name: Darrius Gothly
Boost Value: 0
Items Total/Dupe/Unique/NoSale: 198/7/18/167
[11:16:20] SRAP HUD: Parcel Name and Description Keywords:
*Counts*, 26, 7, 21
1-prim, 1, , 1
2-panel, 1, , 1
blind, 1, , 1
dg, 2, , 2
dgp4sl, 1, 1,

Once the report is displayed and the SRAP HUD returns to its normal color (meaning it's ready for your next command), you can proceed to Step 3.

Step 3 - Creating the Top Keywords Report

Once the Basic Info report is complete, click the Top Kwds function button to begin display of the Top Keywords Report. This report includes a complete alphabetical listing of every keyword found in the Items set to Show In Search on the Parcel. It may also include the Keywords from the Parcel Description as well if you have enabled the Description As Keywords or Desc Kwds option.

Here is a brief example of how the Top Keywords report might look:

show, 8, 0.040201, 8, 0.040201, 0.003428
shows, 1, 0.005025, 1, 0.005025, 0.000428
[11:32:03] SRAP HUD: Keywords 121 to 140
sign, 2, 0.010050, 1, 0.005025, 0.000857
sim-wide, 5, 0.025126, 5, 0.025126, 0.002142

You will also notice three lines of detail at the top of the report that look similar to the following:

[11:31:56] SRAP HUD: There are a total of 2334 words in the page.
[11:31:56] SRAP HUD: There are a total of 1732 unique item words.
[11:31:56] SRAP HUD: There are a total of 154 total unique words in the page.

Copying and Using the Data

Once you have completed the three steps above, you are ready to copy the data and start plugging it into the Analysis Spreadsheet. We recommend that instead of copying it directly from the Local Chat window in your Viewer, that you instead copy the whole report into a separate Text Editor and then work with it from there. This will save you having to do a lot of scrolling around and annoyances, and can also make part of the job a lot easier.

Step 4 - Copy the Entire Text of Both Reports

Highlight the entire text of both the Basic Info Report (created in Step 2 above) and the Top Keywords Report (created in Step 3) and paste it into a new Text Document. It's best to use a text editor or word processor that doesn't automatically add formatting but leaves the text in plain format. (For example, on Windows-based systems, Notepad is a good choice.)

Filling Out a Parcel Worksheet

There are six Parcel Worksheets in a new Workbook created from the Template. Each Parcel Worksheet contains three basic sections: Parcel Details, Name and Description Keywords and Item Keywords. The following image shows their general location on the sheet.

Parcel Worksheet Overview

Step 5 - Copy the Parcel Basic Info

The top section contains details about the Parcel itself. These details are included in the Basic Info report generated by the SRAP HUD in Step 2. The following images show which fields should be copied from the Basic Info Report text and where to paste that data in the Parcel Worksheet's Basic Info section.

Basic Info Report Text

Parcel Basic Info

A - Details for this Parel [Cell B1]
The Name of the Parcel; this is the name you give the Parcel in the About Land window
B - Web Page URL [Cell B2]
The URL of the source web page for the Parcel; the URL is generated by Second Life and will always start with ""
C - Description [Cell B3]
The description of the Parcel assigned using the About Land window; Note that it may wrap across one or more lines, so make sure you copy the entire description text before pasting it into the Parcel Worksheet
D - Category [Cell B4]
The Search Category selected in the About Land window
E - Rating [Cell B5]
The Maturity Rating for this Parcel
F - Owner Name [Cell B6]
The name of the person or group that owns the Parcel
G - Boost Value [Cell B7]
The Boost Value assigned to this Parcel; Refer to the description of the Boost Value for more information
H - Total Items [Cell B8]
The total number of Items on the Parcel that are set to "Show In Search"
I - Dupe Items [Cell C8]
The number of Item Descriptions that appear two or more times (Duplicate Item Descriptions)
J - Unique Items [Cell D8]
The number of Item Descriptions that appear only once on the Parcel
K - No Sale Items [Cell E8]
The number of Items that are set to Show In Search but are not set For Sale

One field at a time, copy the data from the Text Document containing the report data then paste it into the appropriate cell on the Parcel Worksheet. Note that you may have to paste the information into the Cell Edit Bar at the top of the Worksheet depending on the spreadsheet program you are using.

Step 6 - Copy the Name and Description Keywords

The Parcel Name and Description fields are used as the most "relevant" keywords in a Parcel listing. For this reason these two fields are particularly important in determining your ranking in the search results. The Basic Info Report includes an alphabetized list of all the keywords found in these two fields along with information about their location and repetition.

Parcel Name and Description Keywords Report

The image above shows an example of the Name and Description Keywords section of the Basic Info Report. The very first line contains a special entry called "*Counts*". This line contains the totals for the keywords in these two fields. The remaining lines contain one keyword per line along with the number of times that keyword appears in both fields, in just the Name field and in just the Description field.

Highlight all of the lines starting with the special *Counts* line and continuing through to the end of the Basic Info Report then copy and paste them into the Spreadsheet beginning in cell A19 as shown here.

Parcel Name and Description Keywords in the Spreadsheet

The first time you paste the Keywords list, all of the data will wind up in a single column. You must use the "Text to Columns" function in order to split the list into the proper columns A through D. Select Delimited formatting and check the "comma" delimiter to properly split the keyword and numbers into their correct columns.

Step 7 - Copy the Item Keywords

The last part of the report that must be copied to the spreadsheet contains the keywords derived from analyzing the Items set to Show In Search on the Parcel. If you have selected the Description Keywords or Desc Kwd option then the Keywords listed will also include those derived from the Parcel Description as well.

Item Keywords highlighted in Text Editor

The image above shows an example of the Item Keywords Report copied into a text editor. The keywords themselves are highlighted and ready for copying into the Spreadsheet ... almost.

Sorting the Item Keywords Report

When the SRAP HUD generates the Item Keywords Report, it can only display the report in groups of 20 keywords. This means that every 20 lines of output, there will be a line of "garbage" that must be removed before the Keywords may be copied to the spreadsheet. The simplest method is to sort the Item Keywords Report in alphabetic order. This results in the "garbage" lines winding up at the very bottom of the list, thus making them easy to delete or leave out of the copied text. The image below shows the last few lines of our sample report:

Item Keywords and "Garbage" after Sort

After sorting, highlight just the Item Keywords then copy and paste them into the spreadsheet beginning in cell I19. The result will appear similar to the following image:

Item Keywords in Spreadsheet

Using the Summary Sheet

After you have filled out at least one of the Parcel Detail sheets you may begin using the Summary sheet to determine how various keywords will "rank".

Entering Keywords

The following image shows an example Summary Sheet after entering details for six different Parcels. Cells A2 through A7 are used to enter up to six different Keywords that will be evaluated across the Parcel data entered.

Parcel Evaluation Summary Sheet

As you enter different keywords, the detail section on the right-hand side of the Summary Sheet will update to display the statistics for each Parcel. The details are arranged in six blocks, one for each keyword entered. Under each keyword are listed the (up to) six Parcels and their respective results.

Keyword Detail Section

The above image shows an example Keyword Detail section of the Summary sheet. Each column contains a separate metric for the specific keyword in the respective Parcel. The columns displayed are as follows:

Parcel Name/Desc Keyword Statistics

This column contains the number of occurrences of the specified keyword in both the Parcel Name and Description fields.
This column contains the number of occurrences of the specified keyword in the Parcel Name field only.
This column contains the number of occurrences of the specified keyword in the Parcel Description field only.

Parcel Item Keyword Statistics

This column contains the number of occurrences of the specified keyword in the Item Descriptions.
This column contains the percentage of the number of occurrences of the specified keyword divided by the number of Item Descriptions on the Parcel.
This column contains the number of Items that contain the specified keyword.
This column contains the percentage of the number of Items that contain the specified keyword divided by the total number of Items on the Parcel.
This column contains the percentage of the number of occurrences of the specified keyword divided by the total number of keywords in the Item Descriptions.