I found one feature of Google Checkout strangely lacking on the usability front. The payout and transaction download only allows you to specify a single day rather than a date range, so if you wanted a month of data you would have to run the report 30 times and aggregate the data in your own spreadsheet: no thanks Google!
Selecting start and end dates for a report, especially a financial one, is essential, so it was both frustrating and strange that this was not possible. Digging into the page code a little, I noticed something quite odd. Whoever developed this functionality at Google obviously agreed with me on the importance of a report taking start and end date as parameters, and even exposed the end date as a hidden variable called endDay in the form.
Tinkering with the page dynamically using firebug (the best firefox plugin ever) I was able to modify the form to:
- No longer set the end date on submit
- Take a given value for end date.
I have taken the liberty of reproducing that form on this page to fix the dud usability. That means that you can use firebug to edit the page and paste the form I have provided into it. Then fill in the numbers you want and submit the form.
The code is as follows:
<form action="https://checkout.google.com/sell/btReconReport" method="post"> <input id="startDate" name="startDay" type="text" value="2008-12-23" /> <input id="endDate" name="endDay" type="text" value="2008-12-30" /> <input name="daily" type="submit" value="Download" /> </form>
Paste it in so it looks like this:
With the new form right above the old one (or anywhere) like so:
I hope it saves others some time too, if you’re Google, please just provide this functionality, it’ll take your engineer about 2 minutes to unhide that variable!
NB: 10 points if you can tell me why it errors when I try to submit the form from my own html page (instead of editing theirs in firebug). Does Google do some sort of fancy server side referer check on form submission? Or am I missing something obvious with same-domain browser security…