Home → Listen & Analyze →

    The SEM Reports Tab

    The Reports tab allows you to quickly track user and data activity. With user reports, you can see the internal actions per user during a specific time period. For data reports, you can see all content for a channel during a specific time period. These reports can pull information up to two years prior from the date of export.

    You can work with the SEM Reports tab if you are an Oracle Social Engagement and Monitoring customer.

    In this article:

    Exporting User Activity

    Exporting Data from Channels
        · Running Post-Level Reports
        · Running Facebook Page-Level Reports

    Report Content
        · User Reports
        · Twitter Posts
        · Facebook Posts
        · Facebook Pages Daily Report
        · Facebook Pages Aggregated Report
        · LinkedIn Post-Level Report
        · LinkedIn Page-Level Report
        · Weibo Report
        · Weibo Mentions Report
        · Weibo Direct Messages Report
        · Listen Help Topics

    Notes

    Click a link above to get directly to that section, or scroll down and start reading.

    Exporting User Activity

    You can run a report on the internal actions per user to track activity over a specific time range.

    Running User Reports

    1. On the Reports tab under Data Source, click Users.
    2. Select start and end dates for the report (dates default to the past month).
    3. Click EMAIL FILE. Within a few minutes you will receive an email with a link to a report for the content you just exported.
      Note: This link is viable for 24 hours from the time that it is requested.
    4. Open the report for further filtering, sorting, or to plug the data into any reporting device.

    Exporting Data from Channels

    Two types of data reports are available on the Reports tab: post-level reports (for Facebook and Twitter) and page-level reports (for Facebook only). Post-level reports are available also in the Monitoring Stream.

    Filter your message content from one channel and pull a report with only the content that has resulted after applying your filters. Use filtering options to limit the content you would like reported.

    Running Post-Level Reports

    1. On the Reports tab under Data Source, click Channels.
    2. Select the channel from which you would like to see a report.
    3. For Twitter channels: for Message Type, select either All, Statuses, Mentions, or Direct Messages.
      For Facebook channels: for Type of Export, select Post, and for Message Type, select either All, Posts, or Direct Messages.
    4. Select start and end dates for the reports (dates default to the past month).
    5. Click EMAIL FILE Within a few minutes you will receive an email with a link to a report for the content you just exported.
      Note: This link is viable for 24 hours from the time that it is requested.
    6. Open the report for further filtering, sorting, or to plug the data into any reporting device.

    Running Facebook Page-Level Reports

    1. On the Reports tab under Data Source, click Channels.
    2. Select the Facebook page from which you would like to see a report.
    3. For Type of Export, select Page.
    4. Select start and end dates for the report (dates default to the past month).
    5. Click EMAIL FILE. Within a few minutes you will receive an email with links to reports for the content you just exported.
      Note: This link is viable for 24 hours from the time that it is requested.
      The reports:
      • Daily Report - Provides the daily change for the below items, some numbers reflect the total number to date.
      • Aggregated Report - Based on the date range selected when exporting, the aggregated report reflects the change from the beginning to the end of the report.
    6. Open the reports for further filtering, sorting, or to plug the data into any reporting device.

    Note: Page level reports and some per post metrics are not available on Facebook pages with less than 30 likes, as dictated by Facebook Insights.

    Report Content

    This section describes the content provided in the various reports.

    User Reports

    • Date - Day the activity took place
    • Name - The user's or team's name
    • Type - User or team
    • Submissions - Number of posts submitted by the user
    • Published Messages - Number of messages published by the user
    • Replies - Number of replies made by the user
    • Hides - Number of posts hidden by the user
    • Deletions - Number of posts/comments deleted by the user
    • Archived - Number of posts archived by the user
    • Assignments Given - Number of messages assigned to another user by the user
    • Assignments Received - Number of messages assigned to the user
    • Assignments Completed - Number of assigned messages marked as complete

    Twitter Posts

    • Timestamp - Date and time of the message
    • Channel Type - Type of channel: Facebook or Twitter
    • Channel - Public name of the channel
    • User Name - User name who made the post
    • Message Type - Type of message on Twitter (Tweet, Mention, or Direct Message)
    • Message Body - Full content of the message
    • Retweets - Number of retweets a tweet has received to date (Not available for direct messages)
    • Read Status - Read status of the message (Unread or Read)
    • Time To Read - The amount of time it took to read the message in Engage after it was posted to Twitter
    • Post/Comment Responded To - The message that was responded to by an Engage user
    • Time to Respond - The amount of time it took to respond to the message after it was posted to Twitter
    • Visibility Status - Current public visibility status of the post (Visible or Deleted)
    • Assigned To - Name of the user to whom the message has been assigned
    • Label(s) - Any labels added to the message
    • Message URL - URL on Twitter (Not available for direct messages)
    • Oracle SEM URL - URL in Oracle Social Engagement and Monitoring

    Facebook Posts

    • Timestamp - Date and time of the post or comment
    • Channel Type - Type of channel: Facebook or Twitter
    • Channel - Public name of the channel
    • User Name - User's name who made the post (If an admin post, then page name is shown)
    • Social Network User ID - User ID of the user on the corresponding social network
    • Message Type - Type of message on Facebook (Post is an original message, admin or non-admin, on the timeline. Comment is a message made in reply on any original post, admin or non-admin. Direct message is a private message made to the page from a user.)
    • Message Body - Full content of the message
    • Attachment Type - Type of attachment included in the message (Link, Photo, or Video. Timeline only)
    • Attachment URL - A direct link to the attachment (Timeline only)
    • Likes - Number of likes for posts (Timeline only)
    • Comments - Number of comments made on a post (Timeline only)
    • Reach (Impressions) - Number of times your post was seen (Timeline only)
    • Engaged Users - Number of people who clicked anywhere in your post (Timeline only)
    • Talking About This - Number of unique people who created a story about your post. Stories are created when someone likes, comments on, or shares your post; answers a question you posted; or responds to your event. (Timeline only)
    • Shares - Number of times the post was shared (Timeline only)
    • Virality % - Percent of people who saw your post and then created a story about it (Timeline only)
    • Negative Feedback - Number of times people took a negative action on your post (for example, hid it. Timeline only)
    • Link Clicks - If a link was included in the post, this is number of clicks that link received
    • Read Status - Read status of the message (Unread or Read)
    • Time To Read - The amount of time it took to read the message in Engage after it was posted to Facebook
    • Post/Comment Responded To - The message that was responded to by an Engage user
    • Time to Respond - The amount of time it took to respond to the message after it was posted to Facebook
    • Visibility Status - Current public visibility status of the post (Visible, Hidden, or Deleted)
    • Assigned To - Name of the user to whom the message has been assigned
    • Label(s) - Any labels added to the message
    • Message URL - URL on Facebook (Timeline only)
    • Oracle SEM URL - URL in Oracle Social Engagement and Monitoring

    Facebook Pages Daily Report

    • Timestamp - Date
    • Channel Type - Facebook page
    • Channel - Public name of channel
    • Lifetime Page Likes - Total number of people who have liked your page to date
    • New Page Likes (Unique) - Total number of new people who have liked your page, daily
    • New Page Unlikes (Unique) - Unique number of Unlikes of your page, daily
    • Page Negative Feedback - Number of unique people who took a negative action; that is, hid stories or unliked page, daily.
    • Friends of Fans - Number of people who are friends of the fans of your page (estimated), total to date
    • Page Views - Number of times your page was viewed, daily
    • Page Views (Unique) - Number of people who viewed your page, daily
    • Page Impressions - Number of impressions seen of any content associated with your page, daily
    • Page Impressions (Unique) - Number of people who have seen any content associated with your page, daily
    • Page Post Impressions - Number of impressions that came from all of your posts, daily
    • Page Post Impressions (Unique) - Number of unique people who saw any of your page posts, daily
    • Page Engagement - Number of people who engaged with your page, daily
    • Page Stories - Number of stories created about your page, daily
    • People Talking about This - Number of people talking about your page, daily

    Facebook Pages Aggregated Report

    • Timestamp - Date range selected
    • Channel Type - Facebook page
    • Channel - Public name of channel
    • Lifetime Page Likes - Total number of people who have liked your page to date
    • New Page Likes (Unique) - Total number of new people who have liked your page during selected date range
    • New Page Unlikes (Unique) - Unique number of Unlikes of your page during selected date range
    • Page Negative Feedback - Number of unique people who took a negative action; that is, hid stories or unliked page, during selected date range
    • Friends of Fans - Number of people who are friends of the fans of your page (estimated), total to date
    • Page Views - Number of times your page was viewed during selected date range
    • Page Views (Unique) - Number of people who viewed your page during selected date range
    • Page Impressions - Number of impressions seen of any content associated with your page during selected date range
    • Page Impressions (Unique) - Number of people who have seen any content associated with your page during selected date range
    • Page Post Impressions - Number of impressions that came from all of your posts during selected date range
    • Page Post Impressions (Unique) - Number of unique people who saw any of your page posts during selected date range
    • Page Engagement - Number of people who engaged with your page during selected date range
    • Page Stories - Number of stories created about your page during selected date range
    • People Talking about This - Number of people talking about your page during selected date range

    LinkedIn Post-Level Report

    • Timestamp - The date & time of the post or comment
    • Channel Type - The type of channel
    • Channel - The public name of the channel
    • User Name - The user's name that made the post
    • Social Network User ID - The user ID of the user on the corresponding social network
    • Message Type - The type of message
    • Message Body - The full content of the message
    • Attachment Type - The type of attachment included in the message
    • Attachment URL - A direct link to the attachment
    • Likes - Number of likes
    • Comments - Number of comments
    • Read Status - The read status of the message
    • Time To Read - The amount of time it took to read the message after it was posted to the social network
    • Assigned To - The name of the user that the message has been assigned to
    • Label(s) - Any labels added to the message
    • Message URL - The URL on the social network
    • Oracle SEM URL - The Oracle SEM Platform URL
    • Search Term - The search term used
    • Search Option - The search option used

    LinkedIn Page-Level Report

    • Timestamp - The date & time of the post or comment
    • Channel Type - The type of channel
    • Channel Name - The public name of the channel
    • Posts - The number of posts made on your page
    • Comments - The number of comments made on your page

    Weibo Report

    • Timestamp - The date & time of the post or comment.
    • Channel Type - The type of channel.
    • Channel - The public name of the channel.
    • User Name - The user's name that made the post.
    • Message Type - The type of message.
    • Message Body - The full content of the message.
    • Attachment URL - A direct link to the attachment.
    • Likes - Number of likes.
    • Comments - Number of comments.
    • Reposts - Number of Reposts.
    • Read Status - The read status of the message.
    • Time To Read - The amount of time it took to read the message after it was posted to the social network.
    • Assigned To - The name of the user or team that the message has been assigned to.
    • Label(s) - Any labels added to the message.
    • Message URL - The URL on the social network.
    • Oracle SEM URL - The Oracle SEM Platform URL.
    • Search Term - The search term used.
    • Search Option - The search option used.

    Weibo Mentions Report

    • Timestamp - The date & time of the post or comment.
    • Channel Type - The type of channel.
    • Channel - The public name of the channel.
    • User Name - The user's name that made the post.
    • Message Type - The type of message.
    • Message Body - The full content of the message.
    • Attachment URL - A direct link to the attachment.
    • Likes - Number of likes.
    • Comments - Number of comments.
    • Reposts - Number of Reposts.
    • Read Status - The read status of the message.
    • Time To Read - The amount of time it took to read the message after it was posted to the social network.
    • Assigned To - The name of the user or team that the message has been assigned to.
    • Label(s) - Any labels added to the message.
    • Message URL - The URL on the social network.
    • Oracle SEM URL - The Oracle SEM Platform URL.
    • Search Term - The search term used.
    • Search Option - The search option used.

    Weibo Direct Messages Report

    • Timestamp - The date & time of the post or comment.
    • Channel Type - The type of channel.
    • Channel - The public name of the channel.
    • User Name - The user's name that made the post.
    • Message Type - The type of message.
    • Message Body - The full content of the message.
    • Read Status - The read status of the message.
    • Time To Read - The amount of time it took to read the message after it was posted to the social network.
    • Post/Comment Responded To - The responded status of the message.
    • Time To Respond - The amount of time it took to respond to the message after it was posted to the social network.
    • Visibility Status - The current public visibility status of the post.
    • Assigned To - The name of the user or team that the message has been assigned to.
    • Label(s) - Any labels added to the message.
    • Oracle SEM URL - The Oracle SEM Platform URL.
    • Search Term - The search term used.
    • Search Option - The search option used.

      • Listen Topic Report

      • Timestamp - Date and time of the post or comment
      • Channel Type - Type of channel
      • Channel - Public name of the channel
      • User Name - User's name who made the post (If an admin post, then page name is shown)
      • Message Type - Type of message
      • Message Body - Full content of the message
      • Read Status - Read status of the message (Unread or Read)
      • Time To Read - The amount of time it took to read the message in Engage after it was posted to the network
      • Post/Comment Responded To - The message that was responded to by an Engage user
      • Time to Respond - The amount of time it took to respond to the message after it was posted to the network
      • Assigned To - Name of the user to whom the message has been assigned
      • Label(s) - Any labels added to the message
      • Message URL - URL on native site
      • Oracle SEM URL - URL in Oracle Social Engagement and Monitoring
      • Search Term - If a search term was included
      • Search Option - All, message body or username

      Notes

      Time to Read Metric

      A couple things to know about the "Time to Read" metric:

      • Posts made by your Page will have a time read of "N/A". This is because you as the page wrote the post, so there is not Time to Read.
      • Posts that have not yet been read at th etime of the report being pulled will have a Time to Read of "Unread".
      • Posts that were read before 7/30/13 will have a Time to Read of "N/A", because this is when the feature was implemented.

      Time to Respond Metric

      A couple of things to know about the "Time to Respond" metric:

      • Your brand posts will have a "time to respond" of "N/A"
      • If the post/comment has been responded to, the field will have the time in which it took for you to respond
      • If the post/comment has not been responded to, this field will be blank

      Related Topics