Lore

Amazon Hourly Sponsored Ads Report Export

Amazon's native reporting feature (Measurement and Reporting > Sponsored Ads Reports) that can produce campaign-level performance data broken out by hour, not just by day.

Constraint

Each report is capped at 14 days of data.

Workaround

To assemble roughly a month of hourly history, run two separate reports (report type: Campaign, time unit: Hourly), each covering 14 days, and combine the two exports in a spreadsheet. This feeds directly into Manual Hourly Day-Parting Analysis (Pivot Table Method).