Working on a requirement to capture Salesforce Liveagent Chatbot interactions on client website . Captured web analytics data needs to be associated with respective data from salesforce which is stored in Oracle Database . Need help and suggestions to understand how this can be done. Given that I'm able to capture "UniqueChatID" in adobe analytics which can be used as a primary key to link AA data with Oracle DB tables.
Thanks for your help PratheepArunRaj , This is really helpful. Can you help me with this as well . Is there any kind of setup where we can pull required relevant data from Oracle database into Adobe Analytics report ??? Scenario is same we have UniqueChatID both in Adobe data as well as Oracle data.
Capture the UniqueChatID in a prop and select the required metrics & sub dimensions in the data warehouse. Schedule it through FTP where you can extract the data and load it on Oracle Database.
Note that Data Warehouse is a processed data with latency. If you need real-time data, you can opt for Data Feed : Experience Cloud Help - But you need to calculate the metrics by yourself (Through ETL) since it is raw data.