--- title: "Boost sales & loyalty by fixing checkout errors | OWOX" canonical: "https://www.owox.com/blog/success-stories/how-to-boost-sales-and-customer-loyalty" updated: "2026-10-12" --- # How to boost sales and customer loyalty by fixing errors on the checkout page Updated July 4, 2018 · [Alyona Samovar](/team/alyona-samovar) · 4 min read · Retail 3% · conversion boost via checkout fix ![How to boost sales and customer loyalty by fixing errors on the checkout page](https://cdn.owox.ai/www/webflow/679444340f0c19eb7f50a337_39714.png/public) In the modern, fast-evolving digital world, customers rely on the online opportunities offered by businesses and expect everything to be no less than perfect. Having once experienced any errors on their customer journey, these clients will remember the bad service and prefer to look for alternative products/services. That’s why it’s so important to prevent any hardships and monitor the business performance constantly. In this case, we describe the solution provided by the OWOX team for a consumer electronics and home appliances retailer that had challenges with fixing errors at the checkout page to increase sales and customer loyalty. ## Challenge Around 700,000 people visit the retailer’s website per day, to read product reviews or browse around to find what they’d like to buy. However, users may sometimes experience website errors at the checkout page that prevent them from completing an order online, thus, decreasing the company’s revenue. ## Goal The analysts along with testers carefully studied the customer complaints to define the typical error scenarios. The errors that the specialists managed to reproduce were fixed. The rest of the critical bugs required setup monitoring. Previously, the company didn’t use to collect such data, remaining unable to evaluate the exact number of bugs and how they affect the conversion rates. The company also needed to know how each bug was connected with a certain user, in order to help the user place an order. The analysts chose to set up monitoring of the critical bugs on the website and do all their best to help customers successfully place orders at the checkout page. This would increase sales and improve the customer website experience. The challenging factor was that real-time monitoring was required in order not to lose any of the customers currently trying to order something on the website. ## 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](/book-a-call) We'll use your actual use case ## Solution The following plan was prepared to reach the goal: 1. Place the additional code on the website to collect data about errors and send them to Google BigQuery. 2. Process the obtained data and export it to the table with the structure according to the company’s needs. 3. Organize sending data about users and errors to call centers that would contact customers to help them place an order. Here’s how the company’s data flow looks: ![Logo for case study “How to boost sales and customer loyalty”.](https://cdn.owox.ai/www/webflow/679444654eb0cffead182663_39711.png/public) ### Step 1. Collect data about errors The company uses Google Tag Manager to track what users do online. Though, not all logic errors on the website can be tracked by standard Google Tag Manager ways. This is why the custom scripts were written specifically and implemented through Google Tag Manager on the necessary website pages. The scripts add the detailed error data to the _DataLayer_. Next, with the help of the Google Tag Manager tags, the error data goes to Google BigQuery through the OWOX Pipeline. This allows obtaining raw unsampled data from the website in Google BigQuery, in near-real time. Using the API, the analysts send the data about users from CRM to Google BigQuery, obtaining all the data they need in the cloud data warehouse: * Error time. * Error type. * User ID. * User email address. * User city. * Current product status in the cart. ### Step 2. Process data Using OWOX Pipeline, the data tables with a wide range of parameters were obtained. The OWOX analysts created an SQL query to pull data from the table, returning it with a definite structure: a set of lines where each line equals a single mistake. Below is the SQL query example: As the result of the query, the analysts obtained a table containing following information: * Date; * Hour; * Minute; * User email address; * Error description; * User city; * ID of the product in the cart; * Names of products in the cart; * Price of products in the cart; * Total number of products in the cart; * Total price of products in the cart. Then, the data import to [Google Sheets](/product/spreadsheets) was set up, using the OWOX BigQuery Reports add-on that updates the information in the tables automatically and hourly. This means that the report always contains up-to-date data about errors for the previous hour. You can find an example of such a report below: ![A dashboard screenshot with charts and metrics.](https://cdn.owox.ai/www/webflow/6794448e1043917cf5bed747_39713.png/public) ### Step 3. Use the obtained data The users in charge automatically receive the report about errors every hour (9 AM to 6 PM, according to working hours). Next, they send it to the company’s developers in case there are critical issues to fix, and to the customer success managers who call users and help them complete an order on the phone. ## Results * The structured report was created to monitor the website errors that prevent users from making a purchase. * The company’s developers added a feedback form to the website. It automatically appears each time users who didn’t log in see an error, thus, allowing them to report the problem and leave their contact details. This helps the company quickly react to any errors or bugs, as well as extend the customer base, including contacts of the users who didn’t log in. * The call centers of the company can quickly get data about users that face problems while adding the product to the cart and checking out. The call center operators get to know what’s inside the cart and help finish the purchase. * Around 3% of users who received a call because of the website error, successfully finish placing the order on the phone. This gives the company an additional $1,600 that would have been lost if errors were ignored. ## 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](https://www.owox.com/app-signup) ## Who wrote this ![Alyona Samovar](https://cdn.owox.ai/www/webflow/6799099d337aa8a997b03b56_Alyona-Samovar.png/public) [Alyona Samovar](/team/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. [Case Studies](/blog/topics/case-study) [Marketing Analytics](/blog/topics/marketing-analytics) [OWOX](/blog/topics/owox-bi) ## More stories [Avrora: Avrora: analytics transformation with OWOX · May 30, 2024](/blog/success-stories/avrora) [Citrus: Competitors’ prices impact sales: Citrus success · Mar 1, 2018](/blog/success-stories/citrus) [COMFY: Set up marketing analytics · Dec 12, 2018](/blog/success-stories/comfy) ## 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. A9 · re: one source of truth ![Mark Simmons](https://cdn.owox.ai/www/webflow/6a7b298b2b9daab0ade631d7_mark-headshot.png/public) Mark Simmons · CMO, Pürblack® > _“We had six or seven different channels and no single source of truth — it was almost impossible, a lot of guesswork.”_ C7 · re: getting time back ![Nodari Rizun](https://cdn.owox.ai/www/webflow/6a7b298b2ca5055443187566_nodari-headshot.png/public) Nodari Rizun · Founder & CEO, Pürblack® > _“We regained time. And time is the one resource that never comes back.”_ E3 · re: golden data ![Nodari Rizun](https://cdn.owox.ai/www/webflow/6a7b298b2ca5055443187566_nodari-headshot.png/public) Nodari Rizun · Founder & 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.”_ ## Book a call You are booked. The invitation is on its way to , with the calendar invite and the meeting link. [Reschedule](#) [Cancel](#) ## Links Pages this page links to, on this site and on docs.owox.com. Where the page has a Markdown twin, its address follows the link. - [Alyona Samovar](https://www.owox.com/team/alyona-samovar) — /team/alyona-samovar.md - [Book a Demo](https://www.owox.com/book-a-call) — /book-a-call.md - [Google Sheets](https://www.owox.com/product/spreadsheets) — /product/spreadsheets.md - [Get started free](https://www.owox.com/app-signup) - [Case Studies](https://www.owox.com/blog/topics/case-study) — /blog/topics/case-study.md - [Marketing Analytics](https://www.owox.com/blog/topics/marketing-analytics) — /blog/topics/marketing-analytics.md - [OWOX](https://www.owox.com/blog/topics/owox-bi) — /blog/topics/owox-bi.md - [Avrora: Avrora: analytics transformation with OWOX · May 30, 2024](https://www.owox.com/blog/success-stories/avrora) — /blog/success-stories/avrora.md - [Citrus: Competitors’ prices impact sales: Citrus success · Mar 1, 2018](https://www.owox.com/blog/success-stories/citrus) — /blog/success-stories/citrus.md - [COMFY: Set up marketing analytics · Dec 12, 2018](https://www.owox.com/blog/success-stories/comfy) — /blog/success-stories/comfy.md