Case Studies

Lottery business increases sales by 20% using hyper targeting

Industry:

National Lottery

Challenge:

Our client is one of the largest advertisers in their country of operation. However their data was spread across multiple systems and held by many third parties. Understanding the impact of advertising was a real challenge. Due to the disparate nature of their databases, it was challenging to target their customers with specific targeted messaging at the right time.

Solution:

Ddaas enabled our client to measure the return on investment on their core marketing. We measured spend and revenue on TV, radio and SMS. We provided real time analysis down to the minute of performance per advert. Our client was able to decrease spend on advertising while increasing the effectiveness of it. This is a market first solution.

Rather than the same messages being sent to all customers, Ddaas would use data from multiple sources to provide My Lotto Kenya with intelligence such as the customer name, when they last purchased a ticket and how much they won. This enabled My Lotto Kenya to create a timely SMS message for each customer, which had a significant impact on weekly ticket sales for the company.



TV & Broadband company reduces costs and increases access to timely reports

Industry:

Pay TV & Broadband

Challenge:

Our client, a national Premier television, internet and data provider offers over 117 TV channels, set top boxes and a range of subscription packages to a wide and varied customer base across the region.

As the business has grown they lacked a suitable business intelligence solution that would maximise the value of their growing data stores. As with a lot of TV and Telecoms businesses, the systems are legacy in nature and difficult to modernize.

Solution:

Having extracted all the information from numerous CRM and billing systems using data warehouse automation techniques, we were able to provide detailed intelligence reports about the business and its variety of revenue streams.

Analysing the data, we were able to see and understand in more detail, areas such as revenue per product, region and city over a time period, digital box usage and earnings per month, volume of customers per price band and churn through disconnects and reconnects.



Pension auto-enrolment market leader stream-lines their management reporting

Industry:

Financial Services

Challenge:

Our client (huskyfinance.com) is a market leader in enabling companies to setup and manage their company pensions. It is a complex business that integrates with many pension providers and sells to all types of industries and company sizes. They have a very well structured sales and account management organisation. They successfully use Sales Seek CRM (www.salesseek.com) to manage their sales pipeline. Their challenge was bringing data together from Sales Seek and their own internal customer and billing systems in order to get a real time view of their business. This was being carried out by the IT department and analyst staff to create and maintain Excel spreadsheets and PowerPoint reports for management. This was a costly process and difficult and time consuming to create new reports.

Solution:

Ddaas setup data warehouse automation tasks to pull data from all of the systems through a combination of file extracts and API integrations. Our Sales Seek API integration is now available for any of our clients to take advantage of. Raw data is cleansed and aggregated automatically on a regular schedule. Microsoft Power BI reports take this data to present management KPI reports on demand. The team can simply open Power BI and see the current state of the business at any time without any manual intervention. This has resulted in real value to our client with real time accurate reporting and a significant cost reduction in managing the process.



DEDICATED SUPPORT

Ddaas provide end-to-end support from conception to integration and beyond, ensuring your data is always available when you need it