Skip to content

Weekly Reporting Calendar

Use this guide whenever an analysis asks for weekly buckets, YTD weekly rollups, or before/after comparisons around a dated event.

Standard Week Definition

  • The standard reporting week runs Monday through Sunday.
  • Label weekly buckets with the Monday week_start date.
  • In SQL, materialize week_start from the reporting date and reuse that field downstream.
DATE_TRUNC('week', reporting_date)::DATE AS week_start
  • In charts, plot the materialized week_start field instead of relying on visualization-time week bucketing from raw timestamps.

YTD and Custom Date Windows

  • The default weekly reporting view uses full reporting weeks.
  • For weekly YTD rollups, start at the first Monday on or after January 1 and end at the most recent completed Sunday, unless the user explicitly asks for an in-progress view.
  • If the request is explicitly Jan 1 onward or another literal date-to-date window, filter daily rows to that window first and then aggregate to week_start. Keep the opening or closing boundary week if it is only partially inside the window, and label it as a partial week.
  • Example: a literal 2026-01-01 to-date weekly chart can include week_start = 2025-12-29, but that bucket should be labeled as the partial week covering Jan 1–Jan 4, 2026.

Pre/Post Change Analyses

  • Anchor the cutoff on the exact intervention date.
  • When the intervention lands mid-week, use daily or rolling 7-day views for the primary before/after comparison.
  • If you also show a weekly chart for context, keep the standard Monday-Sunday calendar weeks and treat the week containing the intervention as a transition week.
  • Exclude the transition week from summarized before-vs-after lifts, deltas, or averages unless the user explicitly asks to include it.
  • For week-over-week summaries, compare either:
  • complete pre weeks vs complete post weeks, or
  • matched day-count windows on each side of the intervention date.
  • Example: a firmware deployment on Friday 2026-04-17 falls in the reporting week starting 2026-04-13. That week is the transition week, not a pure "before" or "after" bucket.

Reporting Language

  • In chart titles and prose, describe weekly buckets as week of YYYY-MM-DD, using the Monday week_start.
  • Call out partial week or transition week directly in titles, notes, or subtitles whenever those buckets are shown.