To compare Amazon product advertising with what you see in ConnectBooks, you need to use a specific report in Amazon Ads and match it to the correct ConnectBooks columns.
Steps to Generate the Report
Go to the Amazon Advertising portal and create a new report.
Report category: Sponsored Products
Report type: Advertised product
Time unit: Daily
Select your date range
Then, generate the report.
In ConnectBooks
Add this column to your report using the column chooser:
Product Ads
This column in ConnectBooks should match the Spend shown at the bottom of the Amazon Advertised Product report, as long as the date range is the same.