Use natural language to generate SQL queries for timeline event rollups. This GenAI-powered feature in BlueConic reduces the need to write AlaSQL manually, making it easier and faster to explore and summarize profile timeline data. This reduces the technical complexity of working with timeline data and speeds up setup for marketers and analysts.
By simplifying rollup setup for non-technical users, reducing errors from manual SQL writing, and accelerating time to insight, this feature expands access to valuable timeline insights across teams.
In the Timeline Event Rollups SQL Mode, the AI chat can assist you in creating SQL queries:
Generate SQL queries based on your description.
Explain and modify existing queries.
Validate queries and suggest corrections.
Help with timeline event types and data structure.
Note: This feature is available directly in the Timeline Event Rollups configuration window for any rollup in SQL Mode.
Before you begin
Confirm your BlueConic environment has Generative AI features enabled.
You have permission to view and configure timeline event rollups.
The rollup is set to SQL Mode.
Create a GenAI-powered timeline event rollup
Via the BlueConic navigation bar, select More> Timeline events > Timeline Event Rollups.
Choose an existing rollup or select Add timeline event rollup to create one.
In the configuration window, switch to SQL Mode.
Click the AI chat button on the left to open the GenAI assistant.
Enter a plain-language prompt or question.
Review the AI-generated SQL query.
Click Insert or Replace to insert it into the SQL Mode editor.
Test or preview the output.
Click Save to apply the configuration.
Tip: You can continue the conversation to refine your query or ask follow-up questions.
Next steps
Use rollup outputs to create metrics for segmentation, personalization, or reporting.