Thursday, 30 May 2013

Groupon Now and the Rise of the Real-Time Deal

What are you feeling now? Are you hungry? Are you bored? With the answers to those questions, you've probably covered 50 percent of the basic emotions experienced daily by Americans. Add in "feeling frisky" and "hopeful the Cubs will take it all this year" and maybe you're up to 95 percent. (OK, the Cubs are a disorder localized to Chicago.)

But deal-a-day powerhouse Groupon thinks it can help its users and the merchants who want to reach them by asking customers what they want right here and right now. Currently the company is testing a feature addition to its standard smartphone app called Groupon Now. When users (so far, just Chicago-based users) open the app, they confront two statements: "I'm hungry" and "I'm bored." If they click on either, they are taken to a map of Groupon restaurant or entertainment/attraction deals that are available right then--but only for a short window. Users will buy the deals via their smartphones, then go to the merchant's site to redeem them that day.

The setup is different from the deal discovery and redemption process that has helped Groupon grow into a dominant force with 6,000 employees and a looming IPO with a $25 billion valuation. Up to now, Groupon buyers have found their deals mostly via daily e-mails or by visiting the website, and the coupons they buy can be redeemed months after purchase.

But the deep-discount space is becoming crowded with hundreds of other players, all trying to reach consumers who could be motivated by a hefty rebate to switch merchants for things they usually buy, or to spend on a special-occasion purchase in the face of a good price. You may only go sky diving once in your life, but for 50 to 60 percent off, you just may decide that time is now, and the place is your local airport.
Groupon stats
The company has worked with close to 50,000 businesses in north america, most of which are small businesses

10 percent of deals are redeemed within the first 10 days of purchase

More than 70 million subscribers worldwide

Groupons are sold in more than 170 markets in north america

More than 400 deals per day are run in north america

40 million Groupons have been sold in north america

Groupon has saved buyers in north america more than $1.9 billion


A recent study by BIA/Kelsey predicts that U.S. spending on daily deals will grow from $873 million in 2010 to $3.9 billion in 2015. If companies like Groupon and LivingSocial continue to roll their local deals out to more metro areas, Kelsey forecasts that annual U.S. spend on daily deals could reach as high as $6.1 billion in 2015.

For Groupon and LivingSocial, continued expansion means more than just adding cities--it also means increasing ad inventory. The one-deal, one-metro setup means only one merchant can get the spotlight every 24 hours, and that has created a bottleneck of potential advertisers. Hence the efforts to grow into a new but related type of dealing: showing users a roster of merchant offers when they're out on the street, mobile phone in hand.

Washington, D.C.-based LivingSocial technically beat Groupon into this space with a slew of instant-deal offers for $1 lunches in its hometown on April 15. Those who opened the LivingSocial smartphone app to Instant Deals on that day found cheap eats from 100 participating merchants operating within a half mile of their location--deals redeemable via phone screen and good only from 11 a.m. to 2 p.m. that day.

These tests of real-time sales and redemption (because they are still tests) offer a way for Groupon and LivingSocial to rise above the slew of daily-deal clones and coupon-scraping aggregators and to build deeper engagement with their users. It also lets them compete more effectively with anything thrown their way by Google and Facebook--brands that already see strong mobile use and are piloting daily-deal platforms of their own.

For merchants, this real-time dealing opens up a lot of new opportunities, as long as they go in with their eyes open to the potential problems. No longer do restaurants or salons have to position daily-deal coupons and then worry that they'll get redeemed months later during a busy period or after a cost hike, further eating into margins. Instead, they can use these short-term bargain rates to drive traffic during traditionally slow periods, making good use of inventory--whether perishable food, empty room nights or unused stylist chairs--that would simply go to waste anyway.

Calibrating the magnitude and length of a standard daily offer has always been a challenge for merchants using these platforms. Capping the coupon maximum too high can swamp a business in low-revenue sales, while letting the deal last too long muddies the metrics of evaluating its success. (Has a deal worked if 10 percent redeem it in the first week and 60 percent redeem it in the fourth?) Both Groupon and LivingSocial work with merchants to control these factors and manage their expectations, but a badly planned daily deal can still result in long waits, overwhelmed staff and poor service.

