Social Media

Facebook Insights — My Favorite KPIs (as of Dec-2011)

This is the last post in an informal 3-part series covering what Mike Amer, a fellow analyst at Resource Interactive, and I have arrived at when it comes to understanding and using the latest release of Facebook Insights. In this post, I’ll cover what metrics we’re generally gravitating towards as effective ways to measure the performance of a Facebook page.

As many, many, many people pointed out before the latest update to Facebook Insights, Page Likes (or “fan count”), while easy to measure, is not a particularly meaningful metric. As John Lovett would say, it is simply a “counting metric.”

Below are the metrics I’m gravitating to these days as KPIs for a page:

  • Reach and Impressions – pick one or the other, but, if one of your goals for Facebook is to gain exposure for your brand, these are much better measures of exposure than Page Likes. If you’re running Facebook media, you may want to use Organic Reach (or Impressions) to measure the exposure you’re generating through non-paid means while the ads or Sponsored Stories are running (this will undercount the overall exposure slightly, as some of your viral reach is from non-paid activity, but there simply is no way to really tease that out)
  • Engaged Users – if one of your goals for Facebook is to foster dialogue with users, then engaged users is a good measure, because it is a measure of how many people took any actual action related to your page (regardless of whether it “generated a story”); again, if you’re running paid media, you may want to adjust this metric by subtracting out New Page Likes from Ads.
  • Average Post Engagement Rate – this is a second potential KPI for the goal of fostering dialogue with users; you have to get this from the post-level data, but it is simply a matter of dividing the number of engaged users by the total reach of the post and then averaging this for all posts in the reporting period.  This metric does not need to be “adjusted” when paid media is running. It is also a metric for which a page owner really can take direct action to affect by analyzing the virality of the individual posts in the reporting period and developing hypotheses as to what made the posts with the highest/lowest engagement rates different from each other (type of post, time of day, day of week, content, etc.). Those  hypotheses can then be tested with subsequent posts to see if they are validated.
  • People Talking About or Stories Generated – if you are aiming for your users to spread the word about your page through their social graph, then these are KPIs to consider. Keep in mind that a person who generates a story by liking your page is producing a much broader reaching “story” than a person who simply comments on a page post. And, as with Engaged Users, subtracting out New Page Likes from Ads when you’re running paid media will give you a better picture of the non-paid results from the page in the same time period (although there will still be some spillover impact that is not currently possible to eliminate).
  • Average Post Virality – Facebook reports the “virality” of any single post as the number of people talking about the post divided by the reach of the post. It’s a good metric, if something of a misnomer, because “Virality” is really “potential virality but minimal real virality due to Facebook’s EdgeRank algorithms…unless the post is a Facebook Question.”

It’s pretty easy to engineer much more involved metrics by diving into the organic, viral, and paid breakouts…but then you wind up with metrics that are hard for the typical business user to understand.

That’s our take. What metrics are you finding most useful with the new Facebook Insights? What measures are you least able to get that you wish Facebook would add (for me, it’s the ability to break out “viral” metrics into “triggered by paid media” and “not triggered by paid media”)?

Social Media

Facebook Insights — “Viral” Measures and EdgeRank

In my last post, I provided an update as to how to interpret the primary measures and dimensions (organic/paid/viral) that are available in the latest iteration of Facebook Insights. While digging into those dimensions, my fellow Resource Interactive analyst, Mike Amer, stumbled across some mild unpleasantries that don’t quite square with how Facebook talks about brand pages in their formal documentation.

On the one hand, Facebook would have us thinking that it’s all about virality. That’s one of the reasons they’ve made “Friends of Fans” such a prominent (if laughable) metric!

To recap, the viral reach of a page or a post is the number of unique people who were exposed to content as a result of another user generating a story (“talking about” the page or post – liking, sharing, commenting, etc.). This differs from organic reach, which is the number of unique people who visited the page or saw an item in their news feed or ticker as a direct result of the page posting the content.

