Recently, I’m working on Sitecore analytics project, and I found a useful tool for exporting the interactions data from xDB. That’s why I would like to share it with you. It’s an open source project and the source code is stored here https://github.com/Sitecore/experience-extractor. It does exactly the same job as Sitecore analytics, but allows us to export in details which you can use in below scenarios:
- Analyze, present and share Sitecore data with external tools such as Excel, Power BI, R and Tableau
- Prepare and shape data for machine learning
- Integrate Sitecore Experience Data in other big data solutions
The shell section is the configuration for the export in Json format which consists of
- And optionally post-processors
The source is the “Interactions” table in xDB. If you look into the integration table schema, it tells you what data Sitecore is capturing i.e. StartDateTime, the Browser, Location, Device etc. These fields can be the facets for your report.
There are more information about the dimension, filter and mapper can be found here https://github.com/Sitecore/experience-extractor/wiki