As a Campaigns team member, I want to know how and where registration data can be stored, so that the team can begin developing a proposal on data storage & the schema to share with stakeholders.
Background: As the first stage of work in the registration project, we must first develop a proposal to share with various stakeholders. This proposal will detail how and where we will store the data collected in the registration experience on both organizers and participants. The end goal of this ticket should be able to collect the information that is needed to write the proposal. The actual proposal can be written in a separate ticket or document.
Relevant resources:
Acceptance Criteria:
- Investigate how and where we can store the following data to be collected in the registration experience:
- Name of event
- Event page URL
- Start date
- End date
- Start time
- End time
- Timezone for event
- If event is virtual, in-person, or hybrid
- If Virtual:
- Link to join virtually
- Joining notes/additional information
- If in-person
- Location name
- Location address
- If Virtual:
- Organizer usernames
- Organizer who created the registration experience
- Other organizers listed by creator
- Desired tracking tool
- Name of tracking tool
- Link to tracking event
- Link to external chat group for event (such as a Telegram group)
- Usernames of registered participants
- Date participants registered
- Time participants registered
- If the event registration is open or closed
- Date event was created (For future analysis/viz: )
- Drafted vs published
- Campaign_id (which can attach to multiple event_ids)
- Consider any major risks, dependencies, or blockers for doing this work
- Take into account that we the registration experience may be expanded in the future to include:
- Allowing organizers to ask more questions of participants (such as their wiki editing level or what topics interest them)
- Allow organizers to write custom questions that participants can respond to in a blank field
- Allow organizers to specify what kind of event they are organizing (such as a photography contest, writing contest, training for newcomers, etc)
- Take into account 3 data types: allowing organizers to ask more questions of participants that could be public, questions that may only be available to organizers and aggregate analysis, and custom questions
- Share findings in a comment in this ticket