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