dcsimg

How does the Sum across visit option work in custom measures?

Products

Webtrends Analytics 9.x
Webtrends Analytics 8.x

Issue

When creating or editing a custom dimension, the “When to measure” screen has an option to sum the measure across the visit. Some standard measures have this option selected by default, but it is not the appropriate setting for all situations.

Resolution

Use of this option is best explained through an example.

The attached log file contains a single visit with a series of hits which include a custom parameter, WT.test. This parameter has values of 1,2, 3 or 4. Also present on these same hits is the parameter WT.dim with values A, B, C or D.

A custom dimension is created, based on the parameter WT.dim, collecting data on all hits. In the custom report using this dimension, we expect to see the values A, B, C and listed.

Custom measures are created based on the parameter WT.test, collecting on all hits. On one measure, the option to “Sum across visit” is selected. Call this measure “WT.test – sum.” On the other measure, “WT.test – no sum,” the option is not selected.

The custom dimension and custom measures are added to a custom report and the profile is analyzed. Report data will appear as follows:

Dimension:
A
B
C
D
None

“No Sum” measure
1
2
3
4
0

“Sum” measure
10
10
10
10
10

When “Sum across visit” is selected all of the measure totals are summed and apply to all specified dimensional values for that visit. When tracking hit based statistics this option will appear to have little value. However, there are times when this is relevant. For example, a report that displays revenue associated with referring sites will, when the option to “Sum across visit” is selected, display the total revenue for the entirety of each visit. If the option to “Sum across visit” is not selected, the only way to see accurate revenue totals would be if the purchases were made on the first hit to the site.

There are other examples where it is appropriate to use a “Sum across visit” measure, but most often the correct measure to use is going to be the ‘no sum’ option. As always, it is a best practice test custom reports with a sample log before deploying them to production profiles to ensure correct behavior and avoid the need for replays or reanalysis.

More Information

#Resillylogentry: DCS-p#Software: WebTrends SmartSource Data Collector V7.0
#Version: 1.0
#Date: 2009-01-02 16:42:50#Fields: date time c-ip cs-username cs-host cs-method cs-uri-stem cs-uri-query sc-status sc-bytes cs-version cs(User-Agent) cs(Cookie) cs(Referer) dcs-id

