Hello everyone,
I have a table with a company column, and four other columns indicating the actions taken (opened an email, clicked an email, visited a URL, converted).
I would need an idea to calculate some sort of score. Reading an email and a conversion do not hold the same importance.
How should I proceed?
Hi @andreab
who should your score look like?
converted = high
url = medium
email = low
Or what do you have in mind?
BR
How do the columns/entries look like?
company | opend an email | clicked an email | visited a URL | concerted
A | 1 | 0 | 0| 0
B | 0 | 1 | 1 | 0
can one line have only (A) one or multible (B) options?
Hi @ErikG
| company | open email | click email | submission | page views | total interactions | score |
|---|---|---|---|---|---|---|
| a | 1 | 2 | 3 | ?? | ||
| b | 1 | 1 | 1 | 3 | ?? | |
| c | 5 | 1 | 6 | ?? |
you could do something like
score = ({open mail} * 1 + {click mail} * 2 + {page view} * 3 + {submisson} * 4)/{total interactions}
to consider all actions