Aturan: invoice dari QUERY + RAW MASTER yang belum ada di Log Blast (Nomor Invoice) → jadi workorder. Dikecualikan: Flags: Is Not Validate = TRUE (lookup RAW DATA) dan lead LEADS-ZPZ. CSV: phone | nama_outlet | nomer_invoice.
DAILY BLAST ACTIVITYiData berikut adalah total blast attempt 1, 2 dan 3 dari invoice paid.
Validate Invoice MajooiInvoice dari RAW MASTER per Paid Date (lead LEADS-ZPZ/ dikecualikan), dipisah per status: Approved Validasi (Approved & Is Not Validate FALSE), Approved Bypass (Approved & Is Not Validate TRUE), Backlog, Force Closed, Rejected.
AVERAGE TIME HANDLINGiEstimasi waktu handling: jumlah invoice Tervalidasi (Status Approved & bukan Bypass) per tanggal validasi (Waktu Blast terakhir di Log Blast) × 10 menit, ditampilkan dalam jam.
PRODUCTIVITY AGENTiJumlah tiket resolved dengan Check Status = Approved (sheet report resolved), per agent (Nama PIC Resolved) per tanggal (Waktu Resolved). Centang/hilangkan centang agent untuk memfilter.