Skip to main content

Scheduled-Report Export Columns — Old System → New System

We've upgraded the engine that generates your scheduled report CSV exports. This article explains exactly what changed at the column level so you can update any spreadsheet, script, or reporting tool that reads these files.

Written by Elias Nystrom

Renamed

Dropped

Added

Previous-period & change

Unchanged

4

9

34

25

152


1. Renamed — same column, new CSV header (4)

Old header

Old label

New header

New label

Notes

fba_inbound_quantity

FBA inbound Qty

fba_inbound_shipped_quantity

FBA Inventory

velocity

Velocity

velocity_7

Velocity 7d

⚑ Old date-range velocity now maps to the fixed 7-day velocity. The date-range figure is re-added as the new velocity column (see Added).

velocity_last_30

Velocity Last 30d

velocity_30

Velocity 30d

velocity_last_7

Velocity Last 7d

velocity_7

Velocity 7d


2. Dropped — no equivalent column in the new export (9)

Old header

Old label

Notes

b2b_quantity_discounts

Current B2B Buybox Price

⚑ B2B per-quantity tier discounts — tier_price_* and listed_quantity_lower_bound_* (* = 1–5) — are not written to the CSV.

fba_fee_10_to_50

FBA Fee Tiers

⚑ Covered by fba_fee_current

fba_fee_above_50

FBA Fee Tiers

⚑ Covered by fba_fee_current

fba_fee_below_10

FBA Fee Tiers

⚑ Covered by fba_fee_current

inventory_age

Inventory Age

⚑ Old group column; split into the inventory_age_* age buckets (* = 0_30, 31_60, 61_90, 91_180, 181_270, 271_365, 365_plus, plus 0_90) — each listed under Unchanged.

low_price_fba

Low Price FBA

⚑ Covered by fba_fee_current

pkg_volume

Pkg Volume

⚑ Covered by fba_volume

ref_fee_promo

Ref. Fee Promo.

small_and_light

Small and Light


3. Added — new columns in the new system (34)

None of these existed in the old reports. They're all optional — add any of them to a report to include it. Seven of these only appear alongside a specific existing column pick (see "Appears with"); the rest can be added on their own.

New header

UI label

What it is

Appears with

bb_eligible

BB Eligible

Whether the listing is currently Buy Box eligible (Yes/No).

bb_share_7d

BB Share 7d

7-day Buy Box share.

Buy Box columns

buybox_landed_price

BB Landed Price

Buy Box winner's landed price = item + shipping.

Buy Box columns

buybox_shipping_price

BB Shipping

Shipping portion of the Buy Box winner's price.

Buy Box columns

cust_attr_data

Custom Attributes Raw

Raw data behind all custom attributes (internal).

days_until_replenish

Days Until Replenish

Estimated number of days until the item needs reordering.

fba_fee_current

FBA Fees

Current Amazon FBA fulfilment fee — this is where the FBA fee moved to from Fulfillment Cost.

fba_inbound_quantity

FBA Inbound

Internal inbound-units field, separate from the fba_inbound_shipped_quantity column (see Renamed, §1).

fba_size_tier

FBA Size Tier

Amazon's FBA size-tier classification (e.g. standard vs. oversize).

fba_staging_quantity

FBA Reserved Staging

Units received into FBA but not yet sellable (in staging).

fba_volume

FBA Volume

The unit's FBA storage volume.

has_sfp_competitor

Has SFP Competitor

Yes/No — whether the listing has a Seller-Fulfilled-Prime (SFP) competitor (excluding your own offer). Opt-in, off by default.

inbound_inventory_value

Inbound Inventory Value

Cost value of inventory inbound to FBA.

is_hazmat

Hazmat

Whether the listing is classified as hazmat.

Product-detail columns

item_height

Item Height

The product unit's own height (separate from packaging dimensions).

item_length

Item Length

The product unit's own length (separate from packaging dimensions).

item_weight

Item Weight

The product unit's own weight (separate from packaging dimensions).

item_width

Item Width

The product unit's own width (separate from packaging dimensions).

lowest_fba_landed_price

Lowest FBA Price

Lowest competitor FBA landed price = item + shipping.

Competition columns

lowest_fba_listing_price

Lowest FBA Listing

Lowest competitor FBA item price (before shipping).

lowest_fba_shipping

Lowest FBA Shipping

Shipping portion of the lowest competitor FBA offer.

lowest_fbm_landed_price

Lowest FBM Price

Lowest competitor FBM landed price = item + shipping.

Competition columns

lowest_fbm_listing_price

Lowest FBM Listing

Lowest competitor FBM item price (before shipping).

lowest_fbm_shipping

Lowest FBM Shipping

Shipping portion of the lowest competitor FBM offer.

low_sfp_comp_price

