I Opened BigQuery Expecting Numbers. I Closed It With Perspective.

As developers, we often build tools to solve our own problems.

We write code, publish a package, push a release, and move on to the next challenge. Most of the time, we don’t stop to think about who might be using our work on the other side of the world.

Recently, I decided to analyze the adoption of one of my open-source Python packages, CallFlow Tracer, and what started as a simple curiosity turned into a surprisingly meaningful experience.

The Question

I wanted to answer a straightforward question:

How far has CallFlow Tracer reached?

CallFlow Tracer is a Python package designed to improve observability and trace execution flows in applications. Like many open-source maintainers, I occasionally check download numbers, but raw counts rarely tell the full story.

I wanted a deeper understanding of where those downloads were coming from.

Using BigQuery and the PyPI Public Dataset

Google Cloud provides a public dataset containing Python package download statistics from PyPI. Using BigQuery, I queried download data for CallFlow Tracer over the last several months and grouped the results by country.

The query itself was simple:

• Filter downloads for the package.
• Aggregate by country code.
• Sort by total downloads.

A few seconds later, the results appeared.

And that’s when things became interesting.

The Unexpected Discovery

The package wasn’t just being downloaded locally or within a small developer circle.

The data showed downloads from countries across multiple continents:

• United States
• China
• Hong Kong
• Singapore
• France
• Germany
• South Korea
• Japan
• United Kingdom
• Canada
• Sweden
• Israel
• Finland

And many others.

Seeing thousands of downloads from places I have never visited was a powerful reminder of what makes open source unique.

You don’t need a marketing team, a sales department, or a global office network to reach people around the world.

Sometimes all it takes is solving a real problem and making the solution available.

What the Numbers Really Mean

The download counts themselves are not the most important part.

What matters is what they represent:

• Developers experimenting with the package.
• Engineers integrating it into workflows.
• Students learning from the code.
• Teams exploring better observability practices.

Behind every download is a person trying to build something.

That’s what makes open source exciting.

Why Open Source Matters

One of the most rewarding aspects of building in public is the ability to create tools that extend beyond your immediate network.

A repository created on a laptop in one country can help someone debug an application in another country thousands of miles away.

Open source removes geographical boundaries and creates opportunities for collaboration at a global scale.

The experience reminded me that every contribution, no matter how small it seems at the time, has the potential to create impact far beyond what we can see.

Final Thoughts

I started the day looking for metrics.

Instead, I found perspective.

Analyzing the global reach of CallFlow Tracer reminded me why I enjoy building open-source software in the first place. Not because of download numbers, GitHub stars, or analytics dashboards, but because of the possibility that something you create might help someone you’ve never met solve a problem you’ll never hear about.

And honestly, that’s pretty amazing.

If you’re building open source projects, take a moment to look at your usage data once in a while.

You might discover that your work has traveled much farther than you expected.