Zeppelin Case Stats

Zeppelin Case Stats is a tool that allows you to upload your Zeppelin case export file and break down each case type per moderator.

Everything is processed directly in your browser (client side), so no data is ever sent to anyone.

How to use:

1. First, you can:
– a) select the checkbox to automatically find all moderators in your export (finds each unique moderator with at least 1 case)
– b) upload a file where you specify which moderators you want to view (info on supported formats below)

2: Upload your Zeppelin case export file:
This can be downloaded from https://zeppelin.gg/dashboard/guilds/{guild_id}/import-export
This file consists of { "cases": [...] } where cases is the array of cases.
There is currently no case age filter. To filter a range of cases, you can remove cases from the cases array in the export file.

3: If nothing broke, you can now view the data in the table:
You can now filter, sort, and compare case numbers, and you can download the table data in multiple different formats.

Files to specify moderators:

There are currently two supported formats: An array of IDs, or an array of objects.

1: First format, an array of strings (Discord user IDs):

["MOD_ID_HERE", "123123123123123123", "99182302885588992"]

This is a simple array with just the Discord IDs you want to view. The tool will try to get each mod's name from the exported case data automatically.

2: Second format, an array of objects that hold two properties:

[
    { "id": "MOD_ID_HERE", "name": "MOD_NAME_HERE" },
    { "id": "123123123123123123", "name": "Mod name 1" },
    { "id": "99182302885588992", "name": "Mozzy" }
]

You can use this format if you want to specify the mod's name manually.
Each object must have the properties id and name.
The id property is the Discord user ID of the moderator you want to view. This cannot be empty.
The name property is the name you want to assign to this moderator. The name can be whatever, but cannot be empty.
⚠ Both values need to be strings. ⚠

Table example:

Comments and credits:

This tool/website was created by Mozzy. If you find this useful and want to donate, you can do that here ☕.
The Zeppelin Discord bot was created by Dragory.
The table used is Tabulator.

Data examples:

This website was made specifically for Zeppelin case exports, but any export structure could technically be used if structured to match Zeppelin's structure.
Zeppelin case structure:

{
    "case_number": 31332,
    "user_id": "123123789546471544",
    "user_name": "baduser#9270",
    "mod_id": "99182302885588992",
    "mod_name": "Mozzy#9999",
    "type": 4,
    "created_at": "2021-10-17 06:01:47",
    "is_hidden": false,
    "pp_id": null,
    "pp_name": null,
    "notes": [
      {
        "mod_id": "99182302885588992",
        "mod_name": "Mozzy#9999",
        "body": "__[User notified with a direct message]__ Do not discuss political topics, per rule 5",
        "created_at": "2021-10-17 06:01:47"
      },
      {
        "mod_id": "99182302885588992",
        "mod_name": "Mozzy#9999",
        "body": "something",
        "created_at": "2021-10-17 06:02:10"
      }
    ]
}

The relevant properties that this website uses are user_id, mod_id, mod_name, and type. These are all expected at the root level of each case object.

The Zeppelin case types are as follows:

BAN: 1,
UNBAN: 2,
NOTE: 3,
WARNING: 4,
KICK: 5,
MUTE: 6,
UNMUTE: 7,
CASE_DELETED: 8,
SOFT_BAN: 9

(Zeppelin Case Stats) Help & Info - Made by Mozzy ☕