Ad attribution reconciliation mistakes that distort order evidence
Last updated: 2026-07-31
Written and reviewed by Seller Profit Guard Editorial Team.
The most damaging attribution-reconciliation errors compare conversions with orders, allow one row into several defect buckets, mix platforms or windows, ignore timezone and report-date differences, treat refunds as retained, label legitimate repeat orders as duplicates, overwrite source conflicts, reconcile immature data, or call attribution proof of incremental sales.
Wrong denominator
Align platform attributed-order rows with the seller order event being reconciled. In the attribution defect register, record the count, unit, source version, rule version, evidence date, maturity state, reviewer, and declared uncertainty. Recompute from aggregate synthetic or authorized private evidence before formatting a count, rate, or decision.
Conversions, units, customers, and orders differ. Topic 1 documents a supported packet, broken packet, correction path, and why the conclusion belongs to a corrected attributed-order packet rather than a cross-platform or causal performance claim.
Overlapping categories
Use a documented precedence rule so one platform row appears once. In the attribution defect register, record the count, unit, source version, rule version, evidence date, maturity state, reviewer, and declared uncertainty. Recompute from aggregate synthetic or authorized private evidence before formatting a count, rate, or decision.
Double classification destroys the gap check. Topic 2 documents a supported packet, broken packet, correction path, and why the conclusion belongs to a corrected attributed-order packet rather than a cross-platform or causal performance claim.
Mixed windows
Freeze click, view, and reporting windows by platform and date. In the attribution defect register, record the count, unit, source version, rule version, evidence date, maturity state, reviewer, and declared uncertainty. Recompute from aggregate synthetic or authorized private evidence before formatting a count, rate, or decision.
Do not average incompatible rules. Topic 3 documents a supported packet, broken packet, correction path, and why the conclusion belongs to a corrected attributed-order packet rather than a cross-platform or causal performance claim.
Timezone drift
Normalize timestamps privately under one convention. In the attribution defect register, record the count, unit, source version, rule version, evidence date, maturity state, reviewer, and declared uncertainty. Recompute from aggregate synthetic or authorized private evidence before formatting a count, rate, or decision.
Public tools need counts, not timestamps. Topic 4 documents a supported packet, broken packet, correction path, and why the conclusion belongs to a corrected attributed-order packet rather than a cross-platform or causal performance claim.
Immature refunds
Close adverse outcomes before final retained classification. In the attribution defect register, record the count, unit, source version, rule version, evidence date, maturity state, reviewer, and declared uncertainty. Recompute from aggregate synthetic or authorized private evidence before formatting a count, rate, or decision.
Open orders are provisional. Topic 5 documents a supported packet, broken packet, correction path, and why the conclusion belongs to a corrected attributed-order packet rather than a cross-platform or causal performance claim.
False duplicates
Distinguish duplicated report rows from legitimate multiple orders. In the attribution defect register, record the count, unit, source version, rule version, evidence date, maturity state, reviewer, and declared uncertainty. Recompute from aggregate synthetic or authorized private evidence before formatting a count, rate, or decision.
One interaction can precede several real purchases. Topic 6 documents a supported packet, broken packet, correction path, and why the conclusion belongs to a corrected attributed-order packet rather than a cross-platform or causal performance claim.
Causal overclaim
Call the result attribution reconciliation only. In the attribution defect register, record the count, unit, source version, rule version, evidence date, maturity state, reviewer, and declared uncertainty. Recompute from aggregate synthetic or authorized private evidence before formatting a count, rate, or decision.
Incrementality needs experimental evidence. Topic 7 documents a supported packet, broken packet, correction path, and why the conclusion belongs to a corrected attributed-order packet rather than a cross-platform or causal performance claim.
Release and restoration: ad attribution reconciliation mistakes
Require typecheck, unit, integration, build, content, similarity, SEO, images, browser, mobile, privacy, and rollback evidence. Control 1 names the owner, review frequency, exception code, threshold, expiry trigger, correction condition, and prior restorable packet.
Restore on formula, routing, privacy, accessibility, or health regression. Apply it specifically to a corrected attributed-order packet; separate official platform rules, account settings, seller evidence, matching logic, and editable tolerance by authority.
Maturity and timing: ad attribution reconciliation mistakes
Close platform reporting and seller adverse-outcome windows. Control 2 names the owner, review frequency, exception code, threshold, expiry trigger, correction condition, and prior restorable packet.
Keep provisional rows explicit. Apply it specifically to a corrected attributed-order packet; separate official platform rules, account settings, seller evidence, matching logic, and editable tolerance by authority.
Sensitivity and counterexample: ad attribution reconciliation mistakes
Change one supported bucket while preserving the platform-row sum. Control 3 names the owner, review frequency, exception code, threshold, expiry trigger, correction condition, and prior restorable packet.
Retain failed and unfavorable fixtures. Apply it specifically to a corrected attributed-order packet; separate official platform rules, account settings, seller evidence, matching logic, and editable tolerance by authority.
Delayed measurement: ad attribution reconciliation mistakes
Record indexability, impressions, clicks, engagement, tool states, and qualified intent at Day 0/7/14/28. Control 4 names the owner, review frequency, exception code, threshold, expiry trigger, correction condition, and prior restorable packet.
Do not call temporal movement causal proof. Apply it specifically to a corrected attributed-order packet; separate official platform rules, account settings, seller evidence, matching logic, and editable tolerance by authority.
Privacy and access: ad attribution reconciliation mistakes
Use aggregate counts, synthetic fixtures, redacted pointers, access controls, and retention rules. Control 5 names the owner, review frequency, exception code, threshold, expiry trigger, correction condition, and prior restorable packet.
Exclude raw IDs, timestamps, exports, credentials, tokens, and OAuth. Apply it specifically to a corrected attributed-order packet; separate official platform rules, account settings, seller evidence, matching logic, and editable tolerance by authority.
Wrong denominator: reconciliation drill
Recreate “Wrong denominator” from a clean synthetic 100-row platform packet. Align platform attributed-order rows with the seller order event being reconciled. Change one mutually exclusive bucket, preserve the original packet, show the classification sum, and attach the expected Block, Review, or Ready state to the attribution defect register.
Conversions, units, customers, and orders differ. Drill 1 includes click-led, view-led, above-tolerance, nonzero-gap, immature, and corrected cases. Explain which row class moved, which denominator stayed fixed, and what evidence permits the next action.
Overlapping categories: reconciliation drill
Recreate “Overlapping categories” from a clean synthetic 100-row platform packet. Use a documented precedence rule so one platform row appears once. Change one mutually exclusive bucket, preserve the original packet, show the classification sum, and attach the expected Block, Review, or Ready state to the attribution defect register.
Double classification destroys the gap check. Drill 2 includes click-led, view-led, above-tolerance, nonzero-gap, immature, and corrected cases. Explain which row class moved, which denominator stayed fixed, and what evidence permits the next action.
Mixed windows: reconciliation drill
Recreate “Mixed windows” from a clean synthetic 100-row platform packet. Freeze click, view, and reporting windows by platform and date. Change one mutually exclusive bucket, preserve the original packet, show the classification sum, and attach the expected Block, Review, or Ready state to the attribution defect register.
Do not average incompatible rules. Drill 3 includes click-led, view-led, above-tolerance, nonzero-gap, immature, and corrected cases. Explain which row class moved, which denominator stayed fixed, and what evidence permits the next action.
Timezone drift: reconciliation drill
Recreate “Timezone drift” from a clean synthetic 100-row platform packet. Normalize timestamps privately under one convention. Change one mutually exclusive bucket, preserve the original packet, show the classification sum, and attach the expected Block, Review, or Ready state to the attribution defect register.
Public tools need counts, not timestamps. Drill 4 includes click-led, view-led, above-tolerance, nonzero-gap, immature, and corrected cases. Explain which row class moved, which denominator stayed fixed, and what evidence permits the next action.
Immature refunds: reconciliation drill
Recreate “Immature refunds” from a clean synthetic 100-row platform packet. Close adverse outcomes before final retained classification. Change one mutually exclusive bucket, preserve the original packet, show the classification sum, and attach the expected Block, Review, or Ready state to the attribution defect register.
Open orders are provisional. Drill 5 includes click-led, view-led, above-tolerance, nonzero-gap, immature, and corrected cases. Explain which row class moved, which denominator stayed fixed, and what evidence permits the next action.
False duplicates: reconciliation drill
Recreate “False duplicates” from a clean synthetic 100-row platform packet. Distinguish duplicated report rows from legitimate multiple orders. Change one mutually exclusive bucket, preserve the original packet, show the classification sum, and attach the expected Block, Review, or Ready state to the attribution defect register.
One interaction can precede several real purchases. Drill 6 includes click-led, view-led, above-tolerance, nonzero-gap, immature, and corrected cases. Explain which row class moved, which denominator stayed fixed, and what evidence permits the next action.
Causal overclaim: reconciliation drill
Recreate “Causal overclaim” from a clean synthetic 100-row platform packet. Call the result attribution reconciliation only. Change one mutually exclusive bucket, preserve the original packet, show the classification sum, and attach the expected Block, Review, or Ready state to the attribution defect register.
Incrementality needs experimental evidence. Drill 7 includes click-led, view-led, above-tolerance, nonzero-gap, immature, and corrected cases. Explain which row class moved, which denominator stayed fixed, and what evidence permits the next action.
What a corrected attributed-order packet can and cannot prove
It can prove that entered aggregate counts follow the declared platform rows, mutually exclusive classes, seller exception direction, tolerance, timing, and evidence version.
It cannot prove incremental sales, causal media impact, correct budget, customer identity, fraud, contract compliance, accounting profit, liquidity, tax treatment, or future performance.
Block, review, release, and restore attribution defect register
Block invalid counts, nonzero gaps, private exposure, missing scope, or declared conflicts. Review valid packets above tolerance or before maturity. Ready means structure is complete and exceptions fit the dated tolerance.
Release only a reversible public model with synthetic defaults, explicit sources, original diagrams, accessible labels, canonical, schema, links, strict 404, correction policy, and rollback evidence.
Sources and further reading
- Seller Profit Guard methodology: Evidence versions, reconciliation, privacy, correction, release, and rollback.
- Seller Profit Guard data privacy: Local-first boundaries for buyer, order, advertising, payment, refund, and raw-record data.
- TikTok Business Help: TikTok Shop Ads attribution: Reviewed July 31, 2026: official TikTok Shop Ads attribution policy context for Shop ID scope, 7-day click and 1-day view windows, click precedence, and report-date treatment.
- Shopify Help: Marketing reports: Reviewed July 31, 2026: official attribution models, channel credit, report scope, and conversion context.
- Etsy Help: How Etsy's Offsite Ads Work: Reviewed July 31, 2026: official 30-day click window and attributed-order context.
Related Seller Profit Guard tools
- Ad Attribution Reconciliation Checker: Classify aggregate platform-attributed rows and seller exceptions.
- Break-Even ROAS Calculator: Apply economics after attribution evidence reconciles.
- Paid CPA Limit Calculator: Keep cost capacity separate from attribution classification.
- Creator Sample Payback Calculator: Use mature reconciled orders for campaign recovery.
- Payment Reconciliation: Reconcile settlements separately.
- Methodology: Review evidence, privacy, correction, release, and rollback.
- Data Privacy: Protect buyer, order, advertising, payment, and credential data.
- Ad Attribution Reconciliation Formula and Inputs: Classify platform-attributed order rows into retained, excluded, ambiguous, and gap outcomes with aggregate seller evidence.
- Ad Attribution Click Reconciliation Example: Follow 100 synthetic platform rows through click matches, view matches, exclusions, ambiguity, tolerance, and decision state.
- Ad Attribution View Reconciliation: Reconcile view-through attributed orders with shorter windows, precedence, source conflicts, and stronger interpretation limits.
- Ad Attribution Reconciliation Data Sources: Map platform reports, order status, timestamps, source fields, windows, refunds, duplicates, and corrections to authorized evidence.
- Safe Ad Attribution Reconciliation Thresholds: Set classification-gap, ambiguity, retained-rate, excluded-rate, maturity, correction, stop, and restoration controls for attribution evidence.
- Click vs View Attribution Reconciliation: Compare click and view attribution at the same report grain while preserving window, precedence, maturity, and ambiguity differences.
- Weekly Ad Attribution Reconciliation Routine: Run a repeatable cycle from platform report closure through seller matching, classification, correction, release, and rollback.
- Interpret Ad Attribution Reconciliation: Read retained, excluded, ambiguous, gap, click/view mix, and seller exceptions without false precision or causal claims.
- Ad Attribution Reconciliation Audit Template: Use a standalone checklist and dated change log for report scope, rules, buckets, exceptions, correction, release, and rollback.
Next step: Open Seller Profit Guard.
This is operational planning help, not tax, accounting, legal, financial, or platform-policy advice. Review the Terms and disclaimer, and verify current platform rules and fee assumptions before changing prices.