Documentation Index

Fetch the complete documentation index at: https://docs.dataddo.com/llms.txt

Use this file to discover all available pages before exploring further.

Sprinklr

  • 4 minute(s) read
Prev Next

The Sprinklr connector lets you extract data from Sprinklr into Dataddo and sync it to any dashboard, database, or data warehouse. It covers paid, organic, and unified analytics reports, plus your keyword lists.

Refer to our website for the list of available metrics and attributes you can extract from Sprinklr.

If you have multiple Sprinklr accounts and would like to extract the same data from all of them, it's possible through multi-account extraction. Contact our Solutions team to enable this feature.

Authentication Methods

You can connect to Sprinklr in two ways:

  • Sign in with Sprinklr and approve access (recommended). You enter your API subdomain, then log in with your Sprinklr account.
  • Use your own Sprinklr app (for advanced setups). Connect with the Client ID and Client Secret of your own Sprinklr OAuth app.

Authorize Connection to Sprinklr

  1. In Dataddo, go to Authorizers and click Authorize New Service.
  2. Select Sprinklr, or Sprinklr Custom to use your own app.
  3. Fill in the connection details:

For Sprinklr:

Field Details
Subdomain Your Sprinklr API subdomain. Default: api3.
Environment Leave blank for production (app.sprinklr.com). For other environments enter the prefix, e.g. prod0 for prod0.sprinklr.com.

For Sprinklr Custom:

Field Details
Client ID The Client ID of your Sprinklr OAuth app.
Client Secret The Client Secret of your Sprinklr OAuth app.
Environment Your Sprinklr environment (e.g. prod3). Leave blank for the Production environment.

Before you connect with Sprinklr Custom, create an API user and API keys in your Sprinklr account. Then register this Redirect URI in your Sprinklr OAuth app settings: https://app.dataddo.com/settings/service/sprinklrCustom

  1. Click Save and sign in with your Sprinklr account.

Data Coverage

The connector offers the datasets below. The example fields are a representative sample.

Dataset Description Example fields Date range
Fetch All Keyword Lists All keyword lists configured in the Sprinklr workspace. Keyword List ID, Name No
Read Keyword List Full configuration of a single keyword list, including all keyword conditions and tags. Keyword List ID, Term, Description, Distance, Keyword Type, Name (+1 more) No
Organic Posts Rolling Metrics Engagement totals per outbound post, with dimensions for channel, account, status, and campaign. Unique Message ID, Account, Campaign ID, Content Language, Created Date, Is Dark Post (+7 more) Yes
Paid Campaigns Daily Metrics Daily spend, impressions, clicks, and conversions per paid campaign, broken down by channel and status. Date, Campaign ID, Campaign Name, Campaign Status, Channel, Clicks (+4 more) Yes
Unified Analytics Daily Metrics Daily paid and organic engagement metrics per account and channel, combining data from all connected social networks. Date, Account, Campaign ID, Campaign Name, Data Type, Facebook Video Total View Time (Total) (+14 more) Yes

Two datasets need an extra pick during setup:

  • Read Keyword List asks you to select one keyword list from your account.
  • Unified Analytics Daily Metrics asks you to select one of the Unified Analytics reports in your account. The report list is loaded live from Sprinklr.

How Data Extraction Works

The three analytics datasets use a relative date range, for example "last 7 days". The range sets the report's start and end time. Every run re-reads that window against the current date, so the window slides forward over time. Each run replaces the window's data, it does not accumulate older history. To load data from before the window, run a full data re-sync with a wider range. See Data Backfilling.

Note that Organic Posts Rolling Metrics returns rolling engagement totals per post. The numbers reflect the state at extraction time, so we recommend upserting on dataddo_hash to keep your destination current.

The two keyword list datasets have no date range. Every run pulls all data that is currently available.

Metadata Columns

The three analytics datasets can add optional Dataddo metadata columns:

  • dataddo_hash is a fingerprint of each record's key fields. It works as a natural key and is ideal for upserts. You can pick which columns form the hash.
  • dataddo_extraction_timestamp is the time the record was extracted. Use it to track slowly changing dimensions.
  • dataddo_date_start and dataddo_date_stop mark the start and end of the time period the run covered.

The keyword list datasets do not offer metadata columns.

How to Create a Sprinklr Data Source

  1. In Dataddo, go to Sources and click Create Source.
  2. Search for Sprinklr and select it.
  3. Pick the dataset you want to extract.
  4. Choose your Sprinklr authorizer.
  5. Name the data source and select the fields to extract. For Read Keyword List, pick the keyword list. For Unified Analytics Daily Metrics, pick the report.
  6. Set the date range for the analytics datasets.
  7. Click Test Data to preview the data.
  8. Click Save.

Troubleshooting

No Data Preview

If Test Data shows no preview:

  • Try a smaller or different date range. The selected period may have no data.
  • For Unified Analytics Daily Metrics, check that the selected report still exists in Sprinklr.
  • Check that your authorized Sprinklr account has access to the reporting data.

Related Articles

Now that you have successfully created a data source, see how you can connect your data to a dashboarding app or a data storage.

Sending Data to Dashboarding Apps

Sending Data to Data Storages

Other Resources