📊 KPIs, Measures and Pivots
GermainUX provides preconfigured KPIs, measures and pivots for analyzing user experience, business processes, marketing, web activity and technology performance. Organizations can also create and customize them for their own applications and business requirements.
Together, these three elements answer three different questions:
|
Element |
Question answered |
Example |
|---|---|---|
|
KPI |
What type of activity or event are we analyzing? |
User Click |
|
Measure |
Which numerical result do we want to calculate? |
95th-percentile duration |
|
Pivot |
How should the result be segmented? |
Application page |
For example:
Analyze the 95th-percentile duration (measure) of User Clicks (KPI), broken down by application page (pivot).
This model allows the same monitored data to support high-level dashboards, segmented comparisons, detailed drilldowns and root-cause analysis.
🎯 Business Outcomes
KPIs, measures and pivots help organizations:
-
Monitor adoption, conversion, productivity, user experience and technology health.
-
Define consistent calculations across dashboards and teams.
-
Break down performance by users, applications, workflows, products and other dimensions.
-
Identify outliers, degraded segments and leading factors.
-
Move from a high-level result to the instances and evidence behind it.
-
Create custom analytics without building separate reporting logic for every use case.
-
Apply SLAs, alerts and automation to the conditions that matter.
🔗 How the Three Elements Work Together
A GermainUX visualization begins with a KPI and then applies a measure and, when needed, one or more pivots.
KPI: What happened?
↓
Measure: What value should be calculated?
↓
Pivot: How should the value be segmented?
↓
Dashboard, analysis, alert or report
Examples include:
|
Analytical question |
KPI |
Measure |
Pivot |
|---|---|---|---|
|
Which CRM pages have the slowest interactions? |
User Click |
95th-percentile duration |
Page |
|
Which teams lose the most time in a workflow? |
Business Process |
Total lost productivity |
Team |
|
Which campaigns generate the most conversions? |
Conversion |
Conversion count or rate |
Campaign |
|
Which application version generates the most errors? |
Application Error |
Error count |
Application version |
|
Which products experience the most cart abandonment? |
Cart Abandonment |
Abandonment count or revenue impact |
Product |
📈 KPIs
A KPI defines the type of fact, event, transaction or business condition to be monitored and analyzed.
Depending on the use case, a KPI can represent:
-
A user interaction
-
A user session
-
A business-process instance
-
A journey milestone or drop-off
-
A conversion or abandonment
-
An error or exception
-
An application transaction
-
A performance or availability event
-
A marketing or campaign outcome
-
A custom business event
KPI configuration can include:
-
Fact or event type
-
Default measure
-
Available pivots
-
SLAs and statistical SLAs
-
Filters and constraints
-
Relationships with other KPIs
-
Drilldown and analysis behavior
-
Alerts and automation
🗂️ Preconfigured KPI Categories
|
Category |
Documentation |
|
Business Processes and Workflows |
|
|
Marketing |
|
|
Technologies |
|
|
User Experience |
|
|
Web Analytics |
🔢 Measures
A measure defines the numerical value or calculation applied to the instances of a KPI.
Measures can include raw numeric attributes and calculated aggregations such as:
-
Count
-
Sum
-
Average
-
Minimum and maximum
-
Median
-
Percentiles
-
Rate or percentage
-
Duration
-
Throughput
-
Error frequency
-
Conversion rate
-
Lost productivity
-
Revenue or business impact
💡 Why the Measure Matters
The same KPI can produce very different insights depending on the selected measure.
For a User Click KPI:
|
Measure |
Insight |
|
Count |
How many clicks occurred? |
|
Average duration |
What was the average click response time? |
|
95th-percentile duration |
How slow was the experience for users near the slower end of the distribution? |
|
Error rate |
What proportion of clicks failed? |
|
Total lost productivity |
How much user time was lost across all affected clicks? |
Measures should be selected according to the decision being made. Averages are useful for overall trends, while percentiles reveal experiences that an average can conceal. Counts show scale, while rates make segments of different sizes comparable.
🗂️ Preconfigured Measure Categories
|
Category |
Documentation |
|
Business Processes and Workflows |
|
|
Marketing |
|
|
Technologies |
|
|
User Experience |
|
|
Web Analytics |
🔄 Pivots
A pivot is a dimension used to group or segment KPI results.
Pivots help answer where, who, which or under what conditions a result occurs.
Examples include:
-
Application and environment
-
Page, screen or feature
-
User, role or team
-
Business process and milestone
-
Customer segment
-
Product, service or campaign
-
Device, browser or operating system
-
Application version
-
Country, region or location
-
Error category or technology component
📊 Pivot Dashboard
The Pivot Dashboard automatically presents the selected KPI and measure across multiple relevant dimensions. This helps teams identify where a problem is concentrated without configuring every breakdown manually.
GermainUX preconfigures at least ten pivots for applicable KPIs. The exact pivots available depend on the KPI, data model, monitored application, product version and collected attributes.
Pivots can reveal:
-
The pages with the slowest interactions
-
The teams experiencing the most lost productivity
-
The products contributing the most abandonment
-
The application versions generating the most errors
-
The devices or regions with the lowest conversion
-
The workflow stages where completion degrades
🗂️ Preconfigured Pivot Categories
|
Category |
Documentation |
|
Business Processes and Workflows |
|
|
Marketing |
|
|
Technologies |
|
|
User Experience |
|
|
Web Analytics |
Pivots Versus Filters
Pivots and filters serve different purposes.
|
Capability |
Purpose |
Example |
|
Pivot |
Break the data into groups for comparison |
Show response time by browser |
|
Filter |
Restrict the data included in the analysis |
Include only Chrome sessions |
A filter reduces the analysis scope. A pivot keeps the relevant groups visible so they can be compared.
Using Multiple Pivots
Multiple pivots can provide a more precise breakdown.
For example:
User Click duration by application page, then by browser version.
This can reveal that a page is slow only for one browser version. However, excessive pivot combinations can create many small groups and misleading results. Always consider the number of instances behind each segment.
From Aggregate to Root Cause
KPIs, measures and pivots support the complete GermainUX analytics workflow:
-
Aggregate Dashboard: Monitor the KPI and selected measure over time.
-
Pivot Dashboard: Identify the dimensions where the result is concentrated.
-
Drill-through Dashboard: Review the relevant users, sessions or transactions.
-
Analysis Dashboard: Compare baselines, related KPIs, Leading Factors and individual evidence.
-
Session Replay or Trace: Understand what happened in a specific instance.
This allows teams to move from a high-level symptom to evidence-backed root cause without losing the original analytical context.
Create Custom KPIs, Measures and Pivots
Organizations can extend the preconfigured analytics for application-specific and business-specific needs.
Custom configuration can define:
-
New KPI and fact types
-
Custom numerical attributes and calculations
-
Organization-specific pivot dimensions
-
Names, descriptions and display formats
-
Default measures and pivots
-
Filters, constraints and relationships
-
SLAs and statistical thresholds
-
Drilldown and analysis behavior
-
Alerts, reports and automated actions
Custom elements should use consistent definitions and units so results remain comparable across dashboards and teams.
Analytical Best Practices
-
Choose the KPI that represents the event or outcome being investigated.
-
Use a measure aligned with the business question.
-
Compare counts and rates when segment sizes differ.
-
Use percentiles when averages may hide slow or poor experiences.
-
Verify the number of instances behind each pivot value.
-
Avoid conclusions from very small segments.
-
Apply filters to remove irrelevant data before comparing pivots.
-
Drill into representative instances before deciding on root cause.
-
Validate that custom formulas and units are consistent.
Get More Information
Contact GermainUX Support for help selecting or creating KPIs, measures and pivots for your use case.
Service: Analytics
Feature Availability: 8.6.0 or later