Case Study

1

min read

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

Learn how OWOX’s data-driven approach helped Rozetka optimize their ad campaigns and increase revenue in this inspiring success story.

Alyona Samovar

June 24, 2015

 · Last Updated 

June 24, 2015

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

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

Direct marketing revenue increased by 18%.

Average order value increased by nearly 9%.

On this page

What is a Data Mart?

More from the blog

Learn how teams ship analytics faster

Deep dives on data marts, governance, and modern reporting workflows.

See all articles →

Tracking What’s the Deal with Your Direct Traffic, and How to Fix It

Marketing An Overview of Marketing Metrics

Reporting Marketing Reports — The Ultimate Guide, Examples and Templates

Marketing Marketing Mix: A Guide to Channel Marketing

What our clients say

Pürblack I was blind, now I can see. OWOX opened our eyes. For 10 years, we couldn’t get a source of truth. Now — literally in five minutes.

BOG Unmatched Precision I can finally automate reporting across my business with the precision and flexibility that I could previously only get from a team of 20 people

Pandadoc Excellent solution A transparent system that allows us to see what is happening with our data with excellent support team

Answear A leap forward to better analytics OWOX helped us take ANSWEAR’s analytics strategy up a level. By collecting data…

Google Sheets in modern analytics

Google Sheets, powered by governed data marts

Google Sheets were never designed to be a system of record. With OWOX Data Marts, Sheets becomes a trusted analysis layer — powered by governed data marts defined upstream in your warehouse.

✓

Business teams keep the flexibility they love

✓

Data teams retain control over logic and definitions

✓

No more fragile joins duplicated across spreadsheets

See how it works

→

Case studyCase StudiesMarketing AnalyticsOWOX