How can I export individual UTM parameters from the Shopify landing page URL?

The Shopify order data has a field called landing_site which is basically the URL for the page where the buyer landed when they entered the shop.

If you use UTM parameters for tracking where a customer came from before placing an order (such as a Google ad or an email newsletter), this field would contain this data.

EZ Exporter has a function called get_url_query_param_value() that allows to you to automatically extract specific query parameters from a URL and place them in separate columns in the exported CSV file.

For example, a landing_site field may contain this value:

/?utm_source=newsletter&utm_medium=email&utm_campaign=2019%20summer%20sale

Using the formula below:

get_url_query_param_value({{ landing_site }}, "utm_campaign")

Would return "2019 summer sale".

Please note that our app can only export the UTM parameters from this landing_site field.  We currently can't export the additional data from the Conversion Details/Session Details shown in the Shopify Admin.


App: EZ Exporter

Tags: advanced features, url, utm, conversion tracking