Here are a couple of dirty little clarifications and secrets about virality, though:

  • The most common type of viral reach is from someone liking your page despite Facebook’s insinuations that getting people to like and comment on your page posts will tap into that ginormous “friends of fans” number…those user actions tend to go nowhere. When someone likes your page, though, that generates a story that has a meaningful viral reach (unfortunately, that is a one-time viral exposure — that same user may comment on 10 page posts over the next week and the viral reach generated from those actions will be virtually nil).
  • A page’s virality is dramatically impacted by paid media – If a Facebook Ad for the page is run and a user is exposed to the ad, then that exposure counts as 1 person towards the page’s Paid Reach. If the person clicks the Like button, Facebook will record that as a Like Source of “ads” (why they don’t have that data field name capitalized bothers my OCD, FWIW). But, a good chunk of their friends are going to get an item in their ticker that the person liked the page. All of those friends being exposed get counted as viral reach and impressions.
  • Oh…yeah…and Facebook Questions – Facebook Questions are the single type of Facebook page post that appear to drive meaningful viral reach (presumably, because the Ask friends action is more valued by Facebook than other actions such as standard likes, comments, and shares). Questions are good for that! Unfortunately, we’ve seen several cases over the last month across different pages where the Organic Reach of Facebook Questions was reported as dramatically lower than the typical reach for a status update on the page. It’s unclear whether those lower numbers reflect reality or whether they are simply a Facebook Insights glitch

All this is to say that viral reach is messy (…and don’t take what Facebook espouses at face value).

In my last post in this unofficial series, I’ll provide a list of the KPIs we’ve been gravitating towards with our clients and why.

Analytics Strategy, Social Media

Counting ROI in Pennies with Social Media

“Goddam money. It always ends up making you blue as hell.” ~ Holden Caufield, The Catcher in the Rye

That is…if you let it.

During our webinar yesterday Activating Your Socially Connected Business, Lee Isensee (@OMLee) and I caused a minor flurry on Twitter when I Tweeted about the results Lee showed from the IBM/comScore social sales data from Cyber Monday. The findings revealed that $7 million dollars captured on Cyber Monday 2011 in online sales was directly attributable to social media. This makes up 0.56% of all online sales on Cyber Monday 2011.

The skeptics were quick to pounce on the paltry figure, with #WhoopDeeFrigginDo’s and “rounding error” rhetoric (see the Storify.com synopsis). And I agree, that half a percentage point, by anyone’s count isn’t a whole lot of impact. Even when it equates to $7 million bucks in a $1.25 billion dollar day of digital shopping. However folks, remember that all online sales last year represented just 7.2% of holiday cha-chingle in retailers’ pockets. According to comScore’s numbers that’s $32.6B in digital business over the 2010 holiday shopping season. Yet, how many of the total $453B in last year’s holiday sales…or this year’s forecasted $469B in holiday sales…were/will be ***influenced*** by online channels? The answer is a lot.

According to research firm NPD, 30% of all holiday shoppers plan to buy online this year, with the numbers even larger for high income households. Further, a full 50% of shoppers will turn to the Internet to research products prior to buying this year. And this that doesn’t include another 20% that will rely on consumer reviews and 4% who will turn to social media for their pre-buying intel. As we know, many of these shoppers will hit the stores with smartphones in hand, ready to get info or tap into their social networks as necessary.

My point is that if you’re so narrowly focused on social media that the only reason you’re in it is for the money…then you’re missing the point. Social media is today – and will be tomorrow – an enabler. It’s a method to engage with people on a meaningful level and to allow them to engage with one another. As a brand, if you can’t see this then you’re totally missing the point. It’s not all about the Benjamin’s. Social media ROI is important, but trying to pin everything down to bottom line metrics will have you “blue as hell” when it comes time to tally the numbers.

