P_SrchTrmSntTrnd2

Search Term Sentiment Trend 2 | view: PSNTMNTTRND2 | Extraction: Not supported | Component: Social Media Intelligence Foundation
Column Name Description
SocialPostSearchTerm FK Keyword IDs from Search Terms
Column Name Description
Column Name Description
Column Name Description
Column Name Description
IsSocialMediaQueryActivated Checks if the Query is Active Show values
Column Name Description Domain name
socialpostsearchtermtext Search Term SMI_SOCIALPOSTSEARCHTERMTEXT
SclMdaQryLstActivatedDateTime Search Query Last Activated Timestamp (UTC) TZNTSTMPL
SearchTermPstvSntmntwfc_E null
SearchTermNgtvSntmntwfc_E null
SearchTermNetSntmntwfc_E null
SearchTermNtrlSntmntwfc_E null
NmbrOfPstvSocialPostValwfc_E null
NmbrOfNgtvSocialPostValwfc_E null
NmbrOfSocialPostswfc_E null
SearchTermPstvSntmntfc_E null
SearchTermNgtvSntmntfc_E null
SearchTermNetSntmntfc_E null
SearchTermNtrlSntmntfc_E null
NmbrOfPstvSocialPostValfc_E null
NmbrOfNgtvSocialPostValfc_E null
NmbrOfSocialPostsfc_E null
Other Relations Join Conditions
Keyword IDs from Search Terms
  • Client
  • Keyword IDs from Search Terms
  • P_SRCHTRMSNTTRND2.MANDT == SMI_SRCHTERM.CLIENT
  • P_SRCHTRMSNTTRND2.SOCIALPOSTSEARCHTERM == SMI_SRCHTERM.SOCIALPOSTSEARCHTERM