Discourse Narrative Bot Data Explorer Queries 🤖

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:

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:

I've made this post a wiki, so others can add any `@discobot` related queries they come up with

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

1 Like

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

1 Like

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: