| Oracle Retail AI Foundation Cloud Services Implementation Guide Release 22.2.401.0 F72321-01 |
|
 Previous |
 Next |
| Oracle Retail AI Foundation Cloud Services Implementation Guide Release 22.2.401.0 F72321-01 |
|
Previous |
Next |
The Social Analytics (SA) application takes data inputs from two sources, social data and sales data. Through a joint analysis of these two data inputs, SA delivers insights regarding social metrics and the potential links between the social metrics and sales trends.
The SA process runs weekly as a batch process for the most recent social data and sales data of the past eight weeks.
The SA process uses social data and weekly sales data as well as retailer's hierarchy data (including product hierarchy, location hierarchy, and calendar hierarchy).
The social data is provided as a data feed by Oracle Social Relationship Management (SRM) for a specific retailer; the retailer must have a license for SRM in order to be able to implement and use SA.
The SRM platform is a web-based application that helps retailers analyze the content from different social outlets and monitor social metrics such as trending topics, trending sources, number of online references to a particular brand, color, and social sentiments.
The social data feed is provided based on the topics and filters that a user creates in the SRM platform. The feed includes topics, keywords (such as color, fabric, style, and so on), activities (that is, conversations together with the timestamp, location, and source) in different social outlets (for example, tweet messages), and sentiments. This data is stored in the application schema and is updated as part of the weekly batch process.
To learn more about how to create topics and filters, see the Oracle Social Relationship Management documentation.
Social data, sales data, and hierarchy data are all pulled from the application database.
Table 19-1 Data Input
| Data Input | Source Database | Source Table |
|---|---|---|
|
Topics |
ORASE |
SA_TOPIC_DEFINITION |
|
Keywords |
ORASE |
SA_INDICATOR_KEYWORD_FILTER |
|
Activities |
ORASE |
SA_SDF_MESSAGE |
|
Sentiments |
ORASE |
SA_SDF_SNIPPET |
|
Weekly Sales |
ORASE |
RSE_SLS_PH_LC_WK_A |
|
Product Hierarchy |
ORASE |
RSE_PROD_HIER_TC, RSE_PROD_SRC_XREF |
|
Location Hierarchy |
ORASE |
RSE_LOC_SRC_XREF |
|
Calendar Hierarchy |
ORASE |
RSE_CAL_SRC_XREF |
