BlueConic stores time-based event data in timeline events. Timeline events live on the profile's timeline, and with the functionality in timeline event rollups, you can query event data and roll it up into profile properties that you can use for segmentation and activation throughout BlueConic.
Example of a profile timeline:
Querying timeline event data into profile properties
Timeline event rollups provide a Basic query builder that you can use to ask questions of your timeline event data and map the results to BlueConic profile properties (formerly achieved only via the Timeline Query Connection). Use the rolled-up data to:
Enrich or extend BlueConic segments with time-based data
Deliver richer insights into your reports
Export rolled up data to another system that relies on these insights
Create relevant features for your machine learning models
For example, you can target customers based on recent orders or events, by offering a discount for repeat orders. Or you might choose to send discounts only to customers with recent, high-value orders.
Basic and SQL modes
When you add or edit a rollup via More > Timeline events > Timeline event rollups, there are two modes available:
Basic mode includes the point-and-click Basic query builder. This mode, which opens by default when adding a new rollup, is ideal for configuring common, straightforward queries.
SQL mode includes a built-in SQL editor for developers to write more complex queries directly in AlaSQL. For more information, review the article Using SQL mode for timeline event rollups.
You can switch between Basic and SQL modes using the toggle at the top of your rollup page.
Directly store event data that formerly required a Timeline Query Connection
The capabilities in timeline event rollups empower non-technical users, such as marketing or business team members, to self-serve in BlueConic - directly in the timeline event rollups page - without running connections. This feature is also robust enough to serve power users, such as data analysts.
In Basic mode on your rollup page, you can roll up event data into profile properties in just three steps:
Select a timeline event type.
Filter events using conditions. For example: 'find the order value for new customer orders in the month of May', or 'find orders that used coupons associated with a specific campaign'.
Map the resulting rollup to a profile property (new or existing), which you can use for activation in segments, dialogues, insights, notebooks, connections, and more.
How timeline event rollups compare to Timeline Queries
Timeline event rollups provide important benefits over the existing connection-based method of rolling up event data using the Timeline Query Connection.
This feature:
Empowers business users and data analysts with a simple, powerful tool.
Calculates your rollups as your time-based data streams into BlueConic,
Automatically recalculates data rollups based on the retention policy set for your timeline data.
Provides performance and efficiency gains by only rolling up the data when needed.
Offers improved data governance, with features integrated and controlled by a separate role-based permission.
Provides PII-validation and data typing, and blocks users from deleting timeline event properties that are currently used in a rollup.
To get started building rollups in BlueConic, review the steps in the article Create timeline event rollups.
And to learn more how to switch from the connection to rollups, review the article Migrating from the Timeline Query Connection to timeline event rollups.
Role-based access control
Role-based feature access lets BlueConic Application Managers assign permissions to enable BlueConic users at your site to create data rollups.
Important
In order to begin using this feature, you must assign the 'Timeline event rollups' permission to the appropriate user roles in the Roles page. By default, only Application Managers get this permission.
Glossary
Basic query builder: A graphical interface in Basic mode that allows users to configure a timeline event rollup without having to write SQL code.
Conditions and condition operators: To create a timeline event rollup, you first select the timeline event data to be rolled up via the Basic query builder. You use conditions to filter those events for specific event property values and condition operators for constructing queries. Review the article Create timeline event rollups for details.
Mappings and mapping operators: In the steps to create timeline event rollups, you can select which parts of the timeline event data you want to use in the rollup. Depending on the data type, you can select a mapping operator, such as count or sum. Review the article Create timeline event rollups for details.
Profile property: A piece of information associated with a profile that describes a specific aspect of the profile. Timeline event rollups store the rollup results as a profile property value.
SQL editor: A large input field in SQL mode for developers to write custom queries in AlaSQL. It is designed for more complex queries and advanced use cases.
Statistics: Open the right-hand panel of the timeline rollups page to see statistics for the current rollup. Learn more about when rollups are run.
Timeline event rollup: An “SQL-like” query that can add values from timeline events to profile properties.
Timeline event type: The definition of a time-based event that can occur for a profile.