Total Users
—
Revenue (range)
—
AI Calls (range)
—
New users (range)
—
Open Reports
—
Insights
auto-generated from the selected rangeActive users
rangeTop explorers
by scoreTop countries
Latest reports
All Users
Full rankings
Top contributors
ranked by content created — posts + reviews + plans hostedCountry visits
Itineraries
—
Shared
public link
Collaborators
—
joined shared
Edits logged
—
all time
Itineraries created
rangeAll itineraries
Where your travellers are
country stamps (shading) + city visits (pins)Top countries
Top cities
Revenue (AUD)
—
Bookings
—
Avg / booking
—
Confirmed
—
Revenue trend
rangeRevenue forecast
14-day projection (linear trend)Recent bookings
New (range)
—
DAU
—
active today
WAU
—
7-day
MAU
—
30-day
Stickiness
—
DAU / MAU
Signups
rangeSignups calendar
last 119 days · darker = more joins (UTC)Cohort retention
% of each weekly signup cohort active N weeks laterOnboarding funnel
all usersWeekly retention
by signup cohortCalls (range)
—
Input Tokens
—
Output Tokens
—
Est. Cost
—
Active AI Users
—
Calls per day
rangeTop users this month
vs. quotaBy model
Recent calls
Posts
—
Reviews
—
Avg rating
—
Held / reported
—
Recent posts
Recent reviews
lowest ratings firstAI backend
—
DB proxy
—
read/write
Rate-limit pressure
—
calls / last 60s
AI quota
—
per user / month
⚠ Needs attention
Table row counts
Data quality
integrity scan across sampled rowsOpen Reports
—
Subjects
—
Content Holds
—
Keyword watch
scan recent posts & reviews for banned termsReports queue
dismiss or take downAuto-held content
Send a broadcast
push notification to your usersR
Title
Your message preview…
Delivered via APNs through the gated admin-broadcast edge function. Requires that function deployed + ADMIN_BROADCAST_SECRET set on both your host and Supabase.
Drafts
save & reuse announcementsBest time to send
when your community is active (UTC)Recent broadcasts
from the audit logAdmin activity log
every action taken in this dashboardAI quota
Per-user monthly cap on server AI calls. Stored in admin_settings and read by the ai-proxy edge function (falls back to the AI_MONTHLY_LIMIT env var).
Feature flags
read by the iOS app at runtimeStored as admin_settings rows keyed flag_… — kill-switches & gradual rollouts the app reads.
Cost assumptions
Gemini 2.5 Flash est. rates used for the cost figure (display-only): input $0.30 / output $2.50 per 1M tokens. Edit AI_PRICE_IN/OUT in this file if Google's pricing changes.
Funnel steps
tick the milestones — order flows top to bottomConversion funnel
cumulative — each step counts users who did all steps aboveAdd annotation
mark a launch, promo or incident to explain metric movesTimeline
newest first · saved to admin_settingsPosts
—
cap 6k
Total likes
—
across posts
Top city
—
in range
Avg engagement
—
♥ + 2·💬
Top posts
by engagement (likes + 2× comments)Trending cities
posts in the selected rangeTables present
—
of expected
Total rows
—
all tables
Empty tables
—
0 rows
Missing
—
not found
Tables
live row counts via the proxy (service role)KPI goals
Set a target — track live progress against it. Saved to admin_settings.Active (14d)
—
Champions
—
most valuable
At risk
—
win back
Dormant
—
90d+ quiet
Lifecycle distribution
every active user placed by recency, tenure & valueSegments — message a cohort in one click
opens Broadcast pre-targeted to that segment's push-eligible usersEngagement quadrant
recency × value — where each user sitsAt-risk (churn)
—
valuable, going quiet
Dormant
—
90+ days
Flagged behaviour
—
auto-detected
Suspended
—
accounts
Churn risk
valuable users going quiet — re-engage themBehaviour flags
auto-scored from reports, blocks & statusSignups
—
last 24h
Posts
—
last 24h
Bookings
—
last 24h
Reports
—
needs review
Live activity
newest first · toggle Auto (top-right) to refresh every 60sReviews
—
Avg rating
—
all subjects
Low ratings
—
≤2 stars
Place reviews
—
community
Rating distribution
By subject type
Lowest-rated reviews
needs a lookEntries
—
Private
—
of all
Avg length
—
chars
Linked to trip
—
itinerary
Entries over time
rangeMood
Top tags
Posts
—
Likes
—
range
Comments
—
range
Posts / active user
—
range
Likes / post
—
avg
Posts per day
rangeWhen users post
by weekday & hour · UTCContent mix
Most engaged posts
Sent
—
Read rate
—
read_at set
Push opt-in
—
of users
Devices
—
tokens
Notifications per day
rangeBy type
Read-through by type
DM threads
—
total
Direct messages
—
Group-chat msgs
—
plan chat
Active threads
—
last 7d
Messages per day
DMs · rangeChannel mix
With photos
Interactions
—
Save rate
—
outcome 1.0
Engaged
—
tap + save
Dismiss rate
—
outcome 0
Interactions per day
rangeOutcome mix
Signal strength
avg feature scoresPlans
—
Upcoming
—
future date
Avg fill
—
spots taken
Participants
—
confirmed
Plans created
rangeBy status
Top categories
Recent plans
Experiences
—
listed
Active
—
status active
Avg price
—
per person
Avg rating
—
overall
By category
Top cities
All experiences
Deals
—
listed
Active
—
live now
Redemptions
—
Confirmed
—
by business
Redemptions per day
rangeTop deals
By category
All deals
Hosts
—
is_host
Verified
—
identity
Host revenue
—
confirmed
Avg rating
—
host