Difference between revisions of "AY1516 T2 Group 18 Project Overview"

From Analytics Practicum
Jump to navigation Jump to search
Line 47: Line 47:
 
==<div style="background:#ff4fa7; padding: 10px; font-size: 14px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #D3D3D3 solid 25px;"><font color="white">Project Motivation</font></div>==
 
==<div style="background:#ff4fa7; padding: 10px; font-size: 14px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #D3D3D3 solid 25px;"><font color="white">Project Motivation</font></div>==
  
With the advent of the internet and digital devices over the past decade, it has become increasingly complex to understand and influence the choices of consumers. The media landscape has been shifting and traditional marketing approaches no longer work as well today. Many companies now rely on digital marketing to reach out to consumers, where digital media growth have been estimated at 4.5 trillion online advertisements served annually with digital media spend to be at 48% in 2010. As such, it brings forth the need to formulate new marketing approaches in connecting today’s consumers with companies. TNS hopes to generate actionable insights from the dataset of the Connected Life study that will help marketers come up successful marketing strategies to aid business decisions.<br><br>
+
With the advent of the internet and digital devices over the past decade, it has become increasingly complex to understand and influence the choices of consumers. The media landscape has been shifting and traditional marketing approaches no longer work as well today. Many companies start to rely on digital marketing to reach out to consumers, where digital media growth have been estimated at 4.5 trillion online advertisements served annually with digital media spend to be at 48% in 2010. Whilst that is true, the power of traditional marketing approaches cannot be considered obsolete nor neglected in any way as there are cases when dealing with certain products and consumers where it still proves to be more effective. As such, businesses now face a difficulty in deciding and allocating the right amount of marketing resources to reap the best results from their target consumers.
 +
<br><br>
  
As the study covers across 50 countries and over 58 product categories, we will be delving down and focusing on Singapore and Malaysia markets, and the Fast-Moving Consumer Goods (FMCG) sector for the purpose of our analysis.
+
As the Connected Life study conducted by TNS covers across over 50 countries and 58 product categories, we have been given the datasets from two markets - Singapore and Malaysia for our project. Delving down, we have chosen to focus our efforts on the Personal Care sector, under the branch of Fast-Moving Consumer Goods (FMCG) industry for the purpose of our analysis.  
  
 
<div align="left">
 
<div align="left">
Line 55: Line 56:
 
==<div style="background:#ff4fa7; padding: 10px; font-size: 14px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #D3D3D3 solid 25px;"><font color="white">Project Objectives</font></div>==
 
==<div style="background:#ff4fa7; padding: 10px; font-size: 14px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #D3D3D3 solid 25px;"><font color="white">Project Objectives</font></div>==
  
The aim of this project is to help marketers from the FMCG industry identify target consumer profiles, digital media platforms, and as well as devices to allow for more targeted marketing strategies, thus maximizing return on investment (ROI) on their business decisions.<br><br>
+
The aim of this project is to help marketers from the FMCG - Personal Care industry to identify target consumer profiles, digital media platforms, and as well as devices to allow for more targeted marketing strategies, thus maximizing return on investment (ROI) on their business decisions.<br><br>
  
As a market research company, TNS would need to present its findings and insights from the study to senior management and marketers from various companies. As such, our aim is to provide an interactive and dynamic dashboard that will instinctively display crucial actionable insights to marketers without the need for them to be equipped with technical knowledge, nor spending time delving into the data themselves.<br><br>
+
In order to do so, we have identified 5 main objectives that we would like to answer by the end of this project. These objectives follow through a step-by-step process of identifying, connecting, engaging, and lastly, having the power to influence at the end of it:<br>
 
 
The final deliverables will therefore aim to:<br>
 
*Identify FMCG target consumer profiles, digital media platforms they should use, and the type of device(s) used to best engage and connect with target consumers
 
*Allow end users to visualize data findings and generate actionable insights through the means of an interactive and dynamic dashboard
 
 
 
<br>
 
 
 
In order to achieve these objectives, more granular questions must be answered through the course of our analysis:<br>
 
 
*Who are our target consumers?
 
*Who are our target consumers?
 
*What are the digital media platforms and devices that allow marketers to get to my target consumers and connect with them?
 
*What are the digital media platforms and devices that allow marketers to get to my target consumers and connect with them?
Line 71: Line 64:
 
*What are the digital media platforms and content that needs to be prioritized in order to drive engagement and advocacy amongst the target consumers?
 
*What are the digital media platforms and content that needs to be prioritized in order to drive engagement and advocacy amongst the target consumers?
 
*After engagement is done, how do marketers influence the mindsets and decisions of the connected consumer?
 
*After engagement is done, how do marketers influence the mindsets and decisions of the connected consumer?
*How are marketers going to improve their company’s performance in order to enhance the connected customers’ satisfaction?
 
  
 
<br>
 
<br>
Line 77: Line 69:
 
<div align="left">
 
<div align="left">
  
==<div style="background:#ff4fa7; padding: 10px; font-size: 14px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #D3D3D3 solid 25px;"><font color="white">Project Scope</font></div>==
+
==<div style="background:#ff4fa7; padding: 10px; font-size: 14px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #D3D3D3 solid 25px;"><font color="white">Project Methodology</font></div>==
  
The project scope can be split into 4 main areas. They are the Overview, Digital Media Platforms, Devices and Consumers interactive visualizations. The overview visualization is a compilation of key indicators to support operational decision-making by senior management. The other three areas are visualizations that allow marketers to work around the selections and graphics to gain deeper understanding and insights about the data.<br><br>
+
See <b><u>[[AY1516 T2 Group 18 Data|here]]</u></b> for more information about our data<br><br>
  
In order to visualize the data, the data should be cleaned in various ways such that allows meaningful visualization to take place. Fields that are irrelevant or redundant are removed or replaced with human readable detail for ease of visualization. For example, fields that are empty.<br><br>
+
<b>&nbsp;&nbsp;&nbsp;&nbsp;Modelling Process:</b><br>
 +
[[Image: Modelling process.png|300px|link=]]<br><br>
  
The 4 visualizations cannot be done without first understanding what data is available for each of the visualization. After consolidating the data, prototyping of the visualization is important as it give us an idea what are we trying to achieve and whether our visualizations actually help achieve the intended goals. <br><br>
+
After data preparation, we first sieved out a set of relevant variables from the dataset that would help to answer each of our 5 objectives (i.e. identify target segments and their digital behavior to allow marketers to connect to them, identify how to engage target consumers and prioritize marketing efforts, and lastly, identify the ways to influence their decisions). We employed the use of different sections of the questionnaire variables to help us answer the different phases and needs of the objectives.<br><br>
  
Implementation of the actual visualization shall begin after the prototype has been decided.
+
Before we construct our model, we carried out exploratory data analysis by looking at the data distributions across all variables. Besides ensuring that the data has been properly cleaned, it also helps us to get a feel of the distribution of responses for each question and whether it makes sense, and helps us to form initial expectations of the results. For example, we split the distributions according to the response variable (G1. Products purchased P4W - NET - Personal Care) into customers and non-customers of Personal Care to see if there are any obvious discrepancies or patterns in the distributions of the potential predictor variables. We then use that observation to form initial expectations of our model. An example would be Gender, where we observed a greater proportion of female as compared to male who are customers of Personal Care, while the reverse is observed for people who do not buy Personal Care products.<br><br>
  
 +
The Likelihood Ratio and Pearson’s chi-squared tests were then carried out to determine and sieve out statistically significant variables at the 0.05 level. After which, a test of association between all (categorical) variables against each other was then carried out to ensure that the variables selected for model building in the later phase are all independent variables. This helps to ensure the accuracy of our end results.<br><br>
  
<div align="left">
 
 
==<div style="background:#ff4fa7; padding: 10px; font-size: 14px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #D3D3D3 solid 25px;"><font color="white">Project Methodology</font></div>==
 
 
See [[AY1516 T2 Group 18 Data|here]] for more information about our data<br><br>
 
  
<b>The technologies to be used in the project are:</b><br>
 
1. D3.js, a Javascript library that provides numerous functions to manipulate data and drawing of graphics.<br>
 
2. JMP Pro, a statistical data discovery tool. We use this tool in data cleaning and preparation.<br><br>
 
  
<b>Visualizations</b><br>
 
1. Overview<br>
 
&nbsp;&nbsp;&nbsp;&nbsp;a) This visualization aim to provide senior management the summary of key indicators for operational decision support. <br>
 
&nbsp;&nbsp;&nbsp;&nbsp;b) Key indicators includes<br>
 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;i. Digital Media Platforms<br>
 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1. Percentage of consumers engaged in the various digital media platforms<br>
 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2. The periods of the day consumers are most actively engaged in digital media such as In bed after waking up or early/late morning<br>
 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3. The platforms in which certain categories of products are most engaged by consumers such as mobile application for emails and purchasing of movie tickets<br>
 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;ii. Devices<br>
 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1. Percentage of consumers engaged through the various devices<br>
 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2. The periods of the day consumers are most actively engaged in various devices<br>
 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;3. The various services engaged by consumers with a certain device such as the laptop/tablet for watching movie and purchasing of apparels<br>
 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;iii. Consumers Profiles<br>
 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;1. The common characteristics of consumers that are actively participating in eCommerce such as having both internet connection at home with laptop/tablet and smartphone<br>
 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;2. The category of services that the various groups of consumers engaged in such as consumers age between 16 - 24 are more active in the area of movies and TV<br><br>
 
[[Image: Visualization1.png|400px|link=]]<br><br>
 
2. Digital Media Platforms<br>
 
&nbsp;&nbsp;&nbsp;&nbsp;a) This visualization aim to allow marketers to gain insights from the manipulation of the data and various graphical representations regarding activity of the digital media platforms<br><br>
 
[[Image: Visualization2.png|600px|link=]]<br><br>
 
[[Image: Visualization3.png|350px|link=]]<br><br>
 
