NEWSLayers closes first external funding round led by LOI VentureRead more
Schedule a demo
← Back to Changelog

HAVING Clause & Expanded Product Metrics in LayersQL

A LayersQL query showing FROM products, SHOW product_ctr, GROUP BY TOP 20 product, a highlighted new HAVING product_impressions >= 500 clause, and SINCE -30d

LayersQL queries can now include a HAVING clause to filter grouped results after aggregation — for example, only rank products by click-through rate once they've cleared 500 impressions, so metrics with tiny sample sizes don't crowd out the results that matter.

The Products dataset also grew substantially, with new metrics across funnel (sessions, buyers, view-to-cart and cart-to-purchase rates), tile engagement (CTR, add-to-cart rate, average click position), result exposure (result appearances, render rate), and attribution transparency (deterministic vs. modeled revenue). Building a rate-based sort metric now includes the same volume-floor threshold, so custom sort metrics get the same protection from noisy small-sample rates.

Learn more about HAVING or browse the full Products metric catalogue.

FeatureAnalyticsLayersQLMerchandising Metrics