Skip to main content

Questionnaires Analytics and Report - Article

Investigate questionnaire responses across training, applications, onboarding and shared links. Interpret usage context, repeat submissions and revisions, then export the permitted response data with the right filters and columns.
Updated: 9 Nov 2026
11 min read

Summary

Questionnaire evidence is most useful when you know what was asked, where the form was presented and which audience the results represent. Analytics helps identify response patterns; the Excel report supports detailed review and follow-up within the permitted scope.

Use both with care. A submission is not necessarily a unique person, a current question chart is not a complete history of every revision, and an export does not override privacy or retention settings. The reporting context matters as much as the number shown.

Use this article to:

  • Find the questionnaires and responses available to your role
  • Separate evaluation, enrollment, onboarding and URL response contexts
  • Interpret submission totals, question breakdowns and revisions
  • Generate an appropriate Excel report with verified columns
  • Use feedback to improve delivery without overstating what it proves

Start with the business question

A central training team may want to compare the relevance of a programme across several customer regions. An instructor may need to understand practical concerns from one delivery. An application reviewer may instead need the evidence submitted with a particular participation request.

These are different uses of the same reporting framework. Decide the questionnaire, delivery context, period and authorized audience before interpreting the result. A self-reported confidence answer is not a scored assessment result, and positive feedback does not independently establish competence or compliance.

Open analytics and understand the list

Go to Analytics → Questionnaires. You can also use Analytics beside a questionnaire in Course administration → Questionnaires, where that shortcut is available to your role. Search by questionnaire title and use the available filters to narrow the list.

Questionnaires analytics list with creation-date filter badges, Search, Get report and example questionnaire titles.
Search and filter the questionnaire analytics list before opening a form’s response breakdown.

The analytics list's date selection concerns questionnaire creation dates. Do not assume that choosing the same dates in an exported report answers the same question: the report uses Submitted from / To for response submission dates.

Usage filtering depends on recorded response context. A form can exist without having a response in every route where it could theoretically be used. Check filter badges and clear a retained filter before concluding that a questionnaire or response is missing.

Questionnaires filter view with From and To dates, Type set to Enrollment request, an Activity selector, Apply and Cancel.
Usage filtering can narrow the view to a response route and its relevant source activity.

Filter by how the questionnaire was used

Usage contextWhat it identifiesUseful distinction
ActivityActivity- or module-level Questionnaire feedbackEvaluates the selected training context
Button widgetA native questionnaire button in a CourseIdentifies the Course-button route rather than a generic pasted URL
Enrollment requestA questionnaire in an application or participation-approval flowSubmission is evidence for the request, not automatic approval
Enrollment restrictionComplete questionnaire used as a self-enrollment requirementThe response belongs to that activity's enrollment flow
Enrollment request confirmationQuestionnaire after approval, during participation confirmationDistinguish confirmation status from ordinary evaluation
On-demandA training-request formA request is not completed enrollment or a paid booking
Onboarding ruleA questionnaire delivered through onboardingRelates the response to the configured onboarding journey
Automated email workflowA native questionnaire button in a workflow emailThe activity relationship depends on the workflow's context
URLA directly shared questionnaire linkCan include anonymous responses, without inferred activity details
Supplemental questionnaireThe person's maintained supplemental recordLater edits update the current record rather than creating a row for every edit

When the selected type supports it, choose the relevant activity, Course, onboarding rule or workflow in the subtype selection. Available entities remain limited by permission and relationship scope. A direct URL does not acquire activity context merely because someone pasted it into a Course or email.

Use Questionnaires Across Enrollment, Training and Onboarding explains how to configure these routes rather than merely filter their results.

Read totals and question breakdowns together

Open a questionnaire to see its available counters and per-question Breakdown. Number of responses counts submissions: if one person submits through several routes or repeats an allowed route, more than one response can be counted. It is not a guaranteed unique-person measure.

Used in opens the available usage relationships for authorized administrators. Use it to understand reuse before changing the form or combining results. The question count describes the form, not the number of successful assessments or people trained.

A questionnaire breakdown shows 10 questions, 3 answers and 2 usage locations, followed by an expanded Single choice satisfaction distribution and part of a Rating scale question.
Read submission counters alongside the expanded question-level distribution and its response context.

