Enable business reporting from your Google BigQuery data
Turn your data warehouse into a real reporting library. Connected Data Marts, ready for your inbox.
Google BigQueryConnected
EmailDaily 09:00The weekly report email is a Google BigQuery query someone runs by hand, and it goes out late whenever they're away.
Paste this into your AI assistant. It turns your Google BigQuery tables into connected Data Marts with OWOX Data Marts and emails a report from them on a schedule, explained in plain words.
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/google-bigquery-insights-to-email.md. The task: email a weekly report from my Data Marts on Google BigQuery to my team every Monday: the main measures with the change on last week and a short explanation. 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
Start from your Google BigQuery data
Connect your BigQuery project and pick the dataset that holds the data your emailed reports draw on.
- Nothing to move or copy.
Google BigQueryYour data warehouseDatasetBuild a reporting library in Google BigQuery
Each Data Mart is a ready report, described by AI, and joins to other Data Marts through the model.
- Business users browse reports, not tables.
Email Google BigQuery reports on a schedule
Schedule a Data Mart's report as an email, with a short analysis written under the numbers.
- The team sees the numbers where it already works.
EmailScheduledWeekly paid media reportcostInUsdclicksimpressionsAnalysisPaid media for the week, one row per ad platform.Look at platform_cpa first to see where acquisition costs more.platform_roas tells you whether that spend is paying back.Keep Email connected to the same data
Ask in Claude, export to a sheet, share with the boss.
- One source, every tool.
ClaudeAsk in chat
Google SheetsExport to a sheet
- 0.43.0Compare LinkedIn Ads results across markets: spend by country, region, and county
- 0.43.0The Sheet link of a Google Sheets source opens the imported tab, not the first one
- 0.43.0Parallel reads of a SQL Data Mart on Google BigQuery no longer fail with a rate limit error
- 0.43.0Connect a Google Sheets plan with one Google sign-in
- 0.41.0Rotating a warehouse key is one change: Storages share reusable Credentials
Why OWOX for Google BigQuery reporting
Not everyone opens a dashboard, but everyone reads email, so the report goes to their inbox on a schedule.
- You own the data. It lives in your own BigQuery project, not inside an ad platform or a CRM.
- SQL first, AI second. Every insight starts with a number calculated in SQL on BigQuery, and the analysis is written around it.
- No login to read it. Recipients get the numbers and the analysis in the message, without opening BigQuery or a BI tool.
- On your schedule. Send daily, weekly or on a condition to any inbox.
You are booked. The invitation is on its way to , with the calendar invite and the meeting link.