ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
KPI Color Codes:Red = Workaround/Static Vals for NowYellow = Need to Implement by WeekendGreen = Already Implemented
2
3
KPIOmnivore API EndpointOmnivore Query params (Where clauses) or JSON Parsing
Example output of the query (Omnivore request)
Seth's NotesDarren's notesStatus (Implemented, Ongoing, Todo)
4
Average Appetizer Sales (1)https://api.omnivore.io/1.0/locations/TXdkXXgc/tickets?fields=@items(name,@menu_item(@menu_categories.name))?fields=@items(name,price,@menu_item(@menu_categories.name))link to JSON
5
Average Entree Sales (2)https://api.omnivore.io/1.0/locations/TXdkXXgc/tickets?fields=@items(name,price,@menu_item(@menu_categories.name))?fields=@items(name,price,@menu_item(@menu_categories.name))link to JSON
6
Average Dessert Sales (3)https://api.omnivore.io/1.0/locations/TXdkXXgc/tickets?fields=@items(name,price,@menu_item(@menu_categories.name))?fields=@items(name,price,@menu_item(@menu_categories.name))link to JSON
7
Average Beverage Sales (4)https://api.omnivore.io/1.0/locations/TXdkXXgc/tickets?fields=@items(name,price,@menu_item(@menu_categories.name))?fields=@items(name,price,@menu_item(@menu_categories.name))link to JSON
8
Average Home Run Count (5)
9
Average Check Count (6)https://api.omnivore.io/1.0/locations/TXdkXXgc/ticketsnumber of tickets
10
Average Cover Count (7)https://api.omnivore.io/1.0/locations/TXdkXXgc/tickets?fields=guest_count?fields=guest_countlink to JSON
11
Average Check (8)https://api.omnivore.io/1.0/locations/TXdkXXgc/tickets?fields=totals.totaldivision: total/# of ticketslink to JSON
12
Average Sales Per Customer (9)https://api.omnivore.io/1.0/locations/TXdkXXgc/tickets?fields=guest_count,totals.totaldivision: total/guest_countlink to JSON
13
Total Revenue (10)https://api.omnivore.io/1.0/locations/TXdkXXgc/tickets?fields=totals.total
?fields=totals.total (NOTE: NEED TO DIVIDE VALUE BY 100.0 TO GET ACTUAL DOLLAR VALUE
link to JSON
14
Average Net Sales (11)https://api.omnivore.io/1.0/locations/TXdkXXgc/tickets?fields=totals.sub_total?fields=totals.sub_totallink to JSON
15
Average Tip Percentage (12)https://api.omnivore.io/1.0/locations/TXdkXXgc/tickets?fields=totals(tips,total)?fields=totals(tips,total)link to JSON (included 2 tickets since no tip on first one)
16
Average Table Turn Time (13)https://api.omnivore.io/1.0/locations/TXdkXXgc/tickets?fields=opened_at,closed_at?fields=opened_at,closed_atlink to JSON
17
Average Upsells (14)https://api.omnivore.io/1.0/locations/TXdkXXgc/tickets?fields=@items(name,price,modifiers)?fields=@items(name,price,modifiers)link to JSON
18
Average Errors (15)https://api.omnivore.io/1.0/locations/TXdkXXgc/tickets?fields=void?fields=voidlink to JSON
19
Average GoodWorker Score (16)not from omnivore
Formula Doc (may need to simplify for time?)
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