Reports

Pull data from the warehouse into a chart and an Excel export — no SQL, no waiting on the data team. Pick a report type to begin.

Start a new report

Trends

Time-series and period comparisons across eCom, Gifted and cross-channel — track a metric over time or diff two periods side-by-side.

Web analytics

GA4 reports for a single hotel — sales funnel, traffic sources, path analytics, page performance, and more.

Analytics

Reports on the warehouse itself — cost attribution, query volumes, and other data-platform meta.

Saved & recent reports

Cross-channel revenue — monthly

Time-series · All channels · by Property · Monthly · last 12 months

Time-seriesEdited 2d ago

eCom revenue by line-item type — weekly

Time-series · eCommerce · by Line-item type · Weekly · last 13 weeks

Time-seriesEdited 5d ago

EMS appointments — monthly

Time-series · EMS (spa) · by Property · Monthly · last 12 months

Time-seriesEdited 1w ago

Trends

Track a metric over time, diff two periods side-by-side, or look at lead time from purchase to use. Pick the shape that answers your question.

Pick a report

Time-series

How a metric moves over time — by day, week or month, split by property or product family.

Period comparison

This month vs last, this year vs last — deltas and % change side by side.

Voucher redemption lead time

How far ahead do buyers plan? Bucketed lead time from voucher purchase to redemption — same day, day before, week, fortnight, month, 3 months, over 3 months.

eCom booking lead time

Purchase → stay / visit for rooms, spa treatments, spa packages, spa classes, spa facilities, restaurant tables. Uses hcommerce_order_items.check_in — line-items without a visit date (vouchers, events, physical products) are naturally excluded.

Spa occupancy

How full is the spa? Occupancy % = sold minutes / total scheduled minutes, using silver_ems capacity and guest-booking data. One line per hotel with a KPI strip and a per-day table.

A/B test diagnostic

After a product launch, pick the test hotels and the cutover date. Flags each hotel whose revenue / orders / items changed materially pre vs post, using a Welch's t-test on daily eCom activity.

Rooms occupancy SOON

How full is the hotel? Blocked until we wire in a room-inventory source — hCommerce has bookings but no total-room count, so we can't compute a true occupancy % yet. Room-nights sold is trivial; the % is the missing piece.

Web analytics

GA4-sourced reports for a single hotel. Pick a report type to begin — all reports are scoped to one hotel + a date range you'll pick next.

Traffic & sources

Traffic acquisition

Where visitors come from: organic search, social, paid, direct, referrals — traffic + conversions per channel.

Path analytics

Sankey diagram showing how visitors flow between sections on your site — where do they go after the homepage?

Traffic → section flow

How visitors from each channel (social, search, direct) split across site sections (rooms, spa, offers).

Conversion & sales

Sales funnel

Sessions → view item → add to cart → begin checkout → purchase, for one hotel. Shows drop-off at each stage.

Landing page performance

Which entry pages actually convert — sessions, bounces, conversion rate and revenue per landing page.

E-commerce performance

Product sales, AOV, cart-abandonment rate. Tied to GA4 purchase events.

Basket re-adds

How often guests remove an item from the basket and then add it back — surfaces items with the highest "second thoughts" rate.

Conversion & goal tracking

Sign-ups, form submissions, completed purchases — every event in the property, ordered by session share, with goal events flagged.

Behaviour & content

Bounce report

Landing pages with the highest bounce rate — where are people arriving and leaving without engaging?

Page errors

Pages with the most JS exceptions and page views that look like 404s.

Behaviour & content

Top-viewed pages, average time on page, exit rate — the "what did they do?" cut.

Audience

Audience demographics & tech

Geographic location, device (mobile / desktop / tablet), browser — who's on the site.

Analytics

Reports on the warehouse itself — cost attribution, query volumes and other data-platform meta. Pick a report to begin.

Data platform

Database costs

BigQuery scan cost split by user / service account over a time period — see who's driving spend (GrowthBook, Hevo, Dataform, individual analysts, etc.).

Journey Query Tool

Reports

Trends

Web analytics

Analytics

Trends

Time-series

Period comparison

Voucher redemption lead time

eCom booking lead time

Spa occupancy

A/B test diagnostic

Rooms occupancy SOON

Web analytics

Traffic acquisition

Path analytics

Traffic → section flow

Sales funnel

Landing page performance

E-commerce performance

Basket re-adds

Conversion & goal tracking

Bounce report

Page errors

Behaviour & content

Audience demographics & tech

Analytics

Database costs