How can I generate an Analytics report of Sessions from AI sources for my Shopify store?

You can use the ShopifyQL query below to generate a Shopify Analytics report that groups the session data from the last 365 days by the utm_source UTM parameter to only include sessions that appear to come from an AI platform:

FROM sessions
  SHOW online_store_visitors, sessions, pageviews, sessions_with_cart_additions,
    sessions_that_reached_checkout, sessions_that_completed_checkout,
    conversion_rate
  WHERE human_or_bot_session IN ('human', 'bot')
    AND (utm_source CONTAINS 'chatgpt' OR utm_source CONTAINS 'openai' OR
    utm_source CONTAINS 'gemini' OR utm_source CONTAINS 'claude' OR utm_source
    CONTAINS 'perplexity' OR utm_source CONTAINS 'grok')
  GROUP BY utm_source
  SINCE startOfDay(-365d) UNTIL today
  ORDER BY utm_source ASC

Note that this is not a full list of all AI platforms.  Just modify the filter portion of the query to add additional platforms you're aware of.


Related Articles:


App: EZ Exporter

Tags: analytics, shopify analytics, shopify analytics reports, utm parameters, ai, shopifyql