Public Ranking & Analytics Platform

Valuable data, locked behind the scenes

NYIOOC — one of the most recognized names in extra-virgin olive oil competitions — already had years of competition results sitting in an internal system and API. What it didn’t have was a modern, public-facing way for producers, brands, and visitors to actually explore that data. The job was to turn raw internal records into a credible public product.

• Connect to the client’s internal API and normalize messy raw data
• Apply NYIOOC’s own ranking logic, not just simple database sorts
• Generate producer, brand, product, country, region, and yearly views
• Stay fast despite heavy data and high public traffic
• Cut down repeated, expensive calls to the internal API

What we built

We built the public Olive Oil Ranking platform from scratch on top of the client’s existing system — structuring the raw data, applying custom ranking calculations, and presenting it through a clean, searchable analytics UI, plus an admin side to run it all.

• World, producer, brand, and product rankings
• Country, region, and hemisphere rankings
• Organic and monovarietal rankings, plus yearly statistics
• Producer profiles with full gold/silver award history
• SEO-friendly public pages built for discovery
• Admin for content, distributors, notifications, certificates, and caching

Certificates, generated automatically

Award certificates used to be made by hand — the team logged into Certifier.io and filled in each winner’s details one at a time, lookup by lookup. We connected Certifier’s API to the platform’s structured competition data, so the right details auto-fill straight from the source records and certificates generate on background jobs. A slow, copy-paste chore became something the system just does.

• Integrated the Certifier.io API directly into the platform
• Auto-filled winner details from the structured ranking data — no manual lookups
• Generated certificates on background jobs, so the public site stays fast
• Removed a repetitive, error-prone manual step from every award

Making heavy data feel instant

The real work wasn’t displaying the data — it was making it usable and fast. We normalized the raw competition records into structured ranking views, generated rankings from NYIOOC’s business logic, and added Redis-based smart caching to keep the public site quick under thousands of daily users while cutting repeated internal-API calls.

Internal data, now a public product

The platform became a core public layer for NYIOOC’s results — no longer data sitting behind the scenes, but a discovery and analytics product producers and brands actually use.

• Far more public visibility for competition results
• Polished, searchable award history across years and countries
• A stronger, more credible authority for the competition
• A few thousand daily users on an optimized ranking experience