Lookup Tables for URL Parameter Analysis

You can also specify a standard lookup table in the URL Parameter Analysis settings.

Lookup tables must be text files with two columns and use commas, equals signs (=), or tabs as a delimiter. The key column is always the first column from the left, and the value column is the second column. URL Parameter Analysis does not support lookup table databases.

Webtrends interprets the characters before the first delimiter (comma or tab) as the key column, and all the characters after the first delimiter as part of the value column. This means that all characters after the first column are interpreted as part of the translated value, including additional delimiters and quotation marks. Quotation marks are not removed in report output. For example, if the value column contains the value news,foreign, as described in the example for custom report translation, Webtrends processes all the content after the comma as part of the value. The following table shows how Webtrends processes a lookup table where a value contains an internal delimiter.

Lookup Table Key Column

Lookup Table Value Column

Additional Data Column

Translated Value

1234

news,foreign

none

news,foreign

1234

"news,foreign"

none

"news,foreign"

1234

news,foreign

$25,000

news,foreign$25,000

If there are only two columns, Webtrends returns the value correctly as news,foreign. Any quotes enclosing the value are also returned in the report data. However, if the file contains any additional data in the same row, Webtrends interprets it as part of the value column and adds it to the translated string. As shown in the example, if the value column is followed by a comma-delimited column containing information about ad revenue, Webtrends returns a nonsensical value like news,foreign,$25,000.