This document summarizes the user information available through Xeerpa Enterprise DB.
The Information available may differ depending on the Social Networks permissions requested by the apps.
Items in this colour represent Twitter information, when available.
Items in this colour represent LinkedIn information, when available.
Items in this colour represent Google+ information, when available.
All information will be sent via one of these methods:
- Multiple CSV files (exclusively with modified data) weekly via one of the following methods:
- sFTP. You should provide us your server, port, username and password.
- Amazon Web Services S3 Account. You should provide us your region, bucket, secretAccessKey and accessKeyId.
- MongoDB database: You should provide us your server, port, database, username and password.
These are the default files. If you need a specific format or and alternative means of receiving the information, please let us know.
Replace %CLIENTNAME% with the appropriate name when using the following files.
V_%CLIENTNAME%
User information.
Field name
Description
Data type
user_id
User id
Varchar
date
Creation date. NOTE: See V_%CLIENTNAME%_XAPPS.date for the date of participation in an app.
Datetime
modified
Latest modification
Datetime
name
User name
Varchar
surname
Surname(s)
Varchar
sex
Gender (m:male, f:female)
Varchar
birthday
Birthday date
Datetime
born_in
Birth place
Varchar
born_in_country
Birth country
Varchar
born_in_city
Birth city
Varchar
born_in_region
Birth region
Varchar
fbid
Facebook id
Varchar
friends_number_fb
Number of Facebook Friends
Varchar
twid
Twitter id
Varchar
screen_tw
Twitter screen
Varchar
friends_number_tw
Number of Twitter Friends
Varchar
followers_number_tw
Number of Twitter Followers
Varchar
liid
Linkedin id
Varchar
friends_number_li
Number Linkedin Friends
Varchar
headline
Headline
Varchar
industry
Industry
Varchar
goid
Google+ id
Varchar
loc_name
Current location
Varchar
loc_country
Current country
Varchar
loc_city
Current city
Varchar
loc_region
Current region
Varchar
loc_locale
Current locale
Varchar
social_score
Social Influence score
Varchar
promotional_score
Promotional score
Varchar
engagement_score *
Average engagement score
Varchar
fan_value *
Average fan value score
Varchar
robinson **
Robinson
Varchar
latest_scope_fb
Last scope accepted by user
Varchar
Information
Information
0: Accept communications.
V_%CLIENTNAME%_BRANDS
Brands the user has interacted with.
Information
Field name
Description
Data type
user_id
User id
Varchar
brandid
Brand Id
Varchar
Name
Brand name
Varchar
engagement_score
Engagement score
Varchar
fan_value
Fan Value
Varchar
socX
Influence amongst your users in Xeerpa
Varchar
V_%CLIENTNAME%_CONTACT
Ways to contact users (Email, Web...).
Field name
Description
Data type
user_id
User id
Varchar
social_network_id
Contact origin
Varchar (‘fb’ : Facebook, ’tw’ : Twitter, ‘li’ : LinkedIn)
kind
Kind of contact
Varchar (‘Email’, ‘IM’ (Instant Messaging), ‘Web’, ‘Social Network’)
value
Contact
Varchar
V_%CLIENTNAME%_APPS
Facebook applications the user has used, from all vendors and companies.
Field name
Description
Data type
user_id
User id
Varchar
fbid
Facebook’s app id
Varchar
name
App name
Varchar
count
Number of times that the user used the app, interacting with the user’s wall
Varchar
V_%CLIENTNAME%_CATEGORIES
User categories. Note that not all categories have a calculated value.
Field name
Description
Data type
user_id
User id
Varchar
category_en
Category name (English)
Varchar
category_es
Category name (Spanish)
Varchar
value
Value of the interest in this category from 0 to 10
Varchar
V_%CLIENTNAME%_CLOUD
Keywords that are most predominant in the user’s comments
Field name
Description
Data type
user_id
User id
Varchar
social_network_id
Comment origin
Varchar (‘fb’ : Facebook, ’tw’ : Twitter, ‘li’ : LinkedIn)
tag
Keyword
Varchar
V_%CLIENTNAME%_EDUCATION
Educational information for each user
Field name
Description
Data type
user_id
User id
Varchar
social_network_id
Education origin
Varchar (‘fb’ : Facebook, ’tw’ : Twitter, ‘li’ : LinkedIn)
school
Name of the institution
Varchar
year
Year
Varchar
yearEnd
Year
Varchar
type
Type of institution (school, college, university…)
Varchar
field
Education field
Varchar
V_%CLIENTNAME%_EXTERNALDATA
External data related to each user and incorporated into Xeerpa. Includes data filled-in by the user in apps, data pushed from the CRM, etc.
V_%CLIENTNAME%_FRIENDS
List of friends of a user
Field name
Description
Data type
user_id
User id
Varchar
fbid
Friend’s Facebook id
Varchar
twid
Friend’s Twitter id
Varchar
screen
Friend’s Twitter screen
Varchar
name
Friend’s name
Varchar
kind
Kind of Friend
Varchar (‘Friend’ (Following & Follower), ‘Following’, ‘Follower’)
user_id_friend
Xeerpa Id, when the friend is also profiled in Xeerpa
Varchar
V_%CLIENTNAME%_FRIENDSX
List of friends of a user also found in your Xeerpa database
Field name
Description
Data type
user_id
User id
Varchar
friendId
User’s friend
Varchar
V_%CLIENTNAME%_LATESTTWEETS
A user's most recent tweets.
Field name
Description
Data type
user_id
User id
Varchar
date
Tweets’s date
Datetime
tweet
Contents
Varchar
V_%CLIENTNAME%_LANGUAGES
User languages. Note that languages not recognized by Xeerpa will be preceded by ‘0-‘.
Field name
Description
Data type
user_id
User id
Varchar
name_en
Language name (English)
Varchar
name_es
Language name (Spanish)
Varchar
V_%CLIENTNAME%_LATESTPOST
Latest Facebook posts by the user.
Field name
Description
Data type
user_id
User id
Varchar
date
Post’s date
Datetime
feed
Contents
Varchar
link
Link to post, when available
Varchar
V_%CLIENTNAME%_LIKES
User Likes.
Field name
Description
Data type
user_id
User id
Varchar
item
Like name
Varchar
date
Date when user added the Like
Datetime
V_%CLIENTNAME%_LOCATIONS
User Locations.
Field name
Description
Data type
user_id
User id
Varchar
date
When the user added the location
Datetime
name
Location’s name
Varchar
country
Country’s name
Varchar
city
City’s name
Varchar
region
Region’s name
Varchar
lon
Geo-location
Varchar
lat
Geo-location
Varchar
address
Location’s full address
Varchar
V_%CLIENTNAME%_SUBCATEGORIES
User subcategories. Note that not all interests may have a calculated value.
Field name
Description
Data type
user_id
User id
Varchar
category_en
Category name (English)
Varchar
category_es
Category name (Spanish)
Varchar
subcategory_en
Subcategory name (English)
Varchar
subcategory_es
Subcategory name (Spanish)
Varchar
value
Value of the interest in the subcategory, from 0 to 10
Varchar
V_%CLIENTNAME%_POSITIONS
User’s professional information.
Field name
Description
Data type
user_id
User id
Varchar
social_network_id
Comment origin
Varchar (‘fb’ : Facebook, ’tw’ : Twitter, ‘li’ : LinkedIn)
company
Name of the Company
Varchar
position
Role at the Company
Varchar
location
Company’s location
Varchar
country
Company’s country
Varchar
city
Company’s city
Varchar
region
Company’s region
Varchar
year
Year
Varchar
yearEnd
End Year
Varchar
isCurrent
Is current Position?
Varchar
V_%CLIENTNAME%_XAPPS
From your own promotions connected to Xeerpa in which the user has participated.
Field name
Description
Data type
user_id
User id
Varchar
name
App’s name
Varchar
social_network_id
App´s Social Network
Varchar
brand
Brand’s name
Varchar
date
When the user participated for the first time
Datetime
V_%CLIENTNAME%_AWARDS
User awards
Field name
Description
Data type
user_id
User id
Varchar
issuer
Issuer
Varchar
title
Title
Varchar
V_%CLIENTNAME%_SKILLS
User skills
Field name
Description
Data type
user_id
User id
Varchar
skill
Skill name
Varchar
V_%CLIENTNAME%_GROUPS
User groups
Field name
Description
Data type
user_id
User id
Varchar
group
Group name
Varchar
V_%CLIENTNAME%_SHARES
User shares
Field name
Description
Data type
user_id
User id
Varchar
url
Share url
Varchar
description
Share description
Varchar
title
Share title
Varchar
date
Share date
Datetime
V_%CLIENTNAME%_LATESTFEEDS
Latest Google+ Feeds by the user.
Field name
Description
Data type
user_id
User id
Varchar
date
Feed’s date
Datetime
feed
Contents
Varchar
link
Link to feed, when available
Varchar
V_%CLIENTNAME%_PERSONALITY
IBM Watson Personality Insights.
Field name
Description
Data type
user_id
User id
Varchar
trait
Unique, non-localized identifier of the characteristic to which the results pertain
Varchar
pct
0-1 coefficient for each trait
Varchar
V_%CLIENTNAME%_WALL
Fanpage data per user and brand.
Field name
Description
Data type
user_id
User id
Varchar
brand
Brand name
Varchar
interactions_level
Level of interactions
Varchar
react_likes
Total user's reactions to brand content (n_like + n_haha + n_angry + n_sad + n_wow)
Varchar
n_likes
Number of Likes
Varchar
n_haha
Number of Hahas
Varchar
n_love
Number of Loves
Varchar
n_angry
Number of Angries
Varchar
n_sad
Number of Sads
Varchar
n_wow
Number of Wows
Varchar
react_comments
User's comments on brand's posts
Varchar
react_shares
Brand's posts shared on user's walls
Varchar
react_mentions
Mentions to Brand by user on brand's wall.
Varchar
react_hashtags
Tags of Brand in user's posts or comments.
Varchar
user_conversation
Conversations initiated by users - Number of conversations
Varchar
user_likes_by_brand
Conversations initiated by users - Number of user's likes on Brand's posts
Varchar
user_likes_by_other_users
Conversations initiated by users - Number of user's likes on other users' posts/comments
Varchar
user_comments
Conversations initiated by users - Number of user's comments on other users' posts
Varchar
user_shares
Conversations initiated by users - Number of user's shares on other users' posts
Varchar
V_%CLIENTNAME%_WALL_DETAIL
Fanpage data per user and brand.
Field name
Description
Data type
user_id
User id
Varchar
brand
Brand name
Varchar
date
Date of interaction
Datetime
type
Type of interaction ("ANGRY", "HAHA", "LIKE", "LOVE", "SAD", "WOW", "comm", "subc"
Varchar
data
Comment on the wall
Varchar
V_%CLIENTNAME%_HASHTAGS
Hashtags used by the user and number of uses.
Field name
Description
Data type
user_id
User id
Varchar
name
Hashtags
Varchar
number_of_uses
Number of Uses
Varchar
;){kind=link}
;){kind=link}
;){kind=link}