Correct incorrect addresses on spreadsheet, gather missing store id's, find missing phone numbers
$30-250 USD
Selesai
Disiarkan lebih dari 11 tahun yang lalu
$30-250 USD
Dibayar semasa penghantaran
Hello,
We have 16,166 records. Here is a sample record:
ID StoreName Alias City Address State Zip Code Lat Long StoreID Phone Number Address Address Original
Aldi aldi Bessemer 710 Academy Drive AL 35020 33.3598 -86.9981 NULL NULL 710 Academy Drive 710 Academy Drive Bessemer
1.) There are some errors in the 2nd to last column, which is address. The last column contains the Address Original. When we split the address from city and zip code, there were some errors. We need the errors fixed.
Here is an example of an error:
Aldi aldi Harrison 1105 Hwy 65 North AR 72601 36.2759 -93.1555 NULL NULL 1105 Hwy 65 North 1105 Hwy 65 North Harrison
"1105 Hwy 65 North" this should be "1105 Hwy 65" and city should be "West Harrison"
There are probably between 200 and 400 errors (just a rough guess).
You will need to go record by record and correct any mistakes.
2.) We are missing store ID's for 7,100 stores. We need to gather these store id's. You will need to visit the stores web sites, search the address or zip code and record the store id. Sometimes store id is list in the URL.
I.e. http://xxxxxx/[login to view URL]
3.) We are missing phone numbers for about 5,500 stores. We need to gather this information as well.
Thank you.
Hello! After carefully reading your project description I feel that I am the right candidate for the job. Please check private message inbox for details.