Ayyoub Limane

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