I been trying, with no luck, to find the correct algorithm for the following 2 scenarios and I can't seem to get it right.
First scenario
Every day I get data like the following:
+---------+----------+----------+----------+----------+---------+
| day | keyword1 | keyword2 | keyword3 | keyword4 | success |
| | clicks | clicks | clicks | clicks | |
+---------+----------+----------+----------+----------+---------+
| day1 | 10 | 3 | 5 | 9 | 76 |
| ... | ... | ... | ... | ... | ... |
+---------+----------+----------+----------+----------+---------+
Success is a value which measures how well that day's 'clicks' performed on different values, conversions, etc.
Is there any algorithm I can use to assign a weight to each keyword in relation to the success across various days?
I though of association rules and decision trees but I can't seem to get the idea right on how would those help me.
Second scenario
... which is pretty similar were data has the following structure
+------------+---------+---------+---------+---------+
| importance | value 1 | value 2 | value 3 | value 4 |
+------------+---------+---------+---------+---------+
| 1 | 18 | 21 | 35 | 25 |
| 2 | 93 | 36 | 11 | 56 |
| 3 | 34 | 26 | 47 | 47 |
| 1 | 19 | 20 | 10 | 23 |
| 1 | 17 | 20 | 3 | 25 |
+------------+---------+---------+---------+---------+
In this case what I am trying to do is understand how different values affect the importance
value.
In the previous case you can easily see that for importance=1
value 1, value 2, and value 4 are "close" to one another while value 3 is not.