By shortening the redemption window, these mobile deals should make real-time couponing a more feasible prospect with less downside for small to midsize businesses. Of course, if even a three-hour deal is good enough, businesses still have to make sure they're ready for the customer stream. Many of the restaurants taking part in the $1 lunch LivingSocial promotion saw lines out the block, and LivingSocial wound up refunding some of those buyers' dollars. That's why these are still tests. But they're certainly tests worth watching.


Source: http://www.entrepreneur.com/article/219814

Tuesday, 28 May 2013

Database Developer, Groupon Global Travel

Groupon is working on lots of cool technology (beyond group buying) to make life easier and more affordable for people who love to travel.

Do you love to travel?  Do online travel agencies frustrate you with how they make is so difficult to search for and book vacations at the best price? The Groupon Global Travel team (Getaways) is reshaping the way consumers think about buying online travel.  Launched in July 2011, Groupon Global Travel is the suitcase-toting team dedicated to Groupon’s travel vertical.

We’re not your typical online travel platform. We are working to create packages that delight both suppliers and Groupon subscriber alike.  For lodging, we focus on independent and boutique properties as well as chains and B&Bs and listen to their needs to craft a deal that is going to get them the customers that they want, when they want them. There is a lot more to come. Out with the old ways of features that serve as price comparisons. We’re in the business of featuring travel for everything it is – opportunities for our customers to relax, enjoy themselves, share special moments and be delighted.

As part of this effort we have several projects underway and more coming to significantly improve and enhance our travel related offering.

How would you like to put your love of travel, data, insights, scale, and Groupon to use all at once!?  We’re looking to grow our travel development team to help wire our data sources to Hadoop, to Teradata and to Microstrategy and build out the basic data structures for a travel platform.

We’d love it if you were a contributor to the Hadoop family of open source; we’d love it if you have experience with Vertica and/or with Microstrategy… but most importantly, we want you to salivate at the mention of ‘big data’ and we want you to jump up and down with excitement at the thought of being a part of the initial team to design and build the data systems behind our travel platform!

A sampling of experiences on the wish-list are:

    Lots of years experience with working with a modern BI stack, web logs, Hadoop
    Experience dealing with scale… a lot of data, a lot of users
    You’ve gotta be flexible!  You want to be flexible!  You love being flexible!  We’ve got so many problems to solve!
    And of course, you have to want to be a part of Groupon! 


Some more technical requirements and nice-to-haves:



    5+ years of *nix experience
    5+ years of various database experience… MS SQL/Oracle/MySQL/Hadoop/etc …
    5+ years of experience with C/C++/Java/Python/.Net
    5+ years scripting experience with Perl, for example
    Standard data warehousing approaches would be nice to know… star schema anyone?



Source: https://jobs.groupon.com/careers/engineering/database-developer-groupon-global-travel-seattle-wa-united-states/

Friday, 24 May 2013

Aggregate Daily Deals From Livingsocial, Groupon, or Any Website

Contractor list from Angies list or any other website.

Customers looking to extract data from daily deals website(Groupon, LivingSocial, Mamapedia, Woot, Zozi, Tippr, BloomSpot, KGB Deals, Scoutmob, Eversave, HomeRun, Gilt City, BuyWithMe, CrowdSavings, Kgbdeals, Tippr, DealFind, Half Off Depot) can avail the services of various data extraction service provider. Customers looking to extract and collect information about the daily deals and transactions taking place in any location or country can use the services of this company. Users can extract data from daily deals website in no time and the output thus generated can be saved in various database forms such as MS Excel, MySQL, MS Access, HTMS, CSV etc. Truly the task of data extraction has become quite simple with the iWeb Scraping Services.
    livingsocial and groupon daily deals aggregator tools

The entire data scraping process is very fast as compared to the manual process and is preferred by most of the users who wish to aggregate daily deals data from multiple deal websites.
We Scrape the Following Data from the Deal Website:

    Offer Title
    Deal Images
    Offer Start Date & End Date
    Number of Deal Sold
    Discount code / Coupon code
    Number of Deal Remaining
    Price
    City or Contact Details
    Merchant Name
    Deal Link
    And Many More.....