Lowest SFP Price

Lowest Seller-Fulfilled-Prime competitor price.

Competition columns

profit_margin_after_returns

Profit Margin After Returns

Profit margin after returns are taken into account.

profit_margin_at_max

Margin at Max Price

Profit margin if the item sold at its maximum price.

profit_margin_at_min

Margin at Min Price

Profit margin if the item sold at its minimum price.

reduced_fees

Reduced Fees

The reduced (promotional) referral fee when Amazon runs a fee promotion.

revenue_after_ad_spend

Revenue After Ad Spend

Revenue left after advertising spend (overlaps with Profit After Ad Spend).

total_cogs

COGS

Total cost of goods sold over the report period.

total_comps

# Competitors

Total number of competitors (the old total_comps_fba/total_comps_fbm split still exists; this is the recombined count).

total_orders

Orders

Number of orders over the report period.

velocity

Velocity

Sales velocity over the report's own date range (shown alongside the fixed 7- and 30-day velocity).

Header-reuse note: fba_inbound_quantity and total_comps both reuse a CSV header name that also appears elsewhere in this document with different meaning — fba_inbound_quantity was renamed away in §1, and total_comps was the old aggregate that split into total_comps_fba/total_comps_fbm. If you map columns by name alone, treat these two as distinct from their old-system counterparts.


4. Added Previous-period & change — new _prev / _diff columns (25)

Report a metric's prior-period value (_prev) or its change vs. the prior period (_diff). These populate only when the report has "include previous period" turned on.

New header

UI label

What it is

adv_acos_prev

Prev Adv ACOS

Prior-period value of ACOS.

adv_attr_sales_prev

Prev Adv Attributed Sales

Prior-period value of Advertising Attributed Sales.

adv_clicks_prev

Prev Adv Clicks

Prior-period value of Ad Clicks.

adv_conv_rate_prev

Prev Adv Conversion Rate

Prior-period value of Conversion Rate.

adv_cost_per_click_prev

Prev Adv CPC

Prior-period value of Cost Per Click (CPC).

adv_ctr_prev

Prev Adv CTR

Prior-period value of Click-Through Rate (CTR).

adv_impressions_prev

Prev Adv Impressions

Prior-period value of Ad Impressions.

adv_roas_prev

Prev Adv ROAS

Prior-period value of ROAS.

adv_spend_prev

Prev Ad Spend

Prior-period value of Ad Spend.

avg_bb_share_prev

Avg Buy Box Share Prev.

Prior-period value of Avg Buy Box Share.

avg_sales_rank_prev

Avg Sales Rank Prev (Categories)

Prior-period value of Avg Sales Rank (by category).

avg_win_price_prev

Avg Win Price Prev.

Prior-period value of Avg Win Price.

b2b_profit_margin_diff

B2B Profit Margin Diff.

Change in B2B Profit Margin versus the prior period.

b2b_profit_margin_prev

B2B Profit Margin Prev.

Prior-period value of B2B Profit Margin.

b2b_roi_prev

B2B ROI Prev.

Prior-period value of B2B ROI.

cost_of_returns_prev

Cost of Returns Prev.

Prior-period value of Cost of Returns.

profit_after_returns_prev

Profit After Returns Prev.

Prior-period value of Profit After Returns.

return_items_prev

Return Items Prev.

Prior-period value of Returned Items.

return_rate_prev

Return Rate Prev.

Prior-period value of Return Rate.

revenue_after_returns_prev

Revenue After Returns Prev.

Prior-period value of Revenue After Returns.

short_term_storage_fees_prev

Short Term Storage Fees Prev.

Prior-period value of Short-Term Storage Fees.

total_ordered_items_diff

Ordered Items Diff.

Change in units ordered versus the prior period.

velocity_30_prev

Velocity 30d Prev.

Prior-period value of 30-day Velocity.

velocity_7_prev

Velocity 7d Prev.

Prior-period value of 7-day Velocity.

velocity_prev

Velocity Prev.

Prior-period value of the date-range Velocity.


5. Unchanged — same CSV header (and value) in both systems (152)

The CSV header and the value it carries are identical between systems. Many also pick up a slightly different in-app label — shown here where it changed. A in Notes flags something worth knowing beyond the label.

CSV header

Old label

New label (if changed)

Notes

acos

ACOS

⚑ Legacy duplicate of the standard adv_acos column; the old system exported adv_acos.

ad_clicks

Ad Clicks

⚑ Legacy ad_ duplicate of adv_clicks; the old system exported adv_clicks.

ad_impressions

Ad Impressions

⚑ Legacy ad_ duplicate of adv_impressions; the old system exported adv_impressions.

ad_spend

Ad Spend

⚑ Legacy ad_ duplicate of adv_spend; the old system exported adv_spend.

