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)
Hope you can help
Thanks in advance
Try this code:
if(SessionID=SessionID,if(Match(Event,'Buy','itemclick')<>0,RowID)) as Output
(ooxml, embedded labels, table is Sheet1);
Brilliant Aunez! Thank you so much. I was trying to see if i could get a table which only consisted of sessions which had a buy and itemclick. But i cannot seem to figure out how i would get a session table where it consists of session that have both itemclick and buy with same productids.
What would you do if it should look like this?
I have tried this code:
if(upper(Event) = 'ITEMCLICK', if(exists(TempSessionBuy,SessionID),1,0)) as FlagItemBuy
but i also get 1 on those where there is a buy but they have not the same productid
Hi - as you can see in this excel ark - i have a new flag called FlagProductBuyLater
The flag should be 1, when the same cookieid has bought the same productid there has been an itemclick regardless of what session it is in.
So cookieid 1 has an itemclick in session 114 on productid 8 but buys it first in session 178 on same productid 8 - then that line should have 1 in flag as illustrated in the excel file.