Case Studies

Rozetka increases average order value by 9% and direct marketing revenue by 18%

Alyona Samovar1 min readEcommerceMarketplace data model

9% increase in average order value

Rozetka increases average order value by 9% and direct marketing revenue by 18%

Objective

Objective

Rozetka constantly implements new functionality to increase sales volumes. As the market leader, the company’s customer database offers huge potential for monetization through repeat sales. Meanwhile, thanks to the site’s variety of products and significant visitor numbers, they have a large database that can serve as a source for recommendations based on user behaviour and transactions.

With the goals of increasing revenue per user and average order value, Rozetka needed help with product bundling, merchandising, product recommendations and email campaigns. Supported by OWOX analytics specialists, the company implemented a product recommendation system based on data from Google Analytics Related Products functionality. This data could then be used for direct marketing in user emails.

Solution

Solution

The first step was to implement a system in Google Analytics to gather structured data about user interactions with products from all touchpoints, including

  • The desktop site (via Google Tag Manager for web).
  • The mobile-optimised site (via Google Tag Manager for web).
  • Apps (via Google Tag Manager mobile apps SDK).
  • The call centre (via operator extension and Google Tag Manager for web).

The second step was to export the product relations data from Google Analytics using Core v3 Reporting API, then import it into BigQuery. This increased the quality of recommendations data by:

  • Verifying the product availability status.
  • Excluding goods from incompatible categories.
  • Excluding goods that users had already purchased.

The final step was to create direct marketing lists with improved email recommendations.

Results

Results

Direct marketing revenue increased by 18%.

Average order value increased by nearly 9%.

The Turning Point

OWOX Data Marts

See your first report built in real time. 15 minutes.

  1. Connect your data warehouse
  2. Pick your metrics
  3. Get a live Google Sheets report

In the time it takes to write a ticket. Then imagine never writing that ticket again.

Book a Demo

We'll use your actual use case

Your New Normal

Turn your data into decisions.

Governed data marts give you the clean foundation ML needs to actually work.

  • No AI hallucinations
  • Analyst-governed definitions
  • Every number traces to SQL
Get started free

Who wrote this

Alyona Samovar

Alyona Samovar Senior Digital Analyst

Alyona Samovar is a Senior Digital Analyst who spent years at OWOX helping enterprise clients design analytics systems, build BigQuery reporting pipelines, and optimize marketing measurement. She specializes in SQL-based analytics, data modeling, and turning raw marketing data into actionable insights. Alyona writes about practical analytics workflows, BigQuery best practices, and data-driven decision-making.

What users are saying

What our clients say

Real things real customers said — each quote pinned to a specific claim, straight from the quotes database.

A9re: one source of truth
Mark SimmonsMark SimmonsCMO, Pürblack®
“We had six or seven different channels and no single source of truth — it was almost impossible, a lot of guesswork.”
C7re: getting time back
Nodari RizunNodari RizunFounder & CEO, Pürblack®
“We regained time. And time is the one resource that never comes back.”
E3re: golden data
Nodari RizunNodari RizunFounder & CEO, Pürblack®
“Golden data is clean data — the measure of reality, true and not false, that you can trust based on its source. If you have that, you're good.”