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

# Consumption

> Aggregate views of assignment consumption.

In order to monitor usage, the application creates views that give aggregate counts of assignments.

## Application Roles

A user must be mapped to one of the following [application roles](/snowflake-app-details#application-roles) to access assignments:

* `admin`

* `editor`

* `analyst`

* `wvusage`

## Views

### Assignments per day

View: `experimentation.assignments_per_day`

| Field              | Description                                    | Data Type |
| ------------------ | ---------------------------------------------- | --------- |
| `date_created`     | Date the assignment was created                | `DATE`    |
| `assignment_count` | Number of assignments created in the given day | `INT`     |

### Assignments per experiment

View: `experimentation.assignments_per_experiment`

| Field              | Description                                           | Data Type |
| ------------------ | ----------------------------------------------------- | --------- |
| `experiment_id`    | ID of the experiment                                  | `VARCHAR` |
| `experiment_name`  | Name of the experiment                                | `VARCHAR` |
| `lab_id`           | ID of the lab the experiment belongs to               | `VARCHAR` |
| `assignment_count` | Number of assignments created in the given experiment | `INT`     |

## Examples

**Get a daily account of assignments for the month of December 2024**

```SQL theme={null}
USE <application_name>;

SELECT *
FROM experimentation.assignments_per_day
WHERE date_created >= '2024-12-01' AND date_created < '2025-01-01';
```