Import Reports

Upload Amazon advertising and Seller Central CSV/XLSX reports. Files are matched by filename automatically.

Upload Settings
Click to choose files

or drag & drop CSV / XLSX reports here (up to 210 MB each)

How to Use — Getting & Naming Your Reports ▾
Step 1 — Select an account

Use the Account dropdown at the top of this page. If you haven't created one yet, go to Accounts → New Account.

Step 2 — Download reports from Amazon Ads Console

Go to Amazon Ads Console → Reports → Advertising Reports. Create or download the report types below. Amazon's default file names are used for automatic detection — do not rename the files.

Sponsored Products (SP)
SP Campaign
Sponsored_Products_Campaign_report_*.csv
Core spend/sales by campaign — the most important report. Download daily.
SP Placement
Sponsored_Products_Placement_report_*.csv
Top of Search vs Product Pages vs Rest of Search breakdown. Download weekly.
SP Advertised Product
Sponsored_Products_Advertised_product_*.csv
ASIN-level ad performance. Required for product recommendations.
SP Search Term
Sponsored_Products_Search_term_report_*.csv
All matched search queries. Required for negation candidates and branded split.
SP Targeting
Sponsored_Products_Targeting_report_*.csv
Keyword/target level performance (exact, phrase, broad, auto).
SP Budget
Sponsored_Products_Budget_report_*.csv
Budget utilisation and missed impressions. Download if budget-limited campaigns are suspected.
SP Purchased Product
Sponsored_Products_Purchased_product_*.csv
Which ASINs customers actually buy after clicking your ads (halo effect).
SP Audience
Sponsored_Products_Audience_report_*.csv
Audience targeting performance. Download if you use audience segments.
SP Impression Share
SP_Search_Term_Impression_Share_*.csv
How much of available impressions you are capturing per search term.
Sponsored Brands (SB)
SB Campaign
Sponsored_Brands_Campaign_report_*.csv
SB campaign-level spend, sales, NTB orders, and brand metrics.
SB Search Term
Sponsored_Brands_Search_term_report_*.csv
Queries that triggered SB ads. Use for keyword harvesting.
SB Keyword
Sponsored_Brands_Keyword_report_*.csv
Keyword-level performance for SB campaigns.
SB Placement
SB_Campaign_placement_report_*.csv
SB impression and spend split by placement type.
SB Attributed Purchases
SB_Attributed_Purchases_report_*.csv
Which ASINs were purchased after an SB ad click.
SB Category Benchmark
SB_Category_benchmark_report_*.csv
How your CTR and ACoS compare to category peers.
Sponsored Display (SD)
SD Campaign
Sponsored_Display_Campaign_report_*.csv
SD campaign-level spend, sales, view-through metrics.
SD Advertised Product
SD_Advertised_product_report_*.csv
ASIN-level SD performance including NTB and DPV.
SD Targeting
Sponsored_Display_Targeting_report_*.csv
Audience and product targeting breakdown for SD campaigns.
SD Purchased Product
SD_Purchased_product_report_*.csv
Halo sales — products purchased that were not the advertised ASIN.
Step 2b — (Optional) Upload a Bulk Operations File

The Bulk Operations file gives the dashboard a live snapshot of your campaign structure — states, bids, serving status, negative keywords, and product ad eligibility — without needing to run individual report downloads. It is a great complement to the time-series reports above.

How to get the file from Amazon Ads Console
Multi-sheet XLSX Workbook Recommended
Sponsored Products Campaigns.xlsx
Go to Amazon Ads → Bulk Operations → Download. Select all program types (SP, SB, SD) and download the workbook. Upload the .xlsx file as-is — it is auto-detected by its sheet names. Contains Campaign, Ad Group, Keyword, Target, Negative Keyword, Negative Target, and Product Ad rows for all programs in a single file.
Single-program CSV
Bulk_Operations_SP_*.csv
If you export a single-program CSV from Bulk Operations, rename it to include Bulk_Operations, SP_Bulk, SB_Bulk, or SD_Bulk so the importer can recognise it. Or use the manual type selector.
What gets imported
Campaigns
State, budget, bidding strategy, targeting type, serving status
Ad Groups
State, default bid, serving status
Keywords / Targets
State, current bid, match type (rows with Amazon ID only)
Negative Keywords
Level (campaign / ad group), match type, state
Negative Targets
Level, expression, state
Product Ads
State, SKU, ASIN, eligibility status
Re-uploading is safe. Each upload refreshes the current-state snapshot in place (ON DUPLICATE KEY UPDATE). Upload weekly to keep campaign state current. Bulk files do not carry date-series data — they snapshot what is live right now.
Step 3 — Download Business Reports from Seller Central

Go to Seller Central → Reports → Business Reports. These are needed for TACoS, sessions, buy box %, and organic sales. Save the files with the names shown below.

Seller Central Business Reports
Daily Sales & Traffic
Total_Sales_Daily_*.csv
Download from By Date → Sales and Traffic. Rename the file to include Total_Sales_Daily before uploading (e.g. Total_Sales_Daily_Jan-2025.csv). Provides sessions, page views, buy box %, CVR, and total revenue for TACoS calculation.
Sales & Traffic by ASIN
Total_Sales_By_ASIN_*.csv
Download from By ASIN → Sales and Traffic by ASIN. Rename to include Total_Sales_By_ASIN. Provides per-ASIN buy box %, sessions, organic sales, and refund rate.
Note: Seller Central report filenames vary — Amazon does not use a standard naming convention for Business Reports. You must include Total_Sales_Daily or Total_Sales_By_ASIN in the filename, or use the manual type selector after uploading.
Step 4 — Upload

