What is a Project Schema and "Mapping data types"?
The Project Schema defines what type of data each column has for the files in the Project. For example, one column might be mapped to 'Text' data, another column might be mapped to 'Date' data.
The Project Schema is defined when creating a new Project, and all following data files will follow the schema. In order to create a schema, a file is selected as an example for you to review and map the fields (columns) to the correct data types.
Data types and definitions:
- Text/Verbatim: Processed as text data to be used in the language model. Also used to display text excerpts/verbatims. Map your free-text/unstructured data to this data type.
- Numerical: Processed as a numerical value. Numerical values can use mathematical functions in a query, such as "greater than" and "less than". Map any numerical structured data to this data type.
- Date & Date Time: Processed as date formats to use as filters and segments. Also used to map data in timeline and trendline charts. Map any date fields in your data to this data type.
- Category: Processed as a value to be used as a segment. Map any structured data that doesn't fall under the other categories to this type.
- NPS (0-10): Processed as a special value which is used to generate three categories (9-10 are labelled as Promoters, 7-8 are labelled as Passives, 0-6 are labelled as Detractors). Also used to calculate NPS and show NPS statistics. Map your respondent's recommendation score to this data type.
- Ignore: Values in this column will be ignored and not included in this Project. Map anything you don't want to be included to this data type.
How do I edit a project schema?
Once a Project has been created it is not possible to go back and edit your Schema - unfortunately the only way to update a Project's schema today is recreate the project with the correct Schema.
If you have a set of saved queries/themes you would like to keep, please reach out to us (see below) once you've recreated the Project and we'll copy your queries across for you (we'll need to know which Project & Analysis to copy from and to).
Note: The ability to edit an existing Schema is something we're working towards in a future product update so be sure to let us know if this is something you're looking for so that we can keep you in the loop as we make progress!
If you have any questions about your Project schema (or need some help!) you can get in touch with us any time by hitting the blue chat button to your right 👉