As one of the most significant players in the Czech market, Seznam has a broad content portfolio, including Novinky, Seznam Zprávy, or Garáž. Every day, its homepage is visited by 4 million users, 75 million emails are processed, and over 70,000 comments are posted under articles1. Our mission was to provide Seznam with comprehensive user behavior reporting. In real time. Utilizing more than 60 GB of data per website. Every single day.es such as seznamzpravy.cz, novinky.cz, garaz.cz and others.
Our collaboration with Seznam began back in 2024. Our first joint project was focused on reporting for content websites and visualizing user behavior in real time. For this task, we used Dataform, a tool that helps specialists and teams build data pipelines, version code in Git, and orchestrate workflows. The key advantage of this tool is full automation, eliminating time-consuming manual setup. In Dataform, you simply define individual dependencies between tables, and you're done.
"Efficient data management is crucial for our content websites. Thanks to our collaboration with Optimics, we have developed reporting that provides us with key real-time metrics, which will allow editorial teams and managers to respond quickly to content performance,"
The goal of the reporting for Seznam was to display key metrics such as article readership and completion rate. Additionally, the project included an overall performance comparison of the website with the previous week. The biggest challenge was the massive volume of data to be processed—approximately 60 GB per day for each website. The collected data was visualized through Looker Studio, transforming it into a clear and structured overview. Although this reporting is not used as Seznam’s primary analytics system, this tool is useful for editors, chief editors and product managers..
How can Dataform help you?
At Optimics, we believe in contributing to the community, which is why we have created an open-source Dataform package. This package processes Google Analytics 4 e-commerce data in BigQuery into a flat table. This table can then be used as a data source for visualization in Looker Studio or any other BI tool.
Beyond just flat table creation, the package also tracks daily data increments, ensuring that only the previous day's data is processed.
If you're interested in this package, check out our GitHub for a detailed installation guide.
And if you're dealing with a more comprehensive problem or a specific case of reporting, don't hesitate to reach out to us directly at Optimics or +420 731 360 696
Využijte sílu*
marketingových dat k optimálnímu prodeji
Get in touch
Interested to find out the real potential* of your data?
Drop us your contact details and we will
get back to you shortly.
