Hi there,
I would really appreciate some help with this as I am getting to the end of my tether with it.
I’ve created the formulae in the 4 columns in the attachedspreadsheet with yellow headers. I need the last two columns to countconversions and revenue where the channel path doesn’t end either:[FONT="][/FONT]
… > Paid Search[FONT="][/FONT]
Or[FONT="][/FONT]
… > Direct (where Paid Search is the last channel beforeDirect)[FONT="][/FONT]
The formulas I have here do it fine, except where Paid Search isthe last channel before Direct and there has been more than 1 Direct visitafterwards, e.g.[FONT="][/FONT]
… > Paid Search > Direct > Direct[FONT="][/FONT]
[FONT="]Therecould also be a potentially infinite number of Directs.
Can anyone help me? Any guidance would be very much appreciated.
Thanks
David[/FONT]
I would really appreciate some help with this as I am getting to the end of my tether with it.
I’ve created the formulae in the 4 columns in the attachedspreadsheet with yellow headers. I need the last two columns to countconversions and revenue where the channel path doesn’t end either:[FONT="][/FONT]
… > Paid Search[FONT="][/FONT]
Or[FONT="][/FONT]
… > Direct (where Paid Search is the last channel beforeDirect)[FONT="][/FONT]
The formulas I have here do it fine, except where Paid Search isthe last channel before Direct and there has been more than 1 Direct visitafterwards, e.g.[FONT="][/FONT]
… > Paid Search > Direct > Direct[FONT="][/FONT]
[FONT="]Therecould also be a potentially infinite number of Directs.
Can anyone help me? Any guidance would be very much appreciated.
Thanks
David[/FONT]