Skip to main content
Feedback

Sprinklr walkthrough

info

Sprinklr API version 1 is currently supported.

The Sprinklr data source in Data Integration builds on Sprinklr’s reporting mechanism, which powers the widget reports in Sprinklr’s UI. Therefore, any report that works for a widget in the Sprinklr platform UI should function the same way in Data Integration.

note

The following note appears in the Sprinklr topics:

Certain social network terms of service do not enable API transfer of data from the Sprinklr API to another data store. As such, these common metrics, or custom measures created in Sprinklr, may present different numbers than those in our Web UI when the API does not return a specific channel. When querying for common metrics on the Reporting endpoint, make sure to query for the unique social channel metrics that comprise the common metric calculation to determine whether the data is consistent with the Web UI.

Prerequisite

Sprinklr connection.

Getting report data from Sprinklr data source

The Sprinklr source uses the following parameters:

Report

Reporting consists of a set of measures and dimensions that can run together. The Sprinklr platform reporting engine generates the reports available in Data Integration.

image

Dimensions

Dimensions are the group by clause of the report. Each dimension determines the granularity of the report and may affect its performance. The chosen report changes the dimensions list. Custom dimensions (based on expressions or another definition in Sprinklr) also work in Data Integration.

image

Custom dimensions

The Post Insights report includes a field called Custom Dimensions. This enables you to gain deeper insights into social media presence, letting you create custom metrics and analyze data based on specific, user-defined parameters. With this field, you can tailor the reporting to align with specific business objectives and gain a more comprehensive understanding of the social media performance. image.png

Measures

Measures are the metrics summarized in the report by the granularity of the dimensions. Data Integration retrieves each selected measurement using the SUM aggregation. The list of measures changes according to the chosen report. Custom measures also work.

image

Data Integration pulls each measurement with the following field pattern: {aggregation_type}_{measure_name} The aggregation type in the pattern derives from the aggregation type of the measure — for example, Data Integration pulls the measure Followers with SUM aggregation type as total_followers.

Filters

You can filter reports by dimensions and values. Each filter combines a Dimension, Operator, and Value. The available operators are:

  • >= (Greater than equals), > (Greater than)
  • <= (Lower than equals), < (Lower Than)
  • == (Equals), != (Not equal)
  • IN (In some values)

image

To add a filter to the report, click Add Filter. Data Integration connects filters with AND operators only.

Timezone

The report uses the chosen timezone for dates. For example, if a report runs between 1.1.25 and 2.1.25 and the timezone is set to EST, Data Integration offsets the data to 1.1.25 in EST time and returns it as UTC represented as EST.

Time period

You can set the time period to a custom date range or a predefined time period (for example, Yesterday, last week, etc.).

image

Selecting Date Range

  1. Select the start date and end date.
  2. Leave the end date empty to pull data until the Data Flow runs.
  3. After each run of the Data Flow, Data Integration automatically updates the start date with the end date and clears the end date. This enables the next run to pull data from the end of the previous run.

Selecting Days back

Use this input to pull data from the specified days before the given start date.

On this Page