下载PDF
Sisense > 实例探究 > Marketing Firm Sees 60X Improvement in Development Time
Sisense Logo

Marketing Firm Sees 60X Improvement in Development Time

技术
  • 应用基础设施与中间件 - 数据可视化
  • 分析与建模 - 大数据分析
  • 分析与建模 - 预测分析
适用行业
  • Professional Service
适用功能
  • 商业运营
  • 销售与市场营销
服务
  • 数据科学服务
  • 系统集成
挑战
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.
关于客户
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.
解决方案
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.
运营影响
  • What had once taken Michael at least a week to put together for a new client, can now be done in 30 minutes.
  • His clients are happy because now their information isn't locked away with a single person, but is easily accessible to the people that write proposals to receive grants.
  • Requests that would typically take days and were static with no ability to dig deeper into the data are now, with a few clicks, actionable in determining what decisions should be made down to the smallest detail.
数量效益
  • 60x improvement in development time.
  • Program donations decreased by 15% from the prior year.

相关案例.

联系我们

欢迎与我们交流!

* Required
* Required
* Required
* Invalid email address
提交此表单,即表示您同意 IoT ONE 可以与您联系并分享洞察和营销信息。
不,谢谢,我不想收到来自 IoT ONE 的任何营销电子邮件。
提交

Thank you for your message!
We will contact you soon.