ANLY482 Team wiki: 2015T2 TeamROLL Project Overview
Description | Methodology |
About SGAG
Project Motivation
- What are the characteristics of a “great” post? SGAG has so far thrived on an intuitive understanding of their customer's content preferences. However, SGAG does not have a concrete or clear picture of the kinds of attributes which they can work on to make a specific post a "great" one.
- What is audience sentiment on "viral" posts? Are they reacting in a positive or negative manner? SGAG is concerned that "viral" posts become popular because they receive a lot of "hate", which goes against their content philosophy which is to make people "laugh", a positive emotion. Currently, they do not have easy visibility on this aspect.
SGAG hopes this project will be able to utilise a rich pool of historical data to derive insights into the concerns posed above, so that SGAG would be better able to formulate a more relevant content creation strategy.
Project Objective
The final goal of this project is to offer useful insights for SGAG to formulate a better content creation strategy moving forward. To measure the effectiveness of their content strategy, and at a more granular level, the effectiveness of each individual post, SGAG operationalises effectiveness as "growth" which is defined by an increase in 1) Number of fans, 2) Audience reach, and 3) Engagement with audience members. This last indicator is further measured by the number of times audience members perform actions such as “likes”, “comments”, “shares”, “retweets” or clicking on links to find out more about the content SGAG has to offer. To do so, we attempt to answer the two main challenges posed by SGAG in a concrete, data-driven manner by performing an in-depth analysis on SGAG's historical data. More specifically, we attempt to address the following analysis requirements:
- To be able to understand whether a post is popular in a “positive” or “negative” manner
- To assess the role of content layout and design in improving popularity of posts.
- To develop a list of common topics and be able to understand the role of topic-selection in affecting the popularity of posts
Analytical Objective
Taking into account the analytical problems faced, we aim to:
(i) Identify better performing posts and weak performing posts
- Based on clustering engagement level (number of likes, shares and comments)
(ii) Identify the patterns between the characteristics of a picture post and engagement level
- Based on the relationship between engagement level and picture design
- Picture design is based on the number of description lines, character used (e.g. Animals, Foreign celebrities) and the number of frames
- Picture design is based on the number of description lines, character used (e.g. Animals, Foreign celebrities) and the number of frames
(iii) Identify the pattern between engagement level and the topic discussed
- Based on the relationship between engagement level and picture tags
(iv) Identify the relationship between the performance of SGAG’s page and the topics discussed
- Based on the relationship between lifetime total likes (SGAG’s page) and frequently mentioned picture tags
(v) Identify the relationship between the composition of SGAG’s Facebook fans and the topics discussed
- Based on the relationship between the proportion of Male and Female fans from a range of age group and frequently mentioned picture tags
(vi) Identify time-series pattern (eg. the day and time posted) and cluster posts according to engagement level.
- Based on the date and time posted for every posts and the engagement level