One of our more interesting and sexy recent data assets has been developed through a mega-panel of consumer transactions across millions of consumers and thousands of merchants.
As with all of our data sets, we don’t have access to any personal information. The data has proven useful to track spending across many merchants, as well as different categories of merchants and is allowing us to take our product in a number of different directions. One thing we haven’t yet begun to do is to take a data-mining approach to the information whereby we proactively try to identify outliers across all of the merchants.
Ultimately, we believe this will be one of the most powerful ways we can drive insight from the data, but it’s a very time-consuming exercise as it increases the likelihood for a false positive as any bias or nuance or sampling error that occurs will by definition bubble a merchant up to the top.
That said, I thought it might be fun and interesting to do some quick sorts of the data and see what it looks like in May. So the following is an analysis of what has bubbled up in May, along with some thoughts. Strong caveat emptor – some of what shows up below is (as mentioned above) the result of bias, sampling error and nuance, and I have done only some rudimentary work to dig deeper. Hopefully, you will find something provocative, as well as glean a little insight into some of the challenges we face turning raw data into insights.
The first filter I did was to rank companies by the growth in the number of transactions Y/Y in May. I only included companies with a minimum threshold of transactions to mitigate sampling error. Here are the results:
1. Martin’s Food
2. Alabama Power
3. Conoco
4. Fandango
5. Bebe
6. Microsoft
7. Dollar General
8. Family Dollar
9. Boost Mobile
10. Access Group
11. Amazon Video
12. Casey’s
13. Intuit
14. AT&T U-verse
15. WinCo Foods
16. Transamerica
17. Playstation Network
18. Brookshire’s
19. Kwikshop
20. USAA
Some thoughts:
- Martin’s Food reflects the integration and name change of their Ukrop’s acquisition.
- Alabama Power simply reflects the fact that Alabama has grown disproportionately to other states in our panel, so is purely the result of panel bias.
- Conoco showed a big spike in March, which carried into April and May and is not representative of any increased demand for Conoco (a much smaller retail brand vs. Union 76) gas, but likely reflective of either name changes for some stations or else changes in what shows up in the fulfillment.
- Fandango likely reflects a fulfillment migration (and/or purchase migration) away from the cinemas and to Fandango.
- Bebe is a publicly traded retailer in the midst of a cyclical decline over the past few quarters. As the smallest merchant on the list, I suspect the growth is largely due to sampling error, although I suppose there is a chance that there is some benefit from a very easy comp.
- Microsoft is clearly benefitting from the release of Windows 7 in October, which is the month in 2009 we saw the large step up in Microsoft transactions.
- Dollar General and Family Dollar are both likely benefitting from a mix-shift to the discounters in the current economic climate.
- Boost Mobile suggests continued growth in Sprint’s prepaid business.
- Access Group originates and services private student loans and apparently took some share in a period of tightening credit.
- Amazon Video likely has benefitted from the service being accessible from an ever-increasing number of consoles, blue-ray players, wi-fi enabled HDTVs, etc.
- Casey’s General Store’s strong May was confirmed in their monthly same-store report.
- Intuit would suggest more consumers are purchasing Quicken products.
- AT&T U-verse has been growing consistently as they add new markets and new content.
- WinCo Foods reflects the company’s expansion into Utah late last year.
- Transamerica has a relatively small number of transactions, and as a smaller division of a much larger company, it is difficult to assess what might be going on there or if the data is just spurious.
- Playstation Network is apparently benefitting from an increase in customers and content.
- USAA is a financial services company offering insurance and other products to soldiers, veterans and their families; they managed to grow throughout the crisis and appear to be continuing to do so.
Next, I ranked all the companies (again only those with a critical threshold of transactions) by the increase in average basket size (adjusting for clear outliers). I also excluded gasoline retailers since they all saw increased ASPs as a result of the higher cost of fuel.
Here are the results:
1. Movie Gallery
2. Hollywood Video
3. Cabela’s
4. Disney
5. Pavilion’s
6. Apple
7. Abercrombie & Fitch
8. American Airlines
9. Tivo
10. 37 Signals
11. AT&T Wi-fi
12. United Airlines
13. AirTran
14. Playstation Network
15. Carter’s
16. Metropolitan Life
17. FedEx
18. US Airways
19. TGI Friday’s
20. XM Satellite Radio
- Movie Gallery and Hollywood Video are brands of the Movie Gallery company that recently filed for bankruptcy. The ASP spike is clearly a result of promotional activity as a result.
- Cabela’s seems to have some kind of nuance since there is nothing that would suggest a sharp ASP spike for the company – likely it has to do with an increase in monthly payments to Cabela’s branded credit cards.
- Century Theatres (a division of Cinemark) continues to benefit from higher spend on movies, driven by higher-priced 3D films increased penetration, as well as concessions where they also apparently have some pricing power.
- Disney was surprising since the ASP delta in prior months had been in a fairly tight range; May’s ASP increase also coincides with a non-trivial decline in the number of transactions, so it appears that something is amiss.
- Pavilion’s is a grocer banner of Von’s (part of Safeway); in the grocery space there is often an inverse correlation between traffic and ticket which is apparently what we are seeing here as traffic is down.
- Apple – I think they introduced a new device in April, but I can’t seem to remember what it was….
- Delta, like other airlines, has constrained capacity in order to drive higher prices and we saw the largest jump yet in May (note – many purchases in May are for flights in future months with respect to RASM).
- Abercrombie & Fitch has seen direct sales become an increasingly larger part of the mix lately, and I suspect direct likely has a higher ASP than in-store; this would be exacerbated in our data since our data over-weights direct.
- American Airlines is similar to Delta.
- Tivo is difficult to interpret since the average monthly payment in general is much larger than reported ARPU, as one can pre-pay for various periods across a subscription. I wouldn’t read anything into this number.
- 37 Signals is a privately held Web applications company that Jeff Bezos invested in. I am not sure what is driving the ASP increase, but I love their Basecamp application.
- AT&T Wi-fi – did I mention that Apple had introduced a new product?
- United Airlines is similar to Delta as is AirTran.
- Playstation Network has the honor of being the only merchant to make both lists as the collective minds of our young generation become increasingly vacuous.
- Carter’s may have benefitted from the opening of their Web store in April.
- Metropolitan Life appears to be getting higher monthly premiums.
- Facebook’s ASPs have been highly volatile as there are a decent number of very high ($1000+) transactions.
- FedEx played out in their reported revenue per package for the quarter ended May 31st as they benefitted from very easy comps.
- US Airways is similar to the other airlines.
- I’m not sure why TGI Friday’s ASP trended up in May; I’ve never actually been to a TGI Friday’s, but have always wanted to – perhaps I’ll do some field work.
- For XM Radio, the increase was in large part driven by the addition of the music royalty fee put in place in July, 2009.
So there it is – an analysis of a quick and dirty filter of our May consumer mega-panel transaction data.
As you can see, there is a healthy mix of bona fide trends, nuance, and noise. In fact, much of the work that we do here at Majestic is spend a considerable amount of time cleaning, modeling, and analyzing in order to separate the signals from the noise; an exercise that becomes increasingly more necessary when taking a data-mining approach to the data since, by definition, all false positives will bubble up.
As we continue to do more work with the data, we will ultimately be launching a product that focuses on data mining across all merchants, as opposed to regular updates on a basket of companies in a particular category such as grocers. We are certain that this approach will enable us to unearth some real gems for our clients or at the very lease prove to be provocative.
In July, I will post on June data, only the focus will be on negative trends as opposed to positive ones.





Recent Comments