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:
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 '''