WinTree allows you to create, save and manipulate Terms. You will use the Terms to create the decision "nodes" in the trees you will design.
Later, you will be able to combine your term as in
Buyer12Mos AND Retired
However, to get started you will be using a language that is very similar to the database programming language SQL.
For example, to create the term Buyer12Mos you might write:
EXIST(SELECT * FROM OrdersTable
WHERE Months(CurrentDate,OrderDate) < 12)
In English,
select the customers who have orders (OrdersTable)
within the last 12 months. (Months(CurrentDate,OrderDate) < 12)
Click the buttons for more examples...
Click Next to continue...
Term: ParentBuyers
Description: Buyers who bought 2 or more children's products in the last 12 months.
SQL:
2
<= (SELECT SUM (qtyord)
FROM
tblorder
WHERE
category = "C" AND
order_value
> 0 AND
purchase_date
>= SELECT_DATE_12)
In
English:
Select customers with 2 or more orders (SUM (qtyord)
) from the order table (tblorder) where the orders are for children
(category = "C"), the order had a positive value (order_value
> 0) and the order date is within the last 12 months
(purchase_date >= SELECT_DATE_12).
Term: ParentsOver40
Description: Buyers who are parents and are over 40.
SQL:
2
<= (SELECT SUM (qtyord)
FROM
tblorder
WHERE
category = "C" AND
order_value
> 0)
AND age >= 40
In
English:
Select customers with 2 or more orders (SUM (qtyord)
) from the order table (tblorder) where the orders are for children
(category = "C"), the order had a positive value (order_value
> 0) and their age is greater than or equal to 40 (age >= 40).
