[Design]Experiment Definition Schema and Experiment DataProduct

Introduction :

Design Flow :

Experiment Definition Schema:

	Field	type	Description
1	experiment_id	String	unique id for experiment
2	experiment_name	String	name of the experiment
3	channel	String	experiment channel(portal/app/Desktop)
4	start_date	Timestamp	start date of the experiment
5	end_date	Timestamp	end date of the experiment
6	user_count	Long	no of users mapped to the experiment
7	device_count	Long	no of devices mapped to the experiment
8	experiment_mapped	Boolean	flag to check if the experiment is already mapped

Experiment Data Product :

Purpose

To compute the user experiment mapping based on the experiment criteria and save it to elastic search

Inputs

Experiment_Definition Cassandra Table
Experiment Criteria Config

User Criteria Config

UserCriteriaConfig

{
  "experiments": [
    {
      "exp_id": {
        "criteria": {
          "type": "user",
          "channel": "app/portal/desktop",
          "request": {
            "filters": {
              "organisations.orgName": [
                "sunbird"
              ],
              "framework.board": [
                "CBSE"
              ]
            }
          }
        }
      }
    },
    {
      "exp_id": {
        "criteria": {
          "type": "user",
          "channel": "app/portal/desktop",
          "request": {
            "filters": {
              "emailVerified": true
            }
          }
        }
      }
    }
  ]
}

Device Criteria Config

DeviceCriteriaConfig

{
  "exp_id": {
    "criteria": {
      "type": "device",
      "channel": "app/portal/desktop",
      "request": {
        "filters": [
          {
            "name": "state",
            "operator": "IN",
            "value": [
              "Karnataka"
            ]
          },
          {
            "name": "first_access",
            "operator": "GT",
            "value": "2019-07-17"
          }
        ]
      }
    }
  }
}

Outputs

user experiment mapping index to elastic search
user/device id
experiment id.
experiment joined date
experiment exit date.