Understanding Relative Date Filtering
Relative date filtering is a powerful mechanism used in data analysis and segmentation to dynamically include or exclude data points based on time-based criteria. It allows businesses to create segments that automatically adjust as time progresses, ensuring that the data remains relevant without requiring constant manual updates.
How Relative Date Filtering Works
At its core, relative date filtering operates by comparing a specific date field (e.g., "signup date," "last purchase date") against a dynamically calculated time range. For example, a segment might include users who signed up "in the last 30 days" or exclude customers who haven't made a purchase "in the last 90 days." These filters are relative to the current date, meaning they shift automatically as time moves forward.
Instead of recalculating memberships on the spot or relying on internal timers, a more accurate and scalable solution is to pre-calculate when users should join or leave a segment based on relative date criteria. This eliminates the need for constant recalculations and ensures precise updates.
Example of a relative date filter:
