Email Open Holidays reports to your team on a schedule
Load Open Holidays into your data warehouse first, link it to the rest of your data with SQL keys, then send the next public holidays, in the inbox of the people who plan campaigns and staffing. The email comes from your source of truth, not from a hand-built export.
Campaign and staffing plans miss a public holiday because nobody reminded the planners before it arrived.
Paste this into your AI assistant. It loads Open Holidays into a Data Mart in your data warehouse and emails the next public holidays for your countries to the planners on a schedule.
The prompt
Read https://www.owox.com/ai-agent-setup.md and follow it to set up OWOX Data Marts for me, starting from /connectors/open-holidays-insights-to-email.md. The task: email the public holidays from Open Holidays for our countries in the next 30 days to the campaign and staffing planners every Monday. Tag the links you give me with utm_campaign=ai-task and utm_term=data-foundation. Use what you know about my context and goals
Open Holidays Endpoints
1 Open Holidays endpoints you can import. Each lands in its own table in your data warehouse.
Why Open Holidays does not go straight to email
Open Holidays lists public holidays by date, not how a holiday moved your sales. An email built straight from the source sends the source's own numbers to an inbox with nothing to check them against; a scheduled export is no better, because it does not tie them to the rest of the business reliably, at scale or business-ready, so the join happens in a warehouse first.
- A holiday has a date, a name and a type, with no orders or visits to read it against
- The data analyst links the tables by SQL keys and controls what an email may say
- Recipients get one readable message instead of a CSV to open
Step 1: Load Open Holidays into your data warehouse first
Create a Data Mart with Open Holidays as the source and choose where the data lands. It works with any popular data warehouse.
- One endpoint, Public Holidays, with seven fields, in one table
- Pick a country ISO code and a language for holiday names
- Open the Open Holidays connector for your data warehouse below
Step 2: Link Open Holidays to orders and traffic
In your data warehouse the model joins the holiday calendar to sessions and store traffic by date and country code. Pick an industry to see the shape of its model.
- In the Retail model, Open Holidays fills the is_holiday flag on Store Traffic
- Orders and sessions join by SQL keys, not by eye
- The measures, such as conversion_rate, are defined once
Step 3: Email Open Holidays reports to your recipients
Add an email destination with the recipients' addresses, separated by commas, semicolons or new lines, and attach a report of the Open Holidays Data Mart. The subject and the body are Markdown, and a table placeholder drops the rows into the body.
- The table carries date, name, nationwide and type
- Allow-list the sending address insights@e.owox.com so the message reaches inboxes
- Run it once with Create & Run report to see the email before the schedule starts
Step 4: Schedule the Open Holidays email and add a short analysis
Add a trigger in the report's Automate Report Runs section or on the Data Mart's Triggers tab, for example every weekday morning or Monday and Wednesday at a set hour in your time zone. Write the reading under the table.
- Send always, only when the result is not empty, or only when it is empty
- The reading is drawn from the report's fields and says only what the data shows
- Attach a pre-built Insight instead of plain text when you want it written for you
Step 5: Reuse Open Holidays inside OWOX MCP
The Data Mart behind your email report also works in OWOX MCP, your assistant for data. Request any report, chat with your data, then get the report in Google Sheets or Excel in one click.
- Ask in plain words; the answer comes from your data warehouse
- An Open Holidays question worth repeating becomes the next scheduled email
- 0.39.0Reload a year of history in one backfill, not twelve
- 0.37.0Clearer connector errors, and custom connectors that handle more APIs
- 0.36.0Start a connector run without expanding the Input Source card
- 0.35.0Resume an interrupted manual backfill from the last fully loaded date
- 0.35.0Limit manual backfill to 31 days per run
Why OWOX for Open Holidays by email
Scheduled exports and hand-mailed screenshots put numbers in an inbox. OWOX also keeps the data yours, linked and ready to model.
- You own the data. Open Holidays lands in your own data warehouse, in tables you control.
- Dates before the plan. Planners get the coming holidays by email ahead of the week, with the flag that says who they affect.
- Nothing to open. Recipients read the table and the analysis in the message, with no login to a dashboard or to OWOX.
- Same numbers everywhere. The Open Holidays Data Mart behind the email also feeds your reports and your AI assistant.
- You set the rule. A report sends always, only when it has rows, or only when it is empty, so a quiet week does not fill inboxes.
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.