Where displayed, response rate relates replies to an audience defined by the usage context. Activity-based routes can use signups, while onboarding uses assigned users. A shared URL does not establish how many people received the link, so its result is not a reliable email-campaign response rate. Combining usage contexts also does not produce a clean, deduplicated population automatically.

The platform's repeat-feedback configuration can suppress response-rate displays. Optional and conditional questions can also have fewer answers than the overall submission total. Do not treat every blank answer as refusal or every low rate as proof that the course is poor.

Use the appropriate evidence for each question type

Question typeAvailable interpretationUseful follow-up
Single choice and DropdownDistribution across selected options; a pie chart where supportedInvestigate dominant categories and whether the options fit the audience
Multiple choiceSelections across options; a horizontal breakdownRemember that one person can select several options, so selections need not equal people
Linear scale and Rating scaleDistribution on the configured scaleCheck direction, labels and range before calling a number low or high
NPSAnswers on the fixed 0–10 recommendation scaleUse the dedicated NPS dashboard for aggregated NPS; use questionnaire reporting for the underlying response evidence
ConsentThe configured agreement responsesInterpret within the stated purpose; it is not a satisfaction score or an automatic compliance conclusion
Text, Number, Date, Time zone, Name, Address and File uploadDetailed declared information, principally reviewed through the response/report workflowInvestigate the actual context without inventing a generic score or a chart that does not exist
Heading, Text block and DividerPresentation, not respondent answersDo not include them as missing-response questions

Large choice lists can appear as tables instead of charts. Depending on configuration, options with no answers may be hidden in those large lists. An absent option in that presentation is not evidence that the original question never contained it.

Use See details where available for supported choice/scale questions and the permitted respondent detail. It is not available for every question type. Questionnaire privacy settings can prevent personal-detail access even when a user has broader analytics permission.

An expanded Single choice question displays a distribution and See details action; a Multiple choice question below is collapsed. No individual respondent names are shown in this illustration.
See details is offered for supported question types when the questionnaire’s privacy settings permit it.

Understand revisions before investigating missing answers

Editing question content or options can create a revision. Current question-level breakdowns can then show responses for the current revision, while the overall submission total still includes earlier submissions. A new question chart showing zero is not proof that ordinary editing erased every historical response.

In reports, responses to earlier and edited content can appear in separate question-related columns when responses exist for those revisions. Reordering questions affects their order in the export without itself creating the same new-revision effect. Inspect the actual question labels and columns before comparing periods.

Historical availability is not unconditional. Anonymization or response deletion, deleted users or questionnaires, and route-specific lifecycle behavior can change what remains reportable. In particular, cancellation of a registration using a questionnaire enrollment restriction removes that related response and requires a fresh submission for re-enrollment. Do not generalize the normal retention of canceled training feedback to that separate route.

Generate an Excel report

Use Get report from questionnaire analytics to open Questionnaires report. Configure the response scope before generating the file.

  1. Set Submitted from and To for the response period.
  2. Select the relevant Questionnaire or questionnaires. This narrows the available usage context.
  3. Use User type where you need Learner or Instructor responses. Instructor feedback is a configured route, not every form answered by a person who happens to have an instructor role.
  4. Choose Type and any relevant subtype. For URL reporting, review Show anonymous answers where offered.
  5. Select a suitable Template, or use Customize to review the included columns where available. Include at least one column.
  6. Select Generate, then inspect the resulting .xlsx workbook and retain the filter context with the analysis.
Questionnaires report page with side navigation and back link. The form includes Submitted from and To dates, Questionnaire, User type, Type, Template and Generate controls.
Use submission dates, questionnaire, user type and usage context to define the export before choosing its template.

Templates control the included information; they do not grant access to additional people or restore data removed by a questionnaire privacy rule. Verify the current permissions and available template rather than assuming that a Full report includes every field imaginable.

Understand the actual workbook structure

The standard questionnaire report includes response context and Questions (multiple columns). It is not a universal one-row-per-question table with generic Question, Answer and Score fields. Repeated submissions can produce separate response records for the same person, and revised questions can add separate columns.

