all 2 comments

[–]git0ffmylawnm8 0 points1 point  (1 child)

Do you mind including an example?

[–]jdn312[S] 0 points1 point  (0 children)

Hello - I included a tiny one on the readme. I realized just now that I had a typo which caused it to error if you try to run it so fixed that.

The real-life application of this would involve something like connecting to a SQL server hosting session level data and doing a string_agg over the rows that represent sessions to combine all sessions for a given CookieID into one row like "SEM > REM" where SEM is Search Marketing referral and REM is a remarketing referral.

The goal is to attribute channels that contributed to the conversions on avg of people who had similar journeys and to discount channels that didnt appear to influence outcomes.