How to flag rows in script based on events?

[#1]

So i got this issue, and i simply cannot figure out how to manage this.

As in my previous post i want to find the row where there has been a BUY event when there also have been an Itemclick event within the same session.

Notice: It should be in the script and not in a expression (i think its too heavy)

RowID	SessionID	Price	Event	Flag
1	114	20	itemclick	0
2	114	50	visit	0
3	114	90	Buy	1
4	114	27	Buy	1
5	168	26	Buy	0
6	168	56	Buy	0

Hope you can help

Thanks in advance

[#2]

Thomas,

I create a table called TempCookie where I merge cookie and product, so that I get a list I can test (always with exists() function.

I did not catch if the itemclick should occur in the same session or not. You said whatever session but the flag in the file indicated the inverse (the item click should have done in another session).

=> I have made both (see the field name and comments)

Fabrice

[#3]

Thank you! Ive tried something similar but this works great! appreciate it a lot - Hope you didnt have to work to hard

[#4]

Hi Fabrice!

Do you remember this thread?

I have a question regarding this. What if i want to make sure, that the itemclick always has been first (So there cannot be registered a buy if the itemclick is later than the buy )

Like this CORRECT

Header 1	Header 1	Header 2	Header 3	Header 4	Header 5
Date	Cookie	Session	ItemID	Eventtype	Flag
2014-04-20	1	a	100	Itemclick
2014-04-21	1	a	100	Buy	1

This is WRONG:

Header 1	Header 1	Header 2	Header 3	Header 4	Header 5
Date	Cookie	session	Itemid	eventtype	flag
2014-04-20	1	a	100	buy	1
2014-04-21	1	a	100	itemclick

So the itemclick must always be before the buy.