ShopifyQL utm_campaign_name was not recorded in sales

Highlighted
New Member
5 0 0

I was trying to get total item sales for each UTM campaign using the ShopifyQL.

It seems like the UTM and total sales are not recorded, and hope someone could point me to a direction.

Here are the steps I did:

1. Visit a product on my development store (aim to mimic a click from an ad). The link looks like this:
https://xxxxxxxxxx.myshopify.com/products/tee?utm_source=custom-test&utm_medium=cpc&utm_campaign=test

2. On the UI, I added that item to cart and checked out using a test card (bogus gateway)

3. I saw the orders on the store admin, and some conversion events were tracked on Shopify analytics dashboard

4. I then used ShopifyQL to fetch the campaign data, the total_sales and utm_campaign_name fields are all zeros and empty string (see picture below).

Here is the query I used for ShopifyQL:

'''
SHOW total_sales
OVER day(happened_at) AS vday
BY utm_campaign_name
FROM sales
SINCE -1m
UNTIL today ORDER
BY vday ASC
'''

 

Screen Shot 2020-09-30 at 3.00.58 PM.png

0 Likes