Responses by Question

Export response data for a single question across all surveys that include it.

The Responses by Question export generates an Excel workbook containing response data for a single selected question across every survey and program activity that includes it. This is useful for analyzing how a specific question performs across different surveys and programs.

TIP: Navigate to Analyze > Reports > Responses by Question to access this export. Select a question from the list and click Export.

Selecting a Question

The export page displays a list of questions available for export. Only visible questions that appear on at least one survey you have permission to view are shown. The list includes the question text, question type, and the number of surveys that include it.

You can search by question text.

Export Options

When you click Export on a question, a modal appears with the following options:

1

Reporting Period

Optionally select a reporting period to limit the export to program activities within that period.

2

Type of Export

• Individual Responses — Each row represents a single participant's response. The question appears as one column, and the participant's selected option is shown as the cell value.

• All Responses — Response options are split into separate columns (one per option), and cell values show the response count for each option.

3

Date Range

Required. Enter a start date and end date to filter program activities. Only programs with session occurrences or creation dates within this range are included.

4

Additional Options

• Code Values — When checked, response option text is replaced with numeric code values. The Codebook worksheet documents the code mappings.

Response Data Columns

The Response Data worksheet includes the following columns:

• Program Activity ID — Unique identifier of the program activity the response was collected for.

• Program Name — Name of the program activity.

• Program Entered By — User who created the program activity.

• Organization — Organization the program activity belongs to.

• Unit — Extension unit where the program activity took place.

• Primary Curriculum — Primary curriculum assigned to the program (SNAP-Ed programs only).

• Program is Complete — 1 if the program is complete, 0 if not.

• Response Collection Method — How the response was collected: Manual Entry or Public Link.

• Program Survey Name — The label given to the survey when it was attached to the program activity.

• Delivery Type — Survey delivery type: Pre, Post, Followup, or Retrospective.

• Is_aggregated — 1 if the response is an aggregated response, 0 if individual.

• Delivery Date — The date the survey was delivered as part of the program activity.

• Unique PEARS ID of Response — System-generated unique identifier for the response record.

• Unique ID of response — The value from the unique identifier question on the survey, if one exists.

• Question columns — One or more columns for the selected question, depending on the export type.

NOTE: Because a single question can appear on multiple surveys, the export may include responses from different surveys and program activities. The Program Activity ID and Program Survey Name columns help you identify which program each response came from.

Summary Statistics

The Summary Statistics worksheet provides the same statistical analysis as the Responses by Survey export, but scoped to the single selected question across all surveys that include it.