Calendar

Follow our setup guide to connect Calendar to QUANTI:

Prebuilt reports and definition

---

Overview

The Calendar connector enriches your data warehouse with daily calendar context by country — public holidays, school vacations, commercial events (Black Friday, sales periods), local events, and major sporting events. It is designed to be joined with your marketing and sales data for marketing mix modeling (MMM) and seasonality analysis.

No authentication is required. Simply select the countries you want to cover.

---

Setup instructions

1

Select countries

Choose the countries you want to include. Each selected country generates one row per day in the output tables.

Available countries: France, Germany, United Kingdom, Spain, Italy, Belgium.

2

Select prebuilt reports

Review the available prebuilt reports and select the ones you want to activate.

3

Connector information

• Connector Name: Name your connector. It must be unique.

• Dataset ID: Define the ID of the dataset. It must not exist yet, as it will be created and data will be sent there.

---

Prebuilt reports

calendar_days: Daily calendar flags by country and zone. One row per day per country per zone. Each row contains a set of boolean flags indicating the nature of the day — ideal for direct JOIN with marketing data on date and country. Dimensions: date, country, zone. Additional fields: day_of_week, week_number, month, quarter, year. Flags: is_weekend, is_holiday, is_school_vacation, is_commercial_event, is_local_event, is_sporting_event.

calendar_events: Detailed calendar events — one row per event per day. Contains the event name, type (holiday, school_vacation, commercial, local, sporting) and zone. Use for detailed event-level analysis or to join with calendar_days for enriched context. Dimensions: date, country, event_id, event_name, event_type, zone.

---

Prebuilt reports and definition

---

Notes

• No authentication required: The connector uses public data sources — no API key or OAuth is needed.

• Sync frequency: Data is refreshed monthly. Calendar data is stable by nature — events rarely change once published for the year.

• Zone dimension: For some countries, events are regional. In France, the zone field maps to school vacation zones (A, B, C). For countries without zones, zone contains the country code.

• Joining with marketing data: Use calendar_days as a dimension table — join on date and country to enrich any daily performance table with contextual flags.

• Supported countries: France, Germany, United Kingdom, Spain, Italy, Belgium. Additional countries can be added upon request.