If a timeline event rollup uses a relative date condition - such as within the last X days - BlueConic will automatically recalculate when the result of the query would change.
For example, if you create a rollup that counts the number of orders in the last 7 days, BlueConic evaluates relevant profiles and tracks when the recalculation should happen, counting 7 days in the future (UTC, rounding up until midnight). When a timeline event is added, BlueConic will calculate the rollup and then plan to recalculate in 7 days.
Note: You can set relative data conditions for your rollup in Basic mode using the Conditions field (as shown in the image above) or in SQL mode using the event date filter (as shown in the image below).
Example showing a sliding window to re-evaluate a rollup for the last 7 days (UTC)
A profile has 4 orders eligible to be counted in a rollup:
April 1 04:00
April 2 05:00
April 4 06:00
April 8 07:00
On April 10, the rollup is evaluated and BlueConic calculates the number of orders placed in the past 7 days (UTC) and schedules a re-evaluation time:
NumberOfOrdersInLast7days: 2
The system will reschedule a re-evaluation for April 12 at 00:00 (when April 4 order would no longer qualify for the 'last 7 calendar days' condition).
If no new orders have been placed, on April 12 at 00:00, the system will re-evaluate:
NumberOfOrdersInLast7days: 1
The system will reschedule a re-evaluation for April 16 00:00 (when the April 8 order would no longer match the sliding date condition).
If no new orders have been placed, on April 16 at 00:00, the system will re-evaluate:
NumberOfOrdersInLast7days: 0
The system won’t schedule a re-evaluation. (There are no order events that match the condition anymore, and no existing order events that will match the condition in the future.)