Hourly-Weekly Campaigns

Amazon Campaign — Hourly & Weekday Pivot

Upload one or more Sponsored_Products_Campaign_report CSV exports from Amazon Ads. We'll pivot them into hourly and weekday breakdowns with Impressions, Clicks, Orders, Spend, Sales, CTR, CVR, and ACOS — plus charts and a downloadable Excel workbook. Files stay on your device.

Click to upload or drag & drop your CSV(s) here
Multiple files supported. Look for headers like Start Date, Start time, Impressions.

    How to Download the Campaign Report (Sponsored Products)

    1. Step 1: Log in to Amazon Seller Central.
    2. Step 2: Click the ☰ Hamburger Menu (top left corner).
    3. Step 3: Click Advertising, then click Campaign Manager. (This will redirect you to the Amazon Advertising console.)
    4. Step 4: In the left sidebar, click Measurement & Reporting, then select Sponsored Ads Reports.
    5. Step 5: Click the Create Report button.
    6. Step 6: Configure the report settings as follows:
      • Report category: Sponsored Products
      • Report type: Campaign
      • Country: Select your target marketplace (e.g., United States)
      • Time unit: Hourly
      • Report period: Last 14 days (default — see important note below)
    7. Step 7: Under Reporting settings, enter a name for your report (e.g., "Sponsored Products Campaign report").
    8. Step 8: Click Run Report (top right corner).
    ⚠️ Important Note on Date Range: The default report period only covers the last 14 days. If you need a full monthly report, you will need to run the report twice — once for the first half of the month and once for the second half — using the "Previous days" option to cover the full 30-day range.