Celiq
v0.12Open app โ†—
Docs/Collaboration/Weekly Brief

Weekly Brief

A role-personalized weekly business brief โ€” headline, sections, highlights, and watch list โ€” generated by Orion each Monday and kept as history.

WeaverLuminaryUpdated June 2026 ยท 5 min read
โœฆ
In this section
Part of Celiq's semantic layer platform. Connect your warehouse, model your data once, query it everywhere.
๐Ÿ’ก
Tip
What it is: A weekly, role-personalized business brief that Orion writes for you โ€” a one-line headline, a few titled sections, key highlights, and a watch list of risks.
When to use it: Start the week with a shared factual baseline of what moved, what it means, and what to watch โ€” without anyone hand-writing a report.
Where to find it: The Weekly Brief tab in the main navigation (path /brief).
Who can use it: Everyone can read briefs. Generating and configuring them is limited to Weavers and Luminaries.

The Weekly Brief turns your workspace's KPI snapshots, active goals, open actions, and optional live warehouse queries into a short, readable brief. Orion runs once a week โ€” every Monday โ€” and writes a brief per recipient, personalized to their role. Each brief is saved, so you build up a browsable history of how the business read week over week.

This is a weekly cadence, not a daily one. There is no daily morning briefing here โ€” briefs are keyed to the start of the ISO week (Monday) and one is produced per week.

Overview

A Weekly Brief is a structured object Orion fills in for each recipient:

  • Headline โ€” one sentence summarizing the week.
  • Sections โ€” titled blocks, each with a short list of bullets.
  • Highlights โ€” the key wins or positive movements.
  • Watch โ€” risks and items to keep an eye on.

Orion generates briefs automatically on a weekly schedule and emails them to opted-in recipients. You can also generate (or regenerate) the current week's brief on demand from the Weekly Brief page. Every brief is stored against the week it covers, and the page keeps a history you can scroll back through.

Because each brief is written for a role, two people in the same workspace can open the same week and see the same facts framed for their job โ€” revenue and growth for a CEO, channel and CAC for marketing, and so on.

When to use it

  • You want a recurring, no-effort summary of business performance that lands every Monday.
  • Your team needs a shared starting point for a Monday review or stand-up.
  • You want non-technical stakeholders to get the numbers without opening a dashboard.
  • You want a paper trail of how the business looked each week, kept as history.

If you need an interactive, on-demand answer to a specific question instead of a scheduled summary, use Asking questions. If you want a recurring, automated analyst report on a single area (acquisition, retention, etc.), see AI Analysts.

Concepts

TermWhat it means
BriefOne generated weekly summary for one recipient, covering a single week.
Week startThe Monday of the ISO week the brief covers. Briefs are unique per workspace, user, and week start.
Role personalizationThe recipient's role (ceo, ops, marketing, finance, or a general fallback) shapes what Orion emphasizes.
Highlights / WatchThe two summary lists at the top and bottom of a brief โ€” wins to celebrate and risks to monitor.
Brief configWorkspace-level settings (an admin gear in the sidebar) that let you add SQL queries pulling live warehouse data into each brief.
HistoryThe list of past briefs, newest first. The page requests up to the last 52 weeks.

Getting started

You need a workspace with an AI API key configured (Orion uses it to write the brief). To produce useful content, the brief draws on whatever your workspace already has: KPI snapshots, active goals, and open actions. Optionally, an admin can attach warehouse queries so the brief includes live numbers.

To open the page, click Weekly Brief in the main navigation. The page has two parts: a left sidebar listing your brief history, and a main panel that renders the selected brief.

Step-by-step

1

Open the Weekly Brief page

Click Weekly Brief in the navigation (path /brief). The sidebar shows Brief History โ€” every brief generated for you, newest first. Unread briefs are marked with a dot.

2

Read a brief

Click any card in the sidebar. The main panel shows the headline, a green Highlights box, the titled sections, and an amber Watch box. Opening an unread brief marks it as read automatically. The footer shows when it was generated and when you read it.

3

Generate the current week's brief (Weaver / Luminary)

If you are a Weaver or Luminary, click + Generate Brief at the top of the sidebar. Orion writes a brief for the current week using your role and the latest data, then selects it. Running it again in the same week regenerates and overwrites that week's brief rather than creating a duplicate.

4

Add live warehouse data (optional, admin)

Click the gear (โš™) in the sidebar to open Brief Settings. Keep Include warehouse data checked, then add up to 10 labeled SQL queries. Each query needs a label (e.g. "Weekly Revenue") and a SQL statement. Click Save. Future briefs will run these queries and feed the results to Orion.

5

Let the weekly schedule do the rest

Once data is in place, Orion generates briefs automatically every Monday and emails them to opted-in recipients. You do not need to press Generate each week โ€” it is there for refreshing the current week on demand.

Examples

A workspace adds two warehouse queries in Brief Settings so the brief always carries live numbers:

Brief query โ€” Weekly Revenue
SELECT

DATE_TRUNC('week', order_date) AS week,

SUM(revenue) AS total_revenue,

COUNT(*) AS orders

FROM orders WHERE order_date >= CURRENT_DATE - INTERVAL '14 days' GROUP BY 1 ORDER BY 1

When the brief runs, Orion combines that query's results with your KPI snapshots, goals, and open actions, and returns a structured brief. The page renders it from this shape:

json
{
  "headline": "Revenue grew 6% week over week, led by repeat orders.",
  "sections": [
    {
      "title": "Revenue & Growth",
      "bullets": [
        "Total revenue $142k, up 6% vs prior week.",
        "Repeat-customer orders accounted for 48% of volume.",
        "Two of three quarterly goals are on track."
      ]
    }
  ],
  "highlights": [
    "Revenue back above the weekly target after two soft weeks."
  ],
  "watch": [
    "New-customer CAC trending up; channel mix needs review."
  ]
}

The headline becomes the page title, highlights renders in the green box, each sections entry becomes a colored card, and watch renders in the amber box.

Best practices

  • Set the recipient's role correctly. Orion personalizes the brief from the role it is given, so a CEO, ops lead, and marketer each get a relevantly framed brief. The generate action sends your current role.
  • Add a small set of high-signal warehouse queries. A few clear, labeled queries (revenue, orders, a key funnel metric) produce a far better brief than a long list. The config caps you at 10 for a reason.
  • Keep query labels human. The label is what Orion sees as the heading for that data block, so name it the way you'd describe the number in a meeting.
  • Let it run on schedule. The Monday cron handles generation and email delivery. Use + Generate Brief only when you want to refresh after new data lands mid-week.
  • Browse history before a review. The sidebar history lets you compare this week's framing against prior weeks to spot drift in the narrative.

Tips

๐Ÿ’ก
Tip

The schedule is genuinely weekly. Briefs are keyed to the Monday week start and the email send is de-duplicated on that same week, so a re-run in the same week never double-sends. If you came here expecting a daily digest, this is a once-a-week brief by design.

Common mistakes

โš ๏ธ
Warning
Expecting a daily brief. The brief is generated weekly (Monday). There is no daily morning-briefing variant in this feature.

Looking for the Generate button as a Tracer or Lens. + Generate Brief and the settings gear only appear for Weavers and Luminaries. Read-only roles still see and read every brief โ€” they just can't generate or configure them.

Putting too many queries in the config. The config accepts at most 10 queries, and each is truncated (label and SQL have length limits). Keep them focused.

Assuming warehouse data always appears for everyone. Live warehouse results are gated on the recipient's true role. Restricted recipients receive a brief built from KPI snapshots, goals, and actions โ€” not the admin-configured warehouse queries.

Troubleshooting

SymptomCauseFix
"No briefs yet." in the sidebarNo brief has been generated for you yet, and the weekly run hasn't produced one.A Weaver or Luminary clicks + Generate Brief, or wait for the Monday schedule.
Generate fails with a key errorThe workspace has no AI API key configured.Configure the workspace's Claude API key, then generate again.
Brief shows "No data available yet for this workspace."There are no KPI snapshots, goals, actions, or warehouse results to summarize.Add KPI snapshots / goals / actions, or configure warehouse queries in Brief Settings.
Brief renders as one block of raw text instead of sectionsOrion's output couldn't be parsed into the structured shape, so the page shows the raw fallback.Regenerate the brief; if it persists, simplify or reduce the configured warehouse queries.
Warehouse numbers are missing from a briefEither warehouse data is turned off in config, no queries are defined, or the recipient's role is restricted from warehouse data.Enable Include warehouse data and add queries; note that restricted (non-Luminary) recipients won't receive warehouse content.
A configured query is silently absentThat query errored at run time, returned no rows, or was missing a label or SQL.Fix the SQL or fill in the label; queries without both a label and SQL are skipped.
No brief email arrivedEmail is opt-in and only sent by the weekly schedule; on-demand generation is in-app only.Ensure the recipient is opted in (briefing enabled) and has an email on file; on-demand briefs are not emailed.
  • AI Analysts โ€” scheduled, automated analyst reports for specific areas of the business.
  • Building with Orion โ€” how Orion uses your semantic model.
  • Asking questions โ€” interactive, on-demand answers instead of a scheduled summary.
  • Notifications โ€” how alerts and updates reach you.