Loading...
 

Xeerpa Enterprise DB

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.

 

Files

 

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
If your database has more than one brand engagement_score and fan_value will be in %CLIENTNAME%_BRANDS.
Information
1: Does not accept communications.
0: Accept communications.


V_%CLIENTNAME%_BRANDS

Brands the user has interacted with.

Information
If your database has only one brand engagement_score and fan_value will be in %CLIENTNAME% and this file won´t be created.
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%_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