| Dataset | Purpose | Default group key |
|---|---|---|
| Products | Catalog and performance metrics for products | product_id |
| Sales | Order-level metrics from the purchases table | transaction_id |
| Search (text) | Text search analytics grouped by canonical query term | term |
| Search (image) | Image search analytics | image_hash |
| Search (similar) | Similar item search analytics | product_id |
| Collections | Collection browsing and conversion analytics | collection_handle |
| Blocks | Recommendation block requests and conversions | block_id |
Dates (all datasets)
All datasets accept the same date expressions in theSINCE clause:
- Relative offsets:
-24h,-48h,-7d,-14d,-30d,-90d,-12m,-1y - Keywords:
today,yesterday,this_week,last_week,this_month,last_month,this_quarter,last_quarter,this_year,last_year - Rolling windows:
past_7_days,past_14_days,past_30_days,past_60_days,past_90_days,past_180_days,past_365_days - ISO timestamps:
2025-03-15or2025-03-15T10:30:00Z