# Responses by Question

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.

{% hint style="info" %}
**TIP:** Navigate to **Analyze > Reports > Responses by Question** to access this export. Select a question from the list and click **Export**.
{% endhint %}

## 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:

{% stepper %}
{% step %}

#### Reporting Period

Optionally select a reporting period to limit the export to program activities within that period.
{% endstep %}

{% step %}

#### 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.
  {% endstep %}

{% step %}

#### 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.
{% endstep %}

{% step %}

#### Additional Options

* **Code Values** — When checked, response option text is replaced with numeric code values. The Codebook worksheet documents the code mappings.
  {% endstep %}
  {% endstepper %}

## 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.

{% hint style="warning" %}
**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.
{% endhint %}

## Summary Statistics

The Summary Statistics worksheet provides the same statistical analysis as the [Responses by Survey](/analyze/survey-response-exports/responses-by-survey.md) export, but scoped to the single selected question across all surveys that include it.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://support.pears.io/analyze/survey-response-exports/responses-by-question.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.