✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount
✨ New Plugin Alert ✨ SleekRank is now available with €50 launch discount

SleekView Charts for Booking Activities: activity dashboards

Booking Activities writes every reservation to bab_bookings with foreign keys to events, activities, and forms. SleekView Charts joins them once and renders dashboards for activity managers, finance, and instructors who need more than the default admin list.

♾️ Lifetime License available

SleekView Charts dashboard for Booking Activities

From bab_bookings rows to a real dashboard

Booking Activities stores each reservation as a row in wp_bookacti_bookings, linked to an event in wp_bookacti_events, an activity template, and an optional booking group in wp_bookacti_booking_groups. The form configuration sits in wp_bookacti_forms, and per-booking custom fields land in wp_bookacti_bookings_meta. The plugin's own admin shows one paginated list with status filters, which is useful for triage and limiting for any review beyond that.

SleekView Charts reads those tables directly and lets you build cards across them. A studio dashboard pins total active bookings as a Number, charts status mix as a Donut, ranks activities by booking count as a horizontal Bar, and plots daily new bookings as an Area. Each card sits on the same joined dataset, so a date filter applied at the dashboard level cascades to every card at once.

The cards use the indexes Booking Activities already creates on event_id, booking_group_id, and state, so even a year-over-year activity ranking renders in well under a second on a busy install with thousands of bookings per month.

Workflow

Join Booking Activities tables into one dataset

1

Source from bab_bookings

Use wp_bookacti_bookings as the base. Each row is a single reservation with foreign keys to events, activities, forms, and booking groups for richer charting.
2

Join events and groups

Pull wp_bookacti_events and wp_bookacti_booking_groups onto the dataset. Activity, start and end timestamps, group title, and per-form data land alongside each booking row.
3

Configure four cards

Add a Number card for total active bookings, a Donut for booking state mix, a horizontal Bar ranking activities by volume, and an Area card plotting new bookings per day across the selected range.
4

Save activity manager view

Pin the dashboard so studio managers, instructors, and finance each get a saved board sized to their job. WordPress capability gating decides who opens which board.

Sample dashboard

Charts you can build from Booking Activities data

A KPI for active bookings, a status mix donut, an activity-by-activity ranking, and a daily booking trend. Every card reads from the same joined Booking Activities dataset.
Number · Default

Active bookings this month

Count of rows in wp_bookacti_bookings with state of booked or pending whose event_start falls in the current month, with the previous month's number shown underneath for context.
Count
Pie · Donut

Bookings by state mix

Donut split across booked, pending, cancelled, refunded, and removed values from the state column on wp_bookacti_bookings, so the team sees the current reservation mix at a glance.
Count group by state
Bar · Horizontal

Top activities by bookings

Horizontal bar ranking activities by booking count, joining wp_bookacti_events to resolve titles. Surfaces the activities that fill quickly and the ones with weak demand.
Count group by event_id
Area · Gradient

New bookings per day

Gradient area chart of new reservations per day sourced from creation_date on wp_bookacti_bookings. Useful for spotting campaign spikes and weekday booking patterns.
Count group by creation_date

Comparison

Default Booking Activities admin vs SleekView Charts

Booking Activities admin

  • Booking Activities ships a list view, not a configurable chart dashboard
  • Per-activity booking volume requires manual counting across pages
  • Booking group totals are not exposed as their own chart card
  • Trend lines for new bookings per day are not native to the plugin
  • No saved per-role boards for studio managers, instructors, or finance

SleekView Charts

  • Configurable cards over wp_bookacti_bookings with joined events and groups
  • Number, Donut, Bar, and Area cards tied to real Booking Activities columns
  • Dashboard-level filters cascade across every chart at once
  • Per-activity rankings and daily booking trends without exports
  • Saved boards per role with WordPress capability gating

Features

What SleekView Charts gives you for Booking Activities

Cards, not paginated lists

Pick the column, the metric, and the chart type per card. Build an activity-volume bar one week and switch to a refund-rate donut the next, without touching code or exporting CSVs.

Bookings, events, groups joined