Instead, work to identify other Outcomes for your social media objectives that ***don’t have*** direct financial implications, but that ***do have*** business value. Demonstrating that your social channels reduce call center costs, elevate customer satisfaction, or simply drive awareness of your in-store promotions will deliver value deep within the business.

I’m all for generating ROI from social media activities and making direct revenue correlations when they exist. Yet, in today’s world, social media isn’t just about the bucks. It’s a means to deliver better experiences for the many people who turn to that channel.

If you’re interested in learning more about Activating Your Socially Connected Business, download Chapter 3 from Social Media Metrics Secrets, courtesy of IBM.

Social Media

Understanding Facebook Insights Terminology Redux

When the latest Facebook Insights was released, I quickly put up a post that both tried to explain the new metrics that became available and proposed some probable KPIs.

Well, a few months have passed, Facebook has quietly rolled out some changes to Facebook Insights, and we’ve gotten a chance to actually dive into some of these metrics. This post and the next two are the result of some digging that Mike Amer and I have done on behalf of Resource Interactive and our clients.

Note: This is minimally a post about the web-based Facebook Insights interface. Rather, it is focused on the slightly deeper data that is available behind that interface, which is available by exporting page-level and post-level data or through the Facebook API.

Understanding the Basics – Reach, Talking About, Engaged Users, Consumers

I get a little depressed when I think about the number of times I have read and re-read the same one-line Facebook Insights definitions for various metrics, which have the illusion of being crystal clear on an initial reading, and then get increasingly confusing with each subsequent cycle of trying to actually interpret the data.

I continue to think that the best way to understand the main new metrics is via a Venn diagram. But, the page-level Venn diagram has evolved a bit since my initial post, as Facebook quietly added a page-level Engaged Users metric, which is the union of People Talking About and Consumers. I also think that Facebook changed the definition of Consumers to include clicks that generated a story, but I haven’t tracked down old printouts to fully confirm.

Below is an updated Venn diagram for page-level Facebook metrics.

And, below is an (unchanged) Venn diagram for post-level metrics:

What About Paid/Organic/Viral (especially Viral!)?

At both the page level and the post level, Facebook breaks down a number of metrics by “paid,” “organic,” and “viral” Here’s how I’ve been describing these when it comes to page-level reach:

  • Organic – unique people who visited the page or saw an item published by the page in their news feed or ticker
  • Viral – unique people who were exposed to content as a result of another user generating a story (“talking about” the page – liking the page, sharing a post, etc.)
  • Paid – unique people who saw a Sponsored Story or Ad pointing to the page

A single user can be reached by multiple ways in a given time period (e.g., they saw a post from the page that they’re a fan of in their news feed – organic – and then saw that a friend of theirs responded to a question on the page in their ticker – viral – and then was exposed to a Facebook Ad – paid), so, when it comes to reach, the sum of organic reach plus viral reach plus paid reach is greater than the total reach. Reach measures are always de-duped to be a count of unique users.

When it comes to impressions, though, there is no de-duping, so the sum of the different types of impressions equals the total impressions.

In my next post, I’ll dig into “virality” a little deeper (it turns out to be a bit of a bugaboo metric, but it’s also one that turns out to reveal some sneaky little unpleasantries about Facebook’s EdgeRank algorithm).

Conferences/Community

The Evolution of Web Analytics Wednesday

I’ve been thinking a lot about some of the community events that my partners and I have had the opportunity to create over the years lately. While a lot of the focus recently has been on ACCELERATE — the web analytics industry’s first free conference series — our efforts more will turn back to Analysis Exchange and Web Analytics Wednesday as we roll into 2012.

I wanted to discuss the latter event.

Since co-founding the event with June Dershewitz in 2005, Web Analytics Wednesday has impacted web analytics practitioners, consultants, and vendors around the globe. Since January 1, 2009, over nearly 12,800 individuals around the globe have attended 524 different events … all free, almost all sponsored, and all designed to create local community value for web analytics professionals.

