Icon

Lead Scoring

<p>Lead Scoring</p><p></p><p>This workflow reads lead data, handles missing values, and calculates multiple lead scoring metrics (FitScore, EngagementScore, etc.). It categorizes leads into score bands, writes the enriched data to a SQLite database, and filters relevant columns for analysis. Finally, it aggregates and visualizes lead performance by score category to support conversion analysis.</p>

URL: Dataset https://www.kaggle.com/datasets/pramod0308/lead-scoring-dataset?resource=download&select=Leads.csv

Lead Scoring

This workflow reads lead data, handles missing values, and calculates multiple lead scoring metrics (FitScore, EngagementScore, etc.). It categorizes leads into score bands, writes the enriched data to a SQLite database, and filters relevant columns for analysis. Finally, it aggregates and visualizes lead performance by score category to support conversion analysis.

Leads.csv
CSV Reader
replace missing values with NA
Missing Value
write the scores to db table
DB Writer
add Score columns (with missing values for now)
Constant Value Column Appender
Close DB connection
DB Connection Closer
keep only the relevant columns
Column Filter
FitScore,EngagementScore,IntentScore,PenaltyScore,TotalScore
Expression
Connect to SQLite DB
SQLite Connector
Sorter
Visualize lead score distrbution,conversion rate by Score Bands
Component
GroupBy
ScoreCategory,Score Bands
Expression

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Sanket Joshi
Created at: 2025-11-12
On NodePit since: 2025-11-18
Last update: 2025-11-18
Created with KNIME version: v5.8.0
Tags: Lead ScoringMarketing

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!