Case study

Agentic AI Cuts UX Friction Analysis Time 10x

How a digital transformation analytics company built a hybrid LLM pipeline on BigQuery and Gemini to turn billions of clickstream events into repeatable, decision-ready insight.

Book a session
10xFaster user-friction analysis than manual review
100%Repeatable findings, free of analyst bias
AIHidden friction patterns surfaced and prioritized automatically
Billions of eventsOrganized into one scalable data layer

A Silicon Valley-based, VC-backed digital transformation analytics company that helps enterprises find and reduce user friction in their software.

Founded in 2013, it analyzes clickstream data at scale to turn billions of raw events into auditable insight for its enterprise clients.

Impact

Faster user-friction analysis than manual review. Repeatable findings, free of analyst bias. Hidden friction patterns surfaced and prioritized automatically.

Key services
AiAI & Generative AI
DaData & Analytics
Industry

Technology

Key technologies / platforms

BigQuery · Vertex AI · Gemini

The engagement

How SquareShift delivered it.

The challenge

A digital transformation analytics company was drowning in its own data. Its enterprise clients generated billions of raw clickstream events, and the user friction hidden inside that scale — the small breakdowns that slow people down inside enterprise software — was hard to see, let alone fix.

Manual review couldn’t keep up, and it introduced its own problem: every analyst read the same data differently, so findings were inconsistent and every novel issue took repeated manual effort just to quantify.

What we delivered

SquareShift built a hybrid deterministic-plus-LLM pipeline on BigQuery, Vertex AI, and Gemini, organizing billions of user events into a single scalable data layer. An agentic AI architecture paired pattern recognition with causal inference and automated validation, linking UI and system errors to retries, pinpointing labeling errors, and quantifying time lost against an ideal user journey.

The system also surfaced forced workarounds and context-switching between apps — friction that was happening constantly but had never been measured.

The payoff

Friction analysis that used to take manual review now runs 10x faster, and because the pipeline is deterministic where it counts, findings are repeatable rather than dependent on which analyst looked last.

Hidden friction patterns get surfaced and prioritized automatically, so the team spends its time fixing high-impact issues instead of hunting for them.

A pure LLM audit of billions of events would drift; a pure rules engine would miss what's new. The deterministic-plus-AI hybrid is what makes friction analysis both fast and trustworthy.

Analytics Modernization Practice Lead, SquareShift