In order to monitor usage, the application creates a schema with views that give aggregate counts of assignments. These are useful to query assignment creation trends, such as when spikes occur.

Be sure to assign the provider application role to Winning Variant so that we may monitor assignment usage relative to contract terms.

Application Roles

A user must be mapped to one of the following application roles to access assignments:

  • admin
  • editor
  • analyst
  • provider

Views

Assignments per hour

View: <application_name>.experimentation.assignments_per_hour

FieldDescriptionData Type
created_at_hourTimestamp of the assignment creation date, truncated to the hour.TIMESTAMP_TZ
assignment_countNumber of assignments created in the given hourINT

Assignments per day

View: <application_name>.experimentation.assignments_per_day

FieldDescriptionData Type
created_at_dayTimestamp of the assignment creation date, truncated to the day.TIMESTAMP_TZ
assignment_countNumber of assignments created in the given dayINT

Assignments per month

View: <application_name>.experimentation.assignments_per_month

FieldDescriptionData Type
created_at_monthTimestamp of the assignment creation date, truncated to the month.TIMESTAMP_TZ
assignment_countNumber of assignments created in the given monthINT

Assignments per experiment

View: <application_name>.experimentation.assignments_per_experiment

FieldDescriptionData Type
experiment_idID of the experimentVARCHAR
experiment_nameName of the experimentVARCHAR
lab_idID of the lab the experiment belongs toVARCHAR
assignment_countNumber of assignments created in the given experimentINT

Examples

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

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