Category Archives: Mike Handy

Black Friday by the Numbers!

Fact: Black Friday is the biggest shopping day of the year. Millions of dollars are spent on ads to get people in the stores and make them aware of the doorbuster deals.

Using foursquare data publicly shared on Twitter we can get an idea of how well some major retailers did this Black Friday. Users that share their Foursquare check-ins on Twitter are a consistent group and as a result statistical patterns can be established. These same users are also giving away branded impressions at no charge.

The 6 Black Friday pushes that were evaluated using Foursquare check-in data were:

Target, Walmart, and Best Buy: These are the obvious 3, every year they expressly go after tech savvy shoppers with their discounted TV’s, video games, and cell phones.

Gap and Kmart: Very different stores with the same strategy: be open when everyone else is closed.

Macy’s and Kohl’s: Both spent a lot of money this year attempting to drum up excitement about their offerings via TV ads.

Sports Authority: Sports Authority actually ran a Foursquare promotion, making for an interesting case study. Every hour they were giving away $500 gift cards to their store via Foursquare. They didn’t broadcast it much other than leveraging their database and they didn’t provide many outrageous deals.

The Question: Which retailer had the biggest spike over their average on Black Friday? 

The baseline: Which brand got the most check-ins?


This data consists of public check-ins within the 5 days of black Friday. Walmart clearly dominates check-ins, with Target a close second. On the surface level it would appear that Target and Walmart are the big winners.

However environmental effects need to be considered:

- Consumer preference

- Technology proficiency of a consumer group for a given brand

- Average Age of the consumer group and corresponding technographic profile

- Income: can the group afford smart phones/smart phone plans?

- Number of distribution centers

In short we need some more significant data to work with….

The next level: Trending- Were there actually any spikes?

This graph is a little more telling. Clearly, there were spikes by all 6 brands on Black Friday. It is also clear that Walmart averages the most check-ins for this sample group. Finally and most importantly for the purposes this analysis, the samples are fairly consistent.  In almost all cases the standard deviation was less than 20% of the mean. Only Macy’s had a Standard Deviation large enough, above 80% of the mean for the 30 days leading up to Black Friday, to create measurement questions/require deeper analysis of outlying data.

This trending graph doesn’t fully explain which brands had the largest percent of success. How much did Walmart or Target actually improve above their daily average on this Black Friday? This graph doesn’t give us that information.

Actual analysis: The mean is an important number statistically, it’s like the foundation of a building. The mean often gives more information about a sample than we care to realize and needs to be expressly included in analysis. Walmart averaged 1305 check-ins shared on Twitter every day for the 30 days leading up to Black Friday, Target averaged 1035, Best Buy averaged 358, Macy’s (adjusted) 238, Gap averaged 86, K-Mart had 76, Sports Authority got 27, and Kohl’s had a very small 14 .

It is important to note that these samples don’t include Black Friday data, which would skew and destroy the sample. As will become apparent later, Black Friday as a set are super-outliers for all brands.

Which brand actually did the best?  

It is interesting that Kohl’s was one of the biggest winners. On Black Friday they  averaged 31 times their normal standard deviation. I would question the base sample size if no other brands were close to multiplying their standard deviations to that extent. However, Best Buy, who had one of the largest, and most consistent, regular samples sizes had a LARGER multiplication of standard deviation. Again these numbers were very normative when compared to the mean against each other. Kohl’s and Best Buy were within .01% of percentage standard deviation against the mean. Both Kohl’s and Best Buy were within 2% of Target’s and Walmart’s standard deviations compared against the mean. Only Macy’s required further analysis, after which the data falls right in line with Walmart and Target. Macy’s averaged around 15 times a normal standard deviation, when points greater than 2 standard deviations (outliers) were excluded from the sampling.

