Orders Data Views - Metrics and Where the data comes from

	A	B	C	D
1	Metric	Where does this data come from?	Data Type	Example Data

2	Monthly Billing Amount for Order	monthly_billing_amt field on Line Items	Currency
3	Created at	Order Create Date	Date
4	Primary Dashboard Date	Order Start Date OR End Date OR Create Date	Date
5	Order Count	Total Number of Orders	Number
6	Business Unit	Business Unit	Text
7	Client	Client	Text
8	ID (groupable)	Order ID	Text
9	Salesperson	Salesperson (as assigned on the Order using salesperson_id)	Text
10	Status	Order Status	Text
11	Type	Order Type (as assigned on the Order using order_type)	Text
12	Workflow Step	Order Workflow Step	Text
13
14
15
16	"Primary Dashboard Date" Note: - If "Start Date" (from 'start_date') exists, use that for the dashboard date picker - If "Start Date" (from 'start_date') does not exist, then look for End Date (from 'end_date') and use that for the dashboard date picker - If "End Date" (from 'end_date') does not exist, then look for Create Date and use that for the dashboard date picker Create Date is the last step is because an Order is guaranteed to have that value filled in, but that's not ideally how someone would want to report on Orders data in TA, which is why the logic is as it is above. If you have an arbitrary "Start Date" / "End Date" with a key that is not 'start_date' / 'end_date' then the system will revert to "Created Date" - you need to use the special TO fields.
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100