More than Reach: How to Check These Important Metrics

334 Shares Facebook 136 Twitter 127 Buffer 33 Google+ 20 LinkedIn 13 Pin It Share 5 334 Shares ×

more than just reach how to check other data 700x365 More than Reach: How to Check These Important Metrics

Okay, you’ve heard it by now. Organic Reach is dropping for three of four brands on Facebook. Dozens of bloggers are latching on to the frenzy and confusion with link bait articles about why you should jump ship ASAP.

Maybe Facebook is no longer right for you. But if you abandon your efforts there, do so because of substantive evidence associated with your own results — not because a blogger’s panicked headline moved the needle.

The purpose of today’s post is to help you evaluate whether your metrics that matter have taken a hit.

Ready? Let’s go…

First, a Note on Timing

This dust-up came at a very inopportune time since many brands (barring a few exceptions due to niche) are about to see a drop in Facebook and website numbers. That’s typical as users begin taking their holiday vacations, and their activities online drop.

The past two years, my website traffic always drops in the second half of December. And that is again the case this year, even though I was on pace for a record month until December 20.

So first, let’s not pay much attention to anything from December 20 and on. We should expect those numbers to drop (again, barring a few exceptions).

Second, keep in mind that you should never pay too much attention to your stats in real time. Don’t compare this week to last, for example, because your stats for this week are not complete.

Since general consensus seems to be that a drop in Organic Reach started on or around December 2, let’s use the time from December 2 – 15 as our test sample to determine if drops have occurred in important stats.

Download Your Post Level Export

Go into your Admin Panel and click the See Insights button at the top (this is one of a few ways you can access this data).

facebook admin panel access insights 700x366 More than Reach: How to Check These Important Metrics

Now click the Export Data button at the top right…

facebook insights export data More than Reach: How to Check These Important Metrics

You will now be given a dialog to choose the data you want to export. Make sure to select “Post level data” as data type. I still use the old export while it’s available (it really shouldn’t matter for this study). And I suggest using November 18 – December 15 since it will give you two weeks prior to and after the presumed Organic Reach drop.

facebook insights export select data 700x366 More than Reach: How to Check These Important Metrics

Check Organic Reach

While I really don’t care about Organic Reach on a post-by-post basis, we’re going to check it anyway. It’s likely this number has dropped for you, but this is not the case for everyone.

Column I of the Key Metrics tab (the default view) will provide your Organic Reach data. Let’s go to the very bottom of that data and find the median Organic Reach for November 18 – December 1 and December 2 – 15.

The formula I use is as follows:

=MEDIAN(I3:I46)
=MEDIAN(I47:I112)

I use medians so that your data isn’t easily swayed by numbers that are well outside normal range.

If you want to see a change between the two, then add a formula that is something like this:

=I113/I114

In other words, this takes the ratio of the latest two week period over the prior two week period.

Of course, these formulas need to be adjusted based on your data — the rows that apply to each date range will be different for you.

Check Basic Engagement Data

To make this nice and easy, go ahead and copy these three cells and paste them across all columns in those rows. This way, you can get medians and changes for all data within Key Metrics very quickly.

A few columns to pay especially close attention to include:

  • Column P: Lifetime Engaged Users
  • Column Q: Lifetime Talking About This
  • Column R: Lifetime Post Stories
  • Column S: Lifetime Post Consumers
  • Column T: Lifetime Post Consumptions
  • Column X: Lifetime Reach of Fans
  • Column AA: Lifetime Engaged Fans
  • Column AB: Lifetime Fan Stories
  • Column AC: Lifetime Fans Talking About This

Check Specific Consumptions Data

Now do exactly what you just did, but within the fifth tab for Consumptions. This time, you’ll want to find the difference between time ranges for each type of Consumption (Link Clicks, Photo Views, Video Plays, Other Clicks).

Something to keep in mind here is that data now starts with Row 2 instead of Row 3. Otherwise, these formulas should be identical to what you used on the Key Metrics tab.

If your goal is to drive traffic, pay especially close attention to Link Clicks! You should probably remove any rows of data that weren’t link shares for this comparison.

It’s up to you, but you could also run this same process for specific Story types within the Stories or Talking About This tabs. This may be overkill, however, since you already found the general numbers earlier.

Check Revenue Data

I can’t show you how to do this since it’s deserving of a full blog post of its own (in fact, make sure to read this!).

But, hopefully you are tracking revenue based on traffic sources. Compare your revenue for each date range to see if there has been any noticeable difference.

