Record where the file came from
Keep source_system, source_campaign, and source_export_date. A filename alone is not enough once several lists are combined.
Older campaign files may still be labelled Huobi while current operations use HTX. Check the email rows for HTX registration signals without erasing the original campaign name, source date, or member key.
Choose it when an older email roster needs to be reconciled with a current HTX-focused process.
Preserved as submitted
Named separately
Retained by the data owner
Workflow illustration. It is not a live task, performance claim, or promised response schema.
Renaming every historical column to HTX may look tidy, but it can make the source impossible to explain. Preserve the legacy wording and add new fields for the current check.
Keep source_system, source_campaign, and source_export_date. A filename alone is not enough once several lists are combined.
Copy the selected address into htx_check_email after reversible cleanup. Leave legacy_email untouched for comparison.
Store the HTX signal and checked_at value separately from any historical status that already exists in the roster.
This shape prevents a current lookup from being mistaken for information captured by the older campaign.
| campaign_member_id | source_label | htx_check_email | HTX signal | checked_for |
|---|---|---|---|---|
| HB-2022-014 | Huobi rewards 2022 | [email protected] | Matched | HTX reconciliation |
| HB-2022-027 | Huobi rewards 2022 | [email protected] | Unmatched | HTX reconciliation |
| HB-2022-033 | Huobi rewards 2022 | [email protected] | Review | HTX reconciliation |
The names and records are fictional. “Source label” documents the file; it does not claim a separate historical lookup was performed.
A legacy roster may be used for migration, support, or reward reconciliation. Each purpose needs a different decision rule, even though the HTX email signal is the same input.
Use the result to prioritize a follow-up queue only when the migration policy permits it. Keep historical and current fields distinct.
An old email may no longer reflect the member’s current details. Show the export date so support does not treat stale input as a current claim.
Do not retroactively invent a condition. Link the decision to the campaign version and the check date.
A review status should stay separate from a confirmed no-signal result, especially when the source cannot be recreated.
The displayed reference price is $7 per 10,000 checks. Before buying a full legacy-list run, remove rows outside the campaign scope and document why. Then confirm the current price and product response in the app.
Start the HTX Email ReconciliationThese pages help document file structure, data handling, and the broader HTX product choice.
See patterns for retaining original values, IDs, and returned fields.
Review sample fields →Check the site’s description of uploads, results, and customer responsibilities.
Read data handling →Compare HTX email and phone routes before mapping a legacy export.
Open HTX overview →Open ZelNum in your preferred AI assistant to review its bulk WhatsApp, Telegram, phone validation, carrier lookup, social account, crypto exchange, CSV upload, and API workflows.
The prompt points assistants to zelnum.com, live pricing, product pages, and API documentation.