Scraping Yellow Pages. Harvesting Yellow Pages to Excel. Adding LinkedIn job titles.

In Progress Posted Mar 4, 2014 Paid on delivery
In Progress Paid on delivery

This work needs to be completed in a four step process to complete this project:

Step 1:

You need to scrape (harvest) Yellow Pages for the search terms "Office Fitout", "Construction Project Management", "Engineer Construction", "Commercial Builders", "Concrete cutting", "Plumbers commercial and industrial", "Electrical contractors commercial", "Electrician commercial", in Greater Sydney, NSW, and export it to excel.

You should find the below search results:

Construction Project Management: 862

Office Fitout: 585

Engineers Structural: 292

Commercial Builders: 117

Concrete Cutting: 234

Plumbers Commercial & Industrial: 2733

Electrical contractor commercial: 5366

Electrician commercial: 202

Step 2:

Businesses may be listed under more than one category so the next step is to DEDUPE the records against each other so each business is included ONLY ONCE in the excel spreadsheet.

Here are the fields that need to be captured in the spreadsheet include:

First name* (see NB below)

Surname* (see NB below)

Job title* (see NB below)

Business name

Business size* (see NB below)

Address

City

State

Phone Number

Company Fax: (if provided)

Website (if provided)

Email (if provided)

*NB. these details will not be available from Yellow Pages and will need to be added in from another data source - see Step 3 below

Step 3:

The data compiled will be missing the key contacts we need to target and will also be missing the business size/no. of employees, so the next step is to cross reference the compiled contact list in excel, against LinkedIn, searching for these titles within the businesses: "Project Manager", "Contracts Administrator", "Engineer", "Site manager", "Foreman", "Plumber", "Builder" and where data is available, fill in the following fields:

First name

Surname

Job title

Business size (no of employees)

We know some businesses will not exist on Linked in. Where businesses DO NOT exist on Linkedin, please leave the these data fields BLANK (First name, surname, job title, business size).

Please bid on time it will take you, cost you require, and add a note whether you've have harvested or scraped before.

Please also advise if you have any knowledge of sources (other than Linkedin) that can deliver the specific contact information required (First name, surname, job title, business size)?

Looking forward to awarding the project.

Data Entry Data Processing Excel Linkedin Web Scraping

Project ID: #5512655

About the project

20 proposals Remote project Active Mar 15, 2014

20 freelancers are bidding on average $243 for this job

livegoodlife

Hi there i can scrap the yellowpages of Australia , i can get business name, address, city, post code, website, email , if its fine then let me know . waiting for your kind response

$210 AUD in 3 days
(238 Reviews)
7.9
Toperfection

Hi anthonymanly, Hope you are well. I have do data scrapping very often,through scripts. So data scrapping is something that can be completed in maximum of 2 days, the main job starts after de duplicating the file. A More

$144 AUD in 3 days
(167 Reviews)
7.8
uumairkhalid

Hi.. Expert Web Scraper & Data Minor here. I have done too many similar project in past. Having best scraping tools and experience i assure you 100% accurate and good quality work. I have too too scraping experience. More

$147 AUD in 3 days
(182 Reviews)
7.0
diamond247

Hello Sir, We are a well built set up with excellent skilled operator with lot of experience in this segment/skill,have complete more than 200 similar job, i have gone through your project description, its really a More

$250 AUD in 3 days
(241 Reviews)
7.1
afua23

I have done a lot of scraping jobs which if you check my profile you will see. I can scrape the categories from yellow pages for you not manually but using a software to automate the process. When it comes to looking More

$1111 AUD in 20 days
(55 Reviews)
6.5
gillian1607

A proposal has not yet been provided

$155 AUD in 3 days
(27 Reviews)
5.8
THEHIGHTECHSOL

Greetings, thank you for posting your requirement here on freelancer.com we got your ultimate requirement,,let us allow you to offer an suggestion. the process you narrated is a bit allround process as i unders More

$155 AUD in 5 days
(80 Reviews)
5.5
vineet370

Hi, I've read the entire description. I have sound knowledge of data entry, Google search and Internet Research jobs. I am a professional user of Office (Word, Excel, Power Point) and other programs. I have 6 years of More

$130 AUD in 15 days
(61 Reviews)
5.3
teeares

I have done many projects which required the use of the net to get data and I can do this one also. I follow your instructions and got similars results for Construction Project Management and then got on to linkedin to More

$133 AUD in 15 days
(63 Reviews)
5.3
cutenasrin

Hi, After reading your project description. I am willing to do this job for you and ready to work immediately, following your instructions. Kind Regards, cutenasrin.

$172 AUD in 7 days
(4 Reviews)
3.5
ibisREDibis

A proposal has not yet been provided

$250 AUD in 7 days
(9 Reviews)
3.3
sumankorg

I would be pleased if you offer me this project, I have good analytical, writing, communication and interpersonal skills , with several years of experience in BPO industry

$155 AUD in 3 days
(1 Review)
0.0
athiracomputers

Dear client, I read your project description, and I am interested in your project. I am having experience in excel and data entry (not through online). I can finish this job on time with accuracy. Expecting your val More

$155 AUD in 3 days
(0 Reviews)
0.0
Hauck01

With 6+ years experience as a data entry & personal assistant professional, I believe that I am perfect for this job. To make sure the job gets done efficiently and correctly, I have two other personal assistant pro More

$155 AUD in 2 days
(0 Reviews)
0.0
ashleyboylan

I am new to Freelancer but I assure you that I have the skills to complete your job proposal. I am proficient in scraping, data mining, LinkedIn and Excel. I also have a few small tricks for getting information that More

$155 AUD in 3 days
(0 Reviews)
0.0
bogdanmurasan

It's easy work but the volume is big so that is why my bid is higher, and because I know how to do this. If you would like this done faster i can gather a team to do this work but the price would be higher. Best regard More

$250 AUD in 28 days
(0 Reviews)
0.0