Data cleansing and research missing contact details - 5000 records
- or -
Post a project like this2781
$$$
- Posted:
- Proposals: 9
- Remote
- #1250742
- Awarded
Web Scraping | Web Design & Development |Mobile App Design & Development | Wordpress Website Development | Salesforce
Oakland
Data Entry Operator | Image editing and resizing |Magento , Wordpress , Opencart Product Uploading
Ystrad Mynach
Microsoft Small Business Server Administration, Windows Administration, Customer Support,
Nairobi
34762915204553703391971012076731251792127860212839291345273
Description
Experience Level: Expert
Your proposal will be selected ASAP and the results must be delivered before Mon 22nd August.
Details of the job:
**Source Quotations: 4100 records
Entry date is defined by date in Column H Date.
Split School Reference into School/Agent name, Address, Postcode, City, Province/County
Please, Google research “School reference” to find exact address. If unsure, move the entire content of “School reference” to “Notes”
Country maps to Country
Each row might contain more than one records (e.g. Lead 1, Lead 2 in the same cell): please, split them into two records.
Please, split Name into Contact name, Contact Family Name,
The row up to column AA can contain more than an email address. Please, split email addresses into Contact Email and Contact secondary email
Please, recognize the international prefix if present in the phone number and key it in into Contact international prefix
The row up to column AA can contain more than a mobile number. Mobile numbers are different from landline numbers because they start with “3” (after the international prefix, if present). Please, find the Contact mobile
** Source Telemarketing: 900 records (split in 5 files)
*From Output to Telemarketing 2013.xls file DMC interested sheet, 2014 folder (3 files) DMC interested sheet,
Entry date is they Year of the set of files (2013 or 2014)
School/Agent name=Name (NameofSchool for 2014)
Address =Address
Postcode =Cap
City=Common
Province/County=Province
Country=Italy
Contact name=Forename
Contact Family Name= Surname
Contact Email=DMCemail
Contact secondary email
Contact international prefix=
Contact mobile=DMCmobile (please, split international prefix)
Please, research Address, Post code, City and Province for 2014 records by Google search “NameOfSchool” “School Email”
*From Output to Telemarketing 2015.xls file Standard English Interest, Work Experience Interest, Summer School Interest, CLIL Interest Sheets (4 sheets)
Entry date is they Year of the set of files (2015)
School/Agent name=denominazione
Address=indirizzo
Postcode=cap
City =comune
Province/County
Country = Italy
Contact name=DM Name, Please, split into Contact Name and Family Name
Contact Family Name
Contact Email=Personal Email
Contact secondary email
Contact international prefix
Contact mobile=mobile number (please, split international prefix)
Notes
**Source Regione Tuscany: 50 records
Please, split contact Contact into Contact Name and Contact family name
Please, search search the Name of school into the result of the “Reconcile data sources (various xls/doc files) - dirty data - 850 records - URGENT“ and copy Address, postcode, City, Province.
Please, split Email into Contact Email and Contact secondary email if more than one.
Use attached template “Output format”
Details of the job:
**Source Quotations: 4100 records
Entry date is defined by date in Column H Date.
Split School Reference into School/Agent name, Address, Postcode, City, Province/County
Please, Google research “School reference” to find exact address. If unsure, move the entire content of “School reference” to “Notes”
Country maps to Country
Each row might contain more than one records (e.g. Lead 1, Lead 2 in the same cell): please, split them into two records.
Please, split Name into Contact name, Contact Family Name,
The row up to column AA can contain more than an email address. Please, split email addresses into Contact Email and Contact secondary email
Please, recognize the international prefix if present in the phone number and key it in into Contact international prefix
The row up to column AA can contain more than a mobile number. Mobile numbers are different from landline numbers because they start with “3” (after the international prefix, if present). Please, find the Contact mobile
** Source Telemarketing: 900 records (split in 5 files)
*From Output to Telemarketing 2013.xls file DMC interested sheet, 2014 folder (3 files) DMC interested sheet,
Entry date is they Year of the set of files (2013 or 2014)
School/Agent name=Name (NameofSchool for 2014)
Address =Address
Postcode =Cap
City=Common
Province/County=Province
Country=Italy
Contact name=Forename
Contact Family Name= Surname
Contact Email=DMCemail
Contact secondary email
Contact international prefix=
Contact mobile=DMCmobile (please, split international prefix)
Please, research Address, Post code, City and Province for 2014 records by Google search “NameOfSchool” “School Email”
*From Output to Telemarketing 2015.xls file Standard English Interest, Work Experience Interest, Summer School Interest, CLIL Interest Sheets (4 sheets)
Entry date is they Year of the set of files (2015)
School/Agent name=denominazione
Address=indirizzo
Postcode=cap
City =comune
Province/County
Country = Italy
Contact name=DM Name, Please, split into Contact Name and Family Name
Contact Family Name
Contact Email=Personal Email
Contact secondary email
Contact international prefix
Contact mobile=mobile number (please, split international prefix)
Notes
**Source Regione Tuscany: 50 records
Please, split contact Contact into Contact Name and Contact family name
Please, search search the Name of school into the result of the “Reconcile data sources (various xls/doc files) - dirty data - 850 records - URGENT“ and copy Address, postcode, City, Province.
Please, split Email into Contact Email and Contact secondary email if more than one.
Use attached template “Output format”
Francesco C.
99% (70)Projects Completed
70
Freelancers worked with
22
Projects awarded
62%
Last project
26 Jan 2024
Italy
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi,
Can you share your estimated budget for this job?
regards -
I've looked at all 3 sheets, what is you want exactly?
106504106502
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies