account api app bucks complex content cool corresponding cost costs course data day difference down email fairly google including iphone junkie listing log month note open parse parsing plus price product project putting query range sales save selected show showing sites spent stats times together track transaction update useful week

So I'm not a coder, but it's something I'm thinking of putting together a proposal for and listing on rentacoder. If there was more than one person interested, it would keep the costs down.

Basically, I'd like to take the notification emails from e-junkie, parse out the content, and note the name of the product and sales price in a datebase in realtime. Hourly, I would like to query my adwords account using the adwords API to update how much I've spent on PPC for the day, including the other PPC sites I track in my adwords account.

For the iphone app, I'm envisioning a little line graph showing sales v advertising costs that can be manipulated to show data for the month/week/same day (the new google graph API might be useful for this). Underneath the graph, would show the corresponding profit (or loss) for the selected data range. All of this would be self-hosted of course.

Parsing the e-junkie data out of the email won't be difficult. However the adwords API looks fairly complex (http://www.google.com/apis/adwords/). I don't think it would cost more than a couple of hundred bucks to get it going. If anyone is interested in pitching in and collaborating on this little project, let me know. I'm just a stats junkie, and a little app like this would save me from having to open my adwords and e-junkie transaction log several times a day and subtracting the difference, plus it would be pretty cool.