Downloads table is empty in reporting DB

Question

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?

Answer 1

I used the following query with Sitecore 10, give it a try with your version:

SELECT        
    DimensionKeys.DimensionKey, 
    SiteNames.SiteName, 
    Fact_DownloadEventMetrics.Count, 
    Fact_DownloadEventMetrics.Visits, 
    Fact_DownloadEventMetrics.Value

FROM
    DimensionKeys INNER JOIN
    Fact_DownloadEventMetrics ON DimensionKeys.DimensionKeyId = Fact_DownloadEventMetrics.DimensionKeyId INNER JOIN
    SiteNames ON Fact_DownloadEventMetrics.SiteNameId = SiteNames.SiteNameId

GROUP BY 
    DimensionKeys.DimensionKey, 
    SiteNames.SiteName, 
    Fact_DownloadEventMetrics.Count, 
    Fact_DownloadEventMetrics.Visits, 
    Fact_DownloadEventMetrics.Value