Help for dmAdmin BTR/Orders
BTR/Orders and Orderlines/Analysis Spreadsheet
Download the Orders and Orderlines template spreadsheet
What's this page for?
This page lets you choose what kind of report you want, filter for particular kinds of order (eg Gold numbers only) and choose a time period for your report. See below for an explanation of how you can configure your Orders and Orderlines report.
How to configure your report
- Filter: This lets you choose whether to show all orders, orders of a particular type only, or orders aggregated by month.
- Period: This lets you choose the period of time your report will cover.
- Max Rows: This lets you specify the maximum number of rows in your report. Choose between 100, 1000 and 10,000 rows.
- Delivery: This lets you choose whether to see the results of your report in dmAdmin, or download the report as a .zip file containing CSV data. (If you've got detailed analysis to do, we recommending downloading your file as you can open the CSV file in Excel and use our template (below) to analyse the data.
Downloadable analysis template
Click here to download an Excel template that will help you analyse your orders and orderlines information
Guide to the columns in your report
| Column name | Rules | Example Value | Description |
| OrderRef | OrderRef | Ord.2009.10.00312 | The unique reference identifying the order |
| OrderGMT | DateTimeGMT | 2009-10-13 14:43:21 | When the order was initially placed |
| AccDate | DateGMT | 2009-10-13 | The last date on which an accounting transaction took place in relation to the order |
| AccDay | DateGMT | 2009-10-13 | The last day on which an accounting transaction took place in relation to the order |
| AccWeek | WeekGMT | 09W32 | The last week in which an accounting transaction took place in relation to the order |
| AccMonth | MonthGMT | 2009-09 | The last month in which an accounting transaction took place in relation to the order |
| Number | PhoneNumber | 442070173450 | The number to which the order relates |
| OrderType | OrderType | Initial | The type of the order |
| CustDMID | CustAccRef | fred.bloggs@digitalmail.com | The DMID of the customer who placed the order |
| CustStatus | CustStatus | New | Whether the customer is new or already known to us |
| TotVA | Money.Amt (x VA) | 12.5 | The total VA for the order |
| TotDealerVA | Money.Amt (x VA) | 12.5 | The total Dealer VA for the order |
| TotGross | Money.Amt (x VA) | 12.5 | The total gross value of the order |
| GoldValue | Money.Amt (x VA) | 12.5 | The gold value of the order |
| Tariff | TariffName | Public.EC-UK-PER-K-Bas | The tariff the order was placed for |
| TariffGen | TariffGen | T2 | The tariff generation |
| Service | TariffService | dmConnect | The service ordered |
| Plan | TariffPlan | Bas | The plan ordered |
| Region | Number.Region | UK | The region to which the number belongs |
| NumberClass | Number.Class | PER | The class to which the number belongs |
| NumberType | Number.Type | PER-K | The type of the number |
| SessRef | SessRef | 13115255_8758739 | The unique session reference of the session the order was placed in |
|
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 (You need to set up your own tags for anything to appear in this column) |
|
CampaignCode |
[a-zA-Z0-9._-()] |
08noct06 |
A unique campaign identifier (You need to set up your own tags for anything to appear in this column) |
|
SearchTerm |
Free text |
buy 0871 switchboard |
The search term the customer used to find your website |