2024-01-01 10:14:00 23.45.67.89 usera www.test1.org GET /folder/folder2/somefile.html WT.dim=A&WT.test=1&Param1=foo&Param2=foo&WT.tz=-5&WT.bh=10&WT.ul=en-us&WT.cd=32&WT.sr=1280×960&WT.jo=Yes&WT.ti=Untitled%20Document&WT.js=Yes&WT.jv=1.3&WT.sp=@@SPLITVALUE@@&WT.co_d=23.45.67.89-3297284912.29677328::E8E643A6D798DA238B5C9FE3BBED2603&WT.co=Yes&WT.vt_s=1&WT.vt_d=1 200 – – Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322) – – dcsoj8s2rttqseo6mnpxvojdy_7s2b
2024-01-01 10:18:32 23.45.67.89 usera www.test1.org GET /folder/folder2/somefile.html WT.dim=B&WT.test=2&Param2=foo&WT.tz=-5&WT.bh=10&WT.ul=en-us&WT.cd=32&WT.sr=1280×960&WT.jo=Yes&WT.ti=Untitled%20Document&WT.js=Yes&WT.jv=1.3&WT.sp=@@SPLITVALUE@@&WT.co=Yes 200 – – Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322) WEBTRENDS_ID=23.45.67.89-3297284912.29677328::E8E643A6D798DA238B5C9FE3BBED2603 – dcsoj8s2rttqseo6mnpxvojdy_7s2b 2024-01-01 10:18:33 23.45.67.89 usera www.test1.org GET /folder/folder2/somefile.html Param3=foo&WT.tz=-5&WT.bh=10&WT.ul=en-us&WT.cd=32&WT.sr=1280×960&WT.jo=Yes&WT.ti=Untitled%20Document&WT.js=Yes&WT.jv=1.3&WT.sp=@@SPLITVALUE@@&WT.co=Yes 200 – – Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322) WEBTRENDS_ID=23.45.67.89-3297284912.29677328::E8E643A6D798DA238B5C9FE3BBED2603 http://www.somedomain.cod/folder/folder2/somefile.html dcsoj8s2rttqseo6mnpxvojdy_7s2b
2024-01-01 10:18:35 23.45.67.89 usera www.test1.org GET /folder/folder2/somefile.html Param4=foo&WT.tz=-5&WT.bh=10&WT.ul=en-us&WT.cd=32&WT.sr=1280×960&WT.jo=Yes&WT.ti=Untitled%20Document&WT.js=Yes&WT.jv=1.3&WT.sp=@@SPLITVALUE@@&WT.co=Yes 200 – – Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322) WEBTRENDS_ID=23.45.67.89-3297284912.29677328::E8E643A6D798DA238B5C9FE3BBED2603 http://www.somedomain.cod/folder/folder2/somefile.html dcsoj8s2rttqseo6mnpxvojdy_7s2b
2024-01-01 10:19:00 23.45.67.89 usera www.test1.org GET /folder/folder2/somefile.html WT.dim=C&WT.test=3&Param1=foo&Param2=foo&WT.tz=-5&WT.bh=10&WT.ul=en-us&WT.cd=32&WT.sr=1280×960&WT.jo=Yes&WT.ti=Untitled%20Document&WT.js=Yes&WT.jv=1.3&WT.sp=@@SPLITVALUE@@&WT.co_d=23.45.67.89-3297284912.29677328::E8E643A6D798DA238B5C9FE3BBED2603&WT.co=Yes&WT.vt_s=1&WT.vt_d=1 200 – – Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322) – – dcsoj8s2rttqseo6mnpxvojdy_7s2b
2009-01-01 10:19:32 23.45.67.89 usera www.test1.org GET /folder/folder2/somefile.html WT.dim=D&WT.test=4&Param2=foo&WT.tz=-5&WT.bh=10&WT.ul=en-us&WT.cd=32&WT.sr=1280×960&WT.jo=Yes&WT.ti=Untitled%20Document&WT.js=Yes&WT.jv=1.3&WT.sp=@@SPLITVALUE@@&WT.co=Yes 200 – – Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322) WEBTRENDS_ID=23.45.67.89-3297284912.29677328::E8E643A6D798DA238B5C9FE3BBED2603 – dcsoj8s2rttqseo6mnpxvojdy_7s2b 2009-01-01 10:19:33 23.45.67.89 usera www.test1.org GET /folder/folder2/somefile.html Param3=foo&WT.tz=-5&WT.bh=10&WT.ul=en-us&WT.cd=32&WT.sr=1280×960&WT.jo=Yes&WT.ti=Untitled%20Document&WT.js=Yes&WT.jv=1.3&WT.sp=@@SPLITVALUE@@&WT.co=Yes 200 – – Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322) WEBTRENDS_ID=23.45.67.89-3297284912.29677328::E8E643A6D798DA238B5C9FE3BBED2603 http://www.somedomain.cod/folder/folder2/somefile.html dcsoj8s2rttqseo6mnpxvojdy_7s2b
2009-01-01 10:19:35 23.45.67.89 usera www.test1.org GET /folder/folder2/somefile.html Param4=foo&WT.tz=-5&WT.bh=10&WT.ul=en-us&WT.cd=32&WT.sr=1280×960&WT.jo=Yes&WT.ti=Untitled%20Document&WT.js=Yes&WT.jv=1.3&WT.sp=@@SPLITVALUE@@&WT.co=Yes 200 – – Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322) WEBTRENDS_ID=23.45.67.89-3297284912.29677328::E8E643A6D798DA238B5C9FE3BBED2603 http://www.somedomain.cod/folder/folder2/somefile.html dcsoj8s2rttqseo6mnpxvojdy_7s2b
2009-01-01 17:21:33 23.45.67.96 usera www.test1.org GET /folder/folder2/somefile.html Param3=foo&WT.tz=-5&WT.bh=17&WT.ul=en-us&WT.cd=32&WT.sr=1280×960&WT.jo=Yes&WT.ti=Untitled%20Document&WT.js=Yes&WT.jv=1.3&WT.sp=@@SPLITVALUE@@&WT.co=Yes 200 – – Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322) WEBTRENDS_ID=23.45.67.96-3297284912.29677328::E8E643A6D798DA238B5C9FE3BBED2603 http://www.somedomain.cod/folder/folder2/somefile.html dcsoj8s2rttqseo6mnpxvojdy_7s2b
2009-01-01 17:21:35 23.45.67.96 usera www.test1.org GET /folder/folder2/somefile.html Param4=foo&WT.tz=-5&WT.bh=17&WT.ul=en-us&WT.cd=32&WT.sr=1280×960&WT.jo=Yes&WT.ti=Untitled%20Document&WT.js=Yes&WT.jv=1.3&WT.sp=@@SPLITVALUE@@&WT.co=Yes 200 – – Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.1;+SV1;+.NET+CLR+1.1.4322) WEBTRENDS_ID=23.45.67.96-3297284912.29677328::E8E643A6D798DA238B5C9FE3BBED2603 http://www.somedomain.cod/folder/folder2/somefile.html dcsoj8s2rttqseo6mnpxvojdy_7s2b