Have you ever wondered if you could export the data from your report? You can export it to an Excel file or CSV. However, one thing to note is that you can't do that with Amazon Ads data. They only allow to visualise the data.
Excel export
Step 1: Go to one of your reports that you want to export data from, click on the "Actions" button at the top right corner, and then press "Export to Excel".
Step 2: Once you click on the button, you will see a pop-up window asking which pages you would like to export. Tick any pages you want, and click on "Export to Excel". The file will be exported and downloaded within a minute or two, depending on the length of your report.
CSV export
Step 1: Go to one of your reports that you want to export data from and click on the widget that you want to have the CSV file, then click on the three dots in the top right corner and choose "Export to CSV".
Please note that Amazon has API limitations that will not allow data export. Hence, the feature will not work on any widgets with Amazon Ads connected as a source.