Drag & drop or click the upload zone above. You can select multiple files at once — the system processes each independently. Accepted formats: CSV and XLSX.

If a file isn't recognised automatically, a manual type selector will appear in the file list — use it to pick the correct report type before submitting.

Re-uploading is safe. Every import uses ON DUPLICATE KEY UPDATE, so uploading the same file twice updates existing rows rather than creating duplicates. Uploading a wider date range replaces data for overlapping dates.

Step 5 — View the dashboard

Once reports are imported, go to the Dashboard and select your account. Use the date pickers or quick selectors (7D / 30D / 90D / MTD) to choose the audit window.

For the richest audit, upload at least 90 days of SP Campaign + SP Search Term + Seller Central Daily Sales data.

Troubleshooting
"Unknown report type" The filename doesn't contain a recognised pattern. Use the manual type selector, or rename the file to include the pattern shown in Step 2.
"File is empty or could not be parsed" Check that the report contains at least one data row (not just a header). Some Amazon reports return blank files for date ranges with no activity.
0 rows inserted, many updated Normal — you re-uploaded a file whose date range is already in the database. The data was refreshed in place.
Upload error code 1 File exceeds the 210 MB limit set in config.php. Split the date range into smaller batches and upload separately.
Seller Central data not showing Make sure the filename contains Total_Sales_Daily or Total_Sales_By_ASIN. Check the Recent Imports table to confirm the correct report type was detected.
Bulk XLSX not auto-detected The file must contain at least one of the sheets: Sponsored Products Campaigns, Sponsored Brands Campaigns, or Sponsored Display Campaigns. If it's a CSV, rename it to include Bulk_Operations or use the manual type selector.
Recent Imports for This Account
File Report Type Date Range Rows New Updated Skipped Status Imported
bulk-a1qojunazs8ut3-20260316-20260515-1778836660597.xlsx sp_bulk — 970,508 970,508 0 0 success May 15, 2026 2:34pm
bulk-a1qojunazs8ut3-20260316-20260515-1778836660597.xlsx sp_bulk — 12 12 0 0 success May 15, 2026 2:16pm
Sponsored_Products_Targeting_report.xlsx sp_targeting 2026-02-15 → 2026-05-14 279,466 105,607 0 0 success May 15, 2026 2:13pm
Sponsored_Products_Search_term_report.xlsx sp_search_term 2026-03-12 → 2026-05-15 15,218 0 0 0 success May 15, 2026 2:05pm
Sponsored_Products_Purchased_product_report.xlsx sp_purchased_product 2026-03-17 → 2026-05-14 351 0 0 0 success May 15, 2026 2:05pm
Sponsored_Products_Prompts_report.xlsx sp_prompts 2026-04-08 → 2026-05-12 18 0 0 0 success May 15, 2026 2:05pm
Sponsored_Products_Placement_report.xlsx sp_placement 2026-02-15 → 2026-05-15 13,430 0 0 0 success May 15, 2026 2:05pm
Sponsored_Products_Gross_and_Invalid_Traffic_report.xlsx sp_gross_invalid_traffic 2025-12-01 → 2026-05-15 7,208 0 0 0 success May 15, 2026 2:05pm
Sponsored_Products_Performance_Over_Time_report.xlsx sp_performance_over_time 2026-02-15 → 2026-05-15 90 0 0 0 success May 15, 2026 2:05pm
Sponsored_Products_Campaign_report.csv sp_campaign 2025-12-01 → 2026-05-15 7,184 0 0 0 success May 15, 2026 2:03pm
Sponsored_Products_Budget_report.csv sp_budget 2025-12-01 → 2026-05-15 7,184 0 0 0 success May 15, 2026 2:03pm
Sponsored_Products_Advertised_product_report.xlsx sp_advertised_product 2026-02-15 → 2026-05-15 66,125 0 0 0 success May 15, 2026 2:03pm
Sponsored_Products_Audience_report.xlsx sp_audience 2026-02-25 → 2026-05-14 223 0 0 0 success May 15, 2026 2:03pm
Sponsored_Brands_Search_term_report.xlsx sb_search_term 2026-03-12 → 2026-05-15 6,590 0 0 0 success May 15, 2026 2:01pm
Sponsored_Brands_Search_Term_Impression_Share_report.csv sb_impression_share 2026-03-12 → 2026-05-14 6,570 0 0 0 success May 15, 2026 2:00pm
Sponsored_Brands_Keyword_report.xlsx sb_keyword 2026-02-15 → 2026-05-15 7,413 0 0 0 success May 15, 2026 2:00pm
Sponsored_Brands_Campaign_report.xlsx sb_campaign 2026-02-15 → 2026-05-15 450 0 0 0 success May 15, 2026 2:00pm
Sponsored_Brands_Gross_and_Invalid_Traffic_report.xlsx sb_gross_invalid_traffic 2025-12-01 5 0 0 5 error May 15, 2026 2:00pm
Sponsored_Brands_Campaign_placement_report.xlsx sb_placement 2026-02-15 → 2026-05-15 1,155 0 0 0 success May 15, 2026 2:00pm
SP_Search_Term_Impression_Share_report.csv sp_impression_share 2026-03-12 → 2026-05-14 14,957 0 0 0 success May 15, 2026 2:00pm