With timeline event rollups, you can build BlueConic customer segments using time-based data stored in BlueConic timeline events.

You can filter on time-based events such as orders, refunds, abandoned carts, and more. For example, you use rollups for a segment of customers who placed more than 10 orders for a particular campaign.

Note: The following examples use Basic mode for building the rollup. For more advanced rollups, you can use SQL mode, which features a built-in SQL editor for developers to write queries directly (powered by an AlaSQL query engine).

If you create a segment and filter on properties from multiple different timeline rollups, it can produce unexpected results. For this reason, it is not advised to use rolled-up data from multiple timeline event rollups to create a single customer segment.

In this example, we roll up the shipping costs of a range of orders into a single profile property, shipping_sum, which we then use to create a segment.

Once you've created a rollup, you can validate your results by creating a segment of profiles based on the resulting rollup property. Check to see if it's being populated with profiles as expected. For more details, review the "Validating your results" section of the article Create timeline event rollups.