FROM_ACTIVITY_BITS
All functions > BUSINESS > FROM_ACTIVITY_BITS
Returns the activity dates for the given activity bits and date reference.
Signatures
Returns: Array of dates when user was active
FROM_ACTIVITY_BITS(activity_bits: BIGINT, date_ref: DATE) → ARRAY<DATE>sql
| Parameter | Type | Required | Description |
|---|---|---|---|
activity_bits | BIGINT | Yes | Bit-packed activity representation |
date_ref | DATE | Yes | Reference date to decode activity relative to |
Notes
- Decodes bit-packed activity back to array of dates
- Inverse of TO_ACTIVITY_BITS
- Each set bit becomes a date in the result array
- Bit 0 (LSB) maps to reference date
- Bit 1 maps to day before reference date, etc.
- Up to 56 days of history
- Useful for debugging or exporting activity data
On this page