P_SrchTrmSntWithPost

Social Post Details | view: PSNTMNTWTHPST | Extraction: Not supported | Component: Social Media Intelligence Foundation
Column Name Description
SocialDataUUID null
Column Name Description
Column Name Description
Column Name Description
SocialPostCreationDate_E null
Column Name Description
Column Name Description Domain name
SocialPostSearchTermText Search Term SMI_SOCIALPOSTSEARCHTERMTEXT
CalendarMonth null
CalendarYear null
WeekDay null
YearQuarter null
YearWeek null
Quarter null
CalendarWeek null
YearMonth null
SocialPostCreationDate null
SocialMediaUserName Social Media User Name SMI_USERNAME
SocialPostSentimentVal null
SocialPost Social Media Data ID String SMI_SOCIALPOST
SocialPostCreationDateTime Social Post creation Timestamp in UTC Format TZNTSTMPL
SocialPostText_E Mention Text SMI_SOCIALPOSTTEXT
SocialPostCreationTime_E null
SocialMediaChannelDesc Social Media Channel Description SMI_SOCIALMEDIACHANNELDESC
CalculatedScore null
SearchTermPstvSntmntVal_E null
SearchTermNgtvSntmntVal_E null
NmbrOfPstvSocialPostVal_E null
NmbrOfNgtvSocialPostVal_E null
NmbrOfNtrlSoclPostVal_E null
NmbrOfSocialPosts_E null
Master Data Relations Join Conditions
Social Media Channel Code
  • Social Media Channel Code
  • Client
  • P_SRCHTRMSNTWITHPOST.SOCIALMEDIACHANNEL == SMI_CHNLDEF.SOCIALMEDIACHANNEL
  • P_SRCHTRMSNTWITHPOST.MANDT == SMI_CHNLDEF.CLIENT
Other Relations Join Conditions
Keyword IDs from Search Terms
  • Keyword IDs from Search Terms
  • Client
  • P_SRCHTRMSNTWITHPOST.SOCIALPOSTSEARCHTERM == SMI_SRCHTERM.SOCIALPOSTSEARCHTERM
  • P_SRCHTRMSNTWITHPOST.MANDT == SMI_SRCHTERM.CLIENT