Icon

Model Mastersheet A and B

Main Dataset that we used

MODEL A

MODEL B: is_(lead behavior_type) used for the rows that have more than one data

if not converted, then missing values
Joiner
if converted = 1
Constant Value Column Appender
Joiner
if not, converted = 0
Missing Value
marketing quality leads
CSV Reader
orders
CSV Reader
order items
CSV Reader
is_wolf
Rule Engine
closed deals
CSV Reader
is_cat
Rule Engine
is_shark
Rule Engine
won_date: string to date & time
String to Date&Time
CSV Writer
is_eagle
Rule Engine
drop is_unknown
Column Filter
is_unknown
Rule Engine
All seller that got an order
GroupBy
if activated = 1
Constant Value Column Appender
seller's first transaction
Column Renamer
if not activated, it marked as is_active = 0
Missing Value
if not activated, then missing values
Joiner
string to date (all)
String to Date&Time
exc. declared_revenue
Column Filter
activation lag days
Date&Time Difference
won_date filter inc.
Row Filter
only inc. mql_id
Column Filter
CSV Writer

Nodes

Extensions

Links