Sisense Case Studies Crowd Media Turns Messy Data into Powerful Insights

Edit This Case Study Record

	Crowd Media Turns Messy Data into Powerful Insights Sisense

Crowd Media Turns Messy Data into Powerful Insights

Sisense

Technology Category	Application Infrastructure & Middleware - Data Visualization Analytics & Modeling - Predictive Analytics
Applicable Industries	Software Professional Service
Applicable Functions	Business Operation Sales & Marketing Quality Assurance
Services	System Integration Data Science Services Training
Challenge	The company’s marketing, operations, and finance departments all collect large quantities of data. The performance of various marketing channels (social media, television ads, influencer outreach, etc.) would generally be stored in spreadsheets, in addition to operational and financial data. As the business is global and data is coming in multiple formats from a variety of systems, the data was not uniform — it needed to be standardized before analysis. In the beginning, the company was working with a ‘data dump’ — a webpage with the relevant numbers, which could not be filtered or drilled into. As Crowd Media grew, so did their data and number of data sources. Suddenly, they were integrating Redshift DB, MySQL, and connecting to various APIs from Facebook Ads and App Annie in addition to their question/answer database. Ian wanted to generate more detailed reports on a daily basis that could be easily filtered by any user. At first Ian used Excel, but it soon became clear that a more robust system was needed. Read More
About Customer	Founded in 2009, Crowd Media is a global mobile entertainment and micro job company that allows customers to crowdsource answers to questions from experts around the world. The company has a diverse team of over 1000+ dedicated researchers, working in 28 languages, across 40 countries, answering millions of questions per year. Crowd Media's primary focus is on providing expert assistance and insights through various channels, including mobile apps. The company aims to leverage data to improve its marketing, operations, and customer retention strategies. With a global presence and a large volume of data coming from multiple sources, Crowd Media needed a robust BI tool to manage and analyze this data effectively. Read More
Solution	An external consulting agency implemented a competing BI product, but Ian wasn’t happy with this tool’s charting and dashboarding features. Searching for a replacement, Crowd Media considered three BI options, one of them Sisense. After building a few KPI dashboards during the trial period, Ian felt that Sisense was the most intuitive BI tool on the market due to its sophisticated charting abilities and how easy it is to grant contributor access to additional teams that could “get in and do their own thing”. For these reasons, as well as an attractive and flexible pricing model, Crowd Media chose Sisense. Deployment of Sisense was a very straightforward process, and Crowd Media had an Elasticube and a dashboard up and running even before the first onboarding session. Today, Crowd Media uses Sisense to find the best-performing markets and channels, calculate earnings from text messages, taking into consideration the researchers’ fees and marketing costs, and increase overall customer retention. The heaviest Sisense users are in the marketing department. A live dashboard is displayed on a large TV monitor, displaying the most frequently asked questions in the past 15 minutes, along with a map showing which countries have the highest usage. Different marketing campaigns and initiatives are tracked through Sisense and these insights are then used to improve marketing efforts. The dashboards are on all the time and also used to monitor problems — if there is a sharp downward percentage change, this could indicate an issue with marketing efforts or technical difficulty. Read More Log in to view content
Contents

Technology Category

Application Infrastructure & Middleware - Data Visualization

Analytics & Modeling - Predictive Analytics

Applicable Industries

Software

Professional Service

Applicable Functions

Business Operation

Sales & Marketing

Quality Assurance

Services

System Integration

Data Science Services

Training

Challenge

The company’s marketing, operations, and finance departments all collect large quantities of data. The performance of various marketing channels (social media, television ads, influencer outreach, etc.) would generally be stored in spreadsheets, in addition to operational and financial data. As the business is global and data is coming in multiple formats from a variety of systems, the data was not uniform — it needed to be standardized before analysis. In the beginning, the company was working with a ‘data dump’ — a webpage with the relevant numbers, which could not be filtered or drilled into. As Crowd Media grew, so did their data and number of data sources. Suddenly, they were integrating Redshift DB, MySQL, and connecting to various APIs from Facebook Ads and App Annie in addition to their question/answer database. Ian wanted to generate more detailed reports on a daily basis that could be easily filtered by any user. At first Ian used Excel, but it soon became clear that a more robust system was needed.

About Customer

Founded in 2009, Crowd Media is a global mobile entertainment and micro job company that allows customers to crowdsource answers to questions from experts around the world. The company has a diverse team of over 1000+ dedicated researchers, working in 28 languages, across 40 countries, answering millions of questions per year. Crowd Media's primary focus is on providing expert assistance and insights through various channels, including mobile apps. The company aims to leverage data to improve its marketing, operations, and customer retention strategies. With a global presence and a large volume of data coming from multiple sources, Crowd Media needed a robust BI tool to manage and analyze this data effectively.

Solution

An external consulting agency implemented a competing BI product, but Ian wasn’t happy with this tool’s charting and dashboarding features. Searching for a replacement, Crowd Media considered three BI options, one of them Sisense. After building a few KPI dashboards during the trial period, Ian felt that Sisense was the most intuitive BI tool on the market due to its sophisticated charting abilities and how easy it is to grant contributor access to additional teams that could “get in and do their own thing”. For these reasons, as well as an attractive and flexible pricing model, Crowd Media chose Sisense. Deployment of Sisense was a very straightforward process, and Crowd Media had an Elasticube and a dashboard up and running even before the first onboarding session. Today, Crowd Media uses Sisense to find the best-performing markets and channels, calculate earnings from text messages, taking into consideration the researchers’ fees and marketing costs, and increase overall customer retention. The heaviest Sisense users are in the marketing department. A live dashboard is displayed on a large TV monitor, displaying the most frequently asked questions in the past 15 minutes, along with a map showing which countries have the highest usage. Different marketing campaigns and initiatives are tracked through Sisense and these insights are then used to improve marketing efforts. The dashboards are on all the time and also used to monitor problems — if there is a sharp downward percentage change, this could indicate an issue with marketing efforts or technical difficulty.

Impact #1	The operations department uses Sisense to generate a report that shows the response rate of individual researchers, and the researchers whose answers led to customers returning to ask more questions. This reveals who the best researchers are, and also enables the operations managers to improve the work of the other researchers.
Impact #2	The finance department uses Sisense to visually represent data for board reports.
Impact #3	Crowd Media plans to launch a new line of products soon, focused on mobile apps delivering expert assistance on a variety of topics. They plan to use Sisense to track data gathered from these apps and expect to see similar global success as they have with their current products.

Impact #1

The operations department uses Sisense to generate a report that shows the response rate of individual researchers, and the researchers whose answers led to customers returning to ask more questions. This reveals who the best researchers are, and also enables the operations managers to improve the work of the other researchers.

Impact #2

The finance department uses Sisense to visually represent data for board reports.

Impact #3

Crowd Media plans to launch a new line of products soon, focused on mobile apps delivering expert assistance on a variety of topics. They plan to use Sisense to track data gathered from these apps and expect to see similar global success as they have with their current products.

Benefit #1	Crowd Media manages and mobilizes a team of over 1000+ dedicated researchers.
Benefit #2	The team works in 28 languages, across 40 countries.
Benefit #3	They answer millions of questions per year.

Benefit #1

Crowd Media manages and mobilizes a team of over 1000+ dedicated researchers.

Benefit #2

The team works in 28 languages, across 40 countries.

Benefit #3

They answer millions of questions per year.

Download PDF Version

Overview

Crowd Media Turns Messy Data into Powerful Insights

Operational Impact

Quantitative Benefit