revenue distribution

Thu, 17 Jan 2013 00:04:04 GMT

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!

Re: revenue distribution

Thu, 17 Jan 2013 07:24:58 GMT

My table with result (last column) I need:

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

topic revenue distribution in QlikView

revenue distribution

Re: revenue distribution