Each unique assignment for an experiment to a subject is logged and persistently used any time that subject is encountered again in the future. This view becomes the foundation for all experimentation reporting.

Application Roles

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

  • admin
  • editor
  • analyst

View

View: <application_name>.experimentation.assignments

FieldDescriptionData Type
idUnique ID for the assignment. This is a KSUID that is sorted automatically by time.string
subject_idID of the subject that given the assignment. Note that this lacks context of the actual subject type used. That will need to be done via a JOIN on the experiments table, if required.string
experiment_idExperiment IDstring
variant_idID for the variant that was assigned.string
cohort_indexIndex for the active cohort at the time of assignment (the cohort the subject is in).int
created_atTimestamp of when the assignment was made. ISO8601 format.string