To create session summaries, I prefer using congregated individual session data. The data I focus on is the number of events, their corresponding dice-rolls, and chat messages to the next event. This workflow enables me to work faster and more conveniently than having all sessions' data in one place.
I currently export Discords channel-chat-logs from the beginning to the end of a session via the Discord History Tracker. Unfortunately, the output comes in a format that isn't easy for transferring the data to an .ods sheet, so I end up copying many things manually, which is more work than I can reasonably afford to put in.
I browse all these session text logs manually and manually define what counts as an event, and I manually determine which dice rolls correspond to that event. I do not use any preset markers that denote things such as "events" or "rolls," but each roll has the string "roll" in it. This is an output example of the .txt that the Discord History Tracker generates, for anonymity I obscured information by replacing it with "numbers, username1, username2, numbers-representing-user-id, servername, type-name, text-message, and text-message-with dice-roll" :
{"meta":{"users":{"numbers":{"name":"username1"},"numbers-representing-user-id":{"name":"username2"}},"userindex":["numbers","numbers"],"servers":[{"name":"servername","type":"type-name"}],"channels":{"numbers":{"server":0,"name":"servername"}}},"data":{"numbers":{"numbers":{"u":0,"t":numbers,"m":"text-message"},"numbers":{"u":0,"t":numbers,"m":"text-message-with dice-roll"},
So with "the number of events, their corresponding dice-rolls, and chat messages to the next event." on your mind: How do you optimise a session-summary workflow for roleplay sessions on Discord?