Facebook analytics using Excel 2013 Power Query: Without programming!

In few minutes you can analyze any public FB page data.
Here we see how to analyze the likes and comments – instantly.

You need Excel 2010 or Excel 2013 (Professional Plus edition) or Office which is installed from Office 365.

  1. Close Excel if it is open 
  2. Download a new, extremely powerful tool Power Query for Excel
  3. Install the tool
  4. Open Excel
  5. You should now see a tab called Power Query
  6. Open Power Query tab and open the From Other Sources dropdown
  7. Choose Facebook

    image

  8. Choose me and Statuses (you can choose other types as well)

    image

    Remember that you can type any username or object id which has information accessible to you

  9. Click Ok
  10. Sign in to your Facebook account
  11. Save the credentials
  12. Now it will open a query result window and extract status update information from FB
  13. At this stage it shows few results. Later it will fetch all possible results.

    image

  14. Keep the columns Message, Updated Time, Likes and Comments.
  15. Remove other columns by right clicking on each column and deleting it
  16. Now we want the count of likes and comments
  17. As of now, both show Table.
  18. Notice the small icon next to the Likes and Comments column headings

    SNAGHTML17052850

  19. Click on that icon and do the following for Likes and Comments
    1. Choose Aggregate and Count of ID
    2. Now the Column shows count
  20. The date time column contains locale information. We want a simple Date Time column.
  21. Right click on the Updated Time column and choose Date Time

    image

  22. On the right side pane, expand the Steps area
  23. Notice that all the steps you performed are remembered.

    image

  24. Click the Done button
  25. Wait for data to be fetched

    image

  26. Now you can use this data in a Pivot Table or PowerView to analyze the FB data easily

    image

    This is a PowerView chart of one FB site

  27. Here is another one as a PivotChart based upon another public site

    image

 

Enjoy…
Now you can do sophisticated FB analysis without knowing any programming, FQL or Graph API syntax.

Explore Power Query.

It has a very powerful syntax. Yes it is complex but it is extremely powerful.
We will cover more of Power Query, Power View and Power Map in future posts.

11 thoughts on “Facebook analytics using Excel 2013 Power Query: Without programming!

  1. Pingback: Excel: Reading List | Efficiency 365

  2. Pingback: 200+ posts – 200,000+ users .. aiming for more zeros! | Efficiency 365

  3. Pingback: Marketing: Twitter Analytics using Excel | Efficiency 365

  4. Pingback: Jul 2014 Quiz Winner, Answers and Related Articles | Efficiency 365

  5. Pingback: Instant, Interactive 3D mapping of your data – Power Map | Efficiency 365

  6. Ty for this article 🙂
    may i ask some question..
    is it possible to get more than 100 Rows data if we chose connection by Statuses..?

    • Yes of course. There is no limit to the number of rows returned.

      If you are going to work on large amount of data on a regular basis, try to use 64 bit version of Excel and provide maximum possible memory.

  7. Pingback: Knowledge Pack: Data Analytics | Efficiency 365

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s