What does this all really mean? 
[youtube http://www.youtube.com/watch?v=dMH6d4Adm9U]

#1 Apparently this ad worked…

#2 Best Buy is the place to go if you are a tech savvy shopper

#3 Target, Walmart, and Macy’s averaged about 6 times their average check-in traffic on Black Friday. Most likely they had similar foot traffic spikes.

#4 Keeping a store open on Thanksgiving doesn’t generate a tremendous lift. Kmart and Gap both had strong returns, however, both stores were still on the bottom of total Black Friday checkins, and had some of the weakest returns.

#5 A Foursquare promotion doesn’t skew data just because it exists. Sports Authority needed better media support.

___________________________________________________________
Mike Handy has been working in Social Media since Facebook was only for college students. He started his first blog in 1999 when most people were still figuring out this “Internet thing”.  These experiences paired with his background in advertising and data-centric approach provide him with a unique view of social media. When he isn’t working he is probably watching, playing, or doing something hockey related.

The Problem With Google+ Pages

Google recently launched their business pages product. The product is not without serious flaws or issues. Most importantly, officially you are only allowed to have one person as an admin of a page.  The page must be attached to one, and only one, personal account. At the agency level this makes Google plus pages nearly impossible to work with. Having multiple administers serving several different functions is a basic requirement of social networks in 2011.

Google+ Brand Page Creation

Creating a Google+ Brand Page

There are several reasons why businesses need to have multiple, and replaceable, administrators that are obvious at surface level. When working within an agency there are even more reasons. Community Managers, Clients, Media Teams, Digital Strategists, Account Executives, among others might have a need to log in as an administrator of a page.  In fact for most businesses, more than one person needs to have access and control of a social channel. Google, as a company that recently switched CEOs, should have realized this reality. The Spam controls are great for the network as a whole, however, they are well beyond what is needed from the first iteration, mostly because pages didn’t NEED this much functionality at launch.

The fact that the Google plus business product is missing this core administrative feature is probably most disappointing, because it represents a failure Google has been able to avoid since the inception of the network. Until now Google has not re-created the Facebook wheel. The administrative rights alone indicate that avoidance of early Facebook mistakes may have been more luck than skill. Had Google launched nonfunctional pages with just an avatar, static info, and multiple admin rights it would have been better for everyone. Almost every feature they have is 3 or 4 steps beyond the basic administrative level, and shows an inability to fully understand challenge of running a business channel on social media.

I reached out to Google to ask if the Facebook pages 1.0 solution, *creating a business profile that has no activity for the purpose of managing a page*,  was acceptable. The response, “there will be no terms of service exceptions.” With the real name profile policy on Google Plus the Facebook 1.0 solution out of contention. Google seems to be serious about their terms of service, unless of course, a brand spends a few million in ads every year or it is Google themselves. If  you are not in this category or, you don’t value your adwords, Google Docs, Google Analytics  or Gmail accounts, it is probably not worth breaking the rules.

At this point Google Plus has nearly the same number of active users as Foursquare and Get Glue’s user-base put together, or about 20% of active Twitter users. Until the admin issue is resolved, or the network explodes additional resources are best used for the following purposes.

  • Keeping an eye on brands that are messing up/ creating fire storms on the network
  • Looking for bright spots
  • Investing in developing a strategy for organic growth (few brands are doing this at all and it is very possible, that is a different blog post)
  • Clocking post life
  • Analyzing ripples
  • Personally using new engagement functionality no social site has ever brought to a brand
  • Learning the Terms of Service, Google has shown they are not gun shy about closing down anyone, even big name players! (Looks at Ford)
  • Looking at the SEO considerations

Google Plus Pages is hardly a complete or even adequate product for large organizations at this time.

___________________________________________________________
Mike Handy has been working in Social Media since Facebook was only for college students. He started his first blog in 1999 when most people were still figuring out this “Internet thing”.  These experiences paired with his background in advertising and data-centric approach provide him with a unique view of social media. When he isn’t working he is probably watching, playing, or doing something hockey related.

The State Of Mobile

[slideshare id=9882889&doc=blog-stateofmobile2-111025234636-phpapp02]

___________________________________________________________
Mike Handy has been working in Social Media since Facebook was only for college students. He started his first blog in 1999 when most people were still figuring out this “Internet thing”.  These experiences paired with his background in advertising and data-centric approach provide him with a unique view of social media. When he isn’t working he is probably watching, playing, or doing something hockey related.

The State Of Mobile

[slideshare id=9882889&doc=blog-stateofmobile2-111025234636-phpapp02]

___________________________________________________________
Mike Handy has been working in Social Media since Facebook was only for college students. He started his first blog in 1999 when most people were still figuring out this “Internet thing”.  These experiences paired with his background in advertising and data-centric approach provide him with a unique view of social media. When he isn’t working he is probably watching, playing, or doing something hockey related.