|
Primary Use Cases |
{" "} Sprinklr allows an organization to aggregate their various social platform accounts into one place and track social media KPIs.{" "} |
|
Primary Metrics |
|
|
Primary Company Roles |
Social marketers |
|
Average Implementation Time |
{" "} Application process to access the API could take 2 weeks. Actual implementation time once authenticated takes about 5 hours.{" "} |
|
Ease of Use (on a 1-to-10 scale with 1 being easiest) |
7 |
|
Field |
Description |
|---|---|
|
Environment |
Select the Sprinklr environment you want to connect to, either sandbox or production. |
|
Client ID |
Enter your Sprinklr client ID. |
|
Client Secret |
Enter your Sprinklr client secret. |
|
Menu |
Description |
||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Report |
Select a Sprinklr report. The following reports are available:
|
||||||||||||||||||||||||||
|
Aggregate Function |
{" "} Select how you would like the data in the report to be aggregated.{" "} | ||||||||||||||||||||||||||
| {" "} Measurement Names{" "} | {" "} Select all the measurements you want to retrieve data for.{" "} | ||||||||||||||||||||||||||
| {" "} Group By Options{" "} |
{" "} Enter the desired groupby options in the format {" "} (columnName,dimensionName,groupType,detail=value){" "} .{" "} {" "} For example: {" "} ("MyAccountId",ACCOUNT\_ID,FIELD),(date,DATE\_HISTOGRAM,interval=1w){" "} |
||||||||||||||||||||||||||
| {" "} Filter Options{" "} |
{" "} Enter the desired filter options in the format {" "} (dimensionName,filterType,\[value1,value2],detail=value).{" "} {" "} For example: {" "} (SN\_TYPE,IN,\[FACEBOOK]),(CLIENT\_ID,IN,\[62]),(ACCOUNT\_ID,IN,\[3051,553,565]){" "} |
||||||||||||||||||||||||||
| {" "} Measurement Options{" "} | {" "} Select measurement options for additional result calculations.{" "} | ||||||||||||||||||||||||||
|
Duration |
Select whether you want to pull data for a specific date or a date range. |
||||||||||||||||||||||||||
|
Report Date |
Select whether the report data is for a specific date or for a relative number of days back from today. |
||||||||||||||||||||||||||
|
Select Specific Date |
Select the date for the report. |
||||||||||||||||||||||||||
|
Days Back |
Enter the number of past days that should appear in the report. |
||||||||||||||||||||||||||
|
Start Date |
{" "} Specify whether the first date in your date range is a specific or relative date. You select the last date in your range in End Date .{" "} |
||||||||||||||||||||||||||
|
End Date |
{" "} Specify whether the second date in your date range is a specific or relative date. You select the first date in your range in Start Date .{" "} |
||||||||||||||||||||||||||
|
Select Specific Start Date |
Select the first date in your date range. |
||||||||||||||||||||||||||
|
Select Specific End Date |
Select the second date in your date range. |
||||||||||||||||||||||||||
|
Days Back to Start From |
{" "} Enter the number of the farthest day back that should be represented in the report. Combine with {" "} Days Back to End At{" "} to create a range of represented days.{" "} {" "} For example, if you entered 10 for {" "} Days Back to Start From{" "} and 5 for Days Back to End At , the report would contain data for 10 days ago up until 5 days ago.{" "} |
||||||||||||||||||||||||||
|
Days Back to End At |
{" "} Enter the number of the most recent day back that should be represented in the report. Combine with {" "} Days Back to Start From{" "} to create a range of represented days.{" "} {" "} For example, if you entered 10 for {" "} Days Back to Start From{" "} and 5 for Days Back to End At , the report would contain data for 10 days ago up until 5 days ago.{" "} |
||||||||||||||||||||||||||
| {" "} Select Resources{" "} | {" "} Select all resources you want to retrieve data for.{" "} | ||||||||||||||||||||||||||
| {" "} Select Reports{" "} | {" "} Select all reports you want to retrieve custom metric information for.{" "} | ||||||||||||||||||||||||||
| {" "} Dashboard Name{" "} | {" "} Enter the dashboard name (e.g. AutoDashboard ).{" "} | ||||||||||||||||||||||||||
| {" "} Column Name{" "} | {" "} Enter the column name (e.g. fbinbox ).{" "} | ||||||||||||||||||||||||||
| {" "} Channel Type for the Profile{" "} | {" "} Enter the channel type for the profile (e.g. FACEBOOK ).{" "} | ||||||||||||||||||||||||||
| {" "} Profile ID of Social Channel{" "} | {" "} Enter the unique profile ID of the social channel (e.g. {" "} 215244391952058{" "} ).{" "} | ||||||||||||||||||||||||||
| {" "} Stream{" "} | {" "} Enter the ID for the stream you want to retrieve data for.{" "} | ||||||||||||||||||||||||||
| {" "} Widget Type{" "} | {" "} Select the type of listening widget you want to retrieve data for (distribution, trend, etc.).{" "} | ||||||||||||||||||||||||||
| {" "} Columns to Expand (Optional){" "} | {" "} Enter a comma-separated list of columns you want to expand into multiple columns. These are columns normally returned as "List" or "Object."{" "} | ||||||||||||||||||||||||||
| {" "} Dimension{" "} | {" "} Select the first dimension you want to show in your "Listening Widget" report.{" "} | ||||||||||||||||||||||||||
| {" "} Custom Field Name{" "} | {" "} Enter the custom field name for your selected dimension.{" "} | ||||||||||||||||||||||||||
| {" "} Other Dimension{" "} | {" "} Select the second dimension you want to show in your "Listening Widget" report.{" "} | ||||||||||||||||||||||||||
| {" "} Subtype{" "} | {" "} Select the subtype of users you want to retrieve data for in your "Listening Widget" report.{" "} | ||||||||||||||||||||||||||
|
Expand Lists |
{" "} Choose whether you want to expand columns that contain lists. If you choose this option, your DataSet may contain multiple rows for a single post.{" "} |
||||||||||||||||||||||||||
|
Query |
Enter a custom query to pull a Sprinklr report into Domo. |
## Other Panes
For information about the remaining sections of the connector interface, including how to configure scheduling, retry, and update options, see [Adding a DataSet Using a Data Connector](/s/article/360042926274 "Adding a DataSet Using a Data Connector").
## Troubleshooting
The most commonly occurring issue with this connector relates to filters. Each report in Sprinklr is filtered and run on a separate query that cleans the Sprinklr data displayed in the reports on the Sprinklr website. When setting up the connector, you *must* use these same filters; otherwise, data will be duplicated or missing. To do this, you must use the API call that is in the backend of a Sprinklr Report.
To access this code or to find the filters and backend report to pull from the connector, do the following:
1. Open the Chrome browser.
2. Right-click in the browser and select **Inspect**.
3. In the developer screen, navigate to the **Network** tab.
4. Refresh your screen on the Sprinklr report page.
This causes several elements to appear under the **Name** column.
5. Search through the queries and find the corresponding report or data you want to replicate.
6. Select the query and search under **requests** to find all the inputs you need to enter into the Domo Connector.
7. Connect to the Sprinklr connector to Domo using your credentials.
8. Select the report used in the Sprinklr report.
In Sprinklr this is found under **requests >** **parameter**. In the sample it is called “Post Insights.”
9. For **Aggregation Function**, select the function used in the Sprinklr report.
In Sprinklr this is found under **groupBys >** **p** **rojections**. In the sample it is called **SUM**.
10. For **Measurement** **Name**, select the function used in the Sprinklr report.
In Sprinklr this is found under **groupbys > projections > measurement**. In the sample it is called **TOTAL\_ENGAGEMENT**.
11. For **Group By Options,** enter the **groupby** fields found in the Sprinklr report under the **Requests** dropdown menu in the **Network** tab, using the syntax (columnName,dimensionName,groupType,detail=value).
For example, if I had the “Client\_ID” field listed in the group, I would use the following syntax for **Group By Options**: (Client\_ID,Client\_ID, field).
We also recommend you use a date group by even though the Sprinklr report may not contain that information, so the Domo cards will render the data in the needed format. For example: (date,DATE\_HISTOGRAM,interval=1h) or (POST\_PUBLISHED\_DATE,FIELD)
12. For **Filters**, enter the filters used in the Sprinklr report.
In Sprinklr these are found under **requests > filters**. Use the syntax under? that you find by the **Filters** box.
13. (Conditional) If the query code in the Sprinklr report states that
**Columns to Expand** and **Measurement** **Options** are being used, enter the info that is included in the “request” data.
14. When configuring the time frame, use the time frame stated in the actual Sprinklr report/graph or the one needed for your card visualization. For most Sprinklr reports in Domo, no time frame is provided in the actual Sprinklr report. You can see in the backend that the time stated in the **Time** filter is in a format that is not database friendly or recognizable as a date.
## Building Drilldown
To create drilldown in your Sprinklr data, design or find the type of drilldown you wish to see in your card and create a new Sprinklr DataSet that shows that data. For the drilldown to work, you will need to pull or rename the same field names in a DataFlow that correspond with the top level Sprinklr data source.
## FAQs
| {" "} Report Name{" "} | {" "} Endpoint URL(s){" "} |
|---|---|
| {" "} Account Insights{" "} | {" "} /reports/query{" "} |
| {" "} Bootstrap Info{" "} | {" "} /bootstrap/resources{" "} |
| {" "} Custom Metric Information{" "} | {" "} /reports/customMetric{" "} |
| {" "} Custom Query{" "} | {" "} /reports/query{" "} |
| {" "} Dashboard Column{" "} | {" "} /dashboard/{dashboardName}/stream/{columnName}{" "} |
| {" "} Listening Stream{" "} | {" "} /listening/query/stream{" "} |
| {" "} Listening Topic Configuration{" "} | {" "} /listening/topics{" "} |
| {" "} Listening Widget{" "} | {" "} /listening/query/widget{" "} |
| {" "} Paid Ad Stat Insights{" "} | {" "} /reports/query{" "} |
| {" "} Post Insights{" "} | {" "} /reports/query{" "} |
| {" "} Profile Conversion Data{" "} | {" "} /profile/conversations{" "} |
| {" "} Profile Details{" "} | {" "} /profile{" "} |
| {" "} Stream Feed{" "} | {" "} /stream/{streamId}/feed{" "} |