Total Downloads
--
All time
Successful
--
All time
Failed
--
All time
Total Cancelled
--
All time
Countries Reached
--
Unique countries
Languages Reached
--
Unique languages
Store Users
--
Browser stores
Store Reviews
--
Browser stores
Website Visits
--
Website traffic
Website Feedback
--
Uninstall feedback
Website CTA Clicks
--
Install + Download
Map Yes/No Ratio
--
--
Top Today
Browser
--
OS
--
File Type
--
Country
--
Top All Time
Browser
--
OS
--
File Type
--
Country
--
Success vs Failure
All-time percentage
Cancelled vs Downloads
All-time percentage
Download Activity
Hover over bars for details
Loading chart...
Total: 0
Success: 0
Failed: 0
📋 Recent Activity
Download events log with analytics
Loading...
📅 Activity Calendar
Dots mark days with data
Loading calendar...
📐 Analytics Controls
Range presets, compare mode, and segment dimensions
UTC Window: --
📊 Period Comparison
Compare two time periods
Loading comparison...
Website Visitors Time Series
Visits and requests over time
Loading...
Unique vs Returning Sessions
Daily session quality split
Loading...
Downloads by Browser
Last 7 days
Loading...
Downloads by OS
Last 7 days
Loading...
Downloads by File Type
Last 7 days
Loading...
Downloads by Country
Last 7 days
Loading...
Conversion Funnel
Journey from website visits to install/download clicks and map confirmations
Loading...
Dynamic Segments
Real-time split by selected dimension (browser, country, type, action, placement, path)
Loading...
Hourly Activity Heatmap (UTC)
Downloads by day-of-week and hour
Loading...
Daily Downloads
Selectable download window with daily totals
Loading chart...
Infrastructure Dashboards
Quick links for operations
Core Dashboards
Browser Developer Dashboards
Browser Store Listings
Browser Deployments
Store users, ratings, current version, and dashboard links
Website Sync Actions
Control Oracle publish, Cloudflare pull, and website ingestion paths from one panel
Refresh: reloads state and batch snapshots
Force Push: publish current Oracle state immediately
Pull Cloudflare: fetch latest website metrics snapshot
Reconcile: repairs totals using trusted hourly history
Current State
Published Source
--
Published Downloads
--
Published Countries
--
Published Success
--
Published Fail
--
Map Countries (Snapshot)
--
Store Users (Snapshot)
--
Snapshot ID
--
Snapshot Generated (UTC)
--
1AM Flush
--
Override
--
Website Worker Health
--
Current User Changelog Source
--
Last Oracle Push: --
Last Cloudflare Push: --
Last Website Ingest: --
Snapshot Versions: --
Latest Batches
Oracle → Website
--
Cloudflare → Website
--
Website → Oracle
--
Each card shows latest batch status, batch ID, and created timestamp.
Admin Controls
Use these controls to change website publishing behavior. Changes here directly affect live website data.
Website Analysis
Website actions, map responses, feedback analytics, and Cloudflare traffic health
Range controls all website action + feedback aggregates.
Cloudflare sync updates traffic cards/tables only.
Use Export JSON for full payload diagnostics.
Headline Metrics
Install Button Clicks
--
Download Button Clicks
--
Map Yes
--
Map No
--
Map Yes Ratio
--
Feedback Submissions
--
Cloudflare Visits
--
Cloudflare Requests
--
Cloudflare Sync Status
--
Last Feedback Submission: --
Last Cloudflare Sync: --
Website Data Chain Health
Last Batch Accepted (UTC)
--
Last Snapshot Generated (UTC)
--
Lag Minutes
--
Lag Status
--
Backup Drift
--
Sheets Flush Verification
--
Worker Batch Integrity
--
Lag thresholds: --
Backup drift: --
Sheets drift: --
Integrity checks: --
Daily Events
| Day (UTC) | Install | Download | Map Yes | Map No | Feedback |
|---|---|---|---|---|---|
| Loading… | |||||
Daily Traffic (Cloudflare)
| Day (UTC) | Visits | Requests |
|---|---|---|
| Loading… | ||
Top CTA Placements
| Placement | Action | Count |
|---|---|---|
| Loading… | ||
Top Feedback Reasons
| Reason | Count |
|---|---|
| Loading… | |
Feedback Insights
Top Browser in Feedback
--
Top Reason
--
Recent Daily Peak
--
| Day (UTC) | Feedback Submissions |
|---|---|
| Loading… | |
HTML Email Templates
Versioned templates for release and newsletter communication
Newsletter Management
Subscribers database and delivery list control
User Changelog Content
Public release notes shown to students on the website
Legacy Oracle changelog editor is disabled
Website changelog now ships from manual source-controlled files. Keep edits in GitHub, then run the sync script.
Runtime customization controls are kept in code for rollback only, but hidden and excluded from active workflows.
Display Source Control
Choose whether website users see changelog content from Oracle records or directly from GitHub
user-friendly-changelog.md.
Source status: --
Website reads: /api/public/website/changelog
Currently Displayed Changelog
Current Source
--
Entry Count
--
Last Updated (UTC)
--
--
Create / Update Entry (Required Format)
Use this exact format only:
## v1.3.7 ### Summary ... ### Added - ... ### Changed - ... ### Fixed - ...
Preview
Draft Preview
--
Website API Sync
Public API status: --
Tap: /changelog
Extension Changelog & Notifications
Manage changelog entries and notification pill rules for the browser extension.
Public source: /api/public/extension/changelog
Preview behavior matches extension pill classes
Legacy Oracle extension changelog/pill customization is disabled
Extension changelog and notification-pill rules are now manual source files. Update files, run sync, then build the extension.
Legacy CRUD endpoints and UI code are retained for rollback only and intentionally not used by production workflows.
Status
Entries
--
Rules
--
Public Endpoint
/api/public/extension/changelog
📋 Changelog Entries
Loading...
Add / Edit Entry
🔔 Notification Rules (Pill Styling)
Rules control the changelog pill color and animation in the extension. Target: "all" or specific version. Priority: normal/minor/major. Effect: none/glow/pulse.
Loading...
Add / Edit Rule
Live Extension Preview
v1.3.8
📋 Bulk Markdown Import
Paste changelog markdown below. Format:
## vX.Y.Z → ### Summary / ### Added / ### Changed / ### Fixed
Public API Preview
GitHub Notifications
Issues, PRs, branches, and discussions
Source: --
Oracle Operation Logs
Server-side request log for Oracle backend operations only
Loading logs...
Danger Zone
Restricted operations with elevated verification
Operational Safety Actions
🕒 Log Retention Window
Used by delete-older actions in this page.
Action Explanations
Dry Run Clear
Preview mode only. Oracle calculates exactly what would be deleted from non-core analytics tables and returns row counts per table, but commits nothing. Use this first before any destructive cleanup to validate scope and avoid accidental data loss.
Execute Clear
Runs the same cleanup plan as Dry Run but actually deletes data. This action requires elevated verification and should be used only after reviewing Dry Run output. It does not remove core auth/config tables, but it will permanently remove matching operational data.
Run SQLite Backup
Creates a point-in-time backup file under the server backup location. Use this immediately before risky operations. If cleanup or migration has unintended effects, this snapshot is your rollback anchor for the SQLite state.
Flush Google Sheets Now
Runs the Sheets archiver immediately and pushes the latest daily summary row to the configured Google Sheet. Use this to verify backups/sync on demand without waiting for the scheduled run.
Step-Up Now
Starts elevated verification for the current admin session. Critical actions in this page rely on this elevated window. If buttons are rejected with permission errors, run this first and complete verification.
Load Alerts
Retrieves active operational alerts such as no sync success, drift detection, backup failures, and backlog anomalies. This is the fastest health check when dashboard data looks stale or inconsistent.
Verify Audit Chain
Validates append-only hash-chain integrity for admin audit records from oldest to newest. If a link is broken, response includes where validation failed. Run this after critical operations and before incident closure.
Outbox Status
Shows queue health for relay pipelines: pending rows, retry counts, dead-letter presence, and relay freshness. Use this to confirm dual-DB/eventual-consistency pipelines are keeping up and not silently lagging.
Load Feature Flags
Reads server-side feature flags and kill switches currently enforced by backend logic. Use this to confirm whether sensitive modules (sync, destructive endpoints, advanced admin tooling) are intentionally on or off.
Dry Run Delete Older Logs
Uses the retention-days value and reports how many oracle log rows would be deleted. Safe preview mode; no records are removed.
Delete Older Logs
Deletes oracle logs older than the selected retention period. Use this to keep the logs table small while preserving recent operational trace history.
Delete All Oracle Logs
Irreversibly clears all oracle operation logs. Use only when resetting the environment or when log storage must be purged completely.