Total number of unique users.

COUNT(DISTINCT user_pseudo_id)

Citations

• https://developers.google.com/analytics/bigquery/web-ecommerce-demo-dataset