Build a simple keywords analyzer script

进行中

I joined a real sample file called [url removed, login to view] 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 [url removed, login to view] 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 [url removed, login to view] 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 [url removed, login to view]:

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 [url removed, login to view]

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

技能: MySQL, PHP

查看更多: perl script find keywords file, java script based game simple, google follow script names keywords, action script read xml simple sample, php script generate keywords page, php script tracking keywords, asp script analyzer, seo php script analyzer, script determine keywords, shell script bash keywords, php script generate keywords, script respond keywords bot, script paid complete simple offers, news script code php simple, simple accounting convert quick book, cms class sql script create php simple page, php script count keywords, script check keywords forward

项目ID: #12152158

已悬赏给:

PowerFreelancing

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 在1天内
(2条评论)
2.7

2名威客为此工作的平均竞标价是$125

manpreetnijjar

......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 在2天内
(3条评论)
3.3