Event Bulk Data
Standarisasi file dan format data untuk bulk upload event leads
Copy file templatenya disini: Template Bulk Data
Tampilan Template
Yang perlu diperhatikan: nama file, kolom merah wajib diisi, dan kolom hijau tidak wajib diisi.
Jangan merubah nama kolom!
Standarisasi Column
Prop
Type
Prop
Type
Terminologi Event
Prop
Type
| Category | Event Category | Source | Event Type |
|---|---|---|---|
| B2B | Free Event | free_event | Anniversary, Gathering, Seminar, Talk Show, Town Hall, Competition, Sports Non-Competition |
| B2B | Paid Event | paid_event | Anniversary, Gathering, Seminar, Talk Show, Town Hall, Competition, Sports Non-Competition |
| B2C | Free Event | free_event | Birthday Party |
| B2C | Paid Event | paid_event | Birthday Party |
| Internal | Free Event | free_event | [custom] |
| Internal | Paid Event | paid_event | [custom] |
| Internal | Booth Event | booth_event | [custom] |
| Internal | Inhouse Event | inhouse_event | Open House, Holiday Camp, Grading Week, Competition, Celebration Day, Season Event, Anniversary |
Cleaning Data
Format Column timestamp
Menggunakan format tanggal ISO 8601: YYYY-MM-DD hh:mm:ss
- Block column B
- Klik
More Format(icon123) - Pilih date time format
YYYY-MM-DD hh:mm:ssatau2025-02-04 07:37:16 - Selesai
Rapihkan Column phone
Pastikan nomor telepon dimulai dengan 628 bukan 8.
Gunakan Rubot → Data Processing → Cleaning Phone Numbers
Rapihkan Column name
Gunakan Rubot → Data Processing → Cleaning Text
Penyesuaian source, sremarks, medium, mremarks
Jika event belum dibuat di Event Manager budget.kyzn.life, input event tersebut dulu untuk mendapatkan sremarks dari event_id
Cara Mengcopy event_id:
- Buka https://budget.kyzn.life/dl/event-manager
- Klik Event detail terkait
- Klik
Copy
Prop
Type
Hapus Duplicate
- Klik menu
Data - Pilih
Data clean-up - Pilih
Remove Duplicate - Hanya pilih
column E(columnphone) - Klik
Remove Duplicate
Last Update: 26 Desember 2025 pukul 13.50