Calculation Operators

The equations that you build as part of a SiteSpect Calculation use the following set of mathematical and logical operators.

Operator Description
Mathematical Operators
+ Addition
- Subtraction
* Multiplication
/ Division
() Grouping - Follows standard mathematical order of operation rules.
= Equal to
<=> NULL-safe equal to. Performs an equality comparison like the = operator but returns 1 rather than NULL if both operands are NULL and 0 rather than NULL if one operand is NULL.
<>, != Not equal to
< Less than
> Greater than
<= Less than or equal to
>= Greater than or equal to
ROUND(n), ROUND(n, d) Rounds the argument n to d decimal places. d defaults to 0 if it is not specified.
Logical Operators
AND, && Logical AND. Returns 1 if all operands are nonzero and not NULL. Returns 0 if one or more operands is 0. Otherwise, it returns NULL.
OR, || Logical OR. When both operands are non-NULL, returns 1 if any operand is nonzero and 0 otherwise. If an operand is NULL, it returns 1 if the other operand is nonzero and NULL otherwise. If both operands are NULL, it returns NULL.
NOT, ! Logical NOT. Returns 1 if the operand is 0; 0 if the operand is nonzero; NULL if the operand is NULL.
NULL A NULL value represents an unknown variable in a Campaign. Any operation involving a NULL value results in NULL; a NULL value is not true in a test operation (e.g., NULL = NULL returns NULL, which evaluates to false). The Data Points for past visits to a Campaign when a Metric is added are NULL. The Value Capture Data Point for a Metric that did not match is NULL. When the location of a visit cannot be determined, the Geographic Location variables are NULL. Mobile device variables for non-mobile or unknown device users are NULL.
UNIX_TIMESTAMP(), UNIX_TIMESTAMP(date) If called with no argument, returns the current Unix timestamp (seconds since 1970-01-01 00:00:00 UTC). If called with a date argument, it returns the value of the argument as seconds since 1970-01-01 00:00:00 UTC. date is a string in the format 'YYYY-MM-DD HH:MM:SS', or a number in the format YYYYMMDDHHMMSS. The date is interpreted as a value in UTC. This function is used with the Start Time variable to perform date calculations. For example, to test if a visit started within a time frame, use an equation such as: [Start Time] BETWEEN UNIX_TIMESTAMP(20120701040000) AND UNIX_TIMESTAMP(20120705035959). Remember to convert the dates to UTC.
COUNT_STRING(match, source), Finds the number of occurrences of match in the source string.
Usage: (COUNT_STRING('"PageMatch"',[RP:1:CustomVariables])) > 5
IF(expr, then, else) If expr is nonzero and NOT NULL then this returns then, otherwise it returns else.
IFNULL(expr, else) If expr is not NULL then this returns expr, otherwise it returns else. expr LIKE pattern Performs pattern matching using SQL simple Regular Expression comparison.
% Matches any number of characters, even zero characters.
_ Matches exactly one character.
\% Matches one "%" character.
\_ Matches one "_" character.
expr REGEXP pattern Performs pattern matching using SQL Regular Expression comparison. SQL RegEx supports only a limited subset of SiteSpect's RegEx capabilities. Non-greedy quantifiers (.*?) and escape characters (\d) are not supported.
expr BETWEEN min AND max If expr is greater than or equal to min and expr is less than or equal to max, BETWEEN this returns 1, otherwise it returns 0.
expr IS NULL, expr IS NOT NULL Tests whether a value is (NOT) NULL (e.g., NULL IS NULL returns true).