Advanced Data Cleaning & Comparison
Raw Sign-ups Data
ID
First Name
Last Name
Email
Phone
Signup Date
Source
101
John
Doe
--
-
Website
102
Jane
Smith
-
-
-
Mobile App
103
Alice
Johnson
--
-
Website
104
Bob
Williams
--
-
Mobile App
101
John
Doe
--
-
Website
105
Charlie
Brown
--
-
Website
106
David
Miller
--
-
Mobile App
103
Alice
Johnson
--
-
Website
107
Eve
Davis
--
Website
108
Frank
Garcia
--
-
Mobile App
109
Grace
Rodriguez
--
-
Website
110
Heidi
Martinez
--
-
Mobile App
105
Charlie
Brown
--
-
Website
111
Ivan
Hernandez
--
112
Julia
Lopez
--
107
Eve
Davis
-
113
Kyle
Gonzalez
-
114
Liam
Perez
115
Mia
116
117
Website-
Mobile App
-
Website
-
-
Website
--
-
Mobile App
Sanchez
--
-
Website
Noah
Ramirez
--
-
Mobile App
Olivia
Torres
--
-
Website
Master CRM Data
CustomerID
FirstName
LastName
EmailAddress
ContactPhone
RegistrationDate
101
John
Doe
--
-
102
Jane
Smith
--
-
103
Alice
Johnson
--
-
104
Bob
Williams
--
-
105
Charlie
Brown
--
-
106
David
Miller
--
-
107
Eve
Davis
--
-
108
Frank
Garcia
--
-
109
Grace
Rodriguez
--
-
110
Heidi
Martinez
--
-
201
Peter
Jones
--
-
202
Quinn
White
--
-
Cleaned Sign-ups Data
ID
First Name
Last Name
Email
Phone
Signup Date
Source
101
John
Doe
--
-
Website
102
Jane
Smith
--
-
Mobile App
103
Alice
Johnson
--
-
Website
104
Bob
Williams
--
-
Mobile App
105
Charlie
Brown
--
-
Website
106
David
Miller
--
-
Mobile App
107
Eve
Davis
-
N/A
-
Website
108
Frank
Garcia
--
-
Mobile App
109
Grace
Rodriguez
--
-
Website
110
Heidi
Martinez
--
-
Mobile App
111
Ivan
Hernandez
--
Missing Date
Website
112
Julia
Lopez
--
-
Mobile App
113
Kyle
Gonzalez
--
-
Website
114
Liam
Perez
--
-
Mobile App
115
Mia
Sanchez
--
-
Website
116
Noah
Ramirez
--
-
Mobile App
117
Olivia
Torres
--
-
Website
Comparison Results
ID
First Name
Last Name
Email
Phone
Signup Date
Source
CRM Status
101
John
Doe
--
-
Website
Existing Customer
102
Jane
Smith
--
-
Mobile App
Existing Customer
103
Alice
Johnson
--
-
Website
Existing Customer
104
Bob
Williams
--
-
Mobile App
Existing Customer
105
Charlie
Brown
--
-
Website
Existing Customer
106
David
Miller
--
-
Mobile App
Existing Customer
107
Eve
Davis
-
N/A
-
Website
Existing Customer
108
Frank
Garcia
--
-
Mobile App
Existing Customer
109
Grace
Rodriguez
--
-
Website
Existing Customer
110
Heidi
Martinez
--
-
Mobile App
Existing Customer
111
Ivan
Hernandez
--
Missing Date
Website
New Customer
112
Julia
Lopez
--
-
Mobile App
New Customer
113
Kyle
Gonzalez
--
-
Website
New Customer
114
Liam
Perez
--
-
Mobile App
New Customer
115
Mia
Sanchez
--
-
Website
New Customer
116
Noah
Ramirez
--
-
Mobile App
New Customer
117
Olivia
Torres
--
-
Website
New Customer
Summary Report
Metric
Value
Total Raw Sign-ups
21
Exact Duplicates Removed
4
Total Unique Cleaned Sign-ups
17
Missing Phone Numbers Handled
1
Missing Signup Dates Handled
1
---------------------------------New Customers (from Sign-ups)
7
Existing Customers (from Sign-ups)
10
Customers Only in Master CRM
2