The demo application provides a way of comparing a brand or companies Facebook presence with that of competitors or other companies in their (or indeed any) sector.
Download
The latest version of the demo application can be downloaded below:
Facebook For Pages Demo Application V1.7.qvwNOTE - The only change in version 1.7 was to move to utf8 encoding to fix the issue users using Japanese or certain other languages were experiencing. If you were expereincing such issues you will need to delete any QVD files before first reloading with version 1.7 or later.
Usage
The demo download should be composed of a QVW file and a TXT file as illustrated below.
The idea is that all the configuration (for the Facebook pages to load, max number of items etc.) are contained in the config (.txt) file. This is commented up as shown below.
//
// You can set the maximum number of feed items to load here for each Facebook site. Note that
// not all sites will necessary have this number of items.
//
// Please Note: We recommend setting the maxNoOfFeedItems to be high the first time you run this application, so as to
// collect a lot of historical data.
//
let oldestFeedCreatedDateForInitialReload='01-10-2011';
let noOfFeedItemsBackToRefreshOnSubsequentReloads=100;
let noOfCommentsToLoadPerFeedItem=100;
/*
Edit the following table so that the left column contains the
FB page name or id and the right column contains a friendly name
to be used in charts.
*/
FacebookSites:
LOAD * INLINE [
page, Site
qlikview, QlikView
tableausw, Tableau
TIBCOSpotfire, Spotfire
ibmcognossoftware, Cognos
LogiXML, LogiXML
SAPSoftware, SAP
PowerPivot, PowePivot
microstrategy, Microstrategy
];
// This is the company from whose perspective you wish to view the
// dashboard. At present this is only used for the guage on the
// sentiment tab.
let vCompany='QlikView';
//
// If this is set to 1, the data will be refreshed
// each new day the script is reloaded and all the tables for
// that day will be stored to QVDs.
//
let vGetLatestData=1;
//
// Note should set up an account with Repustate or one of the other supported
// sentiment APIs and enter your API key into QVSource
//
let sentimentEngine1='Repustate';
//let sentimentEngine1='Random';
//
// At present the second sentiment engine is actually
// a random number generator. If you want to speed up your
// load script during testing you can set sentimentEngine1='Random'
// and includeSentimentEngine2=0
//
let includeSentimentEngine2=1;
let sentimentEngine2='Random';
//
// This table should reflect the choices you made for the above sentiment
// related variables.
//
SentimentAPIs:
LOAD * INLINE [
SentimentAPI, SentimentAPI_id
Repustate, 1
Random, 2
];
//
// Set a default to email address at the application level
//
let emailNotificationAddress = ''; // 'username@domain.com';
And changing it to a value of your choice.
Please note the following two points:
- It's possible that the Facebook page might not even contain this many items.
- The more items you specify here, the slower the reload will take (assuming there are this many items). This is primarily due to the large number of individual separate requests which need to be made to the sentiment API. The response from the Sentiment API should be cached by QVSource however meaning subsequent reloads will be faster.
Loading
Once you have edited the necessary script above and saved the config (.txt) file you should be able to reload the QVW file (don't forget to make sure QVSource is running).
Daily Reloads
You could also set this application up to reload daily. See the instructions
here and
here for getting started on this.
Screen Shots
Schema
