How to extract UTM tags from a link into separate columns

Task

The url column contains a link with utm_source, utm_medium, and utm_campaign. The export needs a separate column for each tag.

Short Answer

You can extract the value by removing parts of the string step by step. For many links, the regex option is shorter.

How to do it in Eofferix with substring search and removal

Create the final utm_source column from url.
Add a rule: Contains substring utm_source= — Remove before. After it, the string starts with the needed parameter.
Add a rule: Contains substring utm_source= — Remove substring utm_source=.
To remove following parameters, add rule pairs for & and #: Remove after, then Remove substring.
Without regex, the rules cut everything before utm_source, remove the parameter name, and cut the tail after the value.
Repeat the same pattern for utm_medium and utm_campaign, replacing the parameter name.

For utm_source, add: Regular expression (?<=utm_source=)[^&#]+, action Remove everything except.
(?<=utm_source=) means “start right after utm_source=”. [^&#]+ means “take one or more characters until & or # appears”.
The regex keeps only the utm_source parameter value.
Use (?<=utm_medium=)[^&#]+ for utm_medium and (?<=utm_campaign=)[^&#]+ for utm_campaign.

source data

row_id	url
1	https://shop.example.com/product?utm_source=google&utm_medium=cpc&utm_campaign=spring_sale

result

row_id	utm_source	utm_medium	utm_campaign
1	google	cpc	spring_sale