1 Reply Latest reply: Jan 17, 2013 2:26 AM by Dai-Phuc Ha

# revenue distribution

hi everybody,

how can I distribute a revenue to previous contacts?

 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

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?