A while ago I needed to build a conversion report containing two dimensions; a dimension showing conversions entered by one of two Customer Care Centers or showing the term External. The CCS’s could be determined by static IP addresses. So all External conversions could be determined by all IP addresses minus the CCC’s IP addresses.
To build this report, I used a WebTrends Custom Report with one custom Dimension and the standard WebTrends Dimension Product (Drilldown). The Custom Dimension includes a translation with a Custom Report Datasource.
These are the steps I took to get this report:
1. Create Custom Report Datasource translation file “Visitor.csv.txt” and place it on the WebTrends server.

2. Create Custom Report Datasource

3. Create a Custom Dimension based on Visitor (this is the IP address). Check “Override default string” and enter “Extrernal” as description. This will replace the “None” in your report. Enter a Regular Expression to pick out the IP addresses of the CCC’s so that these will be translated and the other IP addresses won’t.

2. Create a new Custom Report, add the newly created Custom Dimension “Visitor” and the WebTrends dimension “Product (Drilldown)”.

Now add this Custom Report to your profile and analyze it.
This is how your report will look like (I removed dimension Product (Drilldown) for this screenshot.
