Q1-2025 Release

To provide greater flexibility and control when querying timeline data in BlueConic, the timeline event rollups feature was extended to include enhanced support for SQL. As part of this update, individual rollups (via More > Timeline events > Timeline event rollups) now include two different modes to define and execute queries:

• Basic mode features the existing point-and-click Basic query builder. This mode is ideal for configuring common, straightforward use cases.
• The new SQL mode features a built-in SQL editor for developers to write queries directly, powered by an AlaSQL query engine. This mode is designed for more complex queries and advanced use cases, allowing timeline event rollups to replace the Timeline Query Connection.

You can switch between the two modes using a new toggle at the top.

SQL mode goes beyond the capabilities of the Basic query builder by offering:

• An SQL editor with a large input field to write custom queries in AlaSQL where the rollup’s conditions and mappings are defined. (Find SQL query examples here.)
• A panel on the left with the timeline event type data model, enabling you to speed up query development by adding properties directly to the editor.
• An event date filter at the top to set relative date conditions quickly.
• Functionality that automatically creates a mapping for each SELECT statement in your query.

For more details, review the article Using SQL mode for timeline event rollups.