Challenge: The customer, a US affiliate marketing network, has been slowly and steadily growing into a large network of sister companies. As time passed, there were multiple spin off and M&A opportunities so today, the network currently contains publishers, an affiliate marketing platform, an email marketing infrastructure company, an email deliverability SaaS and a holding company.
The global nature of their operations as well as the intricate relations between the participants makes aggregated financial reporting challenging and time consuming
We have helped them adopt the Domo Business Intelligence platform and use it as a centralized, unique source of truth place where they can get an accurate understanding of the health of their finances.
The challenges they were facing were very common to the challenges global and multinational companies are facing: they have business units, subsidiaries and incorporated companies in multiple countries, subject to different accounting regulations, located under different time zones, conducting their business in different currencies.
As such, answering a simple question like “how much revenue did we generate yesterday?” becomes difficult to answer and involves receiving and aggregating different reports, files, pdfs and emails on a daily basis.
In order for the executive team to have a unified view of the entire subsidiaries and offices financials, usually there are 2 solutions:
To solve this problem and allow the executive team to have access to daily refreshed information and have the opportunity to timely ensure the company meets its target, we have automated the finance reporting process.
Having standardized this, we have, then, developed a dashboard that allows the executive team to monitor the financial health of the organization:
The report allows the company to monitor the actual results compared to the target, at daily, MTD (month to date) and YTD levels. Moreover, the underlying calculations create an estimate of how much revenue they could be able to generate based on past performance.
MongoDB, MariaDB, Domo, Python
©2024 All rights reserved