# Event email import result reconciliation ledger

English worksheet for one event edition and one import batch. Record counts and secure internal references here; keep contact names and email addresses in the approved source system.

## Source snapshot

| Field | Entry |
|---|---|
| Event edition / internal ID | |
| Exact source-file version and export time | |
| What one source row represents | |
| Total source rows | |
| Distinct email addresses in source | |
| Import platform, audience and batch time | |
| Import owner / campaign reviewer | |
| Where the detailed import result is stored | |

## Result and next action

Copy the provider's category labels exactly. The buckets below are a planning aid, not an equation that every platform report must satisfy.

| Internal bucket | Provider label / result reference | Count | Decision / owner |
|---|---|---:|---|
| New contacts added | | | |
| Existing contacts updated | | | |
| Existing contacts unchanged or skipped | | | Inspect status; do not reimport in bulk |
| Unsubscribed, cleaned or other protected state | | | Preserve state; refer to list-source review |
| Syntax or format error with verified correction | | | Prepare correction-only file |
| Invalid, role-based or unresolved address | | | Hold; source owner decides next step |
| Duplicate source rows | | | Reconcile to distinct addresses |
| Outside this event edition | | | Exclude from this campaign |

**Count explanation:** Source rows ______; distinct addresses ______; provider result total(s) ______; unresolved difference ______; owner ______.

## Correction-only retry

| Check | Result / evidence |
|---|---|
| Address correction confirmed by source record or person, not guessed | |
| Delimiter, format and column mapping match this provider's current instructions | |
| Only approved repair rows included | |
| Existing-profile update setting checked | |
| Marketing status and event edition marker preserved | |
| New import result read and affected records sampled in approved system | |
| Protected or uncertain statuses left unresolved, not forced through | |

## Campaign handoff

- Final intended segment and exclusions: ______
- Actual recipient count in sending tool: ______
- Difference and owner: ______
- Unresolved attendee service-message route, if needed: ______
- Campaign reviewer and decision date: ______

This ledger does not approve a marketing send. Review list provenance and the actual message separately. Do not change unsubscribe or bounce-related states merely to make import counts match.

Primary platform references: [Mailchimp import troubleshooting](https://mailchimp.com/help/troubleshooting-contact-imports/), [Mailchimp import results](https://mailchimp.com/help/view-import-results/), [Mailchimp contact statuses](https://mailchimp.com/help/about-your-contacts/), and [Mailchimp import options](https://mailchimp.com/help/import-contacts-mailchimp/). Provider labels and behavior differ.