Background:
Client is a Mobile apps developer with 20+ apps for kids. The apps are used in many countries and are available on multiple platforms.
The key ask was to evaluate the performance of the various apps based on region, subscription type, and platform to monitor the ecosystem's vitality and drive informed decisions.
Previously, data collection from the app store & play market was a manual process, requiring two days per month for a single individual and offering only limited insights. This monthly data collection method hindered the company from maintaining real-time information throughout the organization.
Challenges in data collection included:
- Over 20 different applications acting as sources of data.
- The necessity for multiple data splits.
- An official API safeguarded by a captcha and export limitations.
- Data sourced from various origins, demanding an optimized data view.
- The absence of a robust analytical infrastructure within the company.
Expected Project Outcome
- Automate the data export for mobile apps.
- Easy view to extract insights.
- Daily KPIs tracking.
- Automation of Reporting & Dashboards
Datrics approach to Solving the Problem:
To address the intricate challenges of data collection and analysis, Datrics adopted a robust systematic approach. Our strategy was not just about gathering data, but ensuring its relevance, accuracy, and ease of interpretation. Here's a detailed breakdown of the steps we took:
- Leveraged the platform to establish a robust analytical framework.
- Integrated both official and internal APIs, along with scrapers, for comprehensive data acquisition.
- Designed and automated data pipelines for efficient cleaning and preparation, tailored for analytics.
- Computed key metrics, established foundational analytics, and archived historical data in the database.
- Crafted specialized dashboards for analytics and product managers, with views specifically curated for business owners to derive insights effortlessly.
The Project Outcomes:
Datrics created a complete analytics solution for the client, from data gathering to visual display and routine reports, resulting in:
- Saving over 20 hours a month for analysts.
- A quick 4-week turnaround from initiation to launch.
- A dashboard customized to the client's needs.
- Data updates increased from once a month to daily.
- Access to more data for better decision-making and monitoring business health.
- No extra costs for analytical tools or infrastructure.