P_SrchTrmSntSclMdChnl2

Search Term Sentiment In Social Media Channel 2 | view: PSRCHTRMSNT2 | 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
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
SearchTermPstvSntmnt_E null
SearchTermNgtvSntmnt_E null
SearchTermNtrlSntmnt_E null
SearchTermNetSntmnt_E null
SrchTrmNetSntmntScore_E null
NmbrOfSocialPosts_E null
NmbrOfPstvSocialPostVal_E null
NmbrOfNgtvSocialPostVal_E null
SclMdaQryLstActivatedDateTime Search Query Last Activated Timestamp (UTC) TZNTSTMPL
p_fact null
StartDay null
EndDay null
Other Relations Join Conditions
Keyword IDs from Search Terms
  • Client
  • Keyword IDs from Search Terms
  • P_SRCHTRMSNTSCLMDCHNL2.MANDT == SMI_SRCHTERM.CLIENT
  • P_SRCHTRMSNTSCLMDCHNL2.SOCIALPOSTSEARCHTERM == SMI_SRCHTERM.SOCIALPOSTSEARCHTERM