Use CharCount operators for searching content having particular characters count range

Updated 

1 year ago

Learn how to use the CharCount operators to fetch mentions containing characters in a specific range.​

​Sprinklr's ​​CharCount​​ operators allow you to fetch conversation on the basis of the number of characters in an article/ conversation. By using this operator, you can monitor your marketing campaigns where you expect the responses to contain a fixed number of characters. ​

​Types of CharCount operators supported –​

  • ​titleCharCount:​​ This will return conversations having a certain number of characters in the title.

  • ​messageCharCount:​​ This will return conversations having a certain number of characters in the message body. ​

  • ​contentCharCount:​​ This will return conversations having a certain number of characters in the title and/or message combined.​

Persona​

​Brands want to monitor the conversation with their brand mention but avoid unnecessary chatter pulling up just the mention of the brand.​

​Use cases​

  • ​titleCharCount:​​ To monitor campaigns across news, blogs/websites, and other web and traditional sources ​

  • ​messageCharCount:​​ To monitor campaigns across social media ​

  • ​contentCharCount:​​ Recommended when there’s no generic channel that needs to be monitored​

​Availability ​

​The CharCount operator can be used in – ​

  • ​Listening Topics ​

  • ​Listening Themes ​

  • ​Story ​

  • ​Quick Search (Listening Explorer) ​

  • ​Filters within the widget at "Query Containing" ​

  • ​Filter at Dashboard Level – "Keyword Query"​

  • ​Search ​

​Any other Query building sections that support advanced operators in Sprinklr Insights​.

​Syntax examples​

  • titleCharCount: [0 TO 15]​​ will return conversations having number of characters between 0 to 15 in the title: inclusive of 0 & 15 ​

  • ​titleCharCount: {0 TO 15]​​ will return conversations having number of characters between 0 to 15 in the title: exclusive of 0 & inclusive of 15 ​

  • ​titleCharCount: [0 TO 15}​​ will return conversations having number of characters between 0 to 15 in the title: inclusive of 0 & exclusive of 15 ​

  • ​titleCharCount: {0 TO 15}​​ will return conversations having number of characters between 0 to 15 in the title: exclusive of 0 & 15​

  • contentCharCount: [0 TO 15]​​ will return conversations having number of characters between 0 to 15 in the title, message, and/or userbio: inclusive of 0 & 15 ​

  • ​contentCharCount: {0 TO 15]​​ will return conversations having number of characters between 0 to 15 in the title, message, and/or userbio: exclusive of 0 & inclusive of 15 ​

  • ​contentCharCount: [0 TO 15}​​ will return conversations having number of characters between 0 to 15 in the title, message, and/or userbio: inclusive of 0 & exclusive of 15 ​

  • ​contentCharCount: {0 TO 15}​​ will return conversations having number of characters between 0 to 15 in the title, message, and/or userbio: exclusive of 0 & 15 ​

  • messageCharCount: [0 TO 15]​​ will return conversations having number of characters between 0 to 15 in the body: inclusive of 0 & 15​

  • ​messageCharCount: {0 TO 15]​​ will return conversations having number of characters between 0 to 15 in the message: exclusive of 0 & inclusive of 15​

  • ​messageCharCount: [0 TO 15}​​ will return conversations having number of characters between 0 to 15 in the message: inclusive of 0 & exclusive of 15​

  • ​messageCharCount: {0 TO 15}​​ will return conversations having number of characters between 0 to 15 in the message: exclusive of 0 & 15​

Query example​

​The operator can be used in conjunction with ​​AND​​ with other operators.​

​For example – ​​userbio: ("Google") AND messageCharCount: [10 TO 50])​

Note:

  • You can use the above operators in the Advanced Query builder section and other query building sections applicable.​

  • ​You will be informed visually if there is a wrong syntax while using the operators in the ​​Preview​​ window as well as in the query builder.​

  • ​The selected/matched entries will be shown in the Preview window.​

  • ​You cannot fetch historic data using the CharCount operators.​

Was this article helpful?

Related Articles

Loading...