I'm using Sitecore 9.1.1. I have a requirement to track the downloads of PDF files across the site. I've marked the required files under the media library with the "Download" event and I am able to see them in the Experience Analytics dashboard under the behavior tab.
I need then to extract the download count of each item, I didn't find an OOTB API that allows me to do so but I found this link which gives a way to extract information from the reporting DB.
But my problem is that the "Fact_Downloads" table in the reporting DB is always empty!
Any idea why the [Fact_Downloads] table is always empty? and where is the downloads data that's showing up in the analytics dashboard under the behavior tab is coming from in that case?