The best thing about Web Analytics Wednesday, at least in my opinion, is that nobody owns the event series! I get calls all the time from vendors asking about having an event in a city or on a date, and I have to admit I cannot really help them because we are only the brand steward for Web Analytics Wednesday, not the owners, and Web Analytics Wednesday ONLY HAPPENS because of the generosity and commitment of the broader web analytics community.

I think this is amazing.

Dozens of sponsors, hundreds of hosts, and thousands of participants, all coming together to make something happen. The list of hosts is too long to write out, but 99% of them are generous, selfless, and incredibly hard-working individuals who spent their free time organizing these events without any thought of compensation or recognition. When they could be with their families, they are working on behalf of the community. When they could be relaxing, they are organizing.

I think this is humbling.

Web Analytics Wednesday has become a nearly frictionless system, one that anyone, anywhere can help to make happen, and one that has helped people find jobs, find employees, find connections, and find new friends.

I think this is freaking awesome.

Sure, we have guidelines … we ask that hosts use our system for registration, we ask that events not charge money, and we ask that sponsors be treated fairly and appropriately at events, and we ask that when Global Funds are used that hosts take pictures for our Flickr Photo Group so that everyone can share in the fun. We expect Web Analytics Wednesday hosts to be cool, to be honest, and to do what they do for “the community.”

So few people have trouble with this model, the exceptions just become noise in the background.

What’s more, we have big plans for Web Analytics Wednesday in the coming year! Where markets have started to languish, Adam, John, and I have started stepping in and offering willing hosts help to reinvigorate their events. Where smaller events have started to grow, the Global Fund has been providing more and more money for reimbursement, and where we see synergies between our other efforts and those of associations and brands we respect and trust, we have been working to organize larger and more diverse events.

And we are just getting started.

If you’re new to Web Analytics Wednesday, here are the five most important things you should know about getting an event started in your town or community:

  1. Web Analytics Wednesday is FREE and OPEN. By design, Web Analytics Wednesday events are open to all practitioners of web analytics and related disciplines and, thanks to the generous support of IQ Workforce and dozens of other companies, always free!
  2. Web Analytics Wednesday belongs to everyone. We do not own Web Analytics Wednesday events, we are only shepherds of the brand, working to ensure consistency across a diverse global analytics community. Anyone willing to follow our very simple guidelines can establish a WAW chapter in their town.
  3. Web Analytics Wednesday is what you make it. Because everyone owns Web Analytics Wednesday, the event is whatever the local community wants it to be. In some cities, WAW happens over lunch. In others, in nightclubs. Sometimes there are presentations, sometimes not.
  4. Web Analytics Wednesday is a state of mind. These events are about local practitioners gathering together, not about a day of the week. Any day can be “Web Analytics Wednesday” … if you’re willing to put in the effort.
  5. Web Analytics Wednesday is a profitless system. Again by design, and with specific intent, nobody makes money off of Web Analytics Wednesday. Regardless of who buys the drinks, nobody — including Analytics Demystified — makes a single, solitary penny off of these events.

This last point is important — if only because some people simply don’t seem to understand.

Every year generous sponsors like IQ Workforce, Coremetrics/IBM, SiteSpect, and dozens more agree to help pay for Web Analytics Wednesday events around the world. And every year my firm (Analytics Demystified) contributes hundreds of hours to ensure that these events go off smoothly. Tens of thousands of dollars are spent to entertain web analysts in great cities like Boston, Chicago, San Francisco, Hong Kong, Sydney, London, and hundreds more. But nobody working on these events — from the mightiest sponsor to the most humble host — gets any compensation in return.

Why do we do this? Why give our money and time to something that won’t make us money? Why did we bother to help create an event series that wouldn’t line out pockets and pay our hourly consulting rate? Simple …

Because we truly care about the web analytics community.

