Syntha Lab RU

Day-of-week and hour indices for schedules

Shows how many times sales on each day of the week are above or below the average day: an index of 1.2 means a fifth above the average. Built from the weeks in the table (untick holiday weeks), optionally also by hour. Needed for the schedule of promotions and mailings (days with an index above one) and as an input to the staffing calculation.

Store sales and receipts: traffic, conversion, ticket For whom: Shop managers, planners and marketers who build schedules of promotions, mailings and shifts.

Calculate on your data →

At a glance

What question does it answer?
How many times each day of the week and hour is stronger or weaker than the average.
What data is needed?
Sales by day of the week for at least four ordinary weeks.
How to read the result?
Look at days with an index above the threshold and at the spread between the best and the weakest day: it sets where a promotion will strengthen a strong day and where it will pull up a weak one. Example on the default values: Best day: Sat · 1.49; Weakest day: Mon · 0.71; Spread: best day to weakest: 2.1×; Share of Saturday and Sunday in the week: 39.7%. The figures are illustrative: enter your own to see your result.

Why and how to reason

The day-of-week index shows how many times the sales of that day are above or below the average day. In the example four weeks give indices Mon–Sun 0.71, 0.78, 0.74, 0.85, 1.14, 1.49, 1.29: Saturday is almost twice as strong as Monday.

When to use it

Apply when building the schedule of promotions, mailings and shifts; exclude holiday weeks.

How to read the result

Look at days with an index above the threshold and at the spread between the best and the weakest day.

Common mistakes

They mix holiday and ordinary weeks.

What data is needed?

  • Sales by day of the week for at least four ordinary weeks.
  • Marks of holiday weeks and weeks with promotions (to be unticked).
  • Sales by hour of an ordinary day (optional).
  • An example: four weeks, indices Mon–Sun 0.71, 0.78, 0.74, 0.85, 1.14, 1.49, 1.29 (illustrative numbers).

Inputs

FieldUnitValue in the exampleMeaning
Index from which a day counts as strong×1Usually 1: the day is stronger than the average. Raise it if you need only the strongest days for promotions. The example value is illustrative.

How it is calculated

StepFormula
Average by daythe sum of sales of the weekday ÷ the number of weeks
Average over all daysthe sum of the seven day averages ÷ 7
Indexaverage by day ÷ average over all days

Worked numbers

Default values from the app; in the interactive version you enter your own.

Best day
Sat · 1.49
Weakest day
Mon · 0.71
Spread: best day to weakest
2.1×
Share of Saturday and Sunday in the week
39.7 %
Days with an index above the threshold
3The threshold is set in the field above.
Weeks in the calculation
4
Best hour
19–20 · 1.45
Day-of-week index (1 = the average day)
Bar chart: Mon 0.71, Tue 0.78, Wed 0.74, Thu 0.85, Fri 1.14, Sat 1.4900.511.5MonMonIndex: 0.710.71TueTueIndex: 0.780.78WedWedIndex: 0.740.74ThuThuIndex: 0.850.85FriFriIndex: 1.141.14SatSatIndex: 1.491.49SunSunIndex: 1.291.29
Data as a table
MeasureIndex
Mon0.71
Tue0.78
Wed0.74
Thu0.85
Fri1.14
Sat1.49
Sun1.29
Hour index (1 = the average hour)
Bar chart: 10–11 0.57, 11–12 0.79, 12–13 0.92, 13–14 1.12, 14–15 1.04, 15–16 0.8800.511.510–1110–11Index: 0.570.5711–1211–12Index: 0.790.7912–1312–13Index: 0.920.9213–1413–14Index: 1.121.1214–1514–15Index: 1.041.0415–1615–16Index: 0.880.8816–1716–17Index: 0.830.8317–1817–18Index: 0.950.9518–1918–19Index: 1.211.2119–2019–20Index: 1.451.4520–2120–21Index: 1.331.3321–2221–22Index: 0.910.91
Data as a table
MeasureIndex
10–110.57
11–120.79
12–130.92
13–141.12
14–151.04
15–160.88
16–170.83
17–180.95
18–191.21
19–201.45
20–211.33
21–220.91

Day-of-week indices

DayAverageIndexReading
Mon1010.71below average
Tue1110.78below average
Wed1050.74below average
Thu1210.85below average
Fri1621.14above average
Sat2121.49above average
Sun1831.29above average

Exclude holiday weeks, take into account the chain’s days off and the Friday before long weekends; the day index describes an ordinary week.

What to do with the result: schedule promotions and mailings on days with an index above one or, on the contrary, pull up the weak days; for staff convert the indices into traffic.

A typical mistake: mixing holiday and ordinary weeks.

Nuances and limits

  • Mixing holiday and ordinary weeks.
  • Taking fewer than four weeks.
  • Forgetting the chain’s days off and the Friday before long weekends.

Terms used

Calculate on your data →