Bookshelf Home | Contents | Index | Search | PDF

Siebel Marketing Guide > Defining Attributes and Buckets > Defining Bucket Values >

Designing Buckets and Ranges of Values

---

When defining bucket values, be sure to cover every possible range, including negative numbers.

NOTE:  You can create two buckets and overlap their values, but each record that qualifies for more than one bucket is assigned to the first one for which it qualifies, starting from the top to the bottom of the Values list.

Table 27 shows a flawed design of a bucket of values.

Table 27. Problem Bucket Design

Label	Code	Operator	Value
Low	L	Between	0 and 10
Medium	M	Between	11 and 20
High	H	Between	20 and 50
Special	S	=	13

This design has several flaws:

No provision for negative values. A value of -5 fails to qualify for any bucket, and the data is lost.
No provision for high values. The highest value for a bucket is 50. Values higher than 50 fail to qualify for any bucket.
There is a gap between 10 and 11. The first bucket covers values up and including 10, and the second bucket covers values beginning with 11. If values are not whole numbers, (such as a value of 10.5), they do not qualify for any bucket. A value of 20 qualifies for both the Medium and High buckets, but the qualified value is assigned to the Medium bucket because it is evaluated before the High bucket.
The Special bucket will never get any assignments. The Medium bucket already covers the value of 13.

Table 28 illustrates a corrected design for a set of buckets:

Table 28. Corrected Bucket Design

Label	Code	Operator	Value
Special	S	=	13
Low	L	<=	11
Medium	M	Between	11 and 20
High	H	>	20

Bookshelf Home | Contents | Index | Search | PDF