vpn
Functions for processing VPN data.
acquisition_channel (UDF)
Assign an acquisition channel based on utm parameters
Parameters
INPUTS
utm_campaign STRING, utm_content STRING, utm_medium STRING, utm_source STRING
OUTPUTS
STRING
channel_group (UDF)
Assign a channel group based on utm parameters
Parameters
INPUTS
utm_campaign STRING, utm_content STRING, utm_medium STRING, utm_source STRING
OUTPUTS
STRING
normalize_utm_parameters (UDF)
Normalize utm parameters to use the same NULL placeholders as Google Analytics
Parameters
INPUTS
utm_campaign STRING, utm_content STRING, utm_medium STRING, utm_source STRING
OUTPUTS
STRUCT<utm_campaign STRING, utm_content STRING, utm_medium STRING, utm_source STRING>
pricing_plan (UDF)
Combine the pricing and interval for a subscription plan into a single field
Parameters
INPUTS
provider STRING, amount INTEGER, currency STRING, `interval` STRING, interval_count INTEGER
OUTPUTS
STRING