[OC] Cheaper products rank higher in Google Visualization

What This Visualization Shows

This data visualization displays "[OC] Cheaper products rank higher in Google" and provides a clear visual representation of the underlying data patterns and trends. The visualization focuses on I analyzed 997,953 product listings from 56,466 search results in Google to find out whether or not cheaper products ranked higher.

Products cheaper than their SERP average have an average depth of **60.4%**, while more expensive products average **65.7%**, meaning cheaper products rank **8.7% higher** on average.

This is a bit more nuanced than it may sound.

First, the position of a product is highly dynamic. You cannot simply calculate the order of the products, because ranking number 1 doesn't always mean you're at the top. Sometimes, Google shows an AI overview on top, or a Google Maps pack, or a YouTube video carousel. Long story short, a product's position can only be accurately calculated by measuring the pixel depth of the product compared to the bottom of the page. If the entire first page of the search result is 2,000 pixels long, and a product is listed at pixel 500, then the pixel depth of that product is 25%. I did this for every product.

Why use the relative position instead of the absolute position? Because 1,000 pixels can be the bottom of the search result but can also still be relatively high. Some search results of Google go on and on and on (because Google likes to put lots of different result types on them). No single method is perfect, but I found this to be the most accurate way to measure a product's position on the search result page.

Then the next tricky bit is defining what "cheaper" means. Whether a $50 product is cheap is relative. If you're searching for pencils, then $50 is quite expensive, whereas if you're searching for dishwashers, then $50 is dirt cheap. So, I normalized all prices for every search result page. So, in case we're looking at a search result page for the keyword "dishwasher", then the average price on the page might be $350. For every search result page, this average price is used to determine if products are cheaper or not.

Finally, I put this together in a distribution chart similar to county population charts. I always liiked this kinda charts (where male/female populations are compared for every age). I kinda think this dataset lends itself perfectly for this chart type.

Y-axis shows the relative position of a product's appearance. 100% means bottom of page. The shape of this "population" is explained by the anatomy of Google's search results. Product carousels are usually placed at the top and the bottom. Some search result pages contain just 1 product carousel, while some contain as much as 4, scattered across the page.

This dataset only includes the first page of Google, because... well, who ever looks at the second page?

**Source:** 997,953 product listings from 56,466 search results in Google

**Tools:** D3.js and Canva, which allows us to understand complex relationships and insights within the data through visual storytelling.

Deep Dive into the Topic

This data visualization represents a sophisticated analysis of complex information patterns that provide valuable insights into underlying trends and relationships. Data visualization serves as a bridge between raw numerical data and human understanding, transforming abstract statistics into comprehensible visual narratives.

The power of data visualization lies in its ability to reveal patterns, outliers, and correlations that might not be apparent in traditional tabular formats. Through careful selection of chart types, color schemes, and interactive elements, effective visualizations can communicate complex information quickly and accurately to diverse audiences.

Modern data visualization combines statistical analysis with design principles to create compelling visual stories. This interdisciplinary approach requires understanding both the underlying data and the cognitive processes involved in visual perception. The result is more effective communication of quantitative insights that can inform decision-making and drive positive change.

Data Analysis and Insights

The patterns revealed in this visualization demonstrate the importance of systematic data analysis in understanding complex phenomena. By examining different data segments, time periods, and categorical breakdowns, we can identify trends that inform strategic planning and decision-making processes.

Statistical analysis of this data reveals variations across different dimensions that provide insights into underlying drivers and relationships. These patterns help identify areas of opportunity, potential risks, and key performance indicators that can guide future actions and resource allocation.

The analytical approach used in this visualization enables comparison across different categories, time periods, or geographic regions, revealing insights that support evidence-based decision-making. This type of analysis is essential for organizations seeking to optimize performance and understand complex market dynamics.

Significance and Applications

This data visualization has important implications for understanding trends and patterns that affect decision-making across multiple sectors. The insights derived from this analysis can inform policy development, business strategy, resource allocation, and operational improvements.

For analysts, researchers, and decision-makers, this type of data visualization provides essential insights for strategic planning and performance optimization. Whether addressing operational challenges, market analysis, or policy development, understanding data patterns helps create more effective strategies and solutions.

The broader significance lies in how this information contributes to our understanding of complex systems and relationships. This knowledge helps predict future trends, identify potential challenges, and develop more informed approaches to problem-solving and opportunity identification.