HOW TO: Configure Site Server Analysis for a Search Top Query Report (323229)

SUMMARY

This step-by-step article shows you how to configure Site Server Analysis to generate a Search Top Query report.

NOTE: You must parse the query from the Uniform Resource Identifier (URI). In the Web log files, the URI query field (cs-uri-query) should appear as follows

ct=qcare&q1=@all+Care&xx=Care&x=6&y=15&MSS.request.Search%20Catalog=qcare...
				

where ct is the parameter for Site Server Search Catalog (qcare is the actual catalog in this example), and q1 is the Search string (Care is the actual query in this example).

back to the top

Configure Usage Import for Query Strings

1. Click Start, point to Programs, point to Microsoft Site Server, point to Analysis, and then click Usage Import.
2. On the View menu, click Server Manager.
3. In the Server Manager window, expand Log Data Sources, expand Log Data Source, expand Servers, and then click the Site for which you want to import query strings.
4. On the Edit menu, click Properties.
5. On the Query Strings tab, in the Filesystem paths (URIs) box, type the URI for the query strings that you want to import. Separate multiple URIs with quotation marks and a space. (For the URI that is mentioned in the "Summary" section, type only a forward slash [/].)
6. In the Names of single-value query parameters to parse box, type the query parameter for the Search Catalog name. (For the URI that is mentioned in the "Summary" section, type only ct.)
7. In Names of multi-value query parameters to parse box, type the query parameter for the Search Query name. (For the URI that is mentioned in the "Summary" section, type only q1.)
8. Click OK to save and to close the Site Properties dialog box.
9. In the Import Manager window, under New Import, click the log data source that you want in the Log data source list, click the log access that you want in the Log access list, locate or type the log path that you want in the Log path list, and then click Add to list to select the log files for import.
10. After you select the log files for import, click Start Import to initiate the Web log import process.
11. Close the Usage Import window after import is completed.

back to the top

Verify Data Import

1. Click Start, point to Programs, point to Microsoft Site Server, point to Analysis, and then click the Custom Import window.
2. Click the Extend Database button. (Alternatively, on the View menu, you can click Custom Import Manager.)
3. Expand Dimensions, expand Requests, expand Query String, and then verify that the catalog column was created. Note that ct is displayed here.
4. Close Custom Import.

back to the top

Configure Report Writer

1. Click Start, point to Programs, point to Microsoft Site Server, point to Analysis, and then click Report Writer.
2. Click Report Writer Catalog.
3. In the Report Writer dialog box, expand Siteserver, select Search top query report, and then click Edit.
4. Remove all the filters at the top two levels in the report definition.
   
   To do this for each of the following levels, right-click the level, click Properties, delete the filter expression, and then click OK.
   • Search top query report (first level).
   • Overall query activity (second level).
   • Problem queries (second level).
5. Under each calculation, expand Row dimensions, and then click to rename the following:
   • Rename Search query as q1.
   • Rename Search catalogs as ct.
6. On the File menu, click Run Report to create and run the report.

back to the top