utm parameters in shopify reporting not matching

Shopify Discussion
1

Hi Team,

utm_parameters such as utm_medium is not matching between shopify UI report and order rest api endpoint. utm_medium value is ‘paid-affiliate’ for order in report but says null in api response for landing_site_ref.

Can you please confirm, if there is another column in rest api response which will hold correct value that will match report data ?

2

Did you make a custom app to map the Shopify order UTM parameters to HubSpot?

We are frustrated that we cannot sync the UTM parameters from Shopify to HubSpot in the native HubSpot-Shopify (datasync) integration.

3

Hi Connor,

I tried using graphql endpoint for orders customerJourney, and it was matching with Shopify UI report, using some logic. Here is the snapshot of query -

when utm_medium_lastvisit is null then utm_medium_firstvisit
else utm_medium_lastvisit
end medium```
And grapql query -

'order_query': """
query getOrders($query: String!, $limit: Int!, $after: String) {
orders(query: $query, first: $limit, after: $after) {
edges {
node {
app {
id,
name
}
id
createdAt
updatedAt
customerJourneySummary {
firstVisit {
source
utmParameters {
medium
source
campaign
content
term
}
}
lastVisit {
source
utmParameters {
medium
source
campaign
content
term
}
}
}
}
}

I am not sure, if this fully helps your query, but might be useful.

Thanks,

Swati