1. Overview
The respondent reconciliation download lists every respondent in the selected dataset alongside the respondent source they came from and the status they ended on. Its purpose is reconciliation: matching what MX8 Labs recorded against what your sample provider or panel partner believes they delivered, so you can agree completes, investigate rejected respondents, and settle invoices.
Unlike the Wide and SPSS exports, this file contains no answer data — only the identifiers and statuses needed to reconcile respondents.
2. Scope
The download is scoped to the dataset you have selected, so a live dataset produces a reconciliation of live respondents, and a synthetic dataset produces one for synthetic respondents. Within that dataset it includes every respondent, not just completes. Partial and rejected respondents appear too, which is what makes the file usable for reconciliation: a provider querying why a respondent was not billed as a complete can find that respondent and see the status MX8 Labs assigned.
3. File Structure & Layout
The file contains a single sheet, Respondents, with one row per respondent and three columns.
| Column | Description |
|---|---|
| Respondent Source | The name of the respondent source the respondent entered from, as configured on the survey (for example a panel partner, a first-party list, or a test set). |
| Respondent ID | The respondent's unique identifier, matching the ID used elsewhere in the platform and in raw data exports. |
| Respondent Status | The status the respondent ended on. |
Example
| Respondent Source | Respondent ID | Respondent Status |
|---|---|---|
| Quest - Nashville | 0403ce23-5ad8-43d5-8f75-cf4aafc1811b | Complete |
| Quest - Nashville | 08712029-d5bd-4a5d-8c1d-16c6f8241f94 | Terminated |
| Quest - Nashville | 0006cdb9-90f8-48ed-aea2-f27794442ec3 | Poor Quality |
4. Respondent Statuses
The statuses that appear in the file are the same ones used across the platform:
- Complete - Finished the survey and passed quality checks. These are the respondents you would normally expect to be billed for.
- Terminated - Screened out by a termination question or a failed quality gate.
- Quota Screenout - Qualified for the survey but the quota cell they matched was already full. See Setting up quotas.
- Poor Quality - Flagged and removed by the fraud and quality systems. See Fraud prevention measures.
- In Progress - Started but had not finished at the time the file was generated.
5. Reconciling with a Sample Provider
A typical reconciliation compares your provider's delivered-respondent list against this file on Respondent ID:
- Respondents marked Complete should match the completes your provider is claiming.
- Terminated and Quota Screenout rows explain respondents who entered but were screened out, and normally map to the exit links you configured for the provider. See Setting up any sample provider.
- Poor Quality rows are the ones most often disputed. Because the file records these explicitly, you can point to the specific respondent IDs that were rejected rather than reconciling on totals alone.
- Grouping by Respondent Source lets you reconcile each provider separately when a survey is fielded across several sources.
6. When to Use It
- Settling invoices or delivery disputes with a panel or sample provider.
- Investigating why the number of completes differs from the number of respondents a provider sent.
- Auditing how many respondents each source contributed, and how they resolved.