Definitions for orders
4 approved definitions on this dataset. Agents that ask for one by name get this definition back with the number, so every agent counts it the same way. 4 used by agents in the last 30 days.
Approved 4
paid_revenue used by agents
sum(amount) where status is "paid"
Approved by Northwind Studio
Revenue from paid orders; refunds excluded.
Edit
average_order_value used by agentsEUR
avg(amount) where status is "paid"
Approved by Northwind Studio · Also answers to aov
Average amount of a paid order.
Edit
paid_orders used by agents
count(rows) where status is "paid"
Approved by Northwind Studio · Also answers to orders
Orders with status paid; refunded orders don't count.
Edit
refunded_orders used by agentslower is better
count(rows) where status is "refunded"
Approved by Northwind Studio
Orders refunded after payment.
Edit
Add a definition
Glossary
Words that mean something specific here. Agents read them with every dataset.No terms yet. For example: active customer, ordered in the last 90 days.