Counting pdf downoad and video plays | Community
Skip to main content
vs_jain
vs_jain
Level 2
June 9, 2017
Solved

Counting pdf downoad and video plays

  • June 9, 2017
  • 4 replies
  • 2385 views

Hi all,

I am implementing Adobe analytics using SQL. My data is stored on AWS. I was able to get metrics like visits, unique visitors etc using business rules from Adobe website (Page # 49 on this link: https://marketing.adobe.com/resources/help/en_US/sc/clickstream/analytics_clickstream.pdf ).

However, I am struggling to get count of pdf downloads/video plays. Has anyone implemented this earlier? Let me know

Regards,

Vishal

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Kaushalendra

    Hi vs.jain​,

    I believe you are calculating metrics using the Clickstream data stored on AWS.

    For PDF Downloads, the call fired is a custom link call and those can be filtered based on page_event. Hence apply filter for "post_page_event = 101". For Video Plays, you can try "post_page_event = 76".

    4 replies

    TanmayMathur
    Adobe Employee
    TanmayMathurAdobe Employee
    Adobe Employee
    June 9, 2017

    Hi Vishal,

    I am not sure about the SQL implementation but for javascript we use s.trackdownloadlinks to track file downloads - Automatic Tracking of Exit Links and File Downloads

    See if this might help you.

    Kaushalendra
    Adobe Employee
    KaushalendraAdobe EmployeeAccepted solution
    Adobe Employee
    June 9, 2017

    Hi vs.jain​,

    I believe you are calculating metrics using the Clickstream data stored on AWS.

    For PDF Downloads, the call fired is a custom link call and those can be filtered based on page_event. Hence apply filter for "post_page_event = 101". For Video Plays, you can try "post_page_event = 76".

      vs_jain
      vs_jainAuthor
      Level 2
      June 9, 2017

      Thanks Kaushalendra. I will try this at my end.

      vs_jain
      vs_jainAuthor
      Level 2
      June 21, 2017

      Kaushal - Thanks for your response earlier. It looks like pdf downloads is working at my end. However, I am not able to isolate video plays using the condition you stated. Is it possible there is another filter to video play? Let me know. I have already tried all possible filters under post_page_event. But that does not give me any result.

      Terms & ConditionsAccessibility statement

      Loading footer...