I checked it out. I'd limited it to the past 90 days because the query was running very slowly. I just tested it and with the new indexes it's working much better, even with my frankly unbelievable number of clicks (from testing, etc). So, it will still display the past 90 days by default, but if you look in the text there is now a link that says "Show all" which will do exactly what it says
Hope that's what you had in mind...
Not EXACTLY what I had in mind but very good addition none the less. I am not quite sure how manual credit works but ...
What I was talking about was, here is an example:
Offer Name Click Date Status Credit Request
Experian Triple Advantage 2007-08-16 Not Credited Ineligible for manual credit.
Please wait 6 more days.
Lets say I had around 30 of those that just weren't getting credited. Where it says: Experian Triple Advantage (the offer name) .. instead of it being plain text, it could be a hyperlink directing the user to the actual offer so you don't have to go searching for it in the offers page if you wanted to try to get credit for it, if you didn't receive it for some reason (not filling it out all the way, ect).
I was putting this suggestion out there because I don't really know how manual crediting works and it would be a sort of reference to the ones that you have clicks so you could go back and eventually try the ones that never did get credited to your account. If this is irrelevant and should not be added I understand, it was merely a suggestion.
If I'm understanding you correctly, you want completed offers to automatically disappear from the site? If that's the case, I have good news -- we've been doing that since day one