Help for dmAdmin BTR/Sessions
BTR/Campaigns And Sessions/Analysis Spreadsheet
Download the Campaigns and Sessions template spreadsheet
What's this page for?
Use this page to specify the kind of report you want. Then choose either to view the report onscreen, or download it as a .CSV file for analysis.
This Help section explains what each group of data means. Bear in mind that there's a lot of information in the reports, and it can be a bit overwhelming when viewed on a screen. So to get the best from your reports, we recommend that you download your chosen report as a .CSV file, and then use our template spreadsheet to analyse it.
Use the links below to jump to more information about different areas of your report.
Help contents for this page
Choosing a campaign and session report
Common naming conventions
Identifying information
Session description
SMACT tagging
Customer information
Counting orders
Adding up commission
Dealer signup
Choosing a campaign and session report
- Filter
- Select whether to show all sessions, sessions with orders or high-valued orders only, or sessions aggregated by campaign code
- Period
- Select the period of time to generate the report for
- Max Rows
- Select the maximum number of rows to be returned and displayed or added to the CSV download file
- Delivery
- Select whether to see the results on this page, or download them as a .zip file containing Excel-readable CSV data
- Download resources
- BTR-CampaignsAndSessions-TEMPLATE_ADB-thu13may10-v5.xls
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.
Identifying information
This group of data gives you information that helps you identify sessions, dealerships and customers.
| 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. |
Session description
This group of data gives you more information about a TST session (a visit to one of your sales pages via a link tagged with TST tags).
|
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. |
|
| 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 |
|
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. |
SMACT tagging
This group of data gives more details about how they arrived at your site. In order to get this information, you need to add SMACT tags to your campaign URLs (such as the click-through URL you provide for a pay per click campaign) when you set up the campaign. For more information on SMACT tagging, see the dmABS Affiliate and Adapted setup guides, available from our Downloads page.
|
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._-()] |
070nov |
A unique campaign identifier. |
|
| CampaignName |
|
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. |
Customer Information
This group of data gives you more information about the customer.
|
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
This group of data tells you more about any orders placed during the session.
|
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
This group of data gives you detail about how much commission you've earned as a result of any sales.
|
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. |
| CmsnDealerId | DealerID (4 or 5 digits) | 6731 | The ID of the dealer earning commission on this line (should be you!) |
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. |