> ## Documentation Index
> Fetch the complete documentation index at: https://docs.uselayers.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Datasets

> LayersQL provides multiple datasets — products, sales, blocks, collections, and search — that you query with SQL-like syntax for ecommerce analytics.

LayersQL provides seven datasets for building metrics. Each dataset exposes its own metrics, dimensions, and example queries.

| Dataset                                                        | Purpose                                               | Default group key   |
| -------------------------------------------------------------- | ----------------------------------------------------- | ------------------- |
| [Products](/platform/layersql/datasets/products)               | Catalog and performance metrics for products          | `product_id`        |
| [Sales](/platform/layersql/datasets/sales)                     | Order-level metrics from the purchases table          | `transaction_id`    |
| [Search (text)](/platform/layersql/datasets/search-text)       | Text search analytics grouped by canonical query term | `term`              |
| [Search (image)](/platform/layersql/datasets/search-image)     | Image search analytics                                | `image_hash`        |
| [Search (similar)](/platform/layersql/datasets/search-similar) | Similar item search analytics                         | `product_id`        |
| [Collections](/platform/layersql/datasets/collections)         | Collection browsing and conversion analytics          | `collection_handle` |
| [Blocks](/platform/layersql/datasets/blocks)                   | Recommendation block requests and conversions         | `block_id`          |

## Dates (all datasets)

All datasets accept the same date expressions in the `SINCE` 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-15` or `2025-03-15T10:30:00Z`

## Next steps

* [LayersQL overview](/platform/layersql/overview)
* [LayersQL syntax](/platform/layersql/syntax)
* [LayersQL functions](/platform/layersql/functions)