Checking My Data

I never want to make any grand proclamations based on my own data, but here are a few notes I see…

Organic Reach: I’m showing Organic Reach is down 21.5% for me. An interesting note is that Viral Reach is down 63%. One reason I don’t trust Reach numbers generally is because of the misreporting of Viral Reach a year ago. I’m not saying that’s at play here, but something to consider.

Stories and Talking About This: These numbers are flat. Whether looking at Fans or all data, each number is either just above or just below 100% of what it was the prior two weeks.

Link Clicks and Referral Traffic: I show an interesting discrepancy, though it doesn’t necessarily mean incorrect data. There is a drop in median link clicks of 28%, but my Google Analytics show that Facebook referrals are up 20%. This doesn’t necessarily mean anything since not all referral traffic comes from my Page, but something to watch.

Referral Revenue: My referral traffic from Facebook has resulted in nearly triple the revenue during the first two weeks of December. Even if I take out my Cyber Monday promotion, revenue was up 30%.

Based on these results, you can probably see why I haven’t yet hit the panic button for my Page. Sure, I’m seeing a drop in Reach, too, but many of the more important metrics are either flat or up.

A Note on Small Sample Sizes

Now, this is a great exercise. However, let’s be careful not to get too wrapped up in small sample size data.

We’re looking at two weeks of data at a time here. Chances are pretty good that you see regular ups and downs. There are many factors at play, not the least of which is the amount you’re committing to advertising.

However, I’d still much rather you do this than freak out about your Reach. Start doing this now if you weren’t already.

Over time — particularly after the first of the year — let’s look again to see if any trends you were seeing during the first two weeks of December continue into 2014.

[NOTE: I encourage you to check some "bigger data" studies by AgoraPulse and EdgeRank Checker.]

What Are You Seeing?

Go ahead and run this exercise yourself. Let me know what results you’re seeing in the comments below!3

334 Shares Facebook 136 Twitter 127 Buffer 33 Google+ 20 LinkedIn 13 Pin It Share 5 334 Shares ×
About Jon Loomer

Jon Loomer is a digital marketing consultant with a unique perspective on social media. He was introduced to Facebook in 2007 while with the NBA (back before Pages) and has been using Facebook for business ever since. Stay in touch by liking his Facebook Page (Jon Loomer Digital).

  • Nicole

    I think you have the formula wrong for calculating change. It should be “=(new_value/original_value)-1″ in order to get percentage change.

    • http://jonloomer.com/blog Jon Loomer

      Sure, it could be, Nicole. I just calculated that in my head after the ratio!

  • Sarah Pinnix

    I’m definitely going to do this analysis, thanks for the step by step. And yes, viral reach is notoriously wrong – it has to be based on the number of shares we see. And speaking of FB conspiracy theories, Facebook always does these reach restrictions on THE day I start a major fund raising campaign! Coincidence? I think not! Haha. (Just kidding, but really.)

  • http://www.linkedin.com/in/daviscollin Collin Davis

    Jon my question is slightly different from what the post is about but still pertaining. Why do you think is Facebook reducing organic reach?

    Shouldn’t Facebook focus on the users first and then on the money? A lot of users today are getting frustrated with Facebook because it no longer shows me updates of all my friends and what I want to see. The negative sentiment for Facebook today is at an all time high.

    Don’t you think it would benefit Facebook to continue to create a better product because the money will continue to come if you have a great product. Case in point being Google. Just feel that Facebook has forgotten its primary objective – USERS.

  • Michelle Pescosolido

    Now I am noticing even my paid reach on my engagement ads are even dropping. This started 3 days ago. Any thought? Here’s the image.

    • http://jonloomer.com/blog Jon Loomer

      Doubt it’s related, Michelle. Are these ads still reaching your budget? If not, are you using Optimized CPM?

      • Michelle Pescosolido

        Doh! Sometimes it’s right under your nose and it takes another perspective. I bet it is my budget maxed out. I am doing optimized CPM fyi…. Off to change that budget. I think I may of tweaked it the other night. Thanks!!!

  • Wahayn Inello Clayton

    GOOD STUFF MAN, I HAVE TO GET UP TO 30 LIKE FIRST? OR IS THERE SOME TWEEKS I CAN DO TO MY FAN PAGE TO OPTIMIZE IT BETTER FOR FANS?

334 Shares Facebook 136 Twitter 127 Buffer 33 Google+ 20 LinkedIn 13 Pin It Share 5 334 Shares ×