Transparent Marketing Budget Allocation for Investment ROI Assessment: JustSchool Case

Client

JustSchool is an online English-language school on the cutting edge of EdTech, with expert teachers who deliver maximum value to their students.

Problem

The Client needed to build an effective analytical system from scratch to evaluate the ROI from the purchased traffic and gain valuable insights into their marketing initiatives.

Results

An analytical system built from scratch that automatically extracts data from AmoCRM into a database. Informative dashboards are generated for transparent budget allocation and efficient management.

Technologies

Our Tech Stack

Alexander Dolmatov,

Chief Marketing Officer

"It has been a pleasure working with Nikolai. First off, he tries to learn about the project in great detail to understand its needs. Secondly, the terms arranged in advance are almost always met, if there are no pitfalls along the way. And thirdly, you can come up to Nikolai with an idea and he knows how to turn it into a real project. That’s my best bet!"

Goal

JustSchool managed its leads in AmoCRM, which is an easy-to-navigate tool with poor analytical functionality. As a result, they couldn’t efficiently evaluate their investments in paid traffic and other marketing initiatives.

To overcome the challenge, they needed expert help from Valiotti Analytics to:

  • automatically extract a lot of data from AmoCRM into the right format for further processing
  • set up informative dashboards to gain valuable insights into marketing spend

Results

  1. Automated data extraction from AmoCRM to a ClickHouse database

The ultimate challenge was to set up data extraction and processing, considering a large data scope. We created a serverless infrastructure and automated data collection and processing based on category, which allowed for seamless data transfer from AmoCRM to the database.

To address the problem, we implemented the following steps:

  • Cluster creation to store and process data from AmoCRM.
  • Clickhouse database set up through Managed Service for ClickHouse, as well as the creation of tables to store AmoCRM data.

  • We set up an AmoCRM service account to manage Yandex.Cloud resources flexibly and assign roles.
  • We performed data extraction by category (users, contact details and emails, requests)

The final solution looks like this:

  • Flexible serverless infrastructure built with an API between AmoCRM, Yandex.Cloud, and Yandex DataLens, to collect, process, and upload data.

Yandex.Cloud

  • 7 functions to collect and process data based on the specifics
  • Python scripts to collect data
  • Custom data transfer algorithm, which is enabled automatically
  1. Data-rich dashboards in DataLens for transparent budgeting

For JustSchool to have access to transparent marketing budget spending and its ROI, we set up informative dashboards in several steps:

  • Two data sets were used to collect the final dashboard for the kids segment.
  • Based on the data sets, charts and dashboards were created. Now the Client can access all the information about the incoming leads, revenue, average spending per user, and sales. All this information can be analyzed within a category or various timeframes to better evaluate marketing investments.

Tips

  • Consider serverless architecture to focus on the case solution, leaving all the server-related problems to the provider. The same applies to a ClickHouse database, which is responsible for backup, monitoring, and updates while you only work with the database.
  • Choose an aligned tech stack to eliminate synchronization risks. If you work within a single tech environment (Yandex solutions in this case), your apps will seamlessly communicate with one another, which reduces the number of bugs and improves processing speed.

Learn How Data Insights Can Benefit Your Business

Wondering what value data insights can bring your business? Get in touch, and we'll answer your questions!

Contact Us

Technologies

Our Tech Stack

Alexander Dolmatov,

Chief Marketing Officer

"It has been a pleasure working with Nikolai. First off, he tries to learn about the project in great detail to understand its needs. Secondly, the terms arranged in advance are almost always met, if there are no pitfalls along the way. And thirdly, you can come up to Nikolai with an idea and he knows how to turn it into a real project. That’s my best bet!"

Other Case Studies

  • From Power BI to Metabase

    Our client needed to migrate slow, unstable Power BI dashboards to Metabase without changing their underlying data infrastructure. We rebuilt key sales and financial dashboards with better filtering, clearer visualizations, and improved performance, resulting in faster load times and dashboards that are actually usable at scale.

    Read more

  • Non-profit

    A government-funded nonprofit in Canada, needed analytics that worked for both daily operations and board-level reporting. We replaced manual Google Sheets with a cost-efficient data stack and built two distinct dashboards—one interactive and real-time for the team, and one static, branded snapshot for sponsors—so every stakeholder got exactly the data they needed.

    Read more

  • p2p Platform

    The client was scaling fast—but their data wasn’t. With fragmented reporting and no reliable way to measure ROAS or long-term user value, decisions stalled. We fixed that by building a unified data pipeline and dashboards that brought instant clarity to their growth strategy.

    Read more