Identifiers
Campaign ID, ad group, creative ID, and conversion event ID must match tracking systems and ad platforms to allow deterministic reconciliation.
A consistent conversion file reduces reporting errors, speeds reconciliation, and creates a single source of truth for campaign performance. It supports accurate payout calculations, tax reporting, and downstream analytics while enabling defensible records that meet business, audit, and regulatory needs.
Clear ownership (who updates the file and when) and a published change log help avoid duplication and ensure data provenance.
Campaign ID, ad group, creative ID, and conversion event ID must match tracking systems and ad platforms to allow deterministic reconciliation.
Event date/time in MM/DD/YYYY HH:MM (UTC or specified timezone) plus ingestion timestamp to track processing latency and attribution windows.
Categorize events (lead, trial, purchase, subscription) with standardized lookup values to avoid free-text variations during aggregation.
Record gross and net conversion amounts with currency code; note discounts, refunds, or chargebacks as separate columns.
Include first-touch, last-touch, and algorithmic attribution fields or a pointer to the attribution model used for transparency.
Version number, preparer name, reviewer name, and a date-signed field (electronic signature supported) to ensure accountability.
| Field | Configuration |
|---|---|
| Campaign ID mapping | Map to ad platform API campaign_id field |
| Conversion timestamp | Parse as ISO 8601; convert to UTC |
| Monetary fields | Validate numeric format and currency code |
| Sign-off field | Enable required e-signature before export |
Confirm connectors, API rate limits, and field mappings during setup to avoid data loss; keep an operational runbook for troubleshooting.
Weekly raw exports, monthly reconciliations, quarterly audits
Close channel-level variance within 30 days of month end
Set payment cutoffs and dispute windows in partner agreements
1099-NEC recipient copies and IRS filing due Jan 31
Archive finalized file after sign-off each fiscal year
Tech Data standardized conversion exports to align sales and finance reporting.
Martin Properties moved lease conversion and tenant application records online.
| signNow | DocuSign | Adobe Sign | PandaDoc | HelloSign | |
|---|---|---|---|---|---|
| Starting Price | $8/user/mo | $15/user/mo | $14/user/mo | $19/user/mo | $15/user/mo |
| Free Trial | 7-day free trial, no credit card | Varies by vendor | Varies by vendor | Varies by vendor | Varies by vendor |
| Bulk Send | Yes (premium tiers) | Yes | Yes | Yes | No |
| Audit Trail | Yes | Yes | Yes | Yes | Yes |
| Envelope Cap | No envelope cap | 100 envelopes/user/year limit | Varies by plan | Varies by plan | Varies by plan |