CSE Demo
| Column Name | Rules | Example Value | Definition |
| SessRef | TST:<date>_<time>_<nnnn> OLD:<nnnnnnnn>_<nnnnnnn> |
2009-07-27_13-54-03_3241 72778538_9002098 |
The unique reference for a web session. |
| CustDMID | Valid email address
|
support@dmclub.net | The email address that uniquely identifies a customer. |
| Address | Valid telephone number | 442070602000 | The telephone number that uniquely identifies a service account. |
| SessStartGMT | GMT date/time | 2009-06-27 13:54:03 | The GMT time of the "entry" hit that started the TST session. |
| SessStartDay | GMT date | 2009-06-27 | The day the session started |
| SessStartWeek | GMT week | 09w31 | The year and week the session started |
| SessStartMonth | GMT month | 2009-06 | The month the session started |
| QHits | Number | 45 | The total number of page hits during the session. |
| DurSecs | Number | 123 | The duration of the session in seconds |
| SourceURL | Valid URL | http://google.com/search?q=dmclub | Where the customer came from. |
| EntryURL | Valid URL | http://dmclub.dmshop.uk.com/ numbers/index.php?FedSessKey= CLB_52227860_7340515_m2001& tsts=clbhs&tstc=_r24s1&tsta=csla |
The complete URL of the first page the customer saw. |
| ExitPage | Page name | numbers/07pn2/choose.php | The page on which the customer left the session |
| App | [a-zA-Z0-9._()] | dmABS | What application was serving the session. |
| AppVersion | [a-zA-Z0-9._()] | 1.6.A.1-(BU)-svn98 | The version number of the application. |
| AppFlags | [a-zA-Z0-9._()] | FCG | Flags indicating various application settings (mainly for internal DML use). |
| AppFQDN | Valid fully qualified domain name | dmclub.dmshop.uk.com | The fully-qualified domain name of the domain the session was served from. |
| DebugTag | [a-zA-Z0-9._()] | test_hit | Any special debugging tags that have been added to the session. |
|
Source |
[a-zA-Z0-9._-()] | The source of the referral. |
|
|
Medium |
[a-zA-Z0-9._-()] | Organic Search | The promotional medium. |
|
AdCode |
[a-zA-Z0-9._-()] | g3a2 | A unique ad identifier. |
|
CampaignCode |
[a-zA-Z0-9._-()] | 070nov | A unique campaign identifier. |
| CampaignName | [a-zA-Z0-9._-()] | November 070 sales campaign | (not implemented yet) A friendly name for the campaign identified by the campaign code |
|
SearchTerm |
Free text | buy 0871 switchboard | The search term the customer used to find your website. |
| CustDMID | Valid email address | support@dmclub.net | The email address that uniquely defines the customer who logged in during the session |
| CustCreateGMT | GMT date/time | 2006-04-03 15:43:03 | When the customer first registered with that email address |
| CustDealerID | Numeric identifier | 9111 | The unique numeric identifier of the dealership the customer originally signed up with |
| QCmplChgdOrd | Number | 3 | The number of complete charged orders for the session/campaign |
| QCmplFreeOrd | Number | 3 | The number of complete free orders for the session/campaign |
| QPendChgdOrd | Number | 3 | The number of pending charged orders for the session/campaign |
| QPendFreeOrd | Number | 3 | The number of pending free orders for the session/campaign |
| TotCmplChgdVA | Currency value (UKPX) with accuracy of four decimal places | 12.3456 | Total amount of VA generated from complete charged orders |
| TotCmplChgdDVA | Currency value (UKPX) with accuracy of four decimal places | 12.3456 | Total amount of Dealer VA generated from complete charged orders |
| TotCmplChgdGross | Currency value (UKPX) with accuracy of four decimal places | 12.3456 | Total gross value of complete charged orders |
| TotPendChgdVA | Currency value (UKPX) with accuracy of four decimal places | 12.3456 | Total amount of VA generated from pending charged orders |
| TotPendChgdDVA | Currency value (UKPX) with accuracy of four decimal places | 12.3456 | Total amount of Dealer VA generated from pending charged orders |
| TotPendChgdGross | Currency value (UKPX) with accuracy of four decimal places | 12.3456 | Total gross value of pending charged orders |
| CmpnTotCmplChgdVA | Currency value (UKPX) with accuracy of four decimal places | 12.3456 | Total amount of VA generated from complete charged orders |
| CmpnTotCmplChgdDVA | Currency value (UKPX) with accuracy of four decimal places | 12.3456 | Total amount of Dealer VA generated from complete charged orders |
| CmpnTotCmplChgdGross | Currency value (UKPX) with accuracy of four decimal places | 12.3456 | Total gross value of complete charged orders |
| CmpnTotPendChgdVA | Currency value (UKPX) with accuracy of four decimal places | 12.3456 | Total amount of VA generated from pending charged orders |
| CmpnTotPendChgdDVA | Currency value (UKPX) with accuracy of four decimal places | 12.3456 | Total amount of Dealer VA generated from pending charged orders |
| CmpnTotPendChgdGross | Currency value (UKPX) with accuracy of four decimal places | 12.3456 | Total gross value of pending charged orders |
| SignupQDealer | Integer | 1 | The number of dealers signed up in the session. |
| SignupDealerID | Integer | 9111 | The DealerID of the first dealer signed up in the session. |
| SignupDealerType | String | Pro | Not currently used. |