Column groupExamples of supported fieldsWhy it matters
Response contextQuestionnaire type, Evaluation date, User typeEstablishes how and when the response was submitted
Source relationshipActivity, Module, Course page, Onboarding rule, Automated email workflowIdentifies the relevant source where the route supplies it
Training contextStatus, Schedule, InstructorsInterprets confirmation or training-related evidence where applicable
Respondent detailsFirst name, Last name, EmailSubject to identity, anonymity and privacy settings
Question answersQuestions in multiple columns, including relevant revision columnsPreserves the actual form's answers rather than an invented generic score model
Customize report dialog on the Questionnaires report page. The available checkboxes include Questionnaire type, Evaluation date, Activity, Module, Course page, Onboarding rule, Automated email workflow, Status, Schedule, Instructors, User type, First name, Last name, Email and Questions (multiple columns).
Customize report exposes the actual context fields and Questions (multiple columns); it does not promise a generic row-per-question export.

When several questionnaires are included, the workbook separates the relevant questionnaire information into worksheets. Not every route supplies every context field: standalone URL responses do not automatically provide Activity, Module, Schedule or Instructor information. A configured submission-page URL column is an optional platform-specific addition, not a universal export field.

Own replies from supported choice questions can appear in an Other column. Review them separately from predefined categories. A self-entered name is also different from an authenticated profile link. Use the generated fields as evidence rather than assuming a user ID, external ID, organization, language or assessment-score column exists in every export.

Respect permission scope and data policy

Access has several layers: permission to open questionnaire analytics, access to the relevant questionnaires or activity relationships, and questionnaire-level privacy settings. Administrative roles can be constrained by organization filtering; unrestricted administrative scope is not a property of every role with Analytics in its menu.

Instructor-style access is limited to relevant questionnaires associated with their responsibility, including the supported feedback and Course-button contexts. Manager-style access to participation-request questionnaires depends on the applicable approval and people relationship; it is not general access to every team member's questionnaire answers. See Roles, Responsibilities, and Management Scope.

Blocked users and expired registrations can remain in questionnaire evidence, whereas deleted users and deleted questionnaires are excluded from the current analytics population. Check the route-specific cancellation exception and any privacy deletion before treating an absent response as a reporting defect.

Hide personal details in analytics and reports (all data is stored) prevents normal respondent-detail access and identity-filled exports even if those columns are selected. Identifier-removal or response-deletion policies have different effects. Data Privacy and Anonymization explains those choices and the separate handling needed for exported or emailed copies.

Use feedback for quality improvement and customer follow-up

A global training provider can reuse a stable evaluation across regional deliveries, then filter comparable activity contexts and periods. A central team can investigate differences in relevance or pacing, while an authorized instructor reviews the deliveries they are responsible for.

Combine the structured signal with the actual comments and delivery conditions. A low rating may reflect scheduling, an audience mismatch or a missing practical exercise rather than only instructor performance. A high rating is useful evidence of sentiment, not proof that learning objectives or regulatory requirements were achieved.

Use identified detail only when the follow-up needs it and policy permits it. Otherwise, grouped evidence may be sufficient to improve the design. Record the questionnaire revision, filters and interpretation alongside an authorized export so the analysis can be understood later. Do not promise that a newly generated export will remain identical after privacy actions, user deletion or later configuration changes.

Troubleshooting

ProblemWhat to check
A questionnaire or usage type is missingCheck title search, creation-date filters, recorded responses, usage context and permission scope
There are more responses than peopleCheck repeat submissions and reuse across routes; submissions are not a unique-user count
A chart shows zero after an editCheck questionnaire revision and filters, then inspect historical question columns in the report
A response rate is absent or misleading for the intended comparisonReview the route's audience definition and repeat-feedback configuration; do not use URL responses as an outreach denominator
Names or See details are unavailableCheck questionnaire privacy settings as well as role and relationship scope
A direct-link response has no Activity valueThe URL route does not infer the activity where a link happened to be pasted
An expected report column is absentReview Customize, the selected template, platform configuration and whether the route supplies that field
A canceled learner's enrollment-restriction response disappearedThis route removes the related response on cancellation and requires resubmission for later enrollment

FAQ