ShopifyQL Revenue-by-UTM Report (No GA4/FB Setup)

I want to see which marketing channels are actually driving revenue, using only Shopify’s own order and traffic-source data — no GA4 attribution settings or Facebook Conversions API configuration (Sidekick can’t reach those systems).

Store URL: [YOUR_STORE_URL]
Date range: [DATE_RANGE, e.g., last 30 days]
Campaigns to track: [CAMPAIGN NAMES, e.g., spring-sale, ig-story-launch]

Please help me:


  Build a ShopifyQL report showing order count and total revenue grouped by UTM source, medium, and campaign for [DATE_RANGE], sorted by revenue descending.
  Within that report, break out new vs. returning customers per UTM source so I can see which channels bring net-new buyers.
  Tag every order whose landing-page URL contains UTM campaign “[CAMPAIGN NAME]” with the tag “campaign:[CAMPAIGN NAME]” so I can filter and re-pull this report for that campaign specifically.
  Save the report from step 1 as a reusable skill (e.g., /revenue-by-source) so I can rerun it weekly with a new date range.


Keep this scoped to Shopify’s own order/session data pulled via ShopifyQL and order tagging — do not propose GA4 attribution model configuration, Facebook Conversions API setup, or cross-platform reconciliation; those live outside Shopify admin.