--- title: "Monitoring web data quality: FxPro case study" canonical: "https://www.owox.com/blog/success-stories/case-how-to-keep-track-of-data-quality" updated: "2026-10-12" --- # How to monitor the quality of your data when you have dozens of websites: An FxPro case study Updated April 9, 2020 · [Alyona Samovar](/team/alyona-samovar) · 6 min read · Finance 28 · language sites monitored automatically ![How to monitor the quality of your data when you have dozens of websites: An FxPro case study](https://cdn.owox.ai/www/webflow/679559488bbae95a36a5570d_53603.png/public) [FxPro](https://www.fxpro.com/) is one of the top online brokers worldwide and has been providing traders with access to financial, stock, metals, energy, and other markets for 15 years. With four online trading platforms available for both web and mobile, FxPro has a user base of more than 870,000 traders. The company has won more than 70 international accolades, including a number of annual awards such as “best forex provider,” “best forex broker,” “best tool/service,” and “best platform.” FxPro has been working with OWOX for several years. They started with consolidating data into cloud storage from different sources and building reports based on that data. Now, OWOX analysts consult FxPro on testing hypotheses, building data-driven marketing strategies, and implementing OWOX and Google products. In this article, FxPro’s marketing specialists share the story of how OWOX helped them implement data monitoring and anomaly reporting across dozens of localized websites and services. ## The task At FxPro, we collect and analyze data about all our users’ actions on our websites and iOS and Android mobile apps. Thanks to this data, we can: * control [data quality](/product/data-quality) by managing trading accounts and operations with funds, verifying uploaded documents, automatically updating data in the Calendar and monitoring trading actions in the markets. * analyze the quality of acquired traffic by key business indicators: registrations, deposits, conversion rates, etc. * analyze the short- and long-term efficiency of paid traffic channels. * analyze the efficiency of SEO traffic. With 870,000 users, we need to consider a huge amount of data and a huge number of behavioral factors. Moreover, our website has versions in 28 languages, most of which are on dedicated domains and each domain must be monitored independently. Having accurate and complete data is crucial for making marketing decisions. Combined with the speed of data retrieval, these factors directly affect the quality of service we provide. Incomplete or inaccurate data can lead to the wrong conclusions when analyzing traffic acquisition channels. This, in turn, can lead to investing in ineffective channels and failing to acquire new users — or simply losing money. Moreover, not getting data in time affects our ability to react to emerging issues in the work of our services and websites. As a global forex broker, an inability to react could lead to both material and reputational damage. To avoid this, we need to: * collect all user behavior data from all our websites and mobile apps and store this data in one place. The collected data must be complete, raw, and unsampled. * analyze the collected data using a single tool. * get timely updates and alerts on possible anomalies and data discrepancies broken down by website, app, and country. Here’s how we do this. ## The solution ### Collecting and storing data We collect raw, unsampled user behavior data and store it in Google BigQuery. To collect this data, we use OWOX. Website data is collected with OWOX’s website data streaming pipeline. Mobile app data is collected via the [AppsFlyer → Google BigQuery](/product/data-connectors) pipeline. All this data is sent to BigQuery in near real-time. We also use OWOX to collect click and ad cost data in Google Analytics from traffic acquisition platforms such as Facebook and Twitter. Eventually, this data also gets from Google Analytics to BigQuery. As a result, all our critical data is consolidated in one place where we can shape it as we need using SQL queries. Once the data is collected and shaped, we can pass it along to data visualization tools like Google Data Studio and PowerBI. ![Flow of data from various sources to a visualization tool](https://cdn.owox.ai/www/webflow/6795598b77fdf801d38606c8_40144.png/public) ### Data visualization Collecting all the data we need in one place is only half the work. No less important is: 1. getting readable and actionable reports based on this data 2. monitoring the quality, accuracy, and completeness of this data OWOX analysts solved both of these tasks for us. The first was solved by implementing Google Data Studio reports, the second with Google Sheets. With OWOX, we connected data stored in BigQuery to Google Data Studio and created a complex report that’s automatically updated when there are changes to the source data. The report features seven [dashboards](/product/dashboards): ![General metrics report](https://cdn.owox.ai/www/webflow/6795598c5b77ccd8669fb096_32845.png/public) _1\. General metrics — number of sessions, conversion and bounce rates, page views, and revenue_ ![Dynamics of key metrics by traffic channel](https://cdn.owox.ai/www/webflow/6795598b880ceef07e849a98_32846.png/public) _2\. Dynamics of key metrics by traffic channel_ ![Dynamics of key metrics by email and other traffic sources](https://cdn.owox.ai/www/webflow/6795598bcd77235d71008bc3_32847.png/public) _3\. Dynamics of key metrics by email and other traffic sources_ ![Dynamics of key metrics by user device type (mobile/desktop/tablet)](https://cdn.owox.ai/www/webflow/6795598b8fcfda28245eb8a6_32848.png/public) _4\. Dynamics of key metrics by user device type (mobile/desktop/tablet)_ ![Conversion rate by country](https://cdn.owox.ai/www/webflow/6795598cc99fea81efe051ca_32849.png/public) _5\. Conversion rate by country_ ![Conversion rate by website domain](https://cdn.owox.ai/www/webflow/6795598b3647e1336b8d8e6b_32850.png/public) _6\. Conversion rate by website domain_ ![Conversion rate by marketing objective for ad channels, device types, countries, website domains, and browser versions:](https://cdn.owox.ai/www/webflow/6795598c6035baa188e5705f_32851.png/public) _7\. Conversion rate by marketing objective for ad channels, device types, countries, website domains, and browser versions_ ## 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 ## Data quality monitoring OWOX analysts set up a data monitoring system using Google Sheets and Apps Script. This system automatically checks data and notifies us of possible anomalies and unexpected behavior. Here’s how it works. The data used to build reports in Data Studio is also connected to Google Sheets, where a number of scheduled checks run automatically. Google Sheets checks the main website metrics, including number of sessions, conversion and churn rates, number of page views, events and transactions, as well as total and average revenue. Once the data has been checked, we receive an automated email report outlining all these metrics accompanied by a short text overview of the data status and possible causes for anomalies in the data. Here’s an example of such a report: ![an automated email report](https://cdn.owox.ai/www/webflow/6795598b0d1ffa66237275c8_32852.png/public) These same short data reviews also appear on the dashboards in Data Studio. However, thanks to email alerts, our analysts don’t even need to open Data Studio regularly to learn about possible anomalies. Once we get a notification, our FxPro team checks the data right away and decides whether there are issues with the data and, if so, how to resolve them. ## Results * Thanks to OWOX’s data collection features, Google Data Studio’s visualization possibilities, and the flexible custom alert system set up by OWOX analysts, our SEO, PPC, and IT departments can easily get all the information they need on the key quality indicators for FxPro services. * We can now collect all the data we need on the behavior of our users in over 170 countries, monitor the efficiency of our online ads and SEO, and keep tabs on the overall stability of our services. * The automatically updated and easily customizable report in Data Studio can be read and used by any FxPro specialist, regardless of their technical proficiency. The automated alert system lets us react to any data anomalies in a timely manner. _This article was written in collaboration with FxPro specialists.Trade responsibly. CFDs are complex instruments and come with a high risk of losing money rapidly due to leverage. 70.25% of retail investor accounts lose money when trading CFDs with this provider. You should consider whether you understand how CFDs work and whether you can afford to take the high risk of losing your money.FxPro Group Limited is the holding company of FxPro Financial Services Ltd, FxPro UK Limited and FxPro Global Markets Ltd. FxPro UK Limited is authorised and regulated by the Financial Conduct Authority (_[_registration no. 509956_](https://register.fca.org.uk/s/) _FxPro Financial Services Ltd is authorised and regulated by the Cyprus Securities and Exchange Commission (_[_licence no. 078/07_](http://www.cysec.gov.cy/en-GB/entities/investment-firms/cypriot/37670/)_) and authorised by the Financial Sector Conduct Authority (’FSCA’) (_[_authorisation no. 45052_](https://promo.fxpro.group/fsb.html)_). FxPro Global Markets Ltd is authorised and regulated by the SCB (_[_license no. SIA-F184_](https://www.scb.gov.bs/registrant-licensee-search/)_)._ ## 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) ## More stories [European Bank: Use advanced analytics to reduce low-quality apps · Sep 6, 2021](/blog/success-stories/advanced-analytics-to-increase-conversions) [IQ Option: Google Ads: assisted conversions analysis by IQ Option · May 21, 2018](/blog/success-stories/iq-option) [InfoTrust: Saving historical GA data for Y-o-Y reporting with OWOX · Aug 9, 2023](/blog/success-stories/saving-historical-ga-data) ## 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 - [data quality](https://www.owox.com/product/data-quality) — /product/data-quality.md - [AppsFlyer → Google BigQuery](https://www.owox.com/product/data-connectors) — /product/data-connectors.md - [dashboards](https://www.owox.com/product/dashboards) — /product/dashboards.md - [Book a Demo](https://www.owox.com/book-a-call) — /book-a-call.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 - [European Bank: Use advanced analytics to reduce low-quality apps · Sep 6, 2021](https://www.owox.com/blog/success-stories/advanced-analytics-to-increase-conversions) — /blog/success-stories/advanced-analytics-to-increase-conversions.md - [IQ Option: Google Ads: assisted conversions analysis by IQ Option · May 21, 2018](https://www.owox.com/blog/success-stories/iq-option) — /blog/success-stories/iq-option.md - [InfoTrust: Saving historical GA data for Y-o-Y reporting with OWOX · Aug 9, 2023](https://www.owox.com/blog/success-stories/saving-historical-ga-data) — /blog/success-stories/saving-historical-ga-data.md