PonceDesign Let's talk
All work

Seismic  ·  2023–2024

Ask Aura — AI Chat Room

Seismic's reporting data was locked behind dashboards and CSV exports. I led the design that turned it into a conversation: ask Aura a question in plain language, get a table, a chart and the SQL behind it — plus an honest line about what the AI can and can't know.

Client

Seismic

Year

Sep 2023 – May 2024 · ~8 months

Role

Lead Product Designer, Insights & Aura

Team

Product, engineering & data science on Insights

Platform

Web · Seismic Insights · Snowflake

Focus

AI · Conversational UX · Analytics

Ask Aura in the Seismic product: a Favorites and Activity panel on the left, and a conversation where Aura answers a question with a SQL query, an explanation and a results table

In one line

Generative Analytics lets people chat with Aura, Seismic's AI, about their own platform data — who is active, what's being searched, which content lands. Over four iterations I took it from an engineering prototype to a shipped surface in Seismic Insights, and set the patterns later Aura surfaces built on.

4Iterations, from engineering prototype to shipped product
$1.34MAverage ARR on a platform deal that listed Aura among its capabilities
2Unprompted endorsements from engineering and product leadership

Context and the problem

Seismic Insights is where enablement leaders and admins go to understand how their platform is used. Before Aura, getting an answer meant one of three routes: a fixed analytics app that might not cover your question, the LiveInsights BI tool that most people never learned, or a raw CSV export from Reports & Data that you took into Excel.

Generative AI promised a fourth route — ask in plain language. Engineering had a working prototype: a model that could write Snowflake SQL against a curated slice of the data model. What it didn't have was a product.

A chat box removes every affordance a dashboard gives you. There's no menu saying what's possible, so the interface has to teach it.

The constraints shaped everything that followed:

  • A deliberately small dataset. Aura could only answer against tables we had curated for it. Anything outside that would fail or, worse, look like it succeeded.
  • Data that wasn't live. Source data refreshed roughly every four hours, so "today" didn't quite mean today.
  • A trust problem specific to analytics. A wrong number in a report gets forwarded to a VP. Users needed a way to check the answer, not just read it.
  • An existing design system. The surface had to be built from Seismic's Mantle components and sit inside the Insights information architecture, not float beside it.

My role and what I owned

I was the lead product designer on Ask Aura from the first concept review through the version that shipped.

  • I owned the end-to-end experience: the entry point on the Insights page, the chat room layout, the answer anatomy (table, chart, SQL, feedback), the Favorites and Activity module, empty states, responsive and panel behaviour, and the disclaimer and timestamp patterns.
  • I partnered with product management on scope and pilot rollout, and with the data team on which questions the curated dataset could answer well enough to suggest.
  • Engineering and data science owned the model, the prompt and SQL generation, and the Snowflake pipeline behind it.
A note on the screens

V1 was designed and piloted in Galileo, a demo tenant, which is why its branding differs from the Seismic screens. Names and figures in the tables are demo or internal test data.

Goals, and how we'd know

Because this was a new capability, not a redesign, success had to be defined as behaviour rather than a lift on an existing number:

  • First question answered without help. A new user should land, understand what to ask, and get a useful answer on the first try. Measured in the pilot by how often a first question needed rephrasing.
  • Answers people trust enough to use. Measured by thumbs up/down feedback on each response and by exports of answer tables.
  • Coming back. Measured by repeat sessions and by how many questions were saved as favorites to re-run.
  • Commercial pull. Whether Aura showed up in sales conversations and deals, not just demos.

Research, and the three things that changed direction

I started from the engineering prototype and walked through it as a first-time user would, then reviewed recordings of internal testers. Three findings shaped the design.

1. It was a demo of the model, not a tool for the user

Early Seismic Insights page with Enablement Impact and Analytics for Meetings apps, and an Ask Aura card under Data Exploration beside LiveInsights and Reports and Data
The starting point, September 2023. Ask Aura sat under Data Exploration as one more card among LiveInsights and Reports & Data, with nothing to say how it was different or when to use it.
Prototype chat showing questions about most active users and top search terms, a small results table, and a long SQL query printed in full in the response while a Working spinner runs
The prototype conversation. Every reply printed the full SQL above or instead of the answer, a spinner said Working… without saying on what, and there was no way to keep, share or rate a result. It proved the model worked. It didn't help anyone use it.

2. An empty text box is an open-ended promise

Given a blank input, testers asked what they would ask a colleague: broad strategy questions the curated dataset could never answer. The failure wasn't the model. It was that nothing on the screen said where the edges were.

