|
Column
|
Description
|
|
action_is_moderator_action
|
(Added Nov 2016) True if the action was initiated by a moderator
Example: true
|
|
action.duration
|
Visit duration in seconds
Example: 720
|
|
action.is_solution_view
|
True or False statement whether this action was a page view on a thread that was marked as a solution
Example: TRUE
|
|
action.key
|
Defines the type of event that has been logged. See action.key events below for the actions.
Example: "view" = page view
|
|
action.span.seconds
|
Duration in seconds for the time to first reply or time to first solution
Example: 7200
|
|
action.weight
|
Used by communities to weight actions of select users higher than other users. Not relevant if the Community does not to use weight. Primarily used for kudos where kudos by some users are weighted higher than kudos by other users.
1 for any users, 2 for super user
Example: 2
|
|
badge.activation_date
|
(Added Nov 2016) The date at which this badge was activated
Example: 1405027061483
|
|
badge.is_retroactive
|
(Added Nov 2016) Indicates whether a badge is applied retroactively or not
Example: true
|
|
badge.title
|
(Added Nov 2016) The title of the badge
Example: Rock Star
|
|
badge.uid
|
Unique identifier of which badge on which this action took place
Example: 123
|
|
board.title
|
Title of board on which this action took place
Example: Product XYZ
|
|
board.uid
|
Unique identifier of which board on which this action took place
Example: 123
|
|
community_app
|
Type of Lithium application (forum, blog, idea, TKB, Q&A, etc.) on which the event took place
Example: forum
|
|
conversation.title
|
Title of thread on which this action took place
Example: Troubleshooting Product XYZ
|
|
conversation.uid
|
Unique identifier of which thread on which this action took place. You can make a Community API request to convert this unique ID to thread content.
Example: 123456
|
|
document.id
|
Unique identifier for each event
Example: Communityname.prod_1234abcd
|
|
event.time.ms
|
Full Unix timestamp of the event - Epoch time in milliseconds
Example: 1405027061483
|
|
labels
|
If the action that took place was on a message, this column would include the names of any labels on the message
Example: wireless
|
|
message.is_topic
|
TRUE or FALSE statement whether the message was the creation of the thread
Example: TRUE
|
|
message.subject
|
The subject field of the message being acted on
Example: CX Live Sydney Recap
|
|
message.type
|
Type of the message, if the action took place on a message:
- answer - answer to Q&A
- article - new thread in TKB
- comment - reply to TKB, Q&A, Blog, Idea, Contest
- idea - new thread for Idea
- reply - reply to Forum or Group
- review - reply to Review
- question - new thread in Q&A
- topic - new thread in Forum or Q&A
|
|
message.uid
|
Unique ID of message being acted on
Example: 123456
|
|
message.view
|
This field is no longer populated. The field remains part of the response for backward compatibility.
Example: 123456
|
|
node.ancestor_path
|
The location in the Lithium Community, specifically the category container and board that this event took place in. You can convert this to Category and Board name using Community API.
Example: /1/2/601/611/517/
|
|
request.device
|
Whether the action took place by user on desktop or mobile device as determined by WURFL. Mobile includes tablets and phones.
Example: mobile
|
|
request.geo.city
|
City of user taking action converted from browser IP using IP2Location DB 11. Country mapping of IP address associated with browser that initiated event.
Example: San Francisco
|
|
request.geo.country
|
Country name from ISO 3166 of the user taking action converted from the browser IP using IP2Location DB11
Example: United States, Australia, India
|
|
request.geo.country_code
|
Two-character country code from ISO 3166 of user taking action converted from browser IP using IP2Location DB11
Example: US
|
|
request.geo.geohash
|
Geohash using latitude and longitude of user taking action converted from browser IP using IP2Location DB11
Example: 9q8yyxwqn2uj
|
|
request.geo.latitude
|
Latitude of the user taking action converted from browser IP using IP2Location DB11
Example: 37.791257
|
|
request.geo.longitude
|
Longitude of the user taking action converted from browser IP using IP2Location DB11
Example: -122.400811
|
|
request.geo.postal
|
Zip/postal code of user taking action converted from browser IP using IP2Location DB11
Example: 94104
|
|
request.geo.region
|
Region or state name of user taking action converted from browser IP using IP2Location DB11
Example: California
|
|
request.geo.timezone
|
Positive (+) or negative (- hour offset from UTC of user taking action converted from browser IP using IP2Location DB11
Example: -08:00
|
|
request.headers.referrer.host
|
(Added Nov 2016) The host part of the referrer URL
Example: www.google.com
|
|
request.headers.referrer.url
|
The URLs of the referrers of the request. A referrer is the site a user came from before entering the community to take the listed action. Depending on type of action, the userâs browser setting, and if your community has SSL disabled, you might not have any referrers for certain actions or might have more than one value. The field returns a comma separated list of all values.
Example: www.google.com,www.google.com/ncr
|
|
request.headers.user_agent
|
User agent of browser initiating event.
Example: Mozilla/5.0 (iPhone; U; CPU iPhone OS 3_0 like Mac OS X; en-us) AppleWebKit/528.18 (KHTML, like Gecko) Version/4.0 Mobile/7A341 Safari/528.16
|
|
request.url.host:
|
The host of the of browser initiating the event.
Example: community.lithium.com
|
|
results.present
|
This field is deprecated
|
|
survey.id
|
The ID of the survey the user interacted with
|
|
survey.response
|
The user's response to a survey
|
|
survey.type
|
If the action that took place was on a message, this column would include the names of any tags on the message
Example: impact
|
|
tags
|
If the action that took place was on a message, this column would include the names of any tags on the message
Example: knitting
|
|
target.user.community.rank.name
|
Rank of user being acted on
Example: Expert
|
|
target.user.community.role.name
|
Role of user being acted on
Example: Employee
|
|
target.user.login
|
Username of the person being acted on
Example: SuzieH
|
|
target_user_registration_status
|
(Added Nov 2016) Registration status of the user who this action acted upon
Example: FULLY REGISTERED
|
|
target.user.uid
|
Unique user ID of user being acted on. For example, user.uid is the person who kudoed, but target.user.uid is the author of the content that was kudoed.
Example: 98765
|
|
user.community.rank.name
|
Rank of registered users that have initiated event. Null value indicates user has no rank or user is anonymous.
Example: Rank15
|
|
user.community.role.name
|
Comma-separated list of all roles associated with user id that took action
Example: Moderator
|
|
user.login
|
Username of the person taking this action
Example: SuzieH
|
|
user.sso.id
|
SSO ID of user taking action, if SSO ID is available
Example: 123ABC
|
|
user.uid
|
Unique identifier for registered members of your community. You can make Community API request to convert this unique ID to user name.
Example: 98765
|
|
visit.id
|
Unique identifier of the series of actions the user took as part of same visit (entry and exit) in community
Example: 987654321
|
|
visitor.id
|
A unique ID that can be used to track unique visitors to your community and how often the same visitor logs events in your community.
Example: B19EFCE0660132A51BACFAF2105C4686
If the Communitycookie banner is enabled on the community, and the user has denied permission to drop cookies, then LSI sets a random internal ID as the value of visitor.id, rather than a trackable session cookie. The random internal ID is not persistent and cannot be used to track unique visitors.
|
