Schedule a call with Gregory

Agency Co-Founder

Calendly

We use cookies to optimize your user experience. We also share information about your use of our site with analytics partners. By continuing to use our site you agree to using cookies in accordance with our Privacy Policy.

Accept

Discuss a partnership with us

Book 30 min call

Analytics for business with Yandex Cloud

Rostelecom approached our team with a request to customize and automate analytics for the Business Drive Academy project
The customer wanted a tool that would allow regular monitoring of relevant data in a single dashboard

View case

What goals did the customer want to achieve?

The previous team's attempts to customize analytics were not successful. The Google analytics counter used previously collected inaccurate data, and data from multiple sources had to be aggregated manually to calculate the cost per user.
Address management's concerns about the vulnerability of data being transmitted through external services
Avoid additional recurring fees for various services

The main conditions for choosing the service were:

avoid the use of additional paid services in the data chain, in particularly connectors for transferring costs from advertising systems;

the tools used should not be at risk of being shut down due to external events (sanctions or blocking).

Choice of tools

To implement the project, we chose Yandex Cloud. The platform meets the customer's objectives and contains a full range of compatible tools from data collection and storage (Yandex.Metrica, ClickHouse) to visualization (DataLens).

Scripts in Python were used to transfer raw data from Yandex.Metrica and AppMetrica to ClickHouse. Also, to avoid paid third-party connector services, they unloaded expenses from advertising accounts using Python.

Yandex.Metrica and AppMetrica have direct integrations with ClickHouse, which greatly simplifies a number of analytics tasks. But the transfer of some of the data we needed, such as expenses or Profile.id, was not supported by such integrations at the time of work, and we had to resort to writing scripts.

Stages of work

After we decided on the platform, the team started the main stages of work

What did we do?

1

Installed the counter "Yandex. Metrica" on sites

The project uses 2 websites:

A welcoming lending which attracts new users;
The main platform with courses, where users get to after registration.

2

Installed AppMetrica counter in iOS and Android apps

3

Set up conversions in "Yandex.Metrics"

Which conversions have been emphasized?

Conversions to introductory lessons.
Conversions to registration.
Registration on platform.
Lesson views on the platform.

4

We have configured the transfer of user event parameters

Each person registered on the platform is assigned a unique user identifier (UserID) ➡ Transfer them to Yandex. Metrics" as parameters of visits ➡ Bind them with ClientID of "Yandex. Metrics.

5

Created a database with the help of Managed Service for ClickHouse inside Yandex Cloud

6

Wrote scripts in Python

What has been finalized?

Transfer of expenses from "Yandex.Direct" and "VKontakte" advertising cabinet to ClickHouse.
Data transfer from Yandex.Metrics to ClickHouse.
Data transfer from AppMetrica to ClickHouse.

7

Created a virtual machine through Compute Cloud, downloaded the data transfer scripts and configured them to run regularly

How did you set up regular data upload to ClickHouse?

We created a virtual machine with Compute Cloud - a service inside Yandex Cloud for creating and managing virtual machines.
Uploaded data transfer scripts to the virtual machine and configured them to run on schedule.

8

We set up visualization in DataLens so that the client receives the final result of the analysis in the form of a dashboard

During the work created:

connection to ClickHouse;
datasets and merge data at dataset level;
charts;
dashboards.

Would you like the same?

Results

Through the work we ve done and combining the data in ClickNuse with subsequent visualization in DataLens, we ve accomplished the main objective -identifying the sources and cost of registrations in various slices

Visualization in DataLens allowed project managers to:

save team resources when preparing regular reports

Reallocate budget between channels and scale successful advertising bundles

promptly track all key metrics

monitor KPI indicators

Vsevolod Mazov

Head of project analytics

The guys did a great job, doing the job on time, on a turnkey basis and taking care of the operational control and communication with the project team. Thanks to the analytics customization there is no need to collect reports manually — everything is displayed in a single dashboard, which saves time for the team and the manager and allows them to focus on the project development.

I would like to note that from the very beginning, the Shevchenko. bz team offered several implementation options and a clear plan of action. Also in the process, the guys promptly helped to perform several additional tasks on setting up advertising systems. All deadlines were met and it was comfortable to work.

"

Conclusions

The Yandex Cloud suite of tools is suitable for much more complex scenarios of business analytics of corporate data. Without the risk of the tools and services falling under sanctions and the impact of foreign policy events

1

The Yandex Cloud data platform allows you to:

Combine all company data for analysis of any complexity and depth with minimal latency;
Host your sites and web services in the cloud for maximum scalability, resiliency and speed.

2

In doing so, the maximum is ensured:

Data Preservation. Provided by automatic backup and replication of data.
Information security. The cloud is placed in secure perimeter of three geographical data centers (located in Russia), complying with 152-FZ (the highest level of security UZ-1).
The speed of visualization is due to the built-in integration of the DataLens BI system from Yandex.

Book a call with Gregory

Discuss the goals and objectives of your project. Choose the best solution based on personal and agency experience. Evaluate the cost and potential benefits of cooperation.

Book a call

Would you like to do the same? Start by submitting an application

Send us a message
or mail [hi@shevchenko.bz]

By leaving a request, you agree to the Privacy Policy and the Rules for the processing of personal data

Other agency cases

case

Yandex training experts

Instagram account as the basis for future growth of the company's advertising revenue through available outreach channels.

Turn your Instagram account into an effective advertising channel.

Awards

Tagline Awards 2020-2021. Best special project with bloggers
Tagline Awards 2020-2021. Best Tricky Performance