Learn how to transform workflow data into business intelligence by querying current statuses and, more powerfully, analyzing the history of status changes to measure process efficiency.
Object
changes status, Luklak records that event, creating a complete audit trail.
This historical data is the key to unlocking deep insights into process efficiency, bottlenecks, and conversion rates. This guide covers how to analyze both the present state and the past journey of your Objects.
Objects
are right now. Using UQL in filters and dashboards, you can get a real-time snapshot of your operations.
Querying by Status:
You can filter for Objects
in a specific custom status you created.
status = "AWAITING_CLIENT_FEEDBACK"
Querying by Status Category:
For a broader, cross-functional view, you can query by the system category.
status.category = "IDLE"
. This would find all Objects that are ON_HOLD
, AWAITING_FEEDBACK
, etc., across the entire company, regardless of their specific status name.Operator | Description |
---|---|
Was in "STATUS" | Finds Objects that have ever been in a specific status at any point. |
Was not in "STATUS" | Finds Objects that have never been in a specific status. |
Changed from "A" to "B" | Finds Objects that made the specific transition from Status A to Status B. |
Changed from "STATUS" | Finds Objects that have successfully transitioned out of a specific status. |
Changed to "STATUS" | Finds Objects that have successfully transitioned into a specific status. |
NEW_LEAD
→ CONSULTATION
→ PROPOSAL_SENT
→ WON
.
The Business Question: “How effective are we at converting leads who have had a consultation into receiving a proposal?”
The UQL Solution: The Changed from
operator is perfect for this.
Counter
gadget to count all Objects that Were in "CONSULTATION"
. Let’s say the result is 100.Counter
gadget using the query above (status changed from "CONSULTATION" to "PROPOSAL_SENT"
). Let’s say the result is 42.