Please enable JavaScript.
Coggle requires JavaScript to display documents.
My90 Data Pipeline, Analyze and Compute (Sentiment analysis (Feature…
-
Analyze and Compute
Sentiment analysis
- Feature Compute sentiment analysis for all text entry (open) responses
When a recipient responds to an open response question
Then the text response is analyzed by AWS Comprehend
And the sentiment score is recorded
And the computation is displayed on the My90 dashboard
-
My90 Contact Score
- Feature Compute community engagement index for all stop and service call scenarios
When a survey conversation is completed or partially completed by a recipient
Then the survey conversation is given a 0-100 score
And it is aggregated with other My90 Contact scores according to some index (i.e. police department)
And it is presented on the My90 dashboard
NoahGift proposes using AWS SageMaker for our learning algorithms.-
-
-
-
Departmental statistics
- Feature Compute statistics from internal police department survey conversations
Given an internal police department survey conversation was distributed
When When responses and survey data are returned
Then summary statistics are computed
-
-
-
Capture, concatenate, and store the proper data
-
Responses
- Feature Capture responses from SMS survey conversation to be stored in My90 database
Given a recipient has received a survey conversation
When a response is submitted
Then the data is captured
And stored in the My90 database
Details in the API documentation are here.-
Questions
- Feature Capture survey data and structure to be stored in My90 database.
Given a recipient responds to a survey conversation
When a recipient responds to a question
Then data about the survey and question are captured
And stored in the My90 database
Details on pulling down a survey are here.
-
Security
- Qualtrics is highly secure. However, is it better for us to remove all data from Qualtrics after it has been sent to My90?
- There is a feature called
anonymize response that wipes all personal identifying information before data is saved. Are there scenarios in which this is the preferred option? :question:
A potential scenario is Departmental Survey Conversations. Details on this survey option here.
-
Language
- Feature Capture and store a respondent's preferred language
Given a survey has more than one language options
When a recipient responds to a language question
Then that response is captured
And the language preference is stored
And all subsequent survey conversations are conducted in that preferred language until otherwise indicated.
-
-
Build the conversations
SMS compatible
- Feature Build a multiple choice or text (open response) conversation to be distributed to and answered by users via text message.
- When an admin builds a new conversation using the Qualtrics UI
Then the survey should be 2-way SMS compatible
- Qualtrics calls surveys
projects. A survey can be formatted by a My90 admin using
the Qualtrics UI. There are limitations to building surveys that can be deployed via 2-way SMS. Details here in Survey Design.
-
Branching
- Feature Build a survey using conditional logic
- When conditional logic is implemented
- Then a recipient is only displayed select questions based on responses
- Conditional logic is called branching in Qualtrics and can be designed by a My90 admin using the UI. It can be accessed through Projects > Survey Flow. For more complex branching requirements,
Survey Blocks in addition to Questions. Details here.
-
Translations
- Feature Build a survey in multiple languages
Given a My90 admin has built a survey conversation using Qualtrics
- When a survey is translated into multiple languages
- Then it is displayed to the recipient in the recipient's preferred language.
- Translations are a built in feature for Qualtrics, but they are primarily designed for web surveys. Branching using blocks is probably the best option for a My90 admin.
-
Security Protections
- Feature Add survey protections to prevent trolling, unwanted responses, and corrupt data
- Given a survey will be deployed via 2-way SMS, an anonymous link, or inbound message
- When a respondent attempts to answer the a survey for a second time during the same session
- Then the response is removed
- Qualtrics has tools to prevent
ballot box stuffing and they also allow for password protection and authenticators to protect surveys. The Qualtrics features only apply to email and web-based surveys, as it uses cookies to detect duplicates. Details here. My90 will need to use a similar feature using the embedded data or phone number to protect the survey conversation.
-
Police Department Admin
Data
- Officer name
Officer badge number
Officer rank
Recipient phone number
Type of interaction
Police reported race
Police reported gender
Police reported age
Ticket/summons id
Location of interaction
-
-
-
Census Data
Data
- City population
City age breakdown
City race breakdown
City gender breakdown
City name or id
It's not clear that there is a good census API for all cities. The data are sometimes calculated using different scales. These percentage vectors may need to be manually added. -
My90 Dashboard 