additional_cost

Additional Cost

adv_acos

ACOS

Adv ACOS

adv_attr_sales

Adv Attr Sales

adv_clicks

Clicks

Adv Clicks

adv_conv_rate

Conversion Rate

Adv Conversion Rate

adv_cost_per_click

CPC

Adv CPC

adv_ctr

CTR

Adv CTR

adv_impressions

Impressions

Adv Impressions

adv_roas

ROAS

Adv ROAS

adv_spend

Spend

Adv Spend

amazon_exists

Num of Comp.

Amazon Competing

asin

Title (product)

ASIN

avg_bb_share

Avg BB Share

Avg Buy Box Share

avg_sales_rank

Avg. Sales Rank

Avg Sales Rank (Categories)

avg_selling_price

Avg Selling Price

Avg Sale Price

avg_win_price

Avg Win Price

avg_win_price_24h

Avg Win Price 24h.

Avg Win Price 24h

b2b_buybox_price

Current B2B Buybox Price

B2B Buybox Price

b2b_buybox_share

Avg. Business Buybox Share

B2B Buybox Share

b2b_listed_price

B2B Listed Price

b2b_profit_margin

B2B Profit Margin

b2b_roi

B2B ROI

b2b_total_ordered_items

B2B Ordered Items

b2b_total_ordered_items_diff

B2B Ordered Items Diff.

b2b_total_ordered_items_prev

B2B Ordered Items Prev.

b2b_total_profit

B2B Total Profit

b2b_total_profit_diff

B2B Total Profit Diff.

b2b_total_profit_prev

B2B Total Profit Prev.

b2b_total_revenue

B2B Total Rev.

b2b_total_revenue_diff

B2B Total Rev. Diff.

b2b_total_revenue_prev

B2B Total Rev. Prev.

bb_fulfillment

Current Buybox Price

BB Fulfillment

bb_share_24h

BB Share 24h.

BB Share 24h

⚑ New bb_share_7d (BB Share 7d) now ships alongside this — see Added, §3.

brand

Brand

business_pricing

Business Pricing

B2B Pricing

consider_cpt

considerCPT

Consider CPT

conv_rate

Conversion Rate

⚑ Legacy duplicate of adv_conv_rate; the old system exported adv_conv_rate.

cost

Cost

cost_of_returns

Returns' Costs

Cost of Returns

cpc

CPC

⚑ Legacy duplicate of adv_cost_per_click; the old system exported adv_cost_per_click.

CPT_price

Comp. Price Threshold

CPT

ctr

CTR

⚑ Legacy duplicate of adv_ctr; the old system exported adv_ctr.

cur_bb_price

Current Buybox Price

⚑ New buybox_landed_price and buybox_shipping_price now ship alongside this — see Added, §3.

cur_sales_rank

Cur Sales Rank

Sales Rank (Categories)

cust_attr_1cust_attr_10

Custom Attribute 1–10

date_created

Date Created

days_cover

Days Cover

days_in_stock

Days In Stock

disable_auto_adjust_max

Max Price

Lock Max

disable_auto_adjust_min

Min Price

Lock Min

efn

EFN

est_date_ooo

Est. Out Of Stock Date

Estimated OOS Date

fba_available_quantity

FBA Available Qty

FBA Fulfillable

fba_researching_quantity

FBA Researching Qty

FBA Researching

fba_reserved_quantity

FBA Reserved Qty

FBA Reserved

fba_total_quantity

FBA Total Qty

FBA Total

fba_unsellable_quantity

FBA Unsellable Qty

FBA Unsellable

fba_warehouse_quantity

FBA Warehouse Qty

FBA Warehouse

fnsku

FNSKU

fulfillment

Fulfillment

⚑ Channel: FBA / FBM. The new UI can also surface SFP as a Fulfillment value; the is_fbm_prime boolean still ships separately.

fulfillment_cost

Fulfillment Cost

⚑ New value is the FBM shipping cost only; empty for FBA (the FBA fee moved to fba_fee_current / FBA Fees).

historical_days_of_supply

Historical Days Of Supply

Days of Supply

inv_value

Inv. value

Inventory Value

inventory_age_0_30

Inv. Age 0-30

Age 0-30 Days

inventory_age_0_90

Inv. Age 0-90

inventory_age_181_270

Inv. Age 181-270

Age 181-270 Days

inventory_age_271_365

Inv. Age 271-365

Age 271-365 Days

inventory_age_31_60

Inv. Age 31-60

Age 31-60 Days

inventory_age_365_plus

Inv. Age 365+

Age 365+ Days

inventory_age_61_90

Inv. Age 61-90

Age 61-90 Days

inventory_age_91_180

Inv. Age 91-180

Age 91-180 Days

