In the interest of tracking user interaction with @discobot, here are are some data explorer queries. If anyone can think of a way to actually show a percentage progress through the track that would be awesome! But as far as I can see there’s no info about the sequence of states in the database :frowning: To use these queries, download the one you want, and import into the Data Explorer Plugin All User Interactions all-narrative-bot-interactions.dcquery.json (1.6 KB) Shows a list of all users that have interacted with @discobot in the last year (configurable) and shows their current state in the track: [image] Summary of Interactions narrative-bot-summary.dcquery.json (1.6 KB) Shows all interactions with discobot in the last year (configurable), grouped by current_state. This can be used to see which state users got stuck on. Results will look something like this: [image] I've made this post a wiki, so others can add any `@discobot` related queries they come up with

[image] david: If anyone can think of a way to actually show a percentage progress through the track that would be awesome! But as far as I can see there’s no info about the sequence of states in the database :frowning: Can you summarize the number of completed steps and divide that by the total number of steps?

As far as I can tell, previously completed steps aren’t stored. All we’ve got is a string describing the “current state”. And that string has no info about the position of that state in the track

I’ve added another query (see first post) which groups by current_step. I’m thinking this might be useful to show which step of the track users get stuck on. I don’t have many new users on my community since introducing discobot, but I’d be interested to see what data other people get! :slight_smile:

Discourse Narrative Bot Data Explorer Queries 🤖

Community Building Data & reporting

mcwumbly (Dave McClure) May 20, 2017, 12:28pm 2

Can you summarize the number of completed steps and divide that by the total number of steps?

Topic		Replies	Views
Data Explorer :handshake: AI - Generate Data Explorer queries with AI Announcements data-explorer , ai	0	236	July 23, 2026
Discourse Narrative Bot Beta Feedback Announcements new-feature	56	31650	June 7, 2017
Provide topic count via Discourse AI tool API `discourse.getUser` function Feature ai	1	216	February 9, 2026
New users aren't starting the discobot tutorial Feature discobot	89	17865	March 13, 2026
Discourse AI + Data Explorer? Feature data-explorer , completed , ai , ai-bot	47	5152	January 11, 2024

Discourse Narrative Bot Data Explorer Queries 🤖

Related topics