Total number of unique days.

COUNT(DISTINCT event_date)

Citations

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