How to interpret your Usage Reports
BoodleBox usage reports come as four separate CSV exports. Each one answers a different question about your team's activity — this article explains what each file covers and what every column means.
The four Usage Reports available
File | One row is | The question it answers |
|---|---|---|
roster.csv | One invited person | Who has access — joined, pending, cancelled, or removed. This is your seat denominator. |
usersalltime.csv | One user with activity | What each person has done across the account's entire history. |
usersrecent.csv | One user with activity | The same columns, filtered to the trailing 90 days. |
dailymetrics.csv | One calendar day | What the whole team did, day by day. Org-wide totals, no names. |
roster.csv — who has access
One row per person invited to the team, whether or not they ever signed in. It's the only file that knows about the people who never showed up.
Column | What it represents in BoodleBox |
|---|---|
name | Display name on the person's BoodleBox profile. |
The login identity, or email, of the user. | |
status | Where the person sits in the invite lifecycle: |
date_added | The day the invite was sent, or the day the account was added to the team. |
date_removed | The day the person's access was revoked. Blank while they're still on the team. |
usersalltime.csv and usersrecent.csv — what each person did
One row per user with any recorded activity. The two files share every column — only the date filter differs: the whole history versus the trailing 90 days.
Column | What it represents in BoodleBox |
|---|---|
name | Profile display name — the same value that appears on the roster. |
The login identity, or email, of the user. | |
user_experience | The User Type the person chose during onboarding — Work, Teacher, or Student. It drives which AI Tools and starter bots they see in the product, and it's what the report templates use to split Teach/Staff from Learn/Student. |
last_activity | The most recent day this person did anything in BoodleBox. |
total_prompts | Every message the person sent to a bot or model. One prompt is one turn in a chat. |
total_words | Words the AI generated in its responses — not words the person typed. |
total_documents | Files the person uploaded — attached to a chat or added to the Knowledge Bank. Not documents produced. |
total_images | Images generated with the image models. |
total_custom_bots_created | Custom bots the person published through Bot Builder. Drafts do not count. |
total_assignments_created | Classroom assignments created, inside the Terms > Classes > Assignments structure. |
active_days_count | The count of distinct days this person had any activity, within the file's window. |
assistants_used | How many distinct assistants — models and bots — the person has used. |
dailymetrics.csv — what the team did, day by day
One row per calendar day on which the team did something. Days with no activity are omitted entirely, so the series has gaps.
Column | What it represents in BoodleBox |
|---|---|
day | The calendar day. |
invites | Invitations sent that day. |
signups | Invited people who created and activated their account that day. |
active_users | Distinct people with any activity on that day. |
prompts | All prompts sent by the team that day. |
words_generated | Words the AI produced that day, team-wide. |
images_generated | Images generated that day. |
documents_uploaded | Files uploaded that day. |
assistants_used | Distinct assistants used across the whole team that day. |
custom_bots_created | Custom bots published that day. |
assignments_created | Classroom assignments created that day. |