The most successful spider-man game Activision released was Spider-Man 2 that sold 2 million units, it was tied with shrek 2. Web of Shadows and Shattered Dimensions were flops, thats why they ultimately lost the license
[UPDATE] Revenue jumps $52.6 million during the publisher's first fiscal quarter thanks to strong sales of Shrek 2 and Spider-Man 2.
www.gamespot.com
These were the first week numbers for Shattered Dimensions and Web of Shadows
Xbox 360 - 64 341
PS3 - 55, 668
Wii - 16, 221
DS - 7, 764
Total: 143,994
Xbox 360 - 51, 531
PS3 - 27, 624
Wii - 18, 251
DS - 9,199
Total: 106.605
Here are the reviews for them…
You can see the sales history here, the game was dropped to 30 dollars a month after it released
Price drop in official PlayStation Store store for Spider-Man™: Shattered Dimensions
psprices.com