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