关闭

Build a simple keywords analyzer script

这项目被授予 PowerFreelancing ,费用为$50 USD

为像这样的项目获取免费报价
雇主工作
项目预算
$30 - $250 USD
全部竞标
2
项目描述

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

在寻找赚取金钱的机会?

  • 设定您的预算和时间框架
  • 大致描述您的建议方案
  • 为您的工作领取工资

雇用同样在该项目上竞标的威客

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online