Marketing Firm Sees 60X Improvement in Development Time
Customer Company Size
SME
Region
- America
Country
- United States
Product
- Sisense
- Raiser’s Edge
Tech Stack
- SQL
- CSV
- Excel
Implementation Scale
- Enterprise-wide Deployment
Impact Metrics
- Productivity Improvements
- Customer Satisfaction
- Digital Expertise
Technology Category
- Application Infrastructure & Middleware - Data Visualization
- Analytics & Modeling - Big Data Analytics
- Analytics & Modeling - Predictive Analytics
Applicable Industries
- Professional Service
Applicable Functions
- Business Operation
- Sales & Marketing
Services
- Data Science Services
- System Integration
About The Customer
CAUSE + EFFECT Strategy and Marketing (CESM) specializes in providing in-depth insights and marketing strategy to clients. As VP of Client Service & New Business Development, Michael Sutton came from a lengthy tenure as a consultant in the nonprofit fundraising business. In 2014, along with his partners, he started CESM to build a data analytics firm to help companies, especially nonprofits, use data to influence all decisions made when developing a marketing plan. Originally working in Excel, Michael worried about it being too time-consuming with little flexibility, which was hiding insights. The move to Sisense gave CESM greater visibility in addition to dropping the effort involved in development by a factor of 60.
The Challenge
Michael says data streams included CSV, Excel, or Salesforce along with donations over time, who gave how much, when they gave it, and in what fundraising program. What may have looked like a very straightforward, neat, and organized Excel document from a foundation, actually possessed a great deal of insight that could be derived from it if the data was manipulated strategically. Michael’s goal was to dig into what donations amount to loyalty, how contributions come in, renewal rate, weight of attrition, and much more. On top of this, because CESM is looking at time series data and is able to look at time analysis, like seasonality or cycles of giving, there were even more insights to be discovered. However, after many days of work, all Michael could say was, for example, 'in 2006, your renewal rate was 60%.' Looking at data that was static, he was unable to go further without putting a lot more effort into it. It was time to find a better solution, and that is where Sisense came in.
The Solution
Many nonprofits use Raiser’s Edge or similar software to track and report on fundraising. While powerful, these tools require an understanding of SQL, which handicaps several companies. In addition, once the raw data is received, it has to be distilled and understood, which can take days. Michael had a client that needed to understand the effectiveness of one-off mailings, and how the new donors to that mailing list performed over time. Successful annual fund programs are built on repeat donors, so in order to make actionable decisions on programs, information like renewal rate, acquisition rate, and lapsed donor reactivation needs to be readily available. Michael developed a dashboard that makes it simple to compare this data across departments and years, taking into account lapsed years from single donors. Another client had seen their program donations decrease by 15% from the prior year, making leadership unhappy. After Michael took the data and ran it through his system, he was able to find that his client hadn’t lost the donor; the donor had simply shifted and was given to another department. Once leadership saw the whole picture, the problem was solved. However, under normal circumstances and without CESM, the client would not have developed a 3D view of their data, greatly affecting the outcome.
Operational Impact
Quantitative Benefit
Case Study missing?
Start adding your own!
Register with your work email and create a new case study profile for your business.
Related Case Studies.
Case Study
UBM plc: Taking the pulse of the business and engaging employees with a far-reaching strategic transformation
UBM, a leading global events business, was undergoing a significant strategic transformation named 'Events First'. As part of this transformation, the company was preparing to complete the largest acquisition in its history - Advanstar, a US-based events and marketing services business valued at more than USD970m. The company faced the risk of human capital flight if it was unable to effectively engage top talent with the new strategic direction. UBM needed to make significant structural, process and systems changes, uniting its previously autonomous regional businesses. The challenge was to ensure all of its employees were engaged and aligned with the new future vision.
Case Study
Wittmann EDV-Systeme launches IT monitoring services
Small and medium-sized businesses often lack the know-how and resources required for thorough IT system monitoring. Wittmann EDV-Systeme wanted to launch a solution to plug the gap – enabling it to improve its own competitiveness and that of its customers. IT landscapes are becoming ever more complex and outsourcing is gaining popularity, IT systems must nonetheless remain easy-to-use and extremely reliable at all times. Automated, round-the-clock system monitoring therefore represents an immensely valuable proposition for companies: downtime for business-critical applications can be avoided, and IT systems remain available at all times.
Case Study
Uncovering behavioral insight to help reward and retain the best employees
The HR services company, an IBM client, was facing the challenge of understanding the factors underlying personal employment choices. They wanted to offer their clients unprecedented insight into what motivates employees and prospective job candidates. However, their existing systems were not capable of handling the surging data volumes collected from a wide range of different data sources. With the total volume likely to keep on growing, the firm looked for a solution that could meet current needs and scale to meet tomorrow’s demands.
Case Study
Infosys achieves a 5–7 percent effort reduction across projects
Infosys, a global leader in consulting, technology, and outsourcing solutions, was facing significant challenges in application development and maintenance due to its distributed teams, changing business priorities and the need to stay in alignment with customer needs. The company used a mix of open source, home-grown and third-party applications to support application development projects. However, challenges resulting from distributed teams using manual processes increased as the company grew. It became more and more important for Infosys to execute its projects efficiently, so they could improve quality, reduce defects and minimize delays.
Case Study
Flex Contact Center: Supporting rapid business growth with IBM Connections Cloud and IBM Verse
Flex Contact Center, a professional services company offering telesales, call-center, anti-attrition, back-office, helpdesk and collection services, has grown rapidly since its establishment in 2009. With operations in 12 sites across two states and four cities in Brazil, the company employs more than 11,000 people. However, the company realized that to prevent barriers to future expansion, it was essential to make it as easy as possible for its people to work together effectively—even if they were based in separate geographical locations. Traditional approaches to collaboration—based on email and phone calls—threatened to reduce productivity. Flex Contact Center wanted to enable better collaboration and communication across its workforce, but did not want to make large investments in infrastructure.
Case Study
PureFluent: Connecting to partners and customers through the cloud for enhanced productivity
PureFluent, a translation services company, was facing challenges in managing its translation and document review processes. The company often received files in uneditable formats from customers, which required staff members to transfer text to word processing or spreadsheet documents. During the translation process, maintaining version control was a challenge because PureFluent sent work to hundreds of translators in multiple geographic locations. It was also time-consuming for staff to manage the large volume of emails and FTP transactions required to submit translations for customer review and ensure the integration of requested changes. Furthermore, staff were spending significant time hunting through their emails for specific attachments.