Reservations, events, booking groups, and forms join into a single SleekView dataset, so every card reads from the same join and groupings stay consistent across the whole dashboard.

Per-role saved boards

Studio managers, instructors, and finance each save the board they care about. Capability gating decides who opens which dashboard so each role lands on the right view.

Audience

Who builds Booking Activities charts dashboards

Activity studio managers

Status mix and per-activity rankings on one board, so the week's capacity and the activities that need a promotion are visible at a glance.

Instructors and coaches

Bookings per instructor and per class type, filtered to the activities they actually teach. The number that drives the weekly plan, not a CSV.

Finance and bookkeeping

Refund counts, cancelled booking trends, and revenue by booking group filtered by date range. Reconciliation runs from a saved board each month-end.

The bigger picture

Why activity studios need a chart view

Booking Activities is built around the activity calendar and the booking list, and that pair handles day-to-day operations well. Once a studio has hundreds of bookings per week across a dozen activities, the questions get harder: which activity actually fills, what share of bookings get cancelled, how the new schedule compares to the previous month. Each question is one chart on a dataset that already exists inside the plugin's own tables.

SleekView Charts gives that dataset a rendering layer, with cards that map cleanly to operational questions: Number for the headline, Donut for the share, Bar for the ranking, Area for the trend. The booking list keeps owning the per-row record, the chart board finally gives managers and finance the picture they have been pulling out of spreadsheets.

Questions

Common questions about SleekView Charts for Booking Activities

No. The Booking Activities admin list and calendar stay where they are. SleekView Charts sits alongside as a configurable layer so managers get the chart dashboards that the plugin doesn't ship, without touching the day-to-day workflow.

 

Yes. Form fields land in wp_bookacti_bookings_meta per booking. SleekView pivots that meta into typed columns and uses them as a chart's groupBy or valueColumn, so custom-segment Pies and custom-numeric Bars are straightforward.

 

Dashboard-level filters such as date range, activity, or state cascade to every card on the board. Per-card overrides exist for cases like a lifetime KPI sitting next to date-scoped trend charts on the same dashboard.

 

Yes. A Donut grouped by state with a counted aggregation already shows refunds against bookings. For revenue, sum a price column joined from the payment metadata so finance gets a refund-to-revenue ratio on the same board.

 

Yes. wp_bookacti_booking_groups joins onto the booking dataset, so a Bar card can rank group bookings by size, and a Number card can pin total group-driven bookings against individual bookings on the same dashboard.

 

Cards query live Booking Activities tables on render. A status change made in the booking list or via a frontend cancellation appears in every card on the next reload, with no separate sync step or refresh cycle to wait on.

 

Yes. Aggregations run server-side using the indexes Booking Activities already maintains on event_id, booking_group_id, and state. A multi-instructor install with years of history renders the whole board in under a second.

 

Yes. Each saved chart board is gated by a WordPress capability, so studio managers, instructors, and finance each open the board that matches their job without seeing each other's data or the wrong slice of the activity calendar.

 

Pricing

More than 1000+
happy customers

Explore our flexible licensing options tailored to your needs. Upgrade your license anytime to access more features, or opt for a lifetime license for ongoing value, including lifetime updates and lifetime support. Our hassle-free upgrade process ensures that our platform can grow with you, starting from whichever plan you choose.

Starter

€79

EUR

per year

  • 3 websites
  • 1 year of updates
  • 1 year of support

Pro

€149

EUR

per year

  • Unlimited websites
  • 1 year of updates
  • 1 year of support

Lifetime ♾️

Most popular

€249

EUR

once

  • Unlimited websites
  • Lifetime updates
  • Lifetime support

...or get the Bundle Deal
and save €250 🎁

The Bundle (unlimited sites)

Pay once, own it forever

Elevate your WordPress site with our exclusive plugin bundle that includes all of our premium plugins in one package. Enjoy lifetime updates and lifetime support. Save significantly compared to buying plugins individually.

What’s included

  • SleekAI

  • SleekByte

  • SleekMotion

  • SleekPixel

  • SleekRank

  • SleekView