ANLY482 AY2016-17 T1 Group6/Project Overview

Home

Team

Project Overview

Midterm Progress

Final Progress

Project Management

Documentation

Business Problem

TrustSphere has a sales team spread across APAC, US and the UK. This has made it hard for the Sales Director to track salespeople activity, especially in a fast-growing company.

Additionally, while a salesperson may be physically located in one particular office, TrustSphere’s salespeople tend to engage in business with clients internationally. A salesperson in Singapore might try to expand his sales into the UK, even though there are already local salespeople there. This also raises some questions about productivity. For instance, are two salespeople from different offices unnecessarily pursuing the same clients?

As a Relationship Analytics company, TrustSphere is also naturally curious about the networks its salespeople are involved in and their effects on sales performance. TrustSphere has pointed out that its salespeople have a tendency to work in silos instead of sharing information. Such behaviour is beneficial to the salesperson who gets to keep his leads to himself and enjoy greater earnings. However, this might negatively affect the company’s overall performance.

Research Objectives

We aim to analyze the sales team’s internal and external networks to gain insight into their communication strategy, to identify silos and any other red flags which may lead to adverse consequences for the company. We seek to develop metrics that would indicate sales health performance in terms of relationships.

On the whole, we seek to address these problems and present our insights by building a dashboard which allows the Sales Director an eagle eye’s view of the entire sales team’s performance and activity.

Scope

The research points we would like to address include:

1. Uncovering Insights into Network and Sales performance
   • Develop a measure to evaluate the quality of internal and external relationships formed, possibly using recency, frequency, TrustScore etc.
   • Discover opportunities through text analysis on salespeople’s email headers and placing them into an appropriate sales cycle. E.g. For Salesperson A, 50% of emails about closing, 20% about meetings
     
     
2. Analysing the Sales Team’s Internal Network
   • Analysing salespeople interactions with various other departments e.g. marketing
   • Deriving a collaboration score to observe how salespeople activate their internal connections to serve an account.
   • Deriving a salesperson’s influencer score within the organization using eigenvector centrality. This will include factors such as Hierarchy, Number of Ties, Strength of Ties to other influential people within the organization
   • Tracking a salesperson’s network trajectory i.e. how a salesperson’s internal network changes over time
     
     
3. Analysing the Sales Team’s External Network
   • Tracking the sent and response rate of emails
   • Identifying which client sectors a particular salesperson tends to interact with e.g. Healthcare, Education, Government
   • Measuring dependency of the firm’s business on a particular salesperson/a team of salespeople
     
     

Data

1. Daily email communication data

   This dataset contains daily email communication data (from May 2016 to present) and 6 variables deemed relevant in our visualization. A total of 70,000 entries are provided.

   • Date: Includes the date and time of a particular email being sent
   • Originator address: Sender email address
   • Recipient address: Receiver email address
   • Direction: Nature of communication (internal, inbound or outbound)
   • MsgID: Unique message ID of emails sent
   • Email Subject: Email subject header
     
     
2. Unique email relationship metrics of each sales employee

   This dataset lists all of TrustSphere sales employee’s unique relationships with both internal and external party. It includes their relationship metrics and contains 9 variables deemed relevant.

   • Contact domain: Sender’s email domain
   • Internal address: TrustSphere employee’s address
   • Contact address: Receiver’s email address
   • Trustscore: Relationship score calculated by TrustSphere (confidential)
   • Received: Number of emails received
   • Sent: Number of emails being sent
   • Last contact: Number of days last email was sent or received
   • Last in: Date and time of last email being received from a particular address
   • Last out: Date and time of last email being sent to a particular address
     
     
3. TrustSphere Staff List

   The dataset lists all of TrustSphere staff (57) with the following variables.

   • Name
   • Hierarchy
   • Department
   • Position
   • Location

References

³ http://dupress.com/articles/people-and-hr-analytics-human-capital-trends-2015/
⁴ Steward, M. D., Walker, B. A., Hutt, M. D., & Kumar, A. (2010). The coordination strategies of high-performing salespeople: Internal working relationships that drive success. Academy of Marketing Science.Journal, 38(5), 550-566. doi:http://dx.doi.org/10.1007/s11747-009-0170-0
⁵ https://hbr.org/2014/08/3-behaviors-that-drive-successful-salespeople