A Groupon Real-time Revenue TrackerPosted: June 24, 2011 | |
Today I built an nice little tool that allows you to track Groupon‘s gross revenue by city, in real time. Wow, right?! As incredible as this may sounds, it took me less than 30 minutes and I used Google Docs. Yes, a Google Docs spreadsheet to be precise. Ok, arguably it only tracks five London areas, but hey..I’ve never coded before in my life (although I have quite an extensive experience with spreadsheets)!
You might see a couple of weird looking formulas in there, like =importxml[ etc. but don’t get scared, even my grandma could do it! How? Get on AppSumo, a daily deal site for startuppers (and the only daily deal site I am still subscribed to!) that is currently featuring a free deal about the secrets behind Google Docs: Google Docs Unleashed, check it out, it’s free!
The short story is, Google spreadsheet can automatically pull information from other sites by importing xml feeds. This can be pretty useful to track competitors pricing for example, or in this case to track Groupon daily revenues.
Here is the link if the embedding is not working: https://docs.google.com/spreadsheet/ccc?key=0AtYrRRRXtRQfdDlsOGJmYXFkYTN0M3VJMWFDNTJENUE#gid=0
So how does it work?
A: Groupons sold =importxml($B$9&B2,”//div[@class=’soldAmount’]”)
B: Price per groupon =importxml($B$9&B2,”//span[@class=’noWrap’]”)
- $B$9 is the fixed part of the URL (i.e. http://www.groupon.co.uk/deals/) and
- B2 is the variable part (i.e. north-london). the “&” simply combines the fixed and the variable parts.
- ‘soldAmount’ is effectively what identifies the number of groupons sold in the HTML of the page
- ‘noWrap’ is what identifies the price of the groupon in the HTML of the page
C: Gross revenue = A x B
It would have been interesting to track every single city in the UK, but the issue with Google docs is that it only lets you use up to 50 import functions, so I limited it to London. With more time, one could build separate spreadhsheets and literally track global Groupon revenues in real-time! I bet this could be a pretty useful tool for traders when Groupon will be a listed company: one could effectively know Groupon’s gross revenue before they release their quarterly results! 😉