Zero Ads Reported, Then a €7,476 Ad: The False Empty in Italy's Meta Leads Cohort

Ask the tracker for every lead-generation ad running on Meta in Italy over the past 90 days and the answer that came back this week was zero. Not a handful. Not a thin slate. A clean, confident nothing. Read at face value, that number would mean Italian advertisers had abandoned lead generation on Meta entirely this quarter, which would be one of the stranger stories in European performance advertising. It is also false. The zero is an artifact of a broken query, and the market it accidentally hid is demonstrably open for business.

What actually happened

This is worth spelling out, because broken is not the same as empty, and the difference changes how any reader should treat the numbers we publish.

Two separate pulls were run against the Italy leads cohort: one across all platforms and one scoped to Facebook, both on a 90-day window. Both died inside the database with ClickHouse error Code 386. The message is terse: there is no supertype for types String and UInt64, raised while executing a greater comparison on the id column. In plain terms, the query asked the database to compare a text field against a numeric constant, and the database refused to guess at a common type. Query aborted. Both runs were recorded as n=0 ads.

Recorded as a result, that zero looks like a finding. It is not. Nothing was measured. A crashed census is not a small population, and a failed query should never be read as an empty market. The distinction matters more for a transparency project than anywhere else: publish enough undefended zeros and readers stop trusting the zeros that are real.

The one ad that breaks the zero

While the cohort queries were failing, the spotlight sampler, pointed at the same market and objective and scoped to Facebook, returned a live ad. One unit, from the home industry, and it is enough to settle whether the cohort exists.

The advertiser is Remail - Trasformazione Vasca in Doccia, a bathtub-to-shower conversion service. The ad is on Facebook, written in Italian, aimed at a unisex audience, and carries a get quote call to action, which is exactly the button you would expect from a business whose job is to turn a high-consideration renovation inquiry into a booked estimate. The creative carries id 926415503123462 and was first logged on 18 July 2026, so it has been live for roughly two of the window's 90 days.

Then the money line: an estimated mid spend of €7,476.12 on this single ad, alongside a cumulative EU total reach of 3,738,062 people. The targeting record lists national Italy plus fourteen regions: Basilicata, Calabria, Campania, Friuli-Venezia Giulia, Lazio, Liguria, Marche, Molise, Puglia, Sardinia, Sicily, Trentino-Alto Adige, Umbria, and Aosta Valley.

The shape of that list earns a pause. It leans toward central and southern Italy and the islands, with a scatter of northern exceptions, and it omits several of the country's largest and wealthiest regional markets from the visible list. We will not over-read a targeting configuration whose logic we cannot see, but the pattern rhymes with how regional home-services brands buy: quote-driven demand, older housing stock, and a customer who would rather step into a walk-in shower than climb over a tub.

What one ad can, and cannot, support

Tier discipline exists for moments like this, so the caveats should be explicit. A single ad is an existence proof, not a distribution. From this record we can say that at least one Italian lead-gen advertiser on Facebook spent on the order of seven and a half thousand euros inside the window. We cannot say anything about cohort medians, platform mix, format splits, or share of voice, because the queries that would establish those numbers are the ones that crashed. The spend figure is a mid estimate with no lower and upper bounds published in this record, and the reach figure is cumulative across the EU, not an Italy-only count. Treat €7,476.12 as a floor on visible activity in a cohort currently reported as empty, and treat everything else about this cohort as unknown.

The fix, and the re-run

The remedy for the false empty is mundane. The failing comparison pits a String id column against a numeric constant, so the fix is to cast the constant to String, or the column to UInt64 where the data is verifiably clean, and re-run both fetches: the all-Italy leads pull and the Facebook-scoped variant. The spotlight row is the tell that the re-run will find material spend rather than silence. When one ad carries €7,476.12 in estimated spend, a cohort query returning zero for that market is returning a bug, not a market read.

When the corrected numbers land, the Italy leads cohort gets its proper treatment: medians, platform and format splits, and a full benchmark against the rest of the value book. Nothing in this piece rests on the broken queries, and no aggregate claim about Italian lead generation will run until the fixed ones return.

Why we publish the bug

It would have been easy to shelve this beat until the pipeline was patched, then write as if the empty week never happened. Publishing the miss instead is the point of the exercise. Readers deserve to know when a zero means nobody is spending and when it means our tools blinked. This week in Italy leads, the tools blinked. The market, as one bathtub conversion with a €7,476.12 budget and 3.7 million EU reach makes plain, did not go anywhere.