Skip to content

vpn

Functions for processing VPN data.

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

Source | Edit

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

Source | Edit

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

Source | Edit

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>

Source | Edit