Custom calendar

Last update: October 17, 2024

CREATED FOR:

  • User
  • Admin
IMPORTANT
A new and streamlined Report Builder was released on October 16, 2024. It is supported on Mac, Windows, and web browsers.
This Legacy Report Builder add-in version still works. You can convert your legacy workbooks to the new Report Builder.

Report builder uses the Analytics custom calendar. You can use the calendar to define the first day of the week and year, or use a different retail calendar style. The calendar formats are used to for various purposes, including sales comparison and forecast standardization, payroll cost analysis, or physical inventory count regulation.

Each of the calendar formats is described below.

CalendarDescription
Gregorian CalendarUses the traditional calendar format (January through December, with 30 or 31 days and a variable number of weeks in each month).
Modified Gregorian CalendarUses the Traditional Gregorian Calendar but enables you to select the first month of the year and first day of the week.
4-5-4 Retail CalendarBreaks down each month by the number of weeks in the month. Meaning, January has four weeks, and so on. The National Retail Federation uses the 4-5-4 calendar format.
Custom Calendar

Offers three formats based on the number of weeks in each month. The number of weeks in each month depends on the selected first day of the year.

A year has 52 weeks. Divide that into 4 quarters and you get 13 weeks per quarter. But there are 3 months in a quarter. 13 is not divisible by three so you end up putting the extra week into one of the months so that it's always consistent. 5/4/4 means the 1st month of the quarter has the extra week. 4/5/4 means the 2nd month has the extra week, etc. In the 5-4-4 calendar, the 53rd week is added onto the last quarter of the year.

  • 4-5-4:January has four weeks, February has five weeks, March has four weeks, and so on.
  • 4-4-5: January has four weeks, February has four weeks, March has five weeks, and so on.
  • 5-5-4: January has five weeks, February has five weeks, March has four weeks, and so on.

Note: This calendar option is supported across all Adobe Analytics tools: Analysis Workspace, Report Builder, and Activity Map. The exception is Data Warehouse, which does not support custom calendars.

Analytics