Hi,
In reference to a case already opened - Calculated score - I need to create a score for each company rather than for each user, but it should still be based on the actions of the users.
In essence, each user can perform the following actions:
Convert = value 4
Navigate a URL = value 3
Click on an email = value 2
Open an email = value 1
Based on this, we could have a score like this:
score = ({open mail} * 1 + {click mail} * 2 + {page view} * 3 + {submission} * 4) / {total interactions}
But in the starting table, I also have the detail of the date when the action was taken.
Therefore, I would like to add these variables to my score:
-
If a user performs more than 1 action on the same day, then they will have a higher value compared to one who performs actions over different weeks.
-
If a user is from a company that already has many other users who have interacted, then their value will be higher. Essentially, the conversion of a user from a company with another 10 people who have read a communication is worth more than 1 conversion of a user who remains the only one from their company to have done something.
This is the structure of the initial table.
| date | user | company | open email | click email | submission | page views | total interactions | score |
|---|---|---|---|---|---|---|---|---|
| 02-mag | abc@gmail.com | a | 1 | 2 | 3 | ?? | ||
| 14-mag | def@gmail.com | b | 1 | 1 | 1 | 3 | ?? | |
| 14-mag | aht@hotmail.it | c | 5 | 5 | ?? | |||
| 14-mag | ars@gmail.com | a | 2 | 5 | 7 | ?? |