FEATURECollection-Scoped SequencesRead moreFEATUREORDER BY & Conversion Rate Metrics in LayersQLRead moreFEATUREEditable Block Strategy and Live Block CollaborationRead moreFEATUREDynamic Linking OffsetRead moreFEATUREClicked Section and Clicked Block ConditionsRead more
Schedule a demo
← Back to Changelog

ORDER BY & Conversion Rate Metrics in LayersQL

A LayersQL query showing FROM search_text, SHOW cvr and ctr, SINCE -30d, and a highlighted new ORDER BY cvr DESC clause

LayersQL queries can now end with an ORDER BY clause, so you choose how rows are ranked. Sort by any metric, expression or dimension in your results, ascending or descending, with empty values always placed last.

We also added engagement and conversion rates to the Search, Collections and Blocks datasets: ctr, atc_rate, cvr, purchase_rate, aov, rpi, hover_rate and touch_rate. Pair them with HAVING to rank terms by conversion once they clear a volume floor.

Learn more about ORDER BY or browse the Search (text) metrics.

FeatureAnalyticsLayersQLMerchandising Metrics