home / sales_assistant

Eventos do Agente

5 rows where conversation_id = 1 sorted by created_at descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: payload, created_at (date)

event_id conversation_id seller_id agent_type event_type payload created_at ▲
5 1 1 Mary 1 consumer intent_detected {"intent": "other", "is_buy": false} 2026-06-16T12:47:14.457568+00:00
4 1 1 Mary 1 consumer intent_detected {"intent": "greeting", "is_buy": false} 2026-06-16T12:46:50.119107+00:00
3 1 1 Mary 1 consumer intent_detected {"intent": "other", "is_buy": false} 2026-06-16T12:33:07.259647+00:00
2 1 1 Mary 1 consumer intent_detected {"intent": "greeting", "is_buy": false} 2026-06-15T19:04:40.362301+00:00
1 1 1 Mary 1 consumer intent_detected {"intent": "other", "is_buy": false} 2026-06-14T05:50:32.362214+00:00

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE agent_event (
    event_id            INTEGER PRIMARY KEY AUTOINCREMENT,
    conversation_id     INTEGER NOT NULL REFERENCES conversation(conversation_id),
    seller_id           INTEGER NOT NULL REFERENCES seller(seller_id),
    agent_type          TEXT NOT NULL,
    event_type          TEXT NOT NULL,
    payload             TEXT NOT NULL DEFAULT '{}',
    created_at          TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%SZ', 'now')),
    CHECK (agent_type IN ('consumer', 'seller')),
    CHECK (event_type IN ('intent_detected', 'escalation', 'nudge_created', 'proposal_drafted',
                          'proposal_sent', 'proposal_responded', 'order_created', 'handoff'))
);
CREATE INDEX idx_agent_event_conversation ON agent_event(conversation_id);
CREATE INDEX idx_agent_event_seller ON agent_event(seller_id);
Powered by Datasette · Queries took 1.2ms