Ask ChatGPT about Open Holidays in your data
A sales dip on a public holiday is not a problem to fix. Load the holiday calendar into your data warehouse, join it to orders by date and country, then ask ChatGPT which days were a calendar effect.
Open HolidaysConnectedPublic Holidays
ChatGPTDateIdNameDaily 09:00ChatGPT calls a sales dip a problem to fix when it was a public holiday it never saw in your data.
Paste this into your AI assistant. It loads Open Holidays into your data warehouse, joins the calendar to orders by date and country, and connects ChatGPT to that Data Mart through the OWOX MCP server.
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-connector-to-chatgpt.md. The task: connect ChatGPT to my Open Holidays and orders data and tell me whether public holidays affected our sales last quarter, and which upcoming holidays to plan campaigns around. 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 ChatGPT
ChatGPT can name a public holiday, but that does not show whether a drop in orders on that day was the calendar or a real problem. Holidays, sessions and orders sit apart, and a reliable, business-ready join belongs in a warehouse first.
- Open Holidays says which days are public holidays; the orders live in your store data
- A weak day is only a problem if no holiday explains it, so the join belongs in your data warehouse
- ChatGPT answers from that linked data, controlled by the data analyst
Open HolidaysHolidays by dateChatGPT
Data warehouseJoined by idStep 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 the date, name, type and regional scope of each holiday
- Set one country ISO code and a language per Data Mart, and refresh on a schedule
- Open the Open Holidays connector for your data warehouse below
Open Holida…Data MartGoogle BigQuery
AWS Athena
Snowflake
AWS Redshift
Databricksopen_holidays.public_holidaysStep 2: Link Open Holidays to sessions and orders
In your data warehouse the model joins the holiday calendar to orders and sessions by date and country. Use one Data Mart per country, with the country set as the key. Pick an industry to see the shape of its model.
- Holidays line up with orders and sessions by date and country
- A calendar effect is separated from a real drop by SQL keys, not VLOOKUP
- Measures such as conversion_rate are defined once
Open HolidaysPublic HolidaysStep 3: Connect ChatGPT to your Open Holidays data with OWOX MCP
Install the "OWOX Data Marts" plugin in ChatGPT (Plugins > Install plugin) and sign in. ChatGPT then sees the Data Marts you publish and queries them through MCP.
- Plugins > Install plugin, find "OWOX Data Marts" and sign in
- ChatGPT sees only the Data Marts you publish
ChatGPTConnectorsOWOX MCPAddConnectedStep 4: Ask ChatGPT whether a drop was a holiday
Ask in plain words. ChatGPT finds the right Data Mart and queries it, so the numbers come from your data warehouse and not from a guess.
- Ask about a day or a country in plain words
- The answer sets holiday days against orders and sessions, with measure names shown
ChatGPTWas last week's drop a holiday effect?get_relevant_data_marts_by_promptquery_data_martorders_totalconversion_rateStep 5: Export the answer to Google Sheets, CSV or XLS
Optional: in one click send ChatGPT's answer, or the data behind it, to Google Sheets, CSV or XLS to check it or share it.
- Verify the answer in a sheet before it goes to stakeholders
- One Data Mart feeds the chat, the sheet and the file
Google SheetsCSVXLSOne click
- 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.0Destinations tab now promotes connecting an AI assistant alongside your existing destinations
- 0.35.0Resume an interrupted manual backfill from the last fully loaded date
Why OWOX for Open Holidays in ChatGPT
Open Holidays in a chat names a holiday. OWOX adds the orders and sessions around it, from data you own.
- You own the data. It lands in your own data warehouse, in tables you control.
- Calendar effect or real drop. Holidays are joined to orders and sessions by date and country, not read from a calendar page.
- Zero hallucinations on your data. ChatGPT answers from governed Data Marts and shows the measure names it used.
- Maintained for you. No scripts to fix when the Open Holidays API changes.
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.