What is a project?
A Project is the highest-level object on Caplena. It is somewhat equivalent to a Sheet in Excel.
Survey Example: When conducting a survey, you will probably have all results in one sheet. Every row then represents on respondent, every column to either a question or some additional data, like identifier, demographics et.
NPS Feedback Example: NPS questionnaires will obviously have a column containing the score (an auxiliary column in Caplena's terms) and often one column containing the open-ended feedback. There might also be multiple questions, e.g. "What did you like..." and "What did you dislike", although we recommend asking only a single question in most cases.
Social Media Data Example: A social media dataset will usually have one column containing the text you want to evaluate, so you would have one question in Caplena's terms. But there will probably be further columns with addition information like user, timestamps or likes.
What is a question?
A question is one column of text data that you wish to analyze. Son in our example data, we would have two questions, with three answers each. The other two columns are not questions, as they do not contain text data that is analyzed.
What is an answer / response?
An answer or response is a single element of text, one response to one question. Or in social media terms: One tweet or one post.
What is a row?
A row is the same as what it is in Excel: A row of data 😊. When appending additional data to your projects, you can only do this row-wise (i.e. you cannot upload a response to only one question - all questions in a project always need to have the same number of answers).
What are additional / auxiliary columns?
Additional or auxiliary columns (we treat those as synonyms) are the additional data columns that you do not select during upload. They will be uploaded nevertheless, but you will not be able to analyze them as text and you will also not be billed for them. But you can use them in charts or display them besides your text in the coding view.