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 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() which you can use in the Calculated Fields 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".
On the "Templates" page of the app, there's also a pre-built template you can use called "UTM Parameters (Last 30 Days)" which already includes the formulas and can be customized further.
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, utm parameters