Save Data in The Screen Output Format

Business executives feel the need to scrape data from daily deal website because the website contains huge amount of data that is very useful for business purposes. The data may include information related to the daily transactions that take place online on the web. One can scrape data from daily deals website and store and save that data in the screen output format that may represent the entire data in an organized manner.
Most Popular Deal Websites

Groupon, LivingSocial, Mamapedia, Woot, Zozi, Tippr, BloomSpot, KGB Deals, Scoutmob, Eversave, HomeRun, Gilt City, BuyWithMe, CrowdSavings, Kgbdeals, Tippr, DealFind, Half Off Depot, etc.
Does Not Require Any Advanced Technical Skills

The process of data extract from daily deals website is fast, accurate and reliable and does not require any advanced technical skills. You can can use various data extraction tools and services which can facilitate the process of data extraction. Many users prefer to go for automated process which is far better than the manual process of data extraction. The simple process, excellent customer service and accurate output has promoted the business users to avail the data mining services.

Source: http://www.iwebscraping.com/aggregate-livingsocial-groupon-daily-deals.php

Friday, 17 May 2013

Groupon subsidiary Sosasta’s entire user database indexed by Google

Hackers have been on a rampage lately targeting commercial and government websites. Those attacks sometimes end with confidential information being leaked out to the Internet. Unfortunately, there are other times when a company leaks the information out themselves and doesn’t realize it. Such is the case of Sosasta.com, which is a subsidiary of Groupon that it acquired in January 2011.

While it is still unclear how the incident happened, the result was that a database of 300,000 users got published on the Internet and indexed by Google. The information leaked included email addresses and clear-text passwords which were discovered by Australian security consultant Daniel Grzelak who operates a website called

His website allows users to search a database to discover if their email address and password has been compromised. The information on the website even includes all LulzSec releases as well as data from 17 recent high-profile breaches. It was in his research of more compromised accounts that Grzelak came across Somsasta’s database.

Grzelak contacted the website Risky.Biz about the compromised information who in turn contacted the CEO of Groupon, Andrew Mason, to notify him of the issue. After receiving the notification, Groupon had the database immediately removed from Google and has begun an internal investigation into how the database was published to begin with.

In a statement released by Groupon, the company was quick to point out that Sosasta.com is not connected with any other Groupon sites and that the website’s platform runs on its own servers thereby eliminating any concern that other Groupon users may have been affected by the breach. Sosasta users have been contacted about the security issue and have been instructed to change their passwords as soon as possible.

Grzelak states that Sosasta’s mistake is actually a pretty common one and that there are thousands of similar databases indexed by Google. Unfortunately for Sosasta, their database was the biggest he has found to date.


Source: http://www.geek.com/news/groupon-subsidiary-sosastas-entire-user-database-indexed-by-google-1397287/

Monday, 6 May 2013

Groupon and LivingSocial Scraping

Among the most famous sites for the updates regarding bulk offerings are the Groupon and LivingSocial that let the people know with the aggregated deal of the day promotions by all companies. This kind of websites help retailer in making their higher levels of the sales along with the accumulation of the coupons in large quantity. Companies are found to be interested in the scraping of these Groupon and LivingSocial sites for the analysis of the data that they have. In this way these companies compare their performance and strengths with the threats and opportunities in the market so as to make some strategic policies.

Scraperservices can produce the best quality results for the scraping of such sites in order to make the customers and clients satisfied. It makes the long term relationship with its stakeholders in order to provide them with the continuous update of the market. People can choose from different combinations of the packages that can be selected on the basis of budget that these people have and the time span that they can wait for results tom come.

So, our esteemed customers are suggested not to waste their precious time by going anywhere else for the services of such sites scraping. They can come straight to us if they really want to have the reliable results and analysis techniques rather than just bogus information that have no value. If you still have any query in your mind, please feel free to write to us at info@scraperservices.com.

