Validate prospect shipping data, then compute brand savings and OpenBorder net revenue — fully annualized.
order_value column. Used to estimate annualized GMV.
| Column name | Required? | Description |
|---|---|---|
| destination_country | Required | Destination country code (e.g. US, GB, CA) |
| shipping_cost | Required | Carrier shipping charge per shipment (USD) |
| date | Required | Shipment or transaction date (used for period & annualization) |
| weight_lbs | ≥ 1 weight | Billable weight in pounds — include one or both weight columns |
| weight_grams | ≥ 1 weight | Billable weight in grams — auto-converted to lbs for rate lookup |
| service | Optional | Service level or carrier name |
| order_value | Optional | Order value / GMV per shipment (USD) — or use AOV override |
Column names are case-insensitive. Destination_Country and destination_country both work.