We created Web Analytics Wednesday with June Dershewitz because there was a need back in 2005. We created Web Analytics Wednesday because our community was growing in a strangely fragmented way. We created Web Analytics Wednesday because we could.

I sincerely hope that all of you who have sponsored, hosted, and participated in a Web Analytics Wednesday over the last seven years will continue to do so for years to come. At Analytics Demystified, our commitment is to what is right and just when it comes to this event series and, more importantly, to continue to help evolve and improve Web Analytics Wednesday to ensure that analysts everywhere are able to enjoy and appreciate the same community spirit that we enjoy every time we attend one of these events.

I welcome your comments.

Adobe Analytics, Social Media

Google’s New Social Data Hub

Google’s Eric Schmidt appeared today at LeWeb 2011 and dropped some notable quotes during his interview with conference organizer Loic Le Meur (@loic), including this prescient perspective: “It’s reasonable to say that in the future, the majority of cars will be driverless or driving-assisted.” Foreshadowing perhaps? Could be…but closer to reality:

Google’s Executive Chairman also quipped, “It’s easier to start a revolution and more difficult to finish it.” Google should know. They’ve been revolutionizing the way in which consumers interact on the Web since their inception and news posted today following the LeWeb chat follows suit.

The news reveals a new initiative launching today called the Social Data Hub. What’s even more exciting is the Google Analytics Social Analytics reporting to appear sometime next year. While the details were somewhat vague, I got the inside scoop and what was published should be enough to incite a minor frenzy in the Social Analytics circles.

The “Social Data Hub” is a data platform that is based on open standards allowing Google to aggregate public social media posts, comments, tags, and a plethora of other activities using ActivityStream protocol and Pubsubhubbub hooks. (Yea, that’s a real thing…I had to look it up too.) Early partners in the initiative include social platforms such as Digg, Delicious, Reddit, Slashdot, TypePad, Vkontakte, and Gigya among others. Of course Google’s own social platforms, Google+, Blogger, and Google Groups are included as well. Noticeably absent from the list are social media moguls like Facebook, Twitter, and LinkedIn who have yet to buy into the new Googley idea of a Social Data Hub.

So What…?

If you’re scratching your head wondering how this is different than Google just trying to get more of the world’s data, you’re not alone. At first glance this may seem like yet another big enterprise ploy to get more data (and oh yeah, Don’t be evil). Well, I see this as a huge win for marketers, bloggers, publishers and anyone else trying to discern the impact of social media marketing across the multitude of channels and platforms available today. Currently, most marketers are forced to evaluate their social media activities through the lens that the platform (or their social monitoring tool) offers. Typically this yields low-hanging counting metrics which can be of some value, but more often than not end up as isolated bits of information that don’t provide business value.

Getting at this all important business value in many cases requires wrangling the metrics into another system, processing data and just generally working hard to gain some incremental insight. This is laborious work for the average marketer, so it’s no wonder that eConsultancy just reported that 41% of marketers surveyed had no idea what their return on investment was for social media spending in 2011. Yikes!

Google’s new Social Data Hub – coupled with Google’s Social Analytics reporting – has the potential to knock the socks off these unknowing marketers. By aggregating data from multiple social platforms into the Social Data Hub, they have the ability to make comparisons across platforms to show which channels are driving referrals, which are generating the most interactions, and which are potentially not worth investing in. It’s not that big of a stretch to imagine Google linking this information to data within their Google Analytics product such as Adwords, Goal completion rates and cool new flow visualizations. If/when Google applies the lens of their analytics tool to this new aggregated data set, look out marketers — you just hit the jackpot! Of course, I’m speculating here, but the possibilities are intriguing for a Social Analytics geek like me. That is of course, if platforms open their APIs to the Social Data Hub. A big if…

So Why Would a Platform buy into the Social Data Hub?

