Bookshelf Home | Contents | Index | Search | PDF |
Siebel Marketing Guide > Creating Measures >
Custom Measures
Custom Measures are derived metrics that are built by using formulas and calculations based on other measures. They may include logical functions such as IsPositive, IsZero, and Not, and mathematical functions such as Absolute, Random, and Sign. Custom measures can also be aggregated to various targeting levels of a customer hierarchy using aggregate functions such as Sum, Count, Average, Minimum, or Maximum.
The Custom measure detail view includes the Custom measure form at top, and the measure-builder panes, which contains Available Measures, and Expression Builder elements. In addition, you can use the optional custom measure Aggregation view and Restriction view to refine the data set to which the custom expression applies.
Custom measures can be aggregated to each targeting level within the customer hierarchy. If you select a customer hierarchy and targeting level for a custom measure, Siebel Marketing assumes that you intend to aggregate the measure, and requires an aggregation function before you can save the custom measure.
When you specify the level, you are indicating that data from the level below should be aggregated up to the level selected. For example, if a customer has multiple bank accounts, calculating a Total Balance (sum) across accounts would be a custom measure for the targeting level.
The choice of aggregation levels determines what measures are available to use in the measure you are building. If you select a secondary targeting level as your aggregation level, you can only work with measures at that level and below. Measures aggregated at higher levels are not available.
Restrictions imposed using the custom measure Restriction view are flagged with a check mark in the Restrictions check box after you save the restriction. Measure restrictions are useful if you want to see list measure output that is computed at a certain hierarchical level, a specific bucket definition, and so on without restricting the counts of a targeted segment or the entire stage. For example, you might want to know the average dollars that were spent in the last quarter of 2000 but see this data for customers that spent money in the four quarters of 2000.
Table 33 provides examples of some uncomplicated custom measures and expressions.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Marketing Guide, Version 7.5, Rev. A Published: 18 April 2003 |