EBATES: Web Portal and Promotion Analysis
EBATES: Analysis of an Online Coupon Web Portal
EBATES is an online coupon web portal website launched in 1998. Sold in 2014 to Rakuten, a Japanese shopping website for $1B, EBATES offers consumers cash back who use the portal to find retail shopping discounts.
To date, EBATES has paid consumers $1B in cash back rewards since website inception. The average cash back value on purchases made with retail partners is 5%. EBATES has 6 million users, over 2,000 retail partners and continues to grow and acquire other coupon website portals. Source: Motley Fool
Given EBATES' success as an online coupon aggregator, do the discounts offered on the website impact purchase behavior or increase cash back to consumers who make more purchases with retailers? This blog post will explore this theory using a web scraped dataset from EBATES and R code visualization analysis.
EBATES Business Model
EBATES partners with web retailers to offer discounts and cash rewards to online shopping consumers. As an aggregator of retail offers, EBATES requires consumer registration before using the website to capture useful consumer data. Once registered, EBATES consumers will search for their shopping destination, click on a cash back offer and redirect to the retail partner website for online shopping. Any purchases made with the retail partner is passed back to EBATES and calculated in the consumer's account as their cash back shopping reward. Quarterly, EBATES will send rebate checks or deposit cash into the consumers Pay Pal account.
EBATES generates revenue through paid commissions based on their web referrals to retail partners.
The EBATES core consumer is female and college educated who shops online both at home and work. Typically college educated females are employed, therefore, this specific demographic doesn't have a lot of time to go to brick-and-mortar stores to shop. Instead, they opt-to use EBATES to gain a cash back discounts on items they would likely purchase anyway.
The following chart illuminates the EBATES' core consumer:
source: Alexa, Amazon
Scraped Data from EBATES
Using scrapy and selenium as web scraping tools to capture data from the EBATES website, the web spider crawled through a table of all current retailers to capture the following dataset: retailer name, total coupons/discounts offered, current coupon promotion and cash back since website inception. Once that data was captured and cleansed, additional variables were calculated as a function of % cash back and total retail purchases to enhance the data collected.
In total, a full dataset was developed on 1,500 retailers (2,200 in total) with the balance maintaining secrecy around total cash back. Without total cash back as a variable, it was difficult to make any conclusions about a retailer or consumer behavior other than highlight the number of coupons offered since site inception.
The biggest retailer holding back proprietary cash back data is Amazon.
Analysis: Top EBATES Retailers by Total Cash Back to Consumers
Prioritizing by total cash back to consumers, the top retailers in the dataset follow in the table below. Clearly, these retailers are aligned with the core demographic described previously with Macy's being the top shopping destination through the EBATES web portal.
Looking at a visualization of the top 50 retailers by total cash back and total purchase amount, the visualization indicates there is a relationship between the two variables as demonstrated by the regression line in the chart below However, one would assume there would be a strong relationship between these two variables anyway; thus you cannot necessarily derive a meaningful conclusion other than when sales increase, more cash paid back is paid to consumers through these top retailers.
Analysis: EBATES Consumer Coupon Promotion by Retailer
Taking the analysis to the next level, the relationship between total coupons and total cash back was reviewed and visualized. In theory, if the retailer offered more coupons, then there should be more sales and ultimately cash back paid to the consumer.
However, based on the visualization below, there is a relationship between the two variables however it is a weak one based on the slope of the regression line. In some cases adding coupons or discounts help generate cash back to consumers but isn't a strong indicator that this type of promotion will drive business to one retailer or another.
Looking further into the dataset, the same analysis was generated on retailers at the mean of total cash back. Two hundred observations were included +/- from the mean.
As the visualization indicates below and similar to the top 50 retailers visualization, there isn't a strong relationship between total coupons offered versus cash back paid to consumers.
Promotions Summary and Next Steps
Based on the data collected and derived, there were no strong relationships found based on coupon promotion and total sales when graphed against cash back paid to consumers. However, one point does stand out which is difficult to quantify and that relates to brand. With strong, established retail partners, EBATES has been able to attract and grow into one of the largest coupon sites on the web and is ranked as the 383rd most visited site. source: Alexa, Amazon . For it's core consumer, EBATES has become a pass through destination when web shopping.
More data and time would yield actionable promotional results for EBATES. Such analyses include: analyzing segmentation by retail category, length of retail relationship with the site, consumer profiling, promotional data performance on the home page and A/B testing of offer, promotion position and creative.
Further to this list, there are many more analyses to be reviewed to truly optimize the promotional value of the site and drive incremental revenue for partners and EBATES as a whole.
Scrapy and Selenium Code
Following is the scrapy and selenium spider utilized to capture the relevant data from the EBATES website included in this analysis.