| title | E-commerce Overview |
|---|---|
| notes | This example uses [theLook eCommerce](https://console.cloud.google.com/marketplace/product/bigquery-public-data/thelook-ecommerce). To connect with Graphene, you'll need to set up [ADC local credentials](https://cloud.google.com/docs/authentication/set-up-adc-local-dev-environment) |
Product Explorer | Returns investigation
from order_items select date_trunc(created_at, day) as day, revenue, gross_profit, gross_margin_pct, units_sold as unitsfrom order_items select products.category, revenue, gross_profit, gross_margin_pct, units_sold as units order by 2 desc limit 20from order_items select users.state, revenue, units_sold as units order by 2 desc limit 25from order_items select products.name, units_sold, revenue as product_revenue, gross_margin_pct, return_rate order by 3 desc limit 30