Questionnaires Analytics and Report - Article
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.

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.

Filter by how the questionnaire was used
| Usage context | What it identifies | Useful distinction |
|---|---|---|
| Activity | Activity- or module-level Questionnaire feedback | Evaluates the selected training context |
| Button widget | A native questionnaire button in a Course | Identifies the Course-button route rather than a generic pasted URL |
| Enrollment request | A questionnaire in an application or participation-approval flow | Submission is evidence for the request, not automatic approval |
| Enrollment restriction | Complete questionnaire used as a self-enrollment requirement | The response belongs to that activity's enrollment flow |
| Enrollment request confirmation | Questionnaire after approval, during participation confirmation | Distinguish confirmation status from ordinary evaluation |
| On-demand | A training-request form | A request is not completed enrollment or a paid booking |
| Onboarding rule | A questionnaire delivered through onboarding | Relates the response to the configured onboarding journey |
| Automated email workflow | A native questionnaire button in a workflow email | The activity relationship depends on the workflow's context |
| URL | A directly shared questionnaire link | Can include anonymous responses, without inferred activity details |
| Supplemental questionnaire | The person's maintained supplemental record | Later 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.

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 type | Available interpretation | Useful follow-up |
|---|---|---|
| Single choice and Dropdown | Distribution across selected options; a pie chart where supported | Investigate dominant categories and whether the options fit the audience |
| Multiple choice | Selections across options; a horizontal breakdown | Remember that one person can select several options, so selections need not equal people |
| Linear scale and Rating scale | Distribution on the configured scale | Check direction, labels and range before calling a number low or high |
| NPS | Answers on the fixed 0–10 recommendation scale | Use the dedicated NPS dashboard for aggregated NPS; use questionnaire reporting for the underlying response evidence |
| Consent | The configured agreement responses | Interpret within the stated purpose; it is not a satisfaction score or an automatic compliance conclusion |
| Text, Number, Date, Time zone, Name, Address and File upload | Detailed declared information, principally reviewed through the response/report workflow | Investigate the actual context without inventing a generic score or a chart that does not exist |
| Heading, Text block and Divider | Presentation, not respondent answers | Do 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.

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.
- Set Submitted from and To for the response period.
- Select the relevant Questionnaire or questionnaires. This narrows the available usage context.
- 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.
- Choose Type and any relevant subtype. For URL reporting, review Show anonymous answers where offered.
- Select a suitable Template, or use Customize to review the included columns where available. Include at least one column.
- Select Generate, then inspect the resulting .xlsx workbook and retain the filter context with the analysis.

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 group | Examples of supported fields | Why it matters |
|---|---|---|
| Response context | Questionnaire type, Evaluation date, User type | Establishes how and when the response was submitted |
| Source relationship | Activity, Module, Course page, Onboarding rule, Automated email workflow | Identifies the relevant source where the route supplies it |
| Training context | Status, Schedule, Instructors | Interprets confirmation or training-related evidence where applicable |
| Respondent details | First name, Last name, Email | Subject to identity, anonymity and privacy settings |
| Question answers | Questions in multiple columns, including relevant revision columns | Preserves the actual form's answers rather than an invented generic score model |

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
| Problem | What to check |
|---|---|
| A questionnaire or usage type is missing | Check title search, creation-date filters, recorded responses, usage context and permission scope |
| There are more responses than people | Check repeat submissions and reuse across routes; submissions are not a unique-user count |
| A chart shows zero after an edit | Check questionnaire revision and filters, then inspect historical question columns in the report |
| A response rate is absent or misleading for the intended comparison | Review the route's audience definition and repeat-feedback configuration; do not use URL responses as an outreach denominator |
| Names or See details are unavailable | Check questionnaire privacy settings as well as role and relationship scope |
| A direct-link response has no Activity value | The URL route does not infer the activity where a link happened to be pasted |
| An expected report column is absent | Review Customize, the selected template, platform configuration and whether the route supplies that field |
| A canceled learner's enrollment-restriction response disappeared | This route removes the related response on cancellation and requires resubmission for later enrollment |
FAQ
-
Why can I edit a questionnaire but not open its analytics?
Editing access and analytics access are separate capabilities. Analytics also applies the relevant questionnaire, organization and responsibility scope, together with questionnaire privacy settings. Check those controls instead of assuming that authoring access grants access to every response.
-
Why does an edited questionnaire show fewer answers in its question charts?
An edit can create a new questionnaire revision. The current question breakdown can then show only responses to that revision while the overall submission total still includes earlier submissions. Inspect filters and the report's revision-related question columns. Historical availability also remains subject to deletion and privacy policies.
-
Does hiding names in a questionnaire report delete personal data?
No. Hide personal details in analytics and reports (all data is stored) hides the relevant identity fields while retaining the data. Removing profile-linked identifiers and deleting questionnaire responses are different cases. Free text, files and separate exports or emails may still contain identifying information.
-
Can the same questionnaire be submitted more than once?
It depends on the route and platform configuration. URL and Course-button routes can accept repeat submissions. Activity/module feedback normally follows a once-only flow, but an enabled repeat-feedback configuration can allow more replies. Some onboarding recommendation journeys offer a retake. Submission totals therefore need not equal unique people.
-
Why does a shared questionnaire link not include activity details in the report?
A generic URL does not infer a relationship to the activity, module or schedule where somebody happened to paste it. Use the native activity feature, Course Questionnaire button or other appropriate connected route when that context is required. Review the resulting usage type with a test submission.
-
Does editing a supplemental profile create another response-history row?
The supplemental reporting record is created after the first relevant submission. Later edits from the profile or linked questions update that current record rather than adding a separate row for every change. Use an ordinary response workflow when the requirement is a historical evaluation or request at a point in time.
-
Does the questionnaire Excel report have one row for every question?
The standard report uses response context and Questions (multiple columns), not a universal generic Question/Answer row format. Repeated submissions can create separate response records, and revisions can introduce separate question-related columns. Inspect the selected template and generated workbook before designing downstream analysis.
-
Why can questionnaire analytics and an export differ for the same dates?
The analytics list's timeframe concerns questionnaire creation, while the report uses Submitted from and To for response dates. Also review usage filters, revisions, repeat submissions, privacy settings and permission scope. Using the same calendar dates does not by itself make the two views the same population.
-
Why did an enrollment-restriction questionnaire response disappear after cancellation?
For a questionnaire used as a self-enrollment restriction, canceling the associated registration removes that related response. The learner must submit again for a later enrollment. This route-specific behavior is different from the usual retention of ordinary training feedback after a registration is canceled.