1.0.99

New Rolling Taskforce and Student Activity Score Marts

Version	1.0.99
Release Date	May 11, 2026

Key Features

This release includes two new marts. There are no changes to existing marts.

Rolling Taskforce Marts & Student Activity Score Marts

Both the taskforce marts and student activity score marts now have "rolling" versions. Rolling refers to how the weekly window moves in the marts. In the original versions of these marts, weeks are always defined as Sunday-to-Saturday, standard weeks. Each record in these marts is per-person, per-course, and per-week.

The rolling versions of these marts shift the same 7-day window each day. This mart has Sunday-to-Saturday, Monday-to-Sunday, Tuesday-to-Monday, etc., weeks. In the non-rolling versions, each week_number is only listed once, in one record, for each person-course intersection. In the rolling versions, each week_number can be present in up to 7 records per person-course intersection.

There are no separate documentation pages for these marts. The existing mart documentation pages linked above introduce sections that describe the differences between the rolling and non-rolling marts. The schemas between the rolling and non-rolling mart versions are mostly identical, especially for metrics.

These marts live in separate datasets in BigQuery:

• Non-rolling Taskforce marts: mart_taskforce

• Rolling Taskforce marts: mart_taskforce_rolling

• Non-rolling Student Activity Score marts: mart_student_activity_score

• Rolling Student Activity Score marts: mart_student_activity_score_rolling

The rolling version of the marts refresh on the same frequency as the non-rolling marts. Most refreshes occur daily.

To increase query size efficiency, we introduced a new helper table called file_interaction. The full location of this table is mart_helper.event__course_offering__file_interaction. This helper table is a subset of the more generic object_interaction helper table. We take the objects that are identified as files to populate the file_interaction helper table. The datamart dependency diagrams on the documentation pages have been updated accordingly.