P_SrchTrmSntSclMdChnl1

Search Term Sentiment In Social Media Channel 1 | view: PSRCHTRMSNT1 | Extraction: Not supported | Component: Social Media Intelligence Foundation
Column Name Description
SocialPostSearchTerm FK Keyword IDs from Search Terms
SocialDataUUID null
SocialPostCreationDate null
Column Name Description
Column Name Description
Column Name Description
TodayDate null
SocialPostCreationDate_E null
Column Name Description
IsSocialMediaQueryActivated Checks if the Query is Active Show values
Column Name Description Domain name
SocialPostSearchTermText Search Term SMI_SOCIALPOSTSEARCHTERMTEXT
SocialPostSearchTermTextLower Search Term SMI_SOCIALPOSTSEARCHTERMTEXT
SocialPostSentimentVal null
SclMdaQryLstActivatedDateTime Search Query Last Activated Timestamp (UTC) TZNTSTMPL
SocialPostPositiveSentiment_E null
SocialPostNegativeSentiment_E null
SocialPostNeutralSentiment_E null
NmbrOfPstvSocialPostVal_E null
NmbrOfNgtvSocialPostVal_E null
NmbrOfMentions_1 null
Other Relations Join Conditions
Keyword IDs from Search Terms
  • Client
  • Keyword IDs from Search Terms
  • P_SRCHTRMSNTSCLMDCHNL1.MANDT == SMI_SRCHTERM.CLIENT
  • P_SRCHTRMSNTSCLMDCHNL1.SOCIALPOSTSEARCHTERM == SMI_SRCHTERM.SOCIALPOSTSEARCHTERM