Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Column

Defintion

Example

Content id

The unique identifier of an the item of content that was engaged with.

1

Content name

The name of an item of content of the item of content that was engaged with.

Items to sell

Creation date (UTC)

The date on which the item of content item was created.

21/5/2021 00:00:00

Creator id

The unique identifier of the user who created the content.

2

Creator name

The name of the user who created the content.

Jane Doe

Creator's role

The role content type of the user who created the content.

The following user types are available roles:

  • User

  • Admin group

  • Site

admin
  • Admin

site admin

Updated date (UTC)

The last date the content was updated.

21/5/2021 00:00:00

Community id

The unique identifier of the community where the content exists.

12345

Info

If the item of content is in multiple communities, the unique identifier of each community is listed.

2

Community name

The name of the community where the content exists.

Sales Community

Info

If the item of content is in multiple communities, the name of each community is listed.

Sales Community

Engagement date (UTC)

The date the user engaged with the content.

21/5/2021 00:00:00

Engagement type

How the user engaged with the content
Available engagement types:

  • view

  • like

  • comment

  • share

  • follow

  • favourite

comment

Comment text

If the user has posted a comment under the content, the text of the comment is displayed.

Thank you for sharing!

User id

The unique identifier of the user engaging who engaged with the content item.

1

Username

The username of the user who engaged with the content.

johndoe

User first name

The first name of the user engaging who engaged with the content.

John

User last name

The last name of the user engaging who engaged with the content.

Doe

E-mail

The email address of the user who engaged with the content.

john.doe@fuseuniversal.com

User role

The system role of the user engaging who engaged with the content
Available roles.

The following user types are available:

  • User

  • Site admin

user

Creation date

The creation date of the users' accountaccount of the user who engaged with the content.

1/1/2021 00:00:00

Last log in date

The last date the user logged in to Fuse (was presented with the log in screen).

14/5/2021 00:00:00

Last activity date

The last date the user accessed Fuse.

17/5/2021 00:00:00

Deactivation date

The date the user’s account was deactivated.

19/5/2021 00:00:00

Time zone setting

The usersuser's time zone as set in their profile.

GMT +1:00 London

Language setting

The user's language, as set in their profile.

en - English

Profile fields (eg Department)

the header contains the label of the custom profile field, the field itself contains the value as presented on the UI of the custom profile field.
(values of the field are either in the table profile_field_values, or profile_field_options)

Sales