Post-Promotion Incremental Margin and Baseline Reconciliation Checklist

Role: Director of Commercial Finance and E-Commerce Optimization with expertise in promotional post-audit analytics.

Context

• Campaign identifier: {{campaign_name}}
• Promoted product portfolio: {{promoted_product_line}}
• Total gross promotional revenue: {{gross_promotional_revenue}}
• Total allocated trade spend: {{trade_spend_investment}}
• Estimated post-promotional pull-forward dip: {{estimated_pull_forward_rate}}
• Calculated synthetic baseline sales: {{synthetic_baseline_sales}}

Task

Create an analytical post-promotional audit checklist to calculate true incremental revenue, reconcile trade spend efficiency, and isolate organic baseline sales for {{campaign_name}} on {{promoted_product_line}}.

Method

1. Establish the clean incremental gross revenue by subtracting {{synthetic_baseline_sales}} from {{gross_promotional_revenue}}.
2. Deduct the financial impact of post-event demand troughs caused by {{estimated_pull_forward_rate}} from the top-line gross lift.
3. Incorporate {{trade_spend_investment}} (including markdowns, slotting, and co-op ad spend) into total promotional cost accounting.
4. Calculate Incremental Return on Trade Spend (iROTS) to determine net cash generation per promotional dollar spent.
5. Audit customer acquisition mix to differentiate existing repeat purchasers from newly acquired incremental shoppers.
6. Reconcile return rates and cancelation anomalies observed specifically during the promotional surge window.
7. Compile a structured checklist for financial sign-off on campaign incrementality and future budget allocation.

Constraints

• MUST subtract synthetic baseline sales before claiming any promotional revenue lift.
• MUST treat pull-forward forward-buying as a direct cost offset against incremental margin.
• Do not include qualitative campaign sentiment or vanity traffic metrics.
• Ensure each audit item contains a clear verification rule or calculation checkpoint.

Output format

Provide a chronological audit checklist formatted into three functional tiers:

1. Baseline & Incrementality Accounting (4 audit items with formula checks)
2. Trade Spend & Cost Reconciliations (3 audit items verifying deductions)
3. Post-Event Demand & Retention Effects (3 audit items evaluating pull-forward and return rates) Total response length must not exceed 550 words.

Self-review

1. Did I clearly enforce the subtraction of baseline sales and pull-forward adjustments from the net lift?
2. Are all 6 variables directly referenced in the audit steps and checklist items?
3. Does the checklist provide commercial finance teams with definitive mathematical audit criteria?