SOCIALUSERINFO

Social User Info Definition | #masterdata | Component: Social Media Intelligence Foundation
Column Name Description
CLIENT Client
SOCIALMEDIACHANNEL FK Social Media Channel Code
SOCIALUSER Social Media User ID
Column Name Description
Column Name Description
Column Name Description
Column Name Description
GENDERCODE Gender Show values
ISUSERIDSURROGATE Is Social Media User ID Surrogate Show values
SOCIALUSERTYPE Social User Type Show values
ISPSEUDOUSER Is User a Pseudo User Show values
Column Name Description Domain name
GIGYAUUID Social Media User ID in Data Provider SMI_USERIDINDATAPROVIDER
SOCIALUSERPROFILELINK Link to User Profile in a Social Media Channel SMI_SOCIALUSERPROFILELINK
SOCIALUSERACCOUNT Social Media User Account SMI_SOCIALUSERACCOUNT
NUMBEROFSOCIALUSERCONTACTS Count of User Contacts in Social Media SMI_COUNT
SOCIALUSERINFLUENCESCOREVALUE Influence Score SMI_SOCLUSRINFLUENCESCOREVALUE
CREATIONDATETIME Post Creation Timestamp SMI_DATETIME
LOCATIONNAME Location SMI_LOCATIONNAME
COUNTRYNAME Country SMI_COUNTRYNAME
SOCIALUSERNAME Social Media User Name SMI_USERNAME
SOCIALUSEREMAILADDRESS Social Media User E-mail Address SMI_SOCIALUSEREMAILADDRESS
SOCIALUSERNAME_UC Social Media User Name in Upper Case SMI_USERNAME_UC
CREATEDAT Creation Date and Time in System (UTC Timestamp) TZNTSTMPS
SOCIALUSERIMAGELINK Social User Profile Image URL SMI_SOCIALUSERIMAGEURL
Master Data Relations Join Conditions
Social Media Channel Code
  • SOCIALUSERINFO.CLIENT == SMI_CHNLDEF.CLIENT
  • SOCIALUSERINFO.SOCIALMEDIACHANNEL == SMI_CHNLDEF.SOCIALMEDIACHANNEL