Report date windows

How date range selection works across Ordinary reports, including timezones, comparisons, and plan lookback limits.

Ordinary Written by The Ordinary Team · Updated

Report date windows

Almost every page in Ordinary has a date range picker in the top-right. It controls what time window the numbers and charts represent.

Preset windows

PresetMeaning
Today00:00:00 today (your shop’s timezone) to now
YesterdayFull previous calendar day
MTD1st of the current month to now
Last 7 / 14 / 30 / 90 daysThe previous N full days plus today so far (rolling), matching how Shopify’s admin counts the same preset
Last 12 monthsThe previous 365 days plus today so far (rolling)
CustomPick any start and end date on the calendar

“Today” and “Yesterday” use calendar boundaries in your shop’s timezone, not UTC and not your browser’s local timezone.

Timezone

Ordinary uses your shop’s IANA timezone (pulled from Shopify on install) for every date-range boundary. That means:

  • The same numbers regardless of where the viewer is — a team member in Tokyo sees the same “today” revenue on the dashboard as the store owner in New York.
  • “Today” matches your business day. A shop in America/New_York at 11pm ET still sees today’s full orders; at 1am ET the next morning, “today” has rolled over.
  • Numbers align with Shopify’s own Sales reports, which also default to the shop timezone — makes cross-checks clean.

What this means practically:

  • A report’s “revenue for 2026-04-22” groups orders by their order time, using whether that time falls within April 22 in your shop’s timezone.
  • If your shop timezone is America/Los_Angeles (UTC-7), an order at 23:00 PT on April 22 shows up on April 22, even though it was 2026-04-23 06:00 UTC.
  • Conversely, an order at 02:00 UTC on April 23 (19:00 PT April 22) groups into the PT April 22 bucket.

The shop timezone is read-only in Ordinary — change it in your Shopify admin (Settings → General → Store details → Timezone) and it refreshes in Ordinary on the next nightly sync (or immediately on a reinstall).

Comparisons

The date range picker has a Compare setting with four modes:

  • Off — reports show the selected window only, with no deltas.
  • Previous period — a window of the same length before the selected one.
  • Previous year — the same window one year earlier.
  • Custom — place the comparison window directly on the calendar: your first click places a window the same length as your selected range, and an optional second click changes its end date. The comparison window shows in a lighter shade alongside your selected range.

Match weekdays (a checkbox in the picker, on by default) keeps weekdays aligned: the comparison window shifts back in whole weeks for Previous period, or exactly 52 weeks for Previous year, so Mondays compare to Mondays and your weekend/weekday mix stays comparable. For windows that aren’t a whole number of weeks this leaves a small gap between the two windows — the picker shows the exact comparison dates before you apply, and the date button in the top bar shows both windows whenever comparison is on. With Match weekdays off, Previous period is the immediately preceding window and Previous year is the same calendar dates last year.

Comparison is a single app-wide setting, like the date range itself — set it once in the picker and every report follows. While it’s on:

  • Metric cards show a green/red % change and the comparison value (“vs $12,400”).
  • Time-series charts overlay a dashed line for the comparison window; hover tooltips include the % change.
  • Campaign and product tables show a small % change under their headline metrics. A dash (—) means the comparison window had no activity to compare against.

How lookback caps your range

Your plan has a lookback window:

  • Free — 30 days.
  • Starter — 12 months.
  • Advanced — 24 months.
  • Enterprise — unlimited.

If you pick a start date beyond your lookback, the picker visually caps it and shows a Partial data badge above the report. See Why do I see “partial data”?.

Inclusive vs exclusive end dates

All date ranges in Ordinary are inclusive of both start and end days. “Last 7 days” with today being April 22 means April 16 through April 22 — 7 full days.

This differs from some BI tools that use exclusive end dates.

Live vs final data

For today and the current hour:

  • Pixel events, orders, and most integrations update hourly or faster.
  • Some “closed” metrics (Meta and Amazon final daily spend, GA4 sessions) take a few hours to finalize; expect early-morning numbers to revise upward as the day progresses.

For yesterday:

  • Finalized each morning (UTC), with the exact time depending on the integration.
  • After that, yesterday’s totals are stable.

See Data refresh cadence for the full schedule.

Saving custom ranges

Once you’ve picked a custom range, it’s saved in the URL. You can bookmark the URL or share it with a teammate — they’ll load the same report with the same date window.

Did this answer your question?

Thanks for your feedback! 🙌

Related articles