Computed fields Examples

Computed fields Examples
Name
Description
Data sources
Target table
Revenues - Total - Customer
Total expenses per customer
Customers
Orders
Customers
Revenues - Total - Month
Volume of expenditure in the last 6 months (excl. VAT)
Customers
Orders
Customers
Products
Revenues - Total - Web
Total volume of expenditure on the website (excl. VAT)
Orders
Customers
Revenues - Total - Store
Total volume of expenditure in shops (excl. VAT)
Orders
Customers
Revenues - Total - Category
Total volume of expenditure per category. Select up to 10 categories (one indicator per category)
Orders
Ordered Items
Products
Average basket
Total turnover / Number of orders
Orders
Customers
Customers
Average basket - On N Month
Total revenue / Number of orders over the last N month
Customers
Orders
Customers
Average basket - Web
Total revenue on Web / Number of orders on Web
Customers
Orders
Customers
Average basket - Store
Total revenue per shop/ Number of orders per shop
Customers
Orders
Customers
Nb orders - Total
Number of orders made
Orders
Customers
Nb of orders - Total - On N Month
Number of orders made over the last N month
Orders
Customers
Nb of orders - Total - Web
Number of orders made on Web
Orders
Customers
Nb of orders - Total - Store
Number of orders made per Shop
Orders
Customers
Nb of orders - Total - With Discount
Number of orders made that include at least one product with a promotion
Orders
Customers
Nb of orders - Total - โ€œLarge Sizesโ€
Number of orders made with at least one "Large size" product
Orders
Products
Product quantity - Total
Number of different products purchased
Orders
Products
Products
Product quantity - Total - On N Month
Number of different products purchased over the last N month
Orders
Products
Products
Average frequency of orders
Average difference between orders expressed in number of days. Empty if less than 2 purchases.
Orders
Customers
Shopping behavior - Preferred days
List of shopping days that account for more than 30% of orders
Orders
Customers
Shopping behavior - Preferred mont
List of months of orders that account for more than 30% of purchases
Orders
Customers
Shopping behavior - Discounts - Orders share
Share of orders made with at least one product with a promotion
Ordered Items
Orders
Customers
Shopping behavior - Discounts - Expenses share
Share of reductions achieved on total expenditure
Orders
Customers
Store - First Purchase
First time buyer's store
Orders
Customers
Store - Last Purchase
Last time buyerโ€™s store
Orders
Customers
Shopping behavior - Nb different categories
Number of different product categories already purchased
Orders
Ordered Items
Customers
First order date
Date of the first purchase
Orders
Customers
Last order date
Date of the last order
Orders
Customers
Shopping behavior -Last Purchase Online
Date of last online order
Orders
Customers
Shopping behavior - Last Purchase Offline
Date of last offline order
Orders
Customers
Shopping behavior - Last Email Opening
Last time an email was opened
Orders
Customers
Shopping behavior - Last Click
Date of the last email click
Orders
Customers
Last purchase channel
Channel (web, store, ..) of last purchase
Orders
Customers
Salesperson - Last Purchase
Salesperson who made the last sale in the shop
Orders
Customers
Shopping behavior - Categories
List of (separate) product categories with at least one order
Products
Customers
Shopping behavior - Stores
List of (separate) stores with at least one order (excluding eShop)
Orders
Customers
Shopping behavior - Collections
List of collections (Men's, Women's, Cultural) from which a order has been made
Products
Customers
Shopping behavior - Seasons
List of seasons (separate)
Orders
Customers
Shopping behavior - Nb of Article Per Basket
Average number of products per order made. (A product ordered twice is counted twice.)
Orders
Ordered Items
Customers
Shopping behavior - Nb of Stores
Number of (separate) stores with at least one order (excluding eShop)
Orders
Customers
Shopping behavior - Nb of Collections
Number of different product collections ordered
Products
Customers
Shopping behavior - Nb of Email - Cliks N Days
Number of clicks in emails received in the last N days
Customers
Customers
Shopping behavior - Nb of Email - Opened in the last N Days
Number of emails opened in the last 30 days
Customers
Customers
Age Ranges
Labelling of age groups > e.g. seniors = 60 years and over
Customers
Customers
Tag - Multi Buyer
True if number of orders > 1
Orders
Customers
Customers
Tag - Multi Categories
True if number of different category > 1
Orders
Products
Customers
Tag - New Customer
True if number of orders = 1
Customers
Orders
Customers
Tag - Regular Customer
True if number of orders >=2 over 12 months
Customers
Orders
Customers
Tag - Web Customer
True if at least one orders on the ecommerce
Customers
Orders
Customers
Tag - Store Customer
True if at least one order in a store
Orders
Customers
Customers
Tag - Mixed Customer
True if web customer and store customer
Customers
Orders
Customers
Tag - Single Store
True if number of store = 1
Orders
Tag - Multi Store
True if number of store > 1
Orders
Tag - Large Size Buyer
If Number_purchase_large_sizes > N
Ordered Items
Orders
Tag - High spending potential
True if you buy at least one item for Xโ‚ฌ or more
Orders
Ordered Items
Tag - Contact engage
True if number of clicks over N months >= X
Customers
Share