However if I only look at a single Spiegel list of 20 items, e.g. hardcovers there are only two items left in common.
I think you will agree that a book sales data analysis that has not made a successful effort to include one of the biggest book sellers in Germany for years can still safely be called garbage. It is baffling for me how much reputation the Spiegel lists still have.
Also, the hardcover Spiegel list has entries like the new book by Spiegel journalist Todenhöfer on rank 10 (rank 2129 on Amazon Germany right now).
[1] I ignored the Spiegel audiobooks list because this data is irrelevant without Audible.
DER SPIEGEL gets its book data from der Buchreport which uses sales info from a few hundred actual bookstores.
Thus the list is not 'garbage', but a represents what bookstores sell and what is currently trending. The list is also filtered by some criteria, which are listed on the SPIEGEL site.
The lists are at https://www.amazon.de/charts/2019-08-11/mostread/nonfiction?... https://www.spiegel.de/kultur/bestseller-buecher-belletristi...
It's all German, obviously. And note that Spiegel has at least two different lists, for hardcover and paperback (plus a few more, less relevant).
FWIW I'm surprised by the claim that Spiegel has too much "light-reading" in its bestsellers. The usual charge is that they exclude certain lowbrow titles/categories.