: A concatenated string or array of channels (e.g., Social > Search > Email ).
: It aggregates individual touchpoints into sequential "paths." This involves grouping all interactions a user had leading up to a specific conversion event [4]. strongmta.sql
: It standardizes timestamps, user identifiers (UIDs), and channel names across different platforms (e.g., Google Ads, Facebook, Organic Search) to ensure a unified view of the customer journey [1, 3]. : A concatenated string or array of channels (e
: A boolean or integer indicating if the path led to a sale (1 or 0). : A boolean or integer indicating if the
: The script applies logic to filter out interactions that occurred outside a defined lookback window (e.g., 30 days) and identifies which touchpoints belong to a single conversion cycle [2, 5].
: The revenue or weight associated with that specific conversion [1, 2]. Why This Feature is Critical
Once the "prepare" feature executes, the output table usually contains: : A unique identifier for the customer.