Importing Business Reports

The per-ASIN Business Report import is how RankASIN populates its KPI charts and trend deltas. Each CSV you upload represents one time period at one cadence (daily, weekly, or monthly). RankASIN stores the rows as asin_performance_snapshots, tagged with the upload's import_id, and derives trend deltas from the two most recent periods of the same cadence.

Prerequisites

You need Business Report access in Seller Central. The relevant reports are under Reports → Business Reports:

• Detail Page Sales and Traffic — parent-level summary, one row per ASIN
• Detail Page Sales and Traffic By Child Item — child-level data for multi-variant ASINs, one row per child ASIN

Download the CSV for the time range you want to import. Weekly and monthly cadences build the most useful trend history; daily imports are useful for short-run experiments (post-launch, post-listing-change).

Import steps

1. Download from Seller Central. Go to Reports → Business Reports and select either "Detail Page Sales and Traffic" or "Detail Page Sales and Traffic By Child Item". Set your date range and download the CSV.

2. Open the import panel in RankASIN. Navigate to Performance and expand "Import and manage per-ASIN Business Reports".

3. Drag or select the CSV file. RankASIN's parser handles both report formats automatically — it detects the format from the column headers. You do not need to specify which format you're uploading.

4. Review the preview. The preview shows the parsed rows, their detected cadence, and the period start/end dates. Confirm the period matches what you intended before proceeding.

5. Confirm the import. Each upload creates one asin_performance_imports row (the import record) plus individual snapshot rows tagged with that import's ID. If you re-upload the same combination of seller account, cadence, period start, and period end, RankASIN upserts the snapshots with the new import ID and deletes the old import record — no orphaned rows.

What auto-fills

Missing ASINs are created automatically during import. When the parser encounters an ASIN not yet in your catalog, it creates the ASIN record and populates:

• asin_code — the child ASIN from the CSV
• parent_asin_code — defaults to the child ASIN for single-variant products
• sku — from the CSV if present
• title — from the CSV's product title column

Back-filling only happens when those fields are null. If you've already edited an ASIN's title or SKU in the RankASIN UI, those values are preserved — the importer never overwrites non-null fields.

Deleting an import

To remove a specific import, go to Performance → History → ASIN Imports and delete the import record. Deleting an import cascades: all snapshot rows tagged with that import's ID are deleted automatically. The ASIN records themselves are preserved unless they have no remaining baselines and no data in any other table.