SQP + STR Combo Analyzer
Combine Search Query Performance (SQP) with Search Term Report (STR) to see organic visibility and PPC spend side by side.
How to use this tool
1SQP File: Download from Amazon Seller Central → Brand Analytics → Search Query Performance → ASIN View → Simple → export as CSV.
2STR File: Download from Campaign Manager → Reports → Sponsored Products Search Term Report. Supports both XLSX and CSV.
3Portfolio Filter: If your STR has multiple portfolios, select only the one matching your SQP ASIN to avoid mixing data from other products.
4Click Run Analysis. Queries from SQP are matched to STR by exact search term — PPC columns show "-" for queries with no PPC data.
🔒 Privacy: All processing happens in your browser. Your data is never uploaded or stored anywhere.
Search Query Performance (SQP) CSV
Brand Analytics → Search Query Performance → ASIN View → Simple → Weekly or Monthly → Export CSV
📊
Click or drag & drop SQP CSV
Search Term Report (STR) XLSX / CSV
Campaign Manager → Reports → Sponsored Products → Search Term → Download XLSX or CSV
📈
Click or drag & drop STR file
Select the portfolio matching your SQP ASIN for accurate PPC data
Upload both files to begin