3. Analysts wanted proof; everyone else wanted the number

Admins comfortable with SQL wanted to see the query to check it. Enablement managers didn't want to see it at all. Showing SQL by default buried the answer for one group; hiding it removed the only means of verification for the other.

Strategy and the decisions that mattered

Decision 1 — Teach capability by example, and narrow the promise

Rather than explain what Aura can do, show it. The empty state leads with three suggested questions drawn from what the curated data answers well. In the shipped version Aura introduces itself and names three starter questions in its first message. And the banner copy narrowed over time, from ask questions about your data to Get answers about your reporting data — one word that sets a far more accurate expectation.

Decision 2 — Show the work, but fold it

SQL went on a journey across the versions: printed in full in the prototype, hidden behind Show code in V1, then a single-line preview with Expand in V2. The one-line version was the compromise that held: the answer and a plain-English explanation lead, the query is visible enough to signal "this is checkable", and one click gives the analyst the whole thing with a Copy code action.

Decision 3 — Be honest about limits, in the interface, every time

Two lines sit permanently under the input: AI Powered – please use with caution and Source data refreshed roughly every 4 hours. There was pressure to drop the caution line as launch approached because it undersold the feature. I argued to keep it: an analytics tool that is wrong once without warning loses its users for good. I specified the freshness message as a Mantle tooltip and a set of relative timestamp formats so it read as information, not a legal footnote.

Specification for the data refreshed label with a tooltip reading Source data refreshed roughly every 4 hours, and a list of timestamp formats from absolute dates to a few seconds ago
Timestamp and freshness spec. Data refreshed: 30 minutes ago in 12px body with a tooltip for the full explanation, and one list of formats — from Jan 08, 2024 at 12:30 PM down to A few seconds ago — reused from Mantle so Aura tells time the way the rest of Seismic does.

Decision 4 — Treat answers as objects, not messages

In a chat, a good answer scrolls away. For analytics that's a loss: the question who are my most active users is one you'll ask again next month. So every answer carries a small toolbar — favorite, thumbs up/down, regenerate, export, table/chart toggle — and a Favorites and Activity panel keeps the questions worth re-running.

Design process and solution

V1 — the pilot

V1 put the four decisions in front of real users as quickly as possible, in a demo tenant.

Galileo Insights page with analytics and dashboard placeholders and a dark Aura card reading Use an AI-driven interface to ask questions about your data, with a Go to chat room button and an AI Powered please use with caution note
The V1 entry point. Aura gets its own dark card on the Insights page, distinct from the analytics apps, with a single action — Go to chat room — and the caution note present from the first touch.
Aura data query page empty state with an illustration, the line Start your data queries with Aura, three suggested questions, and empty Favorites and Activity panels
The empty state does the teaching. Three suggested questions sit directly above the input — active users, lessons completed, engagement by content format — so the first question is a click, not a guess. The input placeholder, Ask anything about your data and follow up with questions, invites the second.
A conversation with Aura AI answering who are my most active users with a table of names and activity counts and how many users are there with a single total, each followed by Show code, Export table, favorite, thumbs and regenerate controls
The answer anatomy. The result comes first as a table, with a Today divider separating sessions. Underneath each: Show code, Export table, favorite, feedback and regenerate — the same five controls every time, so users learn them once.
Show code expanded under an answer, revealing the SQL query in a bordered box with a Copy code button and a plain-language explanation of what the query does
Show code, expanded. The query arrives with a sentence before it saying what it's for and one after saying what it returns — so even someone who can't read SQL can tell whether Aura understood the question.
The same answer toggled into a chart view with two bar charts for activity count and time on app, plus a Make into favorite action on an activity item
Table and chart are the same answer, two views. A toggle at the top of the response switches between them and an expand control gives the data room. On the right, any past question can be promoted with Make into favorite, and favorites show a description on hover.

V2 — revised layout, interactions and branding

V2 moved from the demo tenant into Seismic proper, and reworked the parts the pilot showed were fighting the user.

