This will refresh the data model and build your new reports. Click the Friends worksheet (if you aren't already there).
#Microsoft excel data analysis 2013 download#
Once the download has been processed, click Close.Stop & Process Now to generate the reports with the list of friends already loaded. NOTE: If you have a large number of friends, you may have to wait a few minutes before the download process completes. In the authorization dialog, enter your Facebook credentials and then click.Click Analytics for Facebook within the ribbon.
Open the Analytics for Facebook 2013.xlsx file on your desktop.View summary insights by query into the public page data including breakdowns by location, category, number of check-ins and likes.Įxplore details about public page specifics, such as likes and check-ins by category and/or location. View summary insights by query into public post data including breakdowns by time, day, post type and number of likes, posts and posters.Įxplore details about public post specifics, such as word counts, poster, posting date, posting app and message and like count. See where your friends are located, broken down by various interest categories. Identify key demographics and interests of your Facebook friends. As such, the data that is reported on is dependent on the reliability and accuracy of the data that is presented by the Graph API.įacebook’s Graph API imposes a periodic limit on the number of data rows being returned when their servers are receiving too many requests, both in general and by IP/machine. Analytics for LinkedIn 2013 was developed around the Facebook Graph API for retrieving and downloading of all LinkedIn data.