Wajom!

Showing 25 of 26 from the live probe.

• Wajom List Users

  List Wajom users. Search matches name/email/phone. Dates are ISO-8601.

• Wajom Get User

  Get a Wajom user's full profile: plan, WhatsApp count, purchase stats, affiliate stats.

• Wajom List Orders

  List Wajom orders (sales). Filter by status, user, affiliate, gateway, coupon, product, date range. Statuses: InitiateCheckout, AddPaymentInfo, Purchase, Complete, Failed. Products: 'Bulanan', 'Wajom Mastery — Kelas Chat AI'.

• Wajom Get Order

  Get a single Wajom order with joined user, plan, and coupon details.

• Wajom Order Stats

  Aggregate Wajom order statistics. group_by: status|product|gateway|day|month. Returns buckets with count + revenue per group. Revenue is in MYR.

• Wajom List Abandoned

  List Wajom abandoned checkouts: stuck in InitiateCheckout/AddPaymentInfo for >hours with no Purchase.

• Wajom List Plans

  List Wajom subscription plans with pricing and duration.

• Wajom Get Plan

  Get a Wajom plan with subscriber count and revenue.

• Wajom List Coupons

  List Wajom coupons. Filter by status (active/inactive) and validity date range.

• Wajom Get Coupon

  Get a Wajom coupon by code or ID, with usage stats and recent usage log.

• Wajom List Whatsapps

  List Wajom WhatsApp devices. Filter by user, connection status, server.

• Wajom Get Whatsapp

  Get a Wajom WhatsApp device with permissions, Google connections, AI integrations.

• Wajom Whatsapp Health

  Wajom WhatsApp server health: capacity, usage, device status breakdown per server.

• Wajom List Affiliates

  List Wajom affiliates (users with affiliate_id) with referral count and commission.

• Wajom Get Affiliate

  Get a Wajom affiliate's detail: referral sales, withdrawals.

• Wajom List Feedbacks

  List Wajom feedback/testimonials. Filter by type and rating range.

• Wajom User Activity

  Get Wajom user activity: tracking counters and recent events.

• Wajom List Class Participants

  List Wajom class participants (Wajom Mastery course enrollees). Filter by payment status (InitiateCheckout/Paid/Failed), affiliate, name/email/phone search, date range. Amount is in MYR.

• Wajom Class Stats

  Wajom class participant funnel stats: conversion by status, revenue, top affiliates.

• Wajom List Trial Users

  List Wajom trial-like users (no membership_date) with computed message_counter (SUM of whatsapps.trial_sent_count), trial status (converted/trial_limit_reached/trial_expired/active/golden_time/dormant), last activity, and device counts. Statuses match the admin User Free Trial dashboard. Filter by status, search, plan, signup date range, and message count range.

• Wajom Get Trial User

  Get a single Wajom trial user's full detail: computed message_counter, trial status, daily activity events (last 30 days), recent transactions, plan, and WhatsApp devices with trial_sent_count. Use for the trial detail modal.

• Wajom Trial Stats

  Aggregate Wajom trial cohort statistics: counts by trial status, conversion rate, verified/with-devices/with-messages/limit-reached counts, average and max messages, and message-count distribution buckets (0, 1-10, 11-25, 26-49, 50 cap). Filter by signup date range.

• Wajom Trial Funnel

  Wajom trial cohort funnel: signup -> verified -> has_device -> connected -> purchased. Returns stage counts, stage percentages, and drop-off between stages. Implements the 'ubah trial menjadi loop yang bisa diaudit' recommendation from the Aug-2026 trial readout. Filter by signup date range (users.created_at).

• Wajom Paid User Audit

  Audit Wajom paid_user vs purchase_number vs sales mismatches. Flags three classes: (1) paid_user=1 but no Purchase/Complete sale (stale flag), (2) purchase_number>0 but paid_user=0 (under-flagged), (3) has Purchase sale but purchase_number=0 (counter not incremented). Returns summary counts + paginated mismatch detail. Implements recommendation #1 from the Aug-2026 trial readout.

• Wajom Message Stats

  Aggregate outbound WhatsApp message counts per user (paid vs free). Combines portal persistent counters (total_sent_count, chat_ai_sent_count, trial_sent_count, cap_reached_at — not affected by queue clearing) with WA server queue scan via HTTP (current queue rows by status — may be cleared by admin). Fetches from each WA server instance: GET {whatsapps.connect_url}/api/queue/stats. No WA_SERVER_DB_DIR needed — uses HTTP. Returns summary (paid vs free totals + averages + portal totals) and per-u