Introducing Data Reliability KPIs

Introducing Data Reliability KPIs

This article introduces the concept of Data Reliability KPIs supported by Cuneiform for Salesforce. Use this guide to learn how to measure the data quality or business impact of the records profiled by a given profiling definition.

Table of Contents

Cuneiform for Salesforce supports two types of KPIs that can measure the impact of data quality on an object, a business outcome, or a goal. These KPIs can be assigned to profiling definitions to measure the impact of profiled records.

What are Data Reliability KPIs?

Key performance indicators, or KPIs, are measurable values that can demonstrate how effectively a company or organization achieves critical business objectives. KPIs are vital for organizations to gauge and assess their performance across various dimensions, including performance measurement, goal alignment, decision-making, communication, and continuous improvement.

Just as KPIs are essential for measuring business performance, they are equally necessary for assessing the reliability of CRM data. Once you assign KPIs to a profiling definition, Cuneiform for Salesforce measures the profiling definition’s filtered collection of records each time a profiling definition is run and can display KPI result trends across multiple profiling attempts.

Data Reliability Measured with Data Quality and Business Impact KPIs

Cuneiform for Salesforce supports the following two types of KPIs. Use these KPI types to aggregate data quality or business impact scores, measuring how reliable your data is at producing business outcomes that generate ROI. Once a profiling definition is created, data quality and business impact KPIs can be assigned to a definition, and their values can be calculated during data profiling.

Data Quality KPIs
Data quality KPIs are designed to assess the accuracy, completeness, consistency, and reliability of an organization's data. Examples of data quality dimensions include:

  • Completeness

  • Correctness

  • Consistency

  • Timeliness (Freshness)

  • Validity

Business Impact KPIs
Business impact KPIs are designed to measure the direct effects of business activities on an organization’s success and goals. Examples of business impact KPIs include:

  • Opportunity Amount

  • Opportunity time to close

  • Lead time to convert

  • Case time to resolution

  • Account total revenue won or lost

  • Campaign conversion rate

KPI Calculations Performed During Profiling

When Data Reliability KPIs are assigned to a profiling definition, Cuneiform for Salesforce performs data quality and business impact KPI calculations on the filtered collection of profiled records. The following calculations are performed and recorded for each KPI type.

KPI Calculation

Description

Data
Quality?

Business Impact?

KPI Calculation

Description

Data
Quality?

Business Impact?

Minimum

Calculates the minimum KPI value for a collection of filtered records. Includes zeros in calculations.

Yes

Yes

Minimum (IF)

Calculates the minimum KPI value for a filtered record collection – excluding zeros in calculations.

Yes

Yes

Average

Calculates the average KPI value for the collection of filtered records. Includes zeros in calculations.

Yes

Yes

Average (IF)

Calculates the average KPI value for the collection of filtered records – excluding zeros in calculations.

Yes

Yes

Maximum

Calculates the maximum KPI value for a collection of filtered records.

Yes

Yes

Summary (Sum)

Calculates the summary total KPI value for a collection of filtered records.

No

Yes

These field-specific aggregations can correlate data quality to business impact or performance measures. It is through this correlation that the reliability of CRM data can be measured. Examples include:

Opportunity Data Health

Compare the completeness % of Opportunity records (an average) to the total revenue of Opportunities won and lost (sums).

Account Data Health

Compare the completeness % of Account records (an average) against each account's total YTD Opportunity revenue as earned (sums) by Account region and tier.

Case Data Health

Compare the completion % of Case records (an average) against the average Age of Cases by priority.

In each example, data quality metrics are compared with business performance metrics. Cuneiform for Salesforce can automate the collection of these measurements and display KPI result trends across multiple profiling attempts.

Calculated KPI values can also be leveraged in custom reports to measure how reliable your CRM data is in producing specific outcomes. Please visit our Custom Object Guide for details on KPI field values to leverage in custom reporting.

Creating Data Quality KPIs with Salesforce Formula Fields

Data quality and business impact KPIs can be added to any object via custom fields. Create data quality KPIs using Salesforce formula fields. Any field whose data type supports aggregation can represent business impact KPIs.

Data Quality KPIs

Data quality KPIs are expressed as formula fields with a data type of percent or checkbox. The KPI formula field should perform a calculation whose result is expressed as:

  • a percent

    • ex. Opportunity Completeness is 100%, or Opportunity Completeness is 50%

  • a checkbox

    • ex. Opportunity Next Stage is Missing = true, or Opportunity Has Pushed Closed Date > 3 Times = true

Business Impact KPIs

Business impact KPIs are expressed using any Salesforce field whose data type supports aggregation. This can include standard fields, custom fields, and formula fields. Examples include:

  • Opportunity Amount

  • Opportunity Time to Close (Age)

  • Opportunity Probability to Close

  • Lead Probability to Convert

  • Account Total Revenue Won (roll-up)

  • Account Total Revenue Lost (roll-up)

Measure Record Quality with Data Quality KPIs

Data quality dimensions can measure data quality at multiple levels, from an entire object to individual fields. Cuneiform for Salesforce uses data quality dimensions to measure data quality at the record level.

Use the table below to learn about each data quality dimension and view examples of how each dimension can be applied to a Salesforce object record.

Data Quality Dimension Name

Dimension Description

Example

Data Quality Dimension Name

Dimension Description

Example

Completeness

The degree to which a given Salesforce record can be considered complete. Use this dimension to measure the % of key fields that have a value for a Salesforce Object.

The Billing Address for Account [x] is 75% complete.

Correctness

The degree to which key field value for a Salesforce record can be considered correct and accurate. Use this dimension to measure the correctness of field values for fields used to drive outcomes.

The Email Address for Contact [x] is not correct (we’ve received bounce-backs / return to sender errors).

Consistency

The frequency by which consistent values are being used for key fields. Use this dimension to measure the consistent use of field values.

The State field value for Account [x] is an expected value (ex. PA).

Timeliness
(Freshness)

The degree to which a Salesforce record is current, timely, or “fresh”. Use this dimension to measure how current, recent, or active a record is.

Account [x] is 100% timely – meaning it has been updated in the past seven (7) days.

Validity

The degree to which a Salesforce record field value format is valid. Use this dimension to measure how often values are provided in expected or desired formats.

The Phone Number for Contact [x] is not in the correct format.

Measure Business Performance with Business Impact KPIs

Just as data quality dimensions can be used to measure data quality at multiple levels, the same can be said for business impact KPIs. Cuneiform for Salesforce uses business impact KPIs to measure the business performance or the likelihood that a record will produce a business outcome.

Use the table below to see examples of business impact KPIs for sales and view examples of how each KPI can be applied to an object record.

Business Impact KPI Name

KPI Description

Example(s)

Business Impact KPI Name

KPI Description

Example(s)

Lead Time to Convert

Measures the duration of time required to convert a Lead. This metric gauges the Sales team’s ability to convert Leads into Opportunities.

When a Lead is converted, track the number of days it took to execute the conversion.

Lead First-Response Time

Measures the duration between receiving a lead request or initial engagement and the response from the inbound team. This metric measures the team's efficiency in processing leads.

Track the Response Age of the Lead and ensure that it was converted.

Lead Contact Rate

Tracks the average number of attempts a sales representative makes to contact a lead. It emphasizes the importance of scheduling follow-ups for the prospect and ensuring consistent follow-through.

Track the number of contact attempts and the date of the latest attempt made by the Sales team for a given Lead.

Average Opportunity Amount (Overall / Won/ Lost)

Measures the average of the Opportunity amounts for a given Account – accounting for All Opportunities, Won Opportunities, and Lost Opportunities.

Track the average Opportunity Amount for an Account for All, Won, and Lost related Opportunities.

Total Opportunity Amount (Overall / Won/ Lost)

Measures the sum of the Opportunity amounts for a given Account – accounting for All Opportunities, Won Opportunities, and Lost Opportunities.

Track the total Opportunity Amount for an Account for All, Won, and Lost related Opportunities.

Opportunity Age

Measures the number of days an Opportunity was Open before it Closed (as either Won or Lost).

Track the number of days elapsed between an Opportunity being created and Closed.

Opportunity Push Count

Measures the number of times an Opportunity’s Close Date has been pushed into the future.

Tracks how often an Opportunity’s Age is extended by advancing the Close Date.

Opportunity Days Since Last Stage Change

Measures the number of days that have elapsed since the last Stage change for a given Opportunity.

Tracks how quickly an Opportunity Stage changes in order to advance to Close.