Practitioner tool

Derived Fields Explorer

A reference for all 17 CJA derived-field functions — pick a function to see its rule and a before-and-after of what it does to your data, plus the limits that apply.

Derived Fields — Function Reference

17 functions100 derived fields / connection10 schema fields / derived field

Rule 1·Case WhenConditional & Mapping

▸IF OrderTotal < 50 → "Less than $50"

▸ELSE IF < 250 → "$50 – $250"

▸ELSE IF < 1,000 → "$250 – $1K"

▸ELSE IF < 5,000 → "$1K – $5K"

▸ELSE → "More than $5K"

Before

OrderTotal
$32
$180
$640
$3,400
$4,900
$8,200

After

Order Value Range
Less than $50
$50 – $250
$250 – $1K
$1K – $5K
$1K – $5K
More than $5K

Cascading conditions bucket raw order totals into spend-segment ranges. The same pattern powers the Marketing Channels derived field — chaining URL parse checks before a Case When cascade.

Retroactive

applies to all historical data, no re-ingestion

Connection-level

shared across all data views on the connection

Query-time

transforms computed when the report runs

30-day preview

Final Output shows sample values while you build