Well, it’s questionable if Facebook ever will opt in for this system so I wouldn’t hold your breath on that one. However for other social platforms, being part of the hub has some distinct advantages. They get to prove their value by partnering up with one of the only solutions on the Web that is capable of providing real comparative data on the performance of social channels.

This is a no-brainer for fledgling platforms that want to increase their visibility and even for established players, opting into Google Social Hub could mean the difference in gaining advertising dollars from skeptical marketers. While the big dogs in social media may take a while to come around, I see this new Hub as a potentially great equalizer for understanding the impact of social media as it relates to referrals for on-site activities which can ultimately lead to conversions and bottom line impact.

While today’s announcement may be just a small ripple in the social media pond, I see big waves building for Marketers. But that’s just my take on the disruptive and revolutionary force that is Google…

If you want in on the action, here’s a link to request access to the private beta for Google’s Social Analytics Reporting: https://services.google.com/fb/forms/socialpilot/

And here’s one to for platforms to join the Social Data Hub: http://code.google.com/apis/analytics/docs/socialData/socialOverview.html

Adobe Analytics

Date Stamp Variable [SiteCatalyst]

I was recently working with a client that had a unique situation arise. This client is well-versed in the usage of the Adobe Discover product and frequently takes advantage of its ability to segment by date. For those unfamiliar with this feature, you might use it to address the following scenario: “I’d like to build a segment of people who filled out a form in the third week of January 2011, but I want to see their behavior for the months of February, March and April.” Here is how this segment could be built using Discover:

This functionality is cool since you can use it to limit your population to folks who took some action in a specific time period and then observe their subsequent behavior across a future time period. Another example might be the desire to see purchase behavior of people in Q4 who looked at products in Q3.

However, the challenge facing this client is that very few people in the organization had access to Discover so they wanted to have the ability to apply this date-based segmentation to their SiteCatalyst reports to which everyone had access (and take advantage of the new v15 segmentation capabilities). I hadn’t thought about doing this in SiteCatalyst due to its segmentation limitations (see below), but after contemplating a bit, I came up with a cool trick that should allow SiteCatalyst users to take advantage of this Discover functionality. If this is of interest to you, please read on…

Date Stamp Variable

In order to build a segment that crosses multiple visits, the obvious starting point is the Visitor container within SiteCatalyst’s Segmentation tool. If you want to select a Visit in one time frame, but look at data for another time frame, you will need to use a Visitor container and nest a Visit container and/or Success Event container within it. In the preceding example, we would want to create a Visitor container, but nest a Visit container within it in which the visitor had a Visit where a Form was completed in a specific week of the month of January. Sounds easy right?

Unfortunately, it isn’t as easy as you’d think, because there is no way to segment on a date or month within SiteCatalyst like you can in Discover. Therefore, the trick is to pass the date to a SiteCatalyst variable within each Visit. I suggest you add one new eVar and one new sProp and set the date on every page. In addition, you can easily create a SAINT Classification for each date which rolls these dates up into weeks, months or years as needed.

Once we have set the date to a variable, let’s see an example of how we would create the aforementioned segment from within SiteCatalyst. First, we grab the Visitor container, then we nest a Visit container and within that Visit, we nest a Form Completion Success Event. To narrow down the Form Completion to a specific week in January, we can use our new Date Stamp variable (eVar or sProp version):

Of course, as I mentioned earlier, it may be easier to classify these variables and segment on them by week or month. This process would be identical to the segment shown above, but instead, would use a Classification of the Date Stamp variable. Here is an example of a SAINT Classification of the Date Stamp variable:

If you’ve read my past blog posts, you will soon realize that this trick is similar to the Time-Parting plug-in I described years ago. In fact, it is really just a variation on that, but without the time of the day. However, limiting the values to just the date makes the data much more manageable and more easily classified. The use of this, plus segmentation allows you to mimic what has been possible in Discover for a while so if you have lots of SiteCatalyst users, give this workaround a whirl…Enjoy!