1

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!

enter image description here

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?

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
2
  • Thanks a lot for your solution, I gave it a try and it returned the results. One more question please, any idea what is the difference between "Count" and "Visits" for downloads here? they are always the same for all the returned items.
    – AME
    Aug 2 '21 at 9:22
  • Visits, Is Number of interactions where there was one or more downloads. Count, Number of times the item was downloaded: doc.sitecore.com/en/users/81/sitecore-experience-platform/… Aug 2 '21 at 12:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.