Lithosphere The Lithium Community

Announcement: SMM Supervisor Reports will be deprecated in the next release, learn more about it here.

Migration of SMM Raw Post exports from Supervisor View to Analytics

Lithium Staff JohnD
Lithium Staff

As part of Facebook’s commitment to user security and privacy, they have been making changes to APIs and infrastructure that all third-party apps use. As part of this ongoing effort, we will be making a necessary backend update on December 9th. At that time, 2 of the 9 Supervisor Exports in Lithium SMM will need to be deprecated on a faster timeline than originally intended. We apologize for the inconvenience and are committed to helping customers who might still be using these legacy exports to migrate to SMM Analytics to access the same data.

The Supervisor Reports, which will be fully deprecated in the December Release of SMM, are the “Raw Post” and “Raw Post - Include Agent Actions” exports. Both reports show posts published from an author and the corresponding agent replies sent during the reporting period, as well as data on the conversations that these posts and responses belong to. Specifically:

  • “Raw Post” includes posts that were authored/came into the system during the time period specified.
  • “Raw Post - Include Agent Actions” includes any post that has been authored, claimed, responded to, or closed during the time period selected. This results in duplicate rows appearing when a post is both authored and responded/claimed/closed during the same time period (one row for each action).

This same data is available from SMM Analytics, either separated out by distinct reports that focus on post, response, and conversation data, or in the Raw Combined Export, which combines data from the Incoming Post, Response, and Conversation reports.

The following table maps the fields in Supervisor Raw Post Exports to the relevant Analytics Exports.

Supervisor Raw Post Export

Analytics Raw Incoming Post Export

Analytics Raw Response Export

Analytics Raw Conversation Exports

Analytics Raw Combined Exports

#

Column Name

Column Name

Column Name

Column Name

Column Name

1

Beginning of Range

-

-

-

 

2

End of Range

-

-

-

 

3

Conversation ID

Conversation ID

Conversation ID

Conversation ID

Conversation ID

4

Status

-

-

Status

Status

5

Priority

Conversation Priority

Conversation Priority

Conversation Priority

Conversation Priority

6

Work Queue Name

Conversation Work Queue

Conversation Work Queue

Conversation Work Queue

Conversation Work Queue

7

Assignee

-

-

Assignee

Assignee:Authoring User

8

Post Provider

Post Provider

-

Conversation Source

Source

9

Provider Type

Post Provider

-

Conversation Source

Source

10

Date Post Published

Date Post Published

Post Responded to Published Time

-

Published Date

11

Date Post Received

Date Post Received

Post Responded to Received Time

-

Created Date

12

Author Name

Author Handle

-

Authors

Author Handles

Assignee:Authoring User

13

Post Content

Post Content

Post Responded to Content

-

Content

14

Auto Tags (Post)

Auto Tags

-

Auto Tags

Conversation/Post Tags


Note this field contains all tags, it is not limited to auto tags

15

Manual Tags (Post)

Manual Tags

-

Manual Tags

Conversation/Post Tags


Note this field contains all tags, it is not limited to manual tags

16

Post Sentiment

Post Sentiment

-

-

Sentiment

17

Post Language

Post Language

-

Language Tags

Languages

18

Author Source Tag

Post Source Tag

Source Tags

Source Tags

Source

19

Post ID (Author)

External Post ID

Post Responded to External ID

-

External ID

20

Private Post (Author)

Post Type

-

Total Private Incoming Posts

Private Post

21

Date Claimed

-

Date Claimed or Assigned

-

Date Claimed or Assigned

22

Date Responded

-

Response Published Date

-

Published Date

23

Time to Response (h)

-

Response TAR (min)

-

Average TAR (min)

24

Responding Agent

-

Responding Agent Name

-

Assignee:Authoring User

25

Responding Account

-

Response Handle

Response Handles Used

Source

26

Response Content

-

Response Content

-

Content

27

Post ID (Agent)

-

External Response ID

-

External ID

28

Private Post (Agent)

-

Response Type

Total Private Responses

Private Post

29

Customer Satisfaction Survey

-

-

-

-

30

Close Notes

-

-

Close Notes

Close Notes

31

Permalink

Post Permalink

-

-

Permalink*

Coming Soon

32

Date Closed

-

-

Closed Date

Closed Date

33

Author Post Order

Post Order

-

-

Total PostsSmiley Surprisedrder in Conversation

34

Agent Post Order

-

Response Order

-

Total Responses:Response Order

35

Author Social UID

External Author Handle ID

 

-

Assignee:Authoring User ID

36

Agent UID

-

Responding Agent ID

-

Assignee:Authoring User ID

37

Agent email

-

Responding Agent Email

-

Assignee:Authoring User Email

38

Assignee Team

-

-

-

Assignee:Authoring User Team

39

Responding Agent Team

-

-

-

Assignee:Authoring User Team

1 Comment
Valued Contributor
Valued Contributor

Hi,

Thanks for the heads-up.

Using supervisor reports was advised to be avoided for a while, I know, but I'm still doing so because there's always the one (or plus) field(s) I miss from the Analytics versions (for example: raw response report does not mention the responding agent team forcing me to maintain a vlookup-table).

Anyways, it is what it is.

Kind regards,

Ollie