How can I exclude bots from my Shopify Analytics Sessions reports in ShopifyQL?

In your ShopifyQL query, you can add the following condition in the WHERE clause to exclude sessions that Shopify detected as bots:

human_or_bot_session = 'human'

This filter will only include sessions that appeared to be "human".

For example, to generate a report of Sessions by hour which excludes bots, you would use a ShopifyQL query like this:

FROM sessions
  SHOW online_store_visitors, sessions, pageviews
  WHERE human_or_bot_session = 'human'
  TIMESERIES hour
  SINCE startOfHour(-24h) UNTIL now
  ORDER BY hour DESC

Related Articles:


App: EZ Exporter

Tags: analytics, sessions, shopify analytics, shopifyql