Insights page Option 2 with an Ask Aura card containing the line Get answers about your data and an inline Ask a question field, annotated Start the session from the Insights page
Entry point, option 2 — the one we chose. The card carries its own Ask a question field, so the session starts where the user already is instead of behind a Go to chat room button. The dark hero was replaced by the soft gradient that became Aura's visual signature across Seismic.
Two V2 chat room layouts side by side with Favorites and Activity moved to a left panel, a New question button, one-line SQL previews with Expand and Collapse, sort and column controls on tables, and an annotation about the conversation direction
The V2 chat room. Favorites and Activity move to a collapsible left panel beside a New question button; SQL collapses to one line with Expand; tables gain Sort and Columns. The annotation specifies scroll behaviour: once the thread reaches the bottom of the page, new messages push upward, as users expect from any chat.
Responsive design specification showing a constant 340 pixel side panel and a flexible main panel with fixed margins, and the collapsed panel state where the main panel fills the width
Responsive and panel behaviour. The side panel is a constant 340px; the conversation flexes; margins stay fixed. Collapsing the panel reuses the open/close animation from DocCenter document detail, so it feels like part of Seismic rather than a new pattern to learn.
Favorites and Activity module in four states from empty to full, with overflow menus for Unfavorite, Edit details and Load conversation, and a Favorites conversation details modal for naming and describing a favorite
The Favorites and Activity module, empty to full. Feeds run new to old and cap at five before See all. Overflow menus give Load conversation, Edit details and Unfavorite, and a details modal lets a user rename a favorite and add the description shown on hover. The star became a heart to match favorites everywhere else in Seismic.

In product

Shipped Ask Aura with the side panel collapsed, showing Aura's greeting with three example questions, a user question, and an answer with a one-line SQL query, Expand link, explanation and a results table with Sort and Columns
Ask Aura as shipped, May 2024, panel collapsed. Aura opens by saying what it is and offering three starter questions; the answer leads with a one-line query and a plain-English explanation; the two honesty lines sit under the input. Every decision above is visible in one screen.

Validation and iteration

We thought an open invitation would drive exploration. It drove dead ends.

We thought the V1 promise — ask questions about your data — plus a free-text box would encourage people to explore. We learned in the pilot that it did the opposite: people asked broad questions the curated dataset couldn't answer, got a weak result, and concluded the feature didn't work. So we did three things in V2: narrowed the copy to reporting data, had Aura open every session by stating its role and three questions it answers well, and kept those questions one click away.

Hidden code was trusted less, not more

V1 hid SQL completely behind Show code to keep answers clean. Pilot users who cared about accuracy didn't discover it, and the ones who did had to expand every answer to check it. The one-line preview in V2 made the evidence visible at a glance without taking over the response.

A separate destination was one step too many

The V1 card sent people to a chat room before they could ask anything. Moving the input onto the Insights card itself (option 2) meant the first question could be typed the moment the idea occurred, and the chat room became the place the conversation continued rather than a place you had to go.

Outcome and impact

Usage metrics for Ask Aura are internal, so the evidence here is directional: what leadership said unprompted, and where Aura showed up commercially.

"One of the most game changing technologies for our industry." — VP, Incubation Engineering
"One of the KOOLEST new features we have released… So easy, so powerful." — SVP, Products, Platform and Solutions

Within the same cycle, Aura was named among the capabilities in a new platform deal: Royal London Asset Management, one of the UK's leading fund managers, joining at $1.34M average ARR and $6.72M TCV over five years. Aura was one line in a broad deal, not the reason for it — but it was on the list a customer bought.

Internal deal announcement welcoming Royal London Asset Management, listing ARR of 1.34 million average, 6.72 million TCV, and capabilities including Content, Learning, Meetings and Aura
The internal deal announcement. Aura sits in the capabilities list alongside Content, Learning and Meetings.

The longer-lasting result is the pattern. The answer anatomy, the honesty lines and the gradient signature from this project became the reference for later Aura surfaces, including Aura on mobile.

What I'd do differently

  • Instrument the pilot properly. Thumbs up/down was in V1, but we didn't define in advance what rate would count as good. Too much of V2 was argued from session recordings rather than a number I could point to.
  • Design the failure state first. The most important screen in an AI product is the one where it can't answer. We designed the happy path and patched the edge. Starting from I can't answer that, but here's what I can would have exposed the scope problem weeks earlier.
  • Bring the data team into design reviews from the start. The suggested questions only work if they're the ones the dataset answers best. That list should have been co-owned from the concept stage, not handed over near the pilot.

The broader lesson is that in conversational AI the interface's job is less to present answers than to set expectations. Every decision that mattered here — the narrower copy, the starter questions, the folded SQL, the caution line — was about telling the user honestly what they were talking to.

Get in touch

Tell me a little about your project, what you’re working on, your timeline, or whatever you know so far. I read every message and will get back to you within a couple of days.

Please enter your name.

Please enter a valid email address.

Please add a short message.

Message sent

Thank you for your note! I will get to you shortly.