is_fbm_prime

Fulfillment

SFP

last_purchase_date

Last Purchase Date (GMT)

Last Purchase Date

last_purchase_price

Last Purchase Price

lead_time

Lead Time (Days)

Lead Time

listed_price

Listed Price

listing_state

Title (product)

Listing State

low_inventory_fee_applied

Fulfillment Cost

Low Inv Fee Applied

low_inventory_fee_exempt

Low Inventory Fee Exempt

Low Inv Fee Exempt

manufacturer

Manufacturer

map

MAP

max_markup

Markup on Cost

Max Markup

max_markup_amount

Markup Amount

Max Markup Amount

max_price

Max Price

min_fee

Amazon Fees

Min Fee

min_markup

Markup on Cost

Min Markup

min_markup_amount

Markup Amount

Min Markup Amount

min_price

Min Price

mpn

MPN

note

Note

pkg_height

Pkg Height

pkg_length

Pkg Length

pkg_weight

Pkg Weight

pkg_width

Pkg Width

profit_after_ad_spend

Profit After Ad Spend

profit_after_returns

Profit After Returns

profit_margin

Profit Margin

Margin

profit_margin_after_ad_spend

Profit Margin After Ad Spend

promo_reduced_profit_range

Promo. Reduced Prof. Rng.

RPR Higher Bound

quantity

Fulfillable Quantity

reduced_referral_fee

Amazon Fees

Reduced Fee %

reduced_referral_fee_threshold

Amazon Fees

Reduced Fee Threshold

reduced_referral_fee_type

Amazon Fees

Reduced Fee Type

reference_price

Reference Price

MSRP

regular_referral_fee

Amazon Fees

Referral Fee %

reimbursed_cash

Reimbursed Cash

reimbursed_inv

Reimbursed Inv

replenish_by

Replenish By

reprice_config_preset

Repricing

Repricing Strategy

repricing

Repricing

Repricing Status

req_days_cover

Req Days Cover

Days to Cover

reserved_customerorders

Rsvd. Customer Orders

FBA Reserved Customer Orders

reserved_fc_processing

Rsvd. FC Processing

FBA Reserved Processing

reserved_fc_transfers

Rsvd. FC Transfers

FBA Reserved FC Transfer

return_items

Returned Items

Return Items

return_rate

Return Rate

Return Rates

revenue_after_returns

Rev. After Returns

Revenue After Returns

roas

ROAS

⚑ Legacy duplicate of adv_roas; the old system exported adv_roas.

roi

ROI

roi_after_ad_spend

ROI After Ad Spend

secondary_bb_fulfillment

Current Buybox Price

Secondary BB Fulfillment

secondary_bb_price

Current Buybox Price

Secondary BB Price

sell_through

Sell Through

ship_price

Ship Price

Shipping Price

short_term_storage_fees

Est. Short Term Storage Fee

Short Term Storage Fees

sku

Title (product)

SKU

store_name

Store Name

Store

sugg_qty_replenish

Sugg Qty Replenish

tags

Title (product)

Tags

title

Title (product)

Title

⚑ New is_hazmat (Hazmat) now ships alongside this — see Added, §3.

total_comps_fba

Num of Comp.

FBA Offers

⚑ New lowest_fba_landed_price (Lowest FBA Price) now ships alongside this — see Added, §3.

total_comps_fbm

Num of Comp.

FBM Offers

⚑ New low_sfp_comp_price and lowest_fbm_landed_price now ship alongside this — see Added, §3.

total_ordered_items

Ordered Items

Units Sold

total_profit

Total Profit

Profit

total_profit_diff

Total Profit Diff.

total_revenue

Total Rev.

Revenue

total_revenue_diff

Total Rev. Diff.

var_close_fee

Amazon Fees

Variable Closing Fee

vat_percent

VAT %

⚑ Value = whole-number percent (e.g. 20 for 20%), not a 0.20 decimal — matches the old system. The new system briefly shipped the /100 decimal; now corrected.


Quick notes to remember

  • velocity meant something different in the old system (date-range) than the new velocity_7/velocity_30 it renamed to. A new velocity column with the old date-range behavior is back under Added.

  • 8 legacy advertising duplicates carry over unchanged: acos, ad_clicks, ad_impressions, ad_spend, conv_rate, cpc, ctr, roas. Each is a _-less shorthand of a standard adv_* column from the old system — use the adv_* versions going forward.

  • fulfillment_cost now carries FBM shipping cost only — it's empty for FBA listings. Use fba_fee_current (FBA Fees) for the FBA side.

  • fba_inbound_quantity and total_comps each get reused as a new column name with different meaning from their old-system role (§1 and the FBA/FBM split, respectively) — don't assume same name means same data across systems for these two.

Did this answer your question?