3. Devices<br>
 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;a. This visualization aim to allow marketers to gain insights from the manipulation of the data and various graphical representation regarding the various devices engaged by the consumer<br><br>
 
[[Image: Visualization4.png|450px|link=]]<br><br>
 
[[Image: Visualization5.png|450px|link=]]<br><br>
 
4. Consumer Profiles<br>
 
&nbsp;&nbsp;&nbsp;&nbsp;a. This visualization aim to allow marketers to gain insights from the manipulation of the data and various graphical representation regarding the profiles of consumers<br><br>
 
[[Image: Visualization6.png|400px|link=]]
 
 
<br><br>
 
<br><br>
 
<div align="left">
 
<div align="left">

Revision as of 21:43, 28 February 2016

HOME

 

PROJECT OVERVIEW

 

DATA

 

PROJECT MANAGEMENT

 

DOCUMENTATION


Taylor Nelson Sofres (TNS) is one of the largest research agencies worldwide. They provide actionable insights to help companies make impactful decisions that drive growth. TNS is part of Kantar, one of the world's largest insight, information and consultancy group.

Introduction and Project Background

Understanding your target audience remains at the heart of successful marketing. The Connected Life is TNS's global syndicated study to understand connected consumer better. It is the largest and most comprehensive study of digital behavior of global consumers across the world.

The need for the study includes the following:
a) There was a gap in the market as no one was offering such comprehensive information about digital consumers
b) It was cost prohibitive for one client to undertake such a global venture and hence, clients were only doing these studies selectively and where budgets allowed
c) Other studies which also claim to have such a global footprint were either by publishers themselves or by media agencies, thus clients are apprehensive that the analysis offered by them is biased and hence an independent study like Connected Life has great appeal.

Project Motivation

With the advent of the internet and digital devices over the past decade, it has become increasingly complex to understand and influence the choices of consumers. The media landscape has been shifting and traditional marketing approaches no longer work as well today. Many companies start to rely on digital marketing to reach out to consumers, where digital media growth have been estimated at 4.5 trillion online advertisements served annually with digital media spend to be at 48% in 2010. Whilst that is true, the power of traditional marketing approaches cannot be considered obsolete nor neglected in any way as there are cases when dealing with certain products and consumers where it still proves to be more effective. As such, businesses now face a difficulty in deciding and allocating the right amount of marketing resources to reap the best results from their target consumers.

As the Connected Life study conducted by TNS covers across over 50 countries and 58 product categories, we have been given the datasets from two markets - Singapore and Malaysia for our project. Delving down, we have chosen to focus our efforts on the Personal Care sector, under the branch of Fast-Moving Consumer Goods (FMCG) industry for the purpose of our analysis.

Project Objectives

The aim of this project is to help marketers from the FMCG - Personal Care industry to identify target consumer profiles, digital media platforms, and as well as devices to allow for more targeted marketing strategies, thus maximizing return on investment (ROI) on their business decisions.

In order to do so, we have identified 5 main objectives that we would like to answer by the end of this project. These objectives follow through a step-by-step process of identifying, connecting, engaging, and lastly, having the power to influence at the end of it:

  • Who are our target consumers?
  • What are the digital media platforms and devices that allow marketers to get to my target consumers and connect with them?
  • How do marketers improve their touchpoint planning?
  • What are the digital media platforms and content that needs to be prioritized in order to drive engagement and advocacy amongst the target consumers?
  • After engagement is done, how do marketers influence the mindsets and decisions of the connected consumer?


Project Methodology

See here for more information about our data

    Modelling Process:
Modelling process.png

After data preparation, we first sieved out a set of relevant variables from the dataset that would help to answer each of our 5 objectives (i.e. identify target segments and their digital behavior to allow marketers to connect to them, identify how to engage target consumers and prioritize marketing efforts, and lastly, identify the ways to influence their decisions). We employed the use of different sections of the questionnaire variables to help us answer the different phases and needs of the objectives.

Before we construct our model, we carried out exploratory data analysis by looking at the data distributions across all variables. Besides ensuring that the data has been properly cleaned, it also helps us to get a feel of the distribution of responses for each question and whether it makes sense, and helps us to form initial expectations of the results. For example, we split the distributions according to the response variable (G1. Products purchased P4W - NET - Personal Care) into customers and non-customers of Personal Care to see if there are any obvious discrepancies or patterns in the distributions of the potential predictor variables. We then use that observation to form initial expectations of our model. An example would be Gender, where we observed a greater proportion of female as compared to male who are customers of Personal Care, while the reverse is observed for people who do not buy Personal Care products.

The Likelihood Ratio and Pearson’s chi-squared tests were then carried out to determine and sieve out statistically significant variables at the 0.05 level. After which, a test of association between all (categorical) variables against each other was then carried out to ensure that the variables selected for model building in the later phase are all independent variables. This helps to ensure the accuracy of our end results.




Project Limitations & Asssumptions

  • Datasets given by the sponsor are only based on 2 markets - Singapore and Malaysia, and thus the analysis cannot be a representative for other markets.