How to Export CSV Data from Amazon Ads and Import It into clariBI

Amazon Advertising provides campaign management for Sponsored Products, Sponsored Brands, and Sponsored Display ads on the Amazon marketplace. Exporting your advertising data into clariBI enables you to analyze product performance, ACOS (Advertising Cost of Sales), and campaign ROI.

What You Can Export from Amazon Ads

• Sponsored Products campaign performance (impressions, clicks, spend, sales, ACOS)
• Sponsored Brands campaign data (impressions, clicks, spend, new-to-brand metrics)
• Sponsored Display performance (viewable impressions, clicks, DPVR)
• Keyword and search term level performance data
• Product targeting and ASIN performance
• Placement reports (top of search, rest of search, product pages)
• Campaign budget and bid data
• Daily and date-range performance trends

Export CSV Data from Amazon Ads

Method 1: Export from Campaign Manager

1. Log in to the Amazon Advertising console at advertising.amazon.com
2. Select the correct marketplace and advertiser account
3. Navigate to Campaign Manager from the left sidebar or main navigation
4. Choose the campaign type: Sponsored Products, Sponsored Brands, or Sponsored Display
5. Set your desired date range using the date range selector
6. Apply filters by campaign status, portfolio, or search by campaign name
7. Click the Export button (download icon at the top of the campaign table)
8. Select CSV as the export format
9. The file will download with campaign-level performance data

Method 2: Export from Reports Center

1. Navigate to Reports (or Measurement & Reporting > Reports) in the left sidebar
2. Click Create Report to generate a new report
3. Select the report category: Sponsored Products, Sponsored Brands, or Sponsored Display
4. Choose the specific report type:
   - Search term report: Shows which customer searches triggered your ads
   - Targeting report: Performance by keyword or product targeting
   - Placement report: Performance by ad placement location
   - Advertised product report: Performance by individual ASIN
   - Campaign report: High-level campaign performance summary
5. Set the date range (daily, summary, or custom range)
6. Click Create Report or Run Report
7. Once the report is generated (this may take a few minutes), click Download to get the CSV file

Method 3: Scheduled Reports

1. In the Reports section, select a report type and configure it
2. Toggle the Schedule option to set up recurring report generation
3. Choose frequency (daily, weekly, monthly)
4. Scheduled reports appear in your Reports list for download
5. Download the CSV from the scheduled reports list when available

Tips for Clean Exports

• The Search Term report is essential for understanding which customer searches drive your sales — this data is extremely valuable for keyword optimization analysis in clariBI
• Amazon reports can take a few minutes to generate — check back in the Reports section for your download link if it is not immediately available
• ACOS (Advertising Cost of Sales) is Amazon's key efficiency metric and is included in most exports — clariBI can help you track ACOS trends over time

Import Your Data into clariBI

1. Log in to your clariBI account at claribi.com
2. Click Data Sources in the left sidebar
3. Click the + Add Source button (top right)
4. Under Direct Upload, select CSV File
5. Enter a descriptive name (e.g., "Amazon Ads - Sponsored Products Performance Jan 2025")
6. Click the upload area or drag and drop your CSV file
7. Click Create Data Source

Once imported, you can ask clariBI questions like:
- "Which Sponsored Products campaigns have the lowest ACOS and highest sales volume?"
- "What search terms drive the most conversions for my top-selling products?"
- "How does my ad performance differ between top-of-search and product page placements?"

clariBI's AI will automatically analyze your data and suggest relevant insights.