hi everybody,
how can I distribute a revenue to previous contacts?
Table with tagging already exists:
| Session | Country | Channel | Contact | Buy | OrderID | Revenue | Tagging | Result for Channel 'C1' : Revenue after distribution |
| 123A | CA | A1 | 1 | - | - | - | F |
|
| 123A | CA | B1 | 2 | - | - | - | X |
|
| 123A | CA | A1 | 3 | - | - | - | X |
|
| 123A | CA | C1 | 4 | - | - | - | Y | 20€ |
| 123A | CA | C1 | 5 | 1 | 121212 | 100€ | L | 20€ |
| 123A | CA | S1 | 6 | - | - | - | X |
|
| 456B | CA | C1 | 1 | - | - | - | F | 120€ |
| 456B | CA | A1 | 2 | - | - | - | X |
|
| 456B | CA | B1 | 3 | - | - | - | Y |
|
| 456B | CA | C1 | 4 | 1 | 121213 | 200€ | L | 40€ |
| 456B | CA | S1 | 5 | - | - | - | X |
|
Tags description:
F = FirstContact
Y = LastContactBeforeBuy
L = LastContact
What I wanna do is:
How I can distribute the revenue made by session '123A' and '456B' to channel C1 percentage to the FirstContact, LastContactBeforeBuy and LastContact.
E.g.: Distribution only for channel 'C1':
FirstContact 60%, LastContactBeforeBuy 20%, LastContact 20%
I have try this but is not working:
if(Tagging = 'F', sum(Revenue)*0.6,
if(Tagging = 'Y', sum(Revenue)*0.2,
if(Tagging = 'L', sum(Revenue)*0.2)))
I think the problem is that I dont have any revenue in 'FirstContact' and 'LastContactBeforeBuy'.
How I can move the revenue for calculation?
PLEASE HELP & THX in Advance!
