Icon

EDA 1 - 5

Main Dataset that we used

MASTER_792

(active = 380 ; ghost 462 ; won_date < 2018-08-31 exc.)

MASTER_842

(842 rows closed_deals.csv + column is_active (0/1))

EDA 5: TOP BUSINESS SEGMENT WITH FILTER WON_DATE

If want to filter businesses that are too small (n>=10) ; (p.s based on activation rate)

If dont want to put filter (p.s based on activation rate)

EDA 4: Time Distribution of Seller from Signed to Active (without won_date 2018-08-31 filter)

EDA 3: How many Sellers joined the MQL per month

EDA 2: End to End (sign rate vs activation rate of sellers from each origin)

EDA 1: Seller Per Funnel (MQL --> Sign Contract --> Active Seller) without won_date filter 2018-08-31

GroupBy
end to end rate
Scatter Plot
Column Renamer
end to end
Math Formula
Column Renamer
Joiner
Rule Engine
GroupBy
only n>= 10 inc.
Row Filter
GroupBy
only top 10 and no small n
Bar Chart
sign rate
Math Formula
activation rate
Math Formula
Math Formula
GroupBy
top 10 % all of business segment
Bar Chart
Sorter
Column Renamer
string to date (all)
String to Date&Time
Column Filter
Joiner
Column Filter
GroupBy
Column Renamer
marketing quality leads
CSV Reader
orders
CSV Reader
order items
CSV Reader
Row Filter
closed deals
CSV Reader
Rule Engine
All seller that got an order
GroupBy
Column Filter
won_date: string to date & time
String to Date&Time
Column Filter
Unpivot
Rule Engine
Sorter
Column Renamer
Column Renamer
Joiner
jarak waktu utk aktif
Date&Time Difference
EDA 4: Distribusi Waktu
Bar Chart
Rule Engine
Constant Value Column Appender
if not, it marked as is_active = 0
Missing Value
Joiner
Sorter
Per Funnel (int)
Line Plot
Rule Engine
Per Funnel Rate
Line Plot
nge grouping tahun dan bulan dengan jumlah mql masuk pada saat itu
GroupBy
Column Renamer
GroupBy
ubah nama
Column Renamer
di urutin (asc) dr tahun terlama ke tahun terbaru)
Sorter
EDA 3 = buat ngambil bulan dan tahun aja
String Manipulation
Tren MQL masuk
Line Plot
Rule Engine
Joiner

Nodes

Extensions

Links