Find Jobs
Hire Freelancers

Build a simple keywords analyzer script

$30-250 USD

Completed
Posted over 7 years ago

$30-250 USD

Paid on delivery
I joined a real sample file called [login to view URL] to this job. Your script must be correctly optimized since there could be several thousands results in your final file. Here is job description : In the [login to view URL] file, you must: A) Find all individuals keywords (Column B) and count the number of time you found each word in the file. All words found that generated a combinated total of less than 10 clicks (column F) must be removed. B) I want you to generate with the words found in "A" all possible 2 words combinaisons. For each combinaisons you will search how many search term in [login to view URL] use these 2 words. For all found search terms using these 2 words, I want you to SUM column F (Click), column J (cost), column L (Sales) and Column Q (Total income). Here is a quick example [login to view URL]: cheap cat | 10 clicks | 10 sales | 10$ cost | 20$ income very cheap cat | 100 clicks | 10 sales | 100$ cost | 20$ income nice cats | 20 clicks | 20 sales | 20$ cost | 40$ income dog for sale | 10 clicks | 5 sales | 5$ cost | 10$ income mouse for sale | 5 click | 2 sales | 2$ cost | 5$ income A) cheap | 10 + 100 = 110 clicks cat | 10 + 100 = 110 clicks very | 100 clicks nice | 20 clicks cats | 20 clicks dog | 10 clicks for | 15 clicks sale | 10 + 5 = 15 clicks mouse | 5 clicks Since we remove all words with less than 10 combined click "mouse" will be remove. cheap | 10 + 100 = 110 clicks cat | 10 + 100 = 110 clicks very | 100 clicks nice | 20 clicks cats | 20 clicks dog | 10 clicks for | 15 clicks sale | 10 + 5 = 15 clicks B) Here would be all possible combinaison to search in [login to view URL] cheap + cat | 10 + 100 = 110 clicks | 10 + 10 = 20 sales | 10 + 100 = 100$ cost | 20 + 20 = 40$ income cheap + very | 100 clicks | 10 sales | 100$ cost | 20$ income cheap + nice | NOT FOUND REMOVE THIS LINE FROM RESULT cheap + cats | NOT FOUND REMOVE THIS LINE FROM RESULT cheap + dog | NOT FOUND REMOVE THIS LINE FROM RESULT cheap + for | NOT FOUND REMOVE THIS LINE FROM RESULT cheap + sale | NOT FOUND REMOVE THIS LINE FROM RESULT --- cat + very | 100 clicks | 10 sales | 100$ cost | 20$ income cat + nice | NOT FOUND REMOVE THIS LINE FROM RESULT cat + cats | NOT FOUND REMOVE THIS LINE FROM RESULT cat + dog | NOT FOUND REMOVE THIS LINE FROM RESULT cat + for | NOT FOUND REMOVE THIS LINE FROM RESULT cat + sale | NOT FOUND REMOVE THIS LINE FROM RESULT ---*** I STOP SUM EXAMPLE HERE ***--- very + nice very + cats very + dog very + for very + sale --- nice + cats nice + dog nice + for nice + sale --- cats + dog cats + for cats + sale --- dog + for dog + sale --- for + sale
Project ID: 12152158

About the project

2 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, this is a simple project I can do quickly. Do you have a preferred platform (e.g. Windows/Mac/website) or language (e.g. Python)? Regards, Aleks
$50 USD in 1 day
5.0 (2 reviews)
2.7
2.7
2 freelancers are bidding on average $125 USD for this job
User Avatar
......If we fail to deliver good quality work..... we will refund you the full amount. We always work for client satisfaction with 24x7 support.
$200 USD in 2 days
5.0 (3 reviews)
3.3
3.3

About the client

Flag of CANADA
Alma, Canada
4.9
92
Payment method verified
Member since Nov 27, 2006

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.