Source: http://scraperservices.com/groupon-and-livingsocial-scraping/

Thursday, 2 May 2013

Groupon is getting killed in the Middle East

The Middle East is probably the most underrated growth market on the planet right now: Over 350M people with 70% under the age of 30. Groupon recently established an operation in the region but according to data for the last month they’re being crushed by Cobone.com, the local competitor. Can Groupon execute outside of their core territories?

The graphs below are based on data scraped from the Groupon and Cobone sites (UAE, Lebanon, Jordan, Saudi Arabia and Egypt) between May 14th-June 14th.

At first glance, Cobone is really hammering Groupon just in terms of coupons sold by about two to one.

But taking a closer look at the deals themselves and you see where Cobone is really killing them. Over the same period, Cobone turned over almost three times Groupon’s revenue. Clearly Groupon are having trouble getting to the higher quality merchants in the region.

What’s particularly interesting is how the two companies are leveraging social media in the region. Although the overall user numbers for Facebook and Twitter in the Middle East are still low (but growing rapidly), clearly Cobone understands a) how to engage them and b) how to monetize them. Groupon, on the other hand, appear to be either ignoring social completely (which seems odd) or simply don’t have a handle on it in that particular market.

Source: http://dylancollins.com/?p=316

Note:

Alyce Medina is experienced web scraping consultant and writes articles on email scraping services, email data scraping, scraping email addresses, data scraping services, website scraping, eBay product scraping, Forms Data Entry etc.

Wednesday, 1 May 2013

Groupon Math: Data Scraping to Estimate Revenue

There’s been a lot of talk recently about the Chicago startup Groupon. Groupon brands itself as a group-buying site, but it’s really more of a localized version of what woot.com does. They post a new deal (which they call a Groupon) every day, available only on that day. If enough people want to buy it, everyone gets it for a substantial discount. Otherwise, nobody gets anything, but this rarely happens from what I can tell.

Groupon Screenshot

According to TechCrunch, the company is in the process of raising money at a $1.2 billion dollar valuation. There was lots of speculation about the future worth of the company, but little information about current revenue, even though there is a lot of raw data readily available in the site’s archives. I put together a scraper (in just a few lines of Python, thanks to BeautifulSoup) and gathered a total of 1065 past Groupons.

It isn’t clear how Groupon decides which Groupons to display in its archives. Presumably they are the better selling ones, so my sample is not a random sample, which would affect the numbers. Everything that follows should be taken with a grain of salt, but they should be reasonable as ballpark figures.

According to the data I collected, the average Groupon costs $30 and entitles the buyer to 57% off. On average 1155 people purchase it, resulting in $28,130 of revenue to Groupon ($28,130 is less than 1155 * $30 = $34,650 because, apparently, people are more willing to buy the cheaper Groupons.)

Averages are nice, but what I really wanted was totals. I was able to approximate what fraction of the data I had because Groupon advertises the “Total dollars saved” and “Total Groupons bought” on every page. By dividing my numbers by those, I determined that I had a little over a third of the data. Specifically, my data covered 31.2% of Groupons sold, and 37.4% of total savings.

Extrapolating the data I had (again, with the disclaimer that my sample may not be random), I calculated the total revenue since the beginning to be $80,188,176. If Groupon takes a 35% cut (to take a wild guess), $28 million of that is left after Groupon pays the company offering the deal. According to CrunchBase Groupon employs 90 people. I won’t speculate as to the operating costs of Groupon over the last year and a bit of operation, but once you subtract that number the rest is profit to date.

Looking on a monthly basis, the recent growth of the company is clear. A third of the total savings — in over a year of business — happened last month. This works out to $26,706,059 in revenue last month alone, or about $9.3 million (less the operating costs) profit if you assume they take a 35% cut. The below graph shows the growth by month.

Groupon Growth

Whether or not it’s a $1.2 billion company (BusinessInsider says that’s actually low, though without any quantitative justification), they’re clearly doing well for a company just over a year after launch.

Here are a couple more graphs constructed from the data

Source: http://paulbutler.org/archives/groupon-math-data-scraping-to-estimate-revenue/