Help for the BTR Welcome Page
Data Definition for Dealer Business Reports
Common Naming Conventions
- "Q" at the start of a column name is an abbreviation for "Quantity". It means that the column says how many of something there are.
- "GMT" at the end of a column name indicates that the column contains GMT date/time values.
- "VA" at the end of a column name indicates that the column contains an amount of "Value Add" in UK pounds ex VAT.
Primary Identifier
|
Column Name |
Rules |
Example Value |
Definition |
|
|
SessRef |
TST:<date>_<time>_<nnnn> OLD:<nnnnnnnn>_<nnnnnnn> |
2009-07-27_13-54-03_3241
|
The unique reference for a web session. |
|
|
CmsnDealerID |
Numeric ID |
9111 |
The unique numeric identifier of the dealership to which any commission will be credited. |
|
|
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 |
Session description
|
Column Name |
Rule |
Example Value |
Definition |
|
SessStartGMT |
GMT date/time |
2009-06-27 13:54:03 |
The GMT time of the "entry" hit that started the TST session. |
|
QHits |
Number |
45 |
The total number of page hits during the session |
|
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 |
|
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 |
|
FirstLineLog |
TST log line |
203.55.231.100 - - [30/Jul/2009:03:23:28 +0000] "GET http://dmclub.dmshop.uk.com/numbers/index.php? FedSessKey=CLB_52227860_7340515_m2001 &tsts=clbhs&tstc=_r24s1&tsta=csla HTTP/1.1" 200 - "http://my.dmclub.net/dmclub_R19S1/LoginAction.cfm? dmb1_SessRef=2008- |
The complete first line of the TST session log from which the session information was extracted |
SMACT tagging
|
Column Name |
Rules |
Example value |
Definition |
|
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._-()] |
08noct06 |
A unique campaign identifier |
|
SearchTerm |
Free text |
buy 0871 switchboard |
The search term the customer used to find your website |
Customer Information
|
Column Name |
Rule |
Example value |
Definition |
|
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 |
Counting orders
|
Column Name |
Rule |
Example value |
Definition |
|
QCmplChgdOrd QCmplFreeOrd QPendChgdOrd QPendFreeOrd |
Number |
3 |
The number of orders of each type/status for each session or campaign. Orders can have a status of either Complete or Pending, and a type of either Charged or Free. |
Adding up commission
|
Column Name |
Rule |
Example value |
Definition |
|
TotCmplChgdVA TotCmplChgdDVA TotCmplChgdGross TotPendChgdVA TotPendChgdDVA TotPendChgdGross |
Currency value (UKPX) with accuracy of four decimal places |
12.3456 |
The total amount of VA, dealer VA and gross order value generated in the session from orders of each type and status. Orders can have a status of either Complete or Pending, and a type of either Charged or Free. |
|
CmpnTotCmplChgdVA CmpnTotCmplChgdDVA CmpnTotCmplChgdGross CmpnTotPendChgdVA CmpnTotPendChgdDVA CmpnTotPendChgdGross |
Currency value (UKPX) with accuracy of four decimal places |
12.3456 |
The total amount of VA earned in the campaign from orders of each type and status. Orders can have a status of either Complete or Pending, and a type of either Charged or Free. |
Dealer signup
|
Column Name |
Rules |
Example Value |
Definition |
| 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. |