Posts Tagged: data analysis

Dec 11

What Facebook Should Do With Gowalla

With the rumour out that Facebook is looking to purchase location based social network Gowalla,  discussion is beginning about what the social network could use this new asset for. While Facebook’s location based services haven’t yet caught on, for myself and I’m sure many other data focused marketers the potential of having a successful location service which is tied in with Facebook has been the subject matter of maybe a few dreams!

The Potential For Location Based Data

In a recent update of its systems Facebook has improved the insights dashboard that fan page owners can use to analyse their efforts. Companies can now have a more in depth look at how and how much of their fan base and Facebook users in general interact with the brand generated messaging  being  put out. Adding data from a location based service could add an even deeper (and more meaningful) additional layer to these new features.

There is a large list of potential benifits to measurement and analysis that location based data could create (I’ve had some time to think about it) but in regards to Facebook and fan pages I can think of particularly two scenarios of how location based data could be used when thinking  about brands with retail locations:

Analysis As To What Drives Fans To Purchase: Businesses could potentially see the correlation between the traffic to their stores and the content they had posted during a particular time frame. In the case of for example a product announcement,  a company could potentially measure check ins to the company’s stores to see if there was an increase in visits and linking it back to the firms sales data they could determine if against past product launches there was an increase of decrease in sales.

Determining Where Your Fans Shop: For retail chains knowing the makeup of your customer base on a store by store level is another potential use. By taking a look at the demographic data of users who have checked in, the firm can see if a particular type of customer is more likely to shop at a certain location. From this data  the firm can also have a look if there any particular purchasing trends among this sub set. Looking at this data in a time series could additionally provide insight as to if particular promotions or products should be added or augmented to fit the particular grouping of customers.

In the next few weeks we’ll see if the rumours of Gowalla’s acquisition by Facebook are true or if a few news sources  have to maybe review who they get their info from ;) . None the less, for companies on Facebook and otherwise tapping into the databases of  location based services still hold a lot of potential for improving their results. As brands continue to look deeper into the data that’s available through social media and online sources cwe’ll have to see if these location based services will come into play.




Nov 11

Can I Get Dirty With Your Data?

The initial steps of data analysis; Collecting data from various sources, ensuring the accuracy of the data and then putting it all into a legible format. Doing the grunt work of social media analytics (or really any data analysis) is not the most fun or glamorous part of the process but through my experience I’ve learned that having this level of intimacy with your data is an important  part of in ensuring the delivery of solid insight and analysis .

Getting In Close With The Numbers

Having to compile the different parts of your data puts you at a level of closeness with it that is not as easy to get otherwise. Entering in each source and dealing with all the tools you see almost instantly when there is a gap or significant change within your metrics because you see all the data points in front of you. Compare this with just getting summary data and you just get a snap shot of the entire picture of what is happening. Let’s just say this is like taking your data out for the day compared to having a quick phone call with them. One is much more effective in getting your desired result than the other.

Dressing up your data. Picture C/O Exey Panteleev


Having Your Way with The Data:

When all of the grunt work is done and your data set is put together and prettied up you tend to already have a sense of what you want to explore when you actually go and do your analysis. You’ll know where all the sweet spots are and try to determine why things happened the way they did. Experiencing all the parts of the data as a whole rather than in separation there’s a better understanding of the linkages and causes of change in the data. You are better able to see where something went up as a result of X or Y action. By having your hands in everything means you are able to get in there and push the right buttons to get the best end result.

Growing Old Together:               

In my work there have been some data sets that I’ve dealt with for a LONG time, sometimes since their inception going months back. Much like a long term relationship with a person you can get a read on when things are going as per usual or even great but you can also see when there is a significant drop off or unexpected event. In this sense your mental set is more finely tuned to see the trends and linkages within your data store. When your data set is mad at you, you know almost immediately to do something to fix it!

The 'sexy' end result. Picture C/O @BenLucier


Setting Yourself Up For The “Money Shot”

When all is said and done, the data is all in and you’re fully into writing the report, by knowing your data you are able to tell the right story and enter in the best summary metrics to share with your client. In the end, the job of an analyst is to see the data and make sense of it in the best way possible for your specific audience. Your “money shot” in all of this is when your client is sent off with the best insight and recommendations that they can take action on. When they are happy that they are seeing improvement in their operations or learning something useful that they can apply to their business this means increased results and profit for your organization. Essentially  something people will pay to see ;).