Custom Report level filters behavior with dimensions that use lookup tables

Custom Report level filters behavior with dimensions that use lookup tables

Products:
Webtrends On Demand
Webtrends Analytics 8.7
Webtrends Analytics 9.2


Introduction:
A Custom Report level filter that acts on a dimension that uses a lookup table will only filter on the translated value. The original value passed by the parameter will not be able to be filtered on. This is the case for both hit and visit filters.


Procedure:
As an example, consider a dimension that uses a parameter named Test and the value of 'Test' is passed for this parameter, with the following entry in the Lookup Table's csv file:
Test,Bar

If a hit filter is configured to exclude 'Test' for this dimension, no traffic will be excluded. If the filter is configured to exclude 'Bar' then any values passed for the parameter Test that are translated to 'Bar' (i.e. 'Test') will be excluded.

Note that this only affects Custom Report filters. Profile level hit and visit filters will use the untranslated value that is passed for determining whether or not to exclude traffic.

    • Related Articles

    • Custom Report shows visitors with 0 hits and multiple visits

      Products: Webtrends Analytics 8.x Webtrends OnDemand Symptoms: You have created a custom report with Visitors as a dimension and hits and visits as measures.  You also have at least one filter on the profile.  When viewing the report, it appears the ...

    • Custom dates vs. canned ranges

      For products: Webtrends Analytics v8.x Webtrends Enterprise 7.x Webtrends Professional 7.x Webtrends Small Business 7.x Situation: When viewing a custom date range instead of a canned range, visitor counts are much higher than expected. Solution: ...

    • Can I use letters for a WT.dl value?

      For products: Webtrends On Demand Webtrends Analytics 9.2 Webtrends Analytics 8.x Last modified: 8/3/2010 Situation: You would like to use letters for the value of WT.dl. Solution: While there isn't technically a reason why you wouldn't use an ...

    • How to create custom query parameters with DCSext

      For products: Webtrends On Demand Webtrends Analytics 9.2 Webtrends Analytics 8.x Last modified 8/6/2010 Introduction: The Webtrends tag scans the source code of the page for META tags looking for known Webtrends query parameters to add to the data. ...

    • How to create custom query parameters with DCSext

      For products: Webtrends On Demand Webtrends Analytics 9.2 Webtrends Analytics 8.x Last modified 8/6/2010 Introduction: The Webtrends tag scans the source code of the page for META tags looking for known Webtrends query parameters to add to the data. ...