This handy tool uses Facebook’s authentication to download information about your personal Facebook usage. This is NOT the same as analytics for Facebook pages. But it does use the same permission requests you’d need to play Farmville or a related game.
For those non-geeks out there, the Wolfram Alpha search engine does computation. Put in math problems or ask the GDP of France in a Google-esque search box.
Go check it out and watch it lay bare who your friends are, when you’re online most often, and what things you talk about most.
Type in “Facebook report”.
Click “Analyze My Facebook Data”. Click “Allow” when the app requests permission.
Enter your information when prompted.
Click “Analyze My Facebook Data Now”.
Allow some time to gather data.
At the top, it shows your basic information on a slightly deeper level.
Your posts are broken down by time period, amount, and type.
Then they are broken down into immense detail.
Statistics about your friends’ interactions with your posts are shown, as well as what your top posts are.
Detailed check-in and app activity are also displayed.
You even get a time breakdown based on what you use to access Facebook.
Information on photos and tagging are all displayed.
Your friends are displayed by their gender, relationship status, age, location, and more.
You also see a visual interpretation of your network, color-coated based on occupation, school, local area, etc.
We plotted out every team’s fan count, engagement rate (social metrics), win/loss record, average attendance, merchandise sales, and the population of the city the team plays in (real-world data), looking for correlations and patterns. Ultimately, the best metric was the ratio of average attendence to fan count, though looking at Merchandise sales and standings was also enlightening: The Yankees have the most fans by far (8,474,881). This is not surprising. They have the biggest city (pop. 8,175,133), the highest merchandise sales, and the third best record in the league (60.3%), and have been a consistenly winning team for generations.
The Nationals have the least fans (230,581), which is somewhat surprising, considering they have the fourth best record (58.5%) and a relatively big population (601,723, compared to say, St. Louis’ population of 319,294).
There is no significant difference in the frequency or quality of the posts made by the Yankees and the Nationals.
The teams with the best merchandise sales (New York and Boston) are also the two pages with the most fans, and have the best attendance-fans ratio (0.5 : 100 and 0.7 : 100, respectively; the average is 1 : 25).-With very few discrepencies, the top ten teams that sold the most merchandise correspond with the ten teams with most fans (I.e. NY is #1 in merch sales and in fans, etc.).-Teams with inflated fan counts (NY, Boston, SF, etc.) likely have many fans that don’t live where the team plays.
The ratio of Yankees fans to Mets fans (8,474,881 : 626,869) is far more extreme than the ratio of average attedance (41,570 : 27,458).Team pages do a good job of posting photos, questions, short messages, occasional contests, videos, etc. One possible area of improvement would be to focus more on posting before a game than only doing recap posts.The team with the highest engagement by far is the Dodgers, who have won 61.8% of their games this season. The teams with the next highest engagement rates, the Mets and the Angels, are not ranked as well this year (both currently at 53.6%).
There seems to be a stronger connection in the fact that two of the teams with the best engagement rates are the Los Angeles Dodgers and the Los Angeles Angels (37.2% and 26.8% respectively). The Mets have a 27.5% engagement rate, and it can be presumed that the Yankees’ highly inflated fan count leads to low engagement. Most of the teams with above-average engagements rates are among the larger cities in the league (LA, New York, Chicago, Phoenix, Fort Worth).
There are of course, large cities with poor engagement (Toronto or San Diego, for example), but the only real standout is the smallest city in the league, Pittsburgh, with a high engagement rate.of 27.7%, the 6th highest in the league.
The Dodgers are third in merchandise sales, but other high sellers have poor engagement rates such so that the metrics don’t correlate. Boston, number 2 in merch sales is third to last in fan engagement.
We compared attendance to population, and then compared that to engagement, but data did not correlate well.
There seems to be a difference between people who go to games and people who engage on Facebook. For instance, Atlanta is a small city (pop. 420,003, the 9th smallest in the league) with high average attendance (29,852, well over the league average), and yet the team’s page has an engagement rate of 11.21%- far from remarkable. Cincinnati is another example. They have a killer attendance-population ratio (27,163 : 296,943) and has the second worst engagement in the league- 1.62%.
If you’re a data monkey and would like to see the numbers for yourself, You can check it out here. You can also check out the technology we used to get these numbers and get your free trial over at Blitzmetrics.com
To succeed in social media you must engage your fans and build relationships that go deeper than a transaction. Facebook gives you a chance to humanize your brand and makes it easy to educate and entertain your customers. If done correctly, your fans will become your advocates spreading not only awareness, but endorsement as well. This is called Engagement marketing and it is one of the most powerful ways to build interest and brand loyalty in your products. Think about it, how much more likely are you to see a movie a friend recommended rather than one that is just advertised on TV? So how do you fuel engagement marketing? The best way to learn is from others who have already done it, in this case, that would be Niche Modern, a company that specializes in modern lighting fixtures and lamps.
Niche Modern recognized the chance to connect with fans and replicate their in person customer service skills by engaging fans on their wall and building a vibrant community of loyal supporters. Of course it’s easy to engage with fans when they’re stroking your ego but what about customers who are disgruntled? Niche Modern responds by empathizing with them and then doing whatever they can to resolve the issue and then leaving the post on the wall. This shows the community that they care about their customers experience and will do everything in their power to rectify any grievances.
How do you post engaging content? There is no magic bullet to produce engaging or viral content, if there was, everyone would be doing it. That said here are some tips: pictures and videos generally work better than just words, ask questions that encourage your fans to respond, post exclusive offers and understand your fans with Facebook Insights. With your posts be succinct, 100-250 characters is a good rule of thumb. Post at least twice a week, creating a content calendar will help.If you’re just posting to your wall less than 16% of your fans are going to see the post but with page post ads that number can shoot to 70-80% of your fans and can be done on a shoestring budget.
Use ads to find fans. Entice them by showing them value and targeting the people that are most likely to be interested instead of just blasting your message across Facebook to everybody. A combination of Facebook ads and Sponsored Stories as well as Page Post ads, to keep your current fans engaged, will be the most beneficial strategy for attracting fans and keeping them coming back. The ads may find the people but it’s the social component that will clinch the like.
You don’t need to be some conglomerate or multinational corporation to excel at engagement marketing; anybody can do it. A vivacious Facebook community offers a variety of tangible benefits: people are 51% more likely to buy a product after liking them on Facebook, fans report visiting and purchasing an average of 2x more than non-fans, more in-store traffic can be generated with exclusive Facebook coupons, you will have a new feedback channel to poll customers, you will have increased participation in promotions. Ultimately engagement marketing boils down to four steps: build a Facebook page, connect to fans with ads, engage fans with quality content, and influence the friends of your fans. Although the ROI may be difficult to quantify, if done correctly the end result will pay off in spades for a long time to come.
You can use this tool inside Facebook’s Graph API to find multiple pages for any business or brand! First, go to the Graph API inside the Facebook Developers page. Scroll down until you get to the ‘Searching’ section. You will see that Facebook supports search for many different objects. We’ll use pages to search for all Fuddruckers’ Facebook pages.
After clicking on the ‘Pages’ link, we are taken here. The search is defaulted to search for platform, and we can change where it says platform to Fuddruckers in the url so now it starts with:
https://graph.facebook.com/searchq=Fuddruckers&type=page&access_token=
To pull more than 25 search results, add:
&limit=200
The search will now pull 200 results with the name of each page, its category, and id number
We are interested in the id number because we add it to the end of www.facebook.com/ to bring us to their page
Select all, and copy to a new workbook in Excel, and run a simple ‘Sort’ on the data so we can isolate the user id for each Facebook page.
After the sort, you will end up with a list where all of the id numbers are together. Isolate these and paste them to a new workbook.
We will now use the find and replace feature to:
find: “id”:
replace with: www.facebook.com/
click replace all
Use the find and replace tool to clean up the rest of the apostrophes and spaces, replacing them with no characters. Your list of the top 200 Fuddruckers pages is now be ready to go!
Congratulations to Veronica Stecker and Gordmans “Choose Your Outfit” app’s acceptance into the Facebook Studio Awards! In addition to managing Gordmans’ television, print, and digital marketing, Veronica maintains a blog on all things social at VeronicaStecker.com. Working with BlitzLocal, the “Choose Your Outfit” app launched on July 18th, 2011 and ran through August 19th, 2011. The interactive app allowed Facebook fans to dress a male or female avatar with Gordmans’ clothing and accessories. In order to use the “Choose Your Outfit” app, users had to fan Gordmans’ Facebook page. After a fan had chosen their outfit on the app, they received a 15% off coupon for use at any of Gordmans’ locations. Gordmans ran sponsored story Like ads and Friend of Fan ads to drive users to the “Choose Your Outfit” app. The campaign drove 10,376,388 impressions and 8,771 connections. These are great statistics, but the most telling of all was that Gordmans saw their average transaction size more than double from $32.00 to $68.00. Keep up the fantastic work Veronica! There are surely great things coming from Gordmans after the amazing “Choose Your Outfit” app and campaign.
About the Author: Travis King is Manager of Facebook Marketing at BlitzLocal.