utm parameters in shopify reporting not matching

[SJ19]

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 ?

[theDMM]

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.

[SJ19]

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 -

```select order_id,case when source_lastvisit is not null then utm_medium_lastvisit
                     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