Data cleansing
3082
$
- Posted:
- Proposals: 9
- Remote
- #943859
- Archived
Virtual Assistant, Personal Assistant, Event Assistant, IT Support, Administration support, Business Support, Data Entry, Excel, Lead Generation, Web Research,
City of London
Sales and Business Development Specialist - Telesales, Appointment Setting & Lead Generation.
Zurgena
HR Consultant, Admin, Typist, Translator Hindi, French and English, Graphic Designer
Rose Hill
645117964121265443274356002879341087698410031321080225
Description
Experience Level: Entry
On one spreadsheet 'A' I have 11,000 business names listed .
These business names may have a relationship with emails on another spreadsheet 'B' of 64,000 email clients.
You need to find the URL/web address connected to the business name listed on spreadsheet 'A' (possibly by using google UK) and remove any corresponding email address' with the URL/web address from spreadsheet 'B' with the 64,000 emails.
For example line -
1. Business name could be dhl Ltd you would then need to google dhl ltd in Google.co.uk which would give the corresponding url/webaddress www.dhl.co.uk
2. The block of 60,000 emails needs to be highlighted and the filter run for dhl.co.uk - and emails corresponding to that address should be removed and stored in a seperate column on the spreadsheet.
There are 11,000 business address' to cross reference against the 60,000 email address'
These business names may have a relationship with emails on another spreadsheet 'B' of 64,000 email clients.
You need to find the URL/web address connected to the business name listed on spreadsheet 'A' (possibly by using google UK) and remove any corresponding email address' with the URL/web address from spreadsheet 'B' with the 64,000 emails.
For example line -
1. Business name could be dhl Ltd you would then need to google dhl ltd in Google.co.uk which would give the corresponding url/webaddress www.dhl.co.uk
2. The block of 60,000 emails needs to be highlighted and the filter run for dhl.co.uk - and emails corresponding to that address should be removed and stored in a seperate column on the spreadsheet.
There are 11,000 business address' to cross reference against the 60,000 email address'
Mark C.
100% (6)Projects Completed
13
Freelancers worked with
8
Projects awarded
10%
Last project
2 Jan 2023
Ireland
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
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