How Does Fivetran Get the Key-Value Pairs for the Shopify ORDER_URL_TAG Table?

We use the Shopify Order API to retrieve each order's landing_site URL. This URL contains query parameters that track marketing sources, campaigns, and other referral data. We extract these parameters and store them as key-value pairs in the ORDER_URL_TAG table.

For example, let's say we extract the following landing_site URL: /products/abcd?utm_medium=affiliaté&utm_source=xyz-abc&utm_campaign=99999&publisherId=99999&clickId=00000

We would then process the URL and store the following key-value pairs in the ORDER_URL_TAG table:

• utm_source=xyz-abc
• utm_campaign=99999
• publisherId=99999
• clickId=00000