Build Custom Metrics in Sprinklr Insights
Updated
Learn how to create Custom Metrics & leverage them in reporting to achieve desired use cases.
Custom Metrics allows you to create your own derived metrics using standard reporting metrics. These custom metrics can be used to collect and analyze data that reporting does not track automatically. Custom Metrics offer the capability to build dynamic metrics based on industry-standard norms and various business use cases.
You can create your custom metrics in Listening, Benchmarking, and Media Insights within Sprinklr Insights, Reporting within Social Sales & Engagement, Ads Reporting within Sprinklr Marketing (Ads), and Care Reporting within Sprinklr Service.
Use cases
Custom Metrics allows you to create your own derived metrics using standard reporting metrics.
These custom metrics can be used to collect and analyze data that reporting does not track automatically.
Custom Metrics offer the capability to build dynamic metrics based on industry-standard norms and various business use cases.
To create Custom Metrics
Click the New Tab icon. Under Sprinklr Insights, click Listening Settings within Settings.
On the Listening Settings window, click Custom Metrics.
On the Custom Metrics window, click Add Custom Metric in the top right corner.
On the Create Custom Metric form, enter the Custom Metric details and click Create. For more information, see Custom Metrics – Field Descriptions.
Note: Once the custom metric is created, you will have to refresh any reporting pages you have open for the metric to become available for use in reports or other custom metrics. |
Create Custom Metrics – Field Descriptions
Field | Description |
Name | Enter a name for the metric. |
Description | Enter a description of the metric that you want to create (optional). Note: A description will be automatically filled based on the formula used in the custom metric, if the description field is empty. |
Data Source | Select the desired data source –
|
Metric Type | Select the desired metric type. The metric type is the unit in which the data count gets reflected. You may select from the following metric types:
|
Metric Formula | Select the metric(s) from the list. You can select a numeric operator from the list and add another metric. You can create a custom metric from an existing custom metric. For example, if you have created a metric named Average reach per post, where the metric is Post Reach/Volume of Published Messages, you can create another custom metric with Average reach per post as one of the metrics in the metric field. |
Filters | Select dimensions, filter type, and select values. |
Color Coding | Define the desired value ranges and associated colors. These will be reflected in Table and Cross-Tab (Listening) widgets where the metric is used. |
Note:
|
Supported Operators & Functions
Basic Operators | Syntax – (MENTIONS + ENGAGEMENTS) / REACH | Basic operators (+, - , * , /) can be used to create desired formula combinations |
Power | Syntax – “Earned Engagements” ^ 3 | Returns the Metric raised to the power of “N”, where N can be any real number |
LOG | Syntax – LOG (“Total Engagements”) | Returns the Logarithmic value of Metric. Note that the Base of LOG function is 10 |
LN | Syntax – LN (Impressions) | Returns the Natural Logarithmic value of Metric. Note that the Base of LN function is 10 |
To edit Custom Metric
In order to edit a Custom Metric, hover over the Options icon next to it and click Edit. This will open the Edit Custom Metric form where you can make the desired changed to the custom metric, and then click Save.
To clone Custom Metric
In order to clone a Custom Metric, hover over the Options icon next to it and click Clone. This will open the Clone Custom Metric form. By default, the cloned custom metric will be named as Copy of "Your Custom Metric Name". You can change the custom metric name as desired, and also make other changes to it, if needed.
