Sign in with your Google account to load live Artesian data (BigQuery).
Data access is controlled by BigQuery permissions — only authorised accounts see anything.
Pulse
—
0 on you0 hot0 lagging
⚠ Live trade data can't load — the BigQuery connector has disconnected and needs reconnecting (Settings → Connectors, or /mcp). Revenue, Explore, Venues and the nightly feeds will be blank until it's back. Everything else (actions, notes already loaded) still works.
Loading your day…
✦
Trading · yesterday
…
Today
…
meetings
Priority inbox
…
need a look
Decisions on you
0
Needs attention
Assessing…
Last night · manager's word ▸
Decisions on you
…
Today's calendar
Loading…
Priority inbox
Loading…
Teams — worth a look
Loading…
Door watch
Loading…
Trading now · today so far
…
Live by venue
Loading…
Yesterday — closed
Loading…
Bepoz nett (ex-GST), business-day today · refreshes on open + every 3 min while this tab is active · benchmark = median of the last 6 same-weekday nights at this same clock-time (median, so a one-off event or closure doesn't skew "usual") · ~hourly data load
Portfolio scoreboard
FY27 revenue · actual vs budget
Cost pace vs FY27 targetlast 7 complete days · live
Open loads live wages + COGS…
Needs attention · ranked $ impact/wk
…
Variance heatmap · actual vs FY27 targettargets = FY27 workbook (hover a cell) · Δ vs target · red ≥ +5pp · COGS = 6-wk net (stock-take smoothing, * = flagged weeks) · wages/rev = 4-wk · click a venue to drill
…
Coverage · manager-sheet weeks per quarter
…
Targets are the authoritative FY27 workbook %s (bev/food COGS, wages, security — hover any cell for the exact target). Cost-side variances are provisional from the last manager-sheet snapshot (as-at above) and recompute against these targets once the feed is repointed; live revenue/cost below is BigQuery on open.
All-venue history matrix
Loading…
Nett incl. service charge (ex-GST). L/Y = the same week 52 weeks earlier (weekday-aligned). Click a week row to expand its days. Budget = FY27 monthly target phased to days by each venue's trading pattern.
Bepoz revenue + Tanda all-in labour + StockSummaries COGS. Trend + comparison obey the lens above (up to ~3yr history). Reservation performance is SevenRooms (completed bookings, 90d vs same 90d last year, DOW-aligned). Cost figures held on complete days and may lag load; margin proxy excludes rent, marketing, security and utilities.
Year-on-year · daily — Portfoliothis period vs prior years · pick a venue
Year-on-year table · same day, all venueseach venue: Now · LY · 2yr — days down the left, DOW-aligned
…
Every day compared to the same weekday one and two years ago (−364d / −728d). Bold rows = week-to-Sunday totals; hover a cell for the exact figure. Blank = no trade / no data.
Bepoz nett (ex-GST), business-day. Comparisons are DOW-aligned: day → same weekday last week & ~same day last year (−364d); week → prior week & −364d; month/quarter → prior + same-period-last-year. Headline & per-venue totals are instant from cached daily; category, door, bookings & cost load on open. Cost held on complete days (may lag). New venues (TAMA, Cali post-migration) show "—" for LY.
Loading…
Portfolio forward demand · next 28 dayson-books vs LY same time · click a venue
Loading…
Forward fill · … · next 28 days
…
On the books · next 28 days (pax) forward · lens-exempt
Forward pace · on-books vs last year (same time & final)
Solid = on the books now · amber dashed = where LY stood at this same lead time (the pace benchmark — headline Δ compares to this) · green dashed = where the week finished last year. On-track = at/above the amber line. Same-time excludes bookings later cancelled.
On hand vs prior years · tablebookings held today vs same lead time in prior years, then what those dates finally did · −364d steps keep weekdays aligned
Loading…
“Same time” = bookings that existed at this many days out in that year (excludes ones later cancelled) · “Final” = completed pax that ultimately went through. Only dates with activity are listed. Booking types are derived from reservation type / seating area.
Forward by booking type · next 28 days vs last yearpax & committed min-spend
…
Completed covers · trend
Booking velocity · new demand booked per week
By booking-creation date (when the reservation was made), not the event date — the pulse of incoming demand. Dashed = same weeks last year.
Birthdays · 90d
…
No-show · 90d
…
Cancellations · 90d
…
Returning guests · 90d
…
of completed
Booking mix · 90dcompleted
…
Guests
…
Visit frequency · last 365 daysrepeat vs one-time
…
SevenRooms bookings. Birthday = group online-enquiry early room-fill (own category; may overlap product types). Forward pace = on-books now vs prior-year same 28-day window. Completed-covers trend obeys the lens (up to ~2yr). Fig n Fox & Surfers Pavilion excluded (no real bookings).
ANZ-Roy Morgan Consumer Confidence · latest
…
Hospitality readthis week
Sub-indices · latest
Recent releases
Weekly ANZ-Roy Morgan CC. Long-run monthly history since 2005 (older years trimmed in Pulse). Refreshes into the data island each Tuesday once the feed is repointed.
Scout-observed head-counts (Head Counts.xlsx via SharePoint, same source as the Power BI Head Count report). Weekly per-venue averages, Gold Coast + Brisbane precincts, full history since Nov 2023. US = our venues. Reads live from pulse_ops.
IWSR alcohol trends
Weekly scan of theiwsr.com press releases, filtered for relevance to Artesian: spirits / RTD / beer / no-lo, AU & APAC, on-premise & nightlife, pricing / premiumisation, category shifts. Each with a why-it-matters read + source.
…
Hospitality industry news
Weekly scan for a SE-QLD multi-venue operator: pub / hotel / venue sales, openings & closures, group M&A, and government / regulatory moves (liquor licensing, SNP, gaming, wages / IR).
…
Live month vs budget · …
…
FY27 budget · P&L & Cashflow Forecast workbook
Live month · venue revenue pace vs budgetMTD vs budget phased by LY daily pattern · projection = MTD ÷ typical share of month done
Loading…
FY27 budget vs actual · by month
Loading…
Budget P&Lsummary rows expand to ledger lines · actuals shown where Pulse has them
Loading…
Budget = FY27 P&L & Cashflow Forecast workbook (ledger BUDGET, loaded to pulse_ops.budget_pl). Actuals: revenue = Bepoz POS nett (incl service, ex GST); COGS & wages = manager weekly sheets allocated to the month of week-ending (approx at month edges); wages actuals are all-in labour from Tanda (worked pay + accrued leave + super + payroll tax + WorkCover, DJs excluded) plus manager-sheet security, compared against budget wages & on-costs + security. Weeks not yet synced from Tanda fall back to the manager-sheet wages line. Ledger opex actuals not yet wired. Group totals exclude Fig n Fox (JV) to match the workbook.
Waiting on others
⌕
✓ Done today
Nothing cleared yet today. Tick items above as you close them.
Pulse · live venue data refreshes on open · action state on this device
Edit task
Checklist
Pulse
Sign in with your Artesian Google account to load live data.