A Groupon Real-time Revenue Tracker

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
Soldamount
Nowrap

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! 😉

Thanks Paul Hontz & Tom Critchlow!

Advertisements

2 Comments on “A Groupon Real-time Revenue Tracker”

  1. ColinKlinkert says:

    Hi Yannick,Awesome Mate 🙂 Great work, I ‘ordered’ that Sumo product yesterday and it is spending in my ‘to-dos’ box. Enjoyed the post, thanks for sharing 🙂

  2. Anonymous says:

    Glad you liked it Colin, it was quite